set_cells
Write numeric values, text, or formulas into specific cells of a LibreOffice Calc spreadsheet. Specify cells and values or formulas to update targeted cells in a chosen sheet.
Instructions
Write cells in a Calc document. Returns {written}.
cells is a list of {cell, value?|formula?} entries, e.g.
[{"cell": "A1", "value": 21}, {"cell": "A2", "formula": "=A1*2"}]
A "value" that is a number is written numerically; otherwise as text. A
"formula" (starting with =) is evaluated by Calc. sheet selects the
target sheet by name or 0-based index (defaults to the first sheet).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cells | Yes | ||
| sheet | No | ||
| doc_id | Yes |