SheetXL - v1.0.2
    Preparing search index...

    Interface GetItemsOptions

    Options for IFilter.getItems.

    interface GetItemsOptions {
        limit?: number;
        scope?: "column" | "visible";
        selector?: string | ISelector<Scalar, Scalar> | null;
    }
    Index
    limit?: number

    The distinct values to stop at.

    10000

    scope?: "column" | "visible"

    Which rows are listed.

    • 'visible': as a filter menu lists them (see IFilter.getItems).
    • 'column': every row of the column, hidden or not, so a value every row of which another column's filter hides is listed too, with Item.passesOthers saying so. What a slicer lists.

    'visible'

    selector?: string | ISelector<Scalar, Scalar> | null

    The selector the column is read under, as the condition's will be. Under ICondition.BuiltInSelectorNames.Display the column is grouped by the text its cells SHOW, as a spreadsheet's filter list does: 1 under $0 and under 0% are two items, and a string of only spaces is a blank. The items are then the texts an inSet under Display holds. Any other selector lists the distinct values.

    null — by value, the identity ICondition.InSetOption.items has under no selector.