Rows and sheets

Structural row edits

insertRows and deleteRows shift rows the way Excel does:

• Row elements, cell references, shared/array formula anchors, merged cells, hyperlinks, data validations, conditional formats, auto filters, comment anchors, and the sheet dimension all shift.
• Formulas across the whole workbook are rewritten, including cross-sheet references and defined names. References into deleted rows become #REF!; ranges shrink or grow like Excel.
• Tables entirely below an insertion shift. Edits that overlap a table range are refused; use the table APIs to resize tables instead.
• Deleting rows that would orphan a surviving shared or array formula group is refused with a clear error.
• Drawings and pivot sources are not rewritten; Ironsheet emits review diagnostics instead of guessing.

await workbook.insertRows("Sheet1", 5, 2);
await workbook.deleteRows("Sheet1", 5, 2);

Sheet lifecycle

• addSheet(name) creates an empty worksheet with correct content types and relationships.
• copySheet(name, nextName) duplicates cells, styles, merges, validations, and external hyperlinks. Tables, drawings, comments, and pivot tables are intentionally not duplicated; a diagnostic lists what was skipped.
• deleteSheet(name) removes the sheet and cascade-deletes parts only it references, drops sheet-scoped defined names, reindexes surviving scoped names, breaks formulas that referenced the sheet with #REF!, and keeps at least one visible sheet.

await workbook.addSheet("Report");
await workbook.copySheet("Sheet1", "Sheet1 Copy");
await workbook.deleteSheet("Scratch");

Because copySheet skips tables, drawings, comments, and pivot tables, check report.diagnostics after the mutation to see exactly what was left behind — it is intentional, not a bug, but you should know about it before shipping a report built from a copied sheet.