rename_sheet
Rename a worksheet and update every formula, defined name, validation rule, and internal hyperlink that references it; dry-run by default lists affected formulas before you commit.
Instructions
Rename a sheet AND update every reference to it: formulas on all sheets (only real references, never text inside string literals), defined names, data-validation and conditional-format formulas, and internal hyperlinks. DRY RUN BY DEFAULT: lists each formula that would change. new_name is validated like add_sheet. output/overwrite/allow_loss work as in set_cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | Yes | ||
| output | No | ||
| dry_run | No | ||
| new_name | Yes | ||
| overwrite | No | ||
| allow_loss | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |