SheetXL - v1.0.2
    Preparing search index...

    Interface FreezePanes

    The coordinates for a FreezePane.

    Can have either a coordinate or a topLeft or both.

    interface FreezePanes {
        coords?: Partial<CellCoords>;
        paneSelections?: Partial<Record<Pane, PaneSelection>>;
        topLeft?: Partial<TopLeft>;
    }
    Index
    coords? paneSelections? topLeft?
    coords?: Partial<CellCoords>

    At least one direction must be set.

    paneSelections?: Partial<Record<Pane, PaneSelection>>

    The selections Excel remembers in the panes other than the one holding the selection, as the file wrote them.

    SheetXL has one selection, shown across every pane (IWorksheetView.getSelection); these are carried for the file only. They are dropped when the freeze moves, and do not follow inserts or deletes.

    topLeft?: Partial<TopLeft>

    The scroll offset captured at the start of the frozen region.

    If the current view has a scroll offset and freeze is called it will 'transfer' the scroll coordinates. Like topLeft, this is expressed in zoom-independent (base, unzoomed) px and is therefore stable across zoom changes.

    Settings
    Member Visibility

    On This Page
    Properties