@jsfkit/types
    Preparing search index...

    Type Alias PivotTableLocation

    Describes the position of the pivot table's header and data areas within its output range (ref).

    All offsets are 0-based from the top-left cell of ref. The difference firstDataRow - firstHeaderRow equals the number of column-field header rows.

    type PivotTableLocation = {
        colPageCount?: integer;
        firstDataCol: integer;
        firstDataRow: integer;
        firstHeaderRow: integer;
        rowPageCount?: integer;
    }
    Index

    Properties

    colPageCount? firstDataCol firstDataRow firstHeaderRow rowPageCount?

    Properties

    colPageCount?: integer

    Number of columns occupied by the page field area (see PivotTable's type description). Layout depends on pageOverThenDown and pageWrap.

    0
    firstDataCol: integer

    0-based column offset from the left of ref to the first column containing data values.

    firstDataRow: integer

    0-based row offset from the top of ref to the first row containing data values.

    firstHeaderRow: integer

    0-based row offset from the top of ref to the first row of the body area (column-field items, or data if there are no column fields).

    rowPageCount?: integer

    Number of rows occupied by the page field area (see PivotTable's type description). Layout depends on pageOverThenDown and pageWrap.

    0

    Settings

    Member Visibility

    On This Page

    Properties