SheetXL - v1.0.2
    Preparing search index...

    Interface PivotAreaReferenceJSON

    The items of one field a PivotAreaJSON picks.

    interface PivotAreaReferenceJSON {
        byPosition?: true;
        field: number;
        items?: number[];
        relative?: true;
        selected?: false;
        subtotals?: string[];
    }
    Index
    byPosition? field items? relative? selected? subtotals?
    byPosition?: true

    The items count by position, not by index.

    field: number

    The field, by index; -2 the values.

    items?: number[]

    By index into the field's items, or into the data fields for -2; absent, all of them.

    relative?: true

    The items are relative to the cell.

    selected?: false

    false: the items are not selected; absent, they are.

    subtotals?: string[]

    Which of the field's subtotals, as OOXML spells them (defaultSubtotal, sumSubtotal, ...).

    Settings
    Member Visibility

    On This Page
    Properties