SheetXL - v1.0.2
    Preparing search index...

    Interface PivotItemJSON

    One item of a field: an item of the cache field, or a subtotal or grand-total line.

    interface PivotItemJSON {
        calculated?: true;
        collapsed?: true;
        hidden?: true;
        item?: number;
        missing?: true;
        name?: string;
        type?: string;
    }
    Index
    calculated? collapsed? hidden? item? missing? name? type?
    calculated?: true

    A calculated item: its value is a formula over the field's other items, the cache's.

    collapsed?: true

    Its details are not shown.

    hidden?: true
    item?: number

    The index of the item in the cache field's items.

    missing?: true

    The item is no longer in the source; kept until a refresh drops it.

    name?: string

    The caption shown in place of the item's value.

    type?: string

    The line it is, when not an item of the cache, as OOXML spells it (default, sum, grand…).

    Settings
    Member Visibility

    On This Page
    Properties