Type alias SheetStructureEditIf

SheetStructureEditIf: {
    at: number;
    count: number;
    kind: "insertRows" | "deleteRows" | "insertColumns" | "deleteColumns";
} | {
    from: {
        c1: number;
        c2: number;
        r1: number;
        r2: number;
    };
    kind: "moveCells";
    to: readonly [number, number];
}

A change of the sheet's structure that formulas must follow (adjustFormula): rows or columns inserted or deleted at at (0-based, count of them), or cells moved (cut + paste).

Type declaration

  • at: number
  • count: number
  • kind: "insertRows" | "deleteRows" | "insertColumns" | "deleteColumns"

Type declaration

  • from: {
        c1: number;
        c2: number;
        r1: number;
        r2: number;
    }
    • c1: number
    • c2: number
    • r1: number
    • r2: number
  • kind: "moveCells"
  • to: readonly [number, number]

Since

1.1.99