SheetXL - v1.0.2
    Preparing search index...

    Interface JSON

    JSON representation of a slicer.

    interface JSON {
        cacheName?: string;
        caption?: string;
        columnCount?: number;
        crossFilter?: CrossFilter;
        disabledCustomListSort?: boolean;
        hiddenCaption?: boolean;
        level?: number;
        lockedPosition?: boolean;
        rowHeight?: number;
        sortOrder?: SortOrder;
        source?: string;
        sourceId?: number;
        startItem?: number;
        style?: string;
        uid?: string;
    }
    Index
    cacheName? caption? columnCount? crossFilter? disabledCustomListSort? hiddenCaption? level? lockedPosition? rowHeight? sortOrder? source? sourceId? startItem? style? uid?
    cacheName?: string

    The name formulas refer to the selection by, as the file had it. Absent, made from the column's name.

    caption?: string

    The header text. Absent, the column's or the pivot field's name.

    columnCount?: number
    1
    crossFilter?: CrossFilter

    'showItemsWithDataAtTop'

    disabledCustomListSort?: boolean

    Whether a custom list is ignored when sorting the items.

    hiddenCaption?: boolean

    Whether the header is hidden.

    level?: number

    The level of a hierarchy shown, for a slicer read from a file.

    lockedPosition?: boolean

    Whether the slicer is marked as not to be moved or resized.

    rowHeight?: number

    Each item's height in pixels.

    27
    sortOrder?: SortOrder

    'ascending'

    source?: string

    The column, as a structured reference: Sales[Region]. Absent for a slicer on a pivot table.

    sourceId?: number

    The id the file gave the slicer's frame.

    startItem?: number

    The index of the first item showing: where the list was scrolled to when saved.

    Restored when the slicer is first drawn. Scrolling the slicer does not change it.

    style?: string

    'SlicerStyleLight1'

    uid?: string

    The id the file gave the slicer.

    Settings
    Member Visibility

    On This Page
    Properties