spreadsheet_set_range · LibreOffice MCP Tools MCP

WHAT IT DOES

What spreadsheet_set_range does on LibreOffice MCP Tools

AI agents use spreadsheet_set_range to create or update resources in LibreOffice MCP Tools — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your LibreOffice MCP Tools environment.

WHY IT NEEDS A POLICY

Why spreadsheet_set_range needs a policy

This tool creates or modifies data in a reversible manner (cells can be edited or undone), fitting the Write category. It does not delete or irreversibly destroy data (not Destructive), does not execute arbitrary code (not Execute), and does not involve financial transactions (not Financial).

From the tool's definition Tool description states 'Set multiple cell values in a spreadsheet' — this directly modifies data within a spreadsheet document. The verb 'set' indicates creation or modification of cell values.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

spreadsheet_set_range Rate-limited

spreadsheet_set_range stays usable, but capped — an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "spreadsheet_set_range": {
      "limits": [
        {
          "counter": "spreadsheet_set_range_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches LibreOffice MCP Tools, so you can run agents against it safely.

FAQ

Questions about spreadsheet_set_range

What does the spreadsheet_set_range tool do? +

Set multiple cell values in a spreadsheet. Provide a 2D array of values matching the range. It is categorised as a Write tool in the LibreOffice MCP Tools MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on spreadsheet_set_range? +

Register the LibreOffice MCP Tools MCP server in PolicyLayer and add a rule for spreadsheet_set_range: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches LibreOffice MCP Tools. Nothing to install.

What risk level is spreadsheet_set_range? +

spreadsheet_set_range is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit spreadsheet_set_range? +

Yes. Add a rate_limit block to the spreadsheet_set_range rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block spreadsheet_set_range completely? +

Set action: deny in the PolicyLayer policy for spreadsheet_set_range. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides spreadsheet_set_range? +

spreadsheet_set_range is provided by the LibreOffice MCP Tools MCP server (passerbyflutter/libreoffice-mcp-tools). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.