SheetXL - v1.0.2
    Preparing search index...

    Interface CacheFieldJSON

    One field of a cache: a column of its source, or a grouping of one.

    interface CacheFieldJSON {
        calculatedItems?: { formula: string; item: number }[];
        dateItems?: number[];
        dates?: true;
        formula?: string;
        group?: CacheFieldGroupJSON;
        inline?: true;
        name: string;
        noRecords?: true;
        numberFormat?: string | number;
        rest?: string;
        unused?: number[];
    }
    Index
    calculatedItems? dateItems? dates? formula? group? inline? name noRecords? numberFormat? rest? unused?
    calculatedItems?: { formula: string; item: number }[]

    The field's calculated items: each one's index in its items, and its formula, as a file spells it (Region[North]+Region[South]).

    dateItems?: number[]

    The items that are dates, by index, when others are plain numbers. A date and a number of the same value are two items.

    dates?: true

    The items that are numbers are dates.

    formula?: string

    A calculated field's formula, as a file spells it (Sales-Cost), with noRecords.

    group?: CacheFieldGroupJSON

    How the field groups values, or the field its values are grouped by.

    inline?: true

    The records hold the values themselves, not the index of a shared item.

    name: string
    noRecords?: true

    Not a column of the source (a grouping or calculated field): the records hold nothing for it.

    numberFormat?: string | number

    The number format of its values: a format code, or a built-in format's id; absent, General.

    rest?: string

    The field's markup with what is modeled taken out (name, number format, items): its grouping, formula and anything else not typed yet.

    unused?: number[]

    The items the source no longer holds, kept from an earlier refresh.

    Settings
    Member Visibility

    On This Page
    Properties