Spreadsheet Manipulation
Lido provides action formulas for programmatically editing the spreadsheet itself — updating cells, inserting or deleting rows and columns, and clearing sheets.
UPDATECELL
Updates the value of a cell or cell range.
Syntax:
=UPDATECELL(cell_ref, value)
Parameters:
| Parameter | Description | Required |
|---|---|---|
cell_ref | Cell reference to update | Yes |
value | New value (single value or 2D array for a range) | Yes |
Example:
=UPDATECELL(B2, "Approved")
=UPDATECELL(A1:C1, {"Name", "Age", "City"})
INSERTROWS
Inserts one or more rows into a worksheet.
Syntax:
=INSERTROWS(worksheet_name, array)
=INSERTROWS(worksheet_name, array, options)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
array | 2D array of data to insert | Yes |
options | Insert options | No |
ADDROW
Adds a row to a worksheet.
Syntax:
=ADDROW(worksheet_name, row)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
row | Row number to add | Yes |
DELETEROW
Deletes a row from a worksheet.
Syntax:
=DELETEROW(worksheet_name, row)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
row | Row number to delete | Yes |
ADDCOLUMN
Adds a column to a worksheet.
Syntax:
=ADDCOLUMN(worksheet_name, column)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
column | Column number to add | Yes |
DELETECOLUMN
Deletes a column from a worksheet.
Syntax:
=DELETECOLUMN(worksheet_name, column)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
column | Column number to delete | Yes |
CLEARSHEET
Clears the contents of a worksheet.
Syntax:
=CLEARSHEET(worksheet_name)
=CLEARSHEET(worksheet_name, keep_headers)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Worksheet to clear | Yes |
keep_headers | If true, preserves the header row | No |
APPENDTOSHEET
Appends data to the end of a worksheet.
Syntax:
=APPENDTOSHEET(worksheet_name, values)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Target worksheet name | Yes |
values | Data to append | Yes |