SheetXL - v1.0.2
    Preparing search index...

    Interface Item

    One distinct value of a filtered column.

    interface Item {
        checked: boolean;
        count: number;
        firstRow: number;
        passesOthers?: boolean;
        text: string;
        value: Scalar;
    }
    Index
    checked count firstRow passesOthers? text value
    checked: boolean

    Whether at least one row holding the value passes the filters.

    count: number

    The rows holding the value.

    firstRow: number

    The sheet row of the first listed row holding the value.

    passesOthers?: boolean

    Whether at least one row holding the value passes every other column's filter: a slicer's "has data". Read under GetItemsOptions.scope 'column' only.

    text

    text: string

    The item's label: by value, the value as General shows it (a date as its date format does); under Display, the text the cells show, which is then the item an inSet under Display holds.

    value: Scalar

    The value, or by display the value of the first cell showing text; the item's place in the order.

    Settings
    Member Visibility

    On This Page
    Properties