Set WorkPaper Cell Contents And Read Back
set_cell_contents_and_readbackWrite raw content to one cell, recalculate dependents, read a dependent range in the same tool call, and return persistence proof. Use this for stateless MCP clients such as hosted Open WebUI integrations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value | Yes | Raw cell content. Formula strings must start with =; plain strings are stored as literals. Strict MCP hosts require a single parameter type, so pass evaluated numbers/booleans as formulas such as =0.4 or =TRUE(). The server still accepts JSON number, boolean, or null arguments from clients that support them. | |
| address | Yes | Single A1 cell address to edit, such as B3. Ranges are not accepted. | |
| sheetName | Yes | Existing sheet name for the cell to edit, for example Inputs. | |
| readbackRange | Yes | Dependent A1 range to read before and after the edit, for example Summary!A1:B5. | |
| readbackSheetName | No | Default sheet name when readbackRange omits a sheet name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| after | Yes | ||
| before | Yes | ||
| checks | Yes | ||
| editedCell | Yes | Canonical sheet-qualified address that was edited. | |
| persistence | Yes | ||
| afterReadback | Yes | ||
| readbackRange | Yes | Canonical sheet-qualified range read before and after the edit. | |
| beforeReadback | Yes | ||
| restoredReadback | Yes |