SheetXL - v1.0.2
    Preparing search index...

    Interface Shift

    One insert or delete of cells, as ChangeEvent.getShifts reports it.

    interface Shift {
        getAxis(): Axis;
        getKind(): ShiftKind;
        getRanges(): ICellRanges | null;
    }
    Index
    • The axis the neighboring cells moved along: 'row' moves them down or up, 'column' right or left.

      Returns Axis

    • The cells inserted or deleted, read where they exist: an insert's on the sheet, a delete's on a detached copy of the sheet as it was before the change.

      Returns ICellRanges | null

      null for a delete when the store no longer keeps the state before it. When one change makes several shifts, each one's addresses are as that shift found the sheet.