Google Apps Script API
    Preparing search index...

    Interface Slicer

    Represents a slicer, which is used to filter ranges, charts and pivot tables in a non-collaborative manner. This class contains methods to access and modify existing slicers. To create a new slicer, use Sheet.insertSlicer(range, anchorRowPos, anchorColPos).

    interface Slicer {
        getBackgroundColor(): string;
        getColumnPosition(): number;
        getContainerInfo(): ContainerInfo;
        getFilterCriteria(): GoogleAppsScript.Spreadsheet.FilterCriteria;
        getRange(): GoogleAppsScript.Spreadsheet.Range;
        getTitle(): string;
        getTitleHorizontalAlignment(): string;
        getTitleTextStyle(): GoogleAppsScript.Spreadsheet.TextStyle;
        isAppliedToPivotTables(): boolean;
        remove(): void;
        setApplyToPivotTables(applyToPivotTables: boolean): Slicer;
        setBackgroundColor(color: string): Slicer;
        setColumnFilterCriteria(
            columnPosition: number,
            filterCriteria: GoogleAppsScript.Spreadsheet.FilterCriteria,
        ): Slicer;
        setPosition(
            anchorRowPos: number,
            anchorColPos: number,
            offsetX: number,
            offsetY: number,
        ): Slicer;
        setRange(rangeApi: GoogleAppsScript.Spreadsheet.Range): Slicer;
        setTitle(title: string): Slicer;
        setTitleHorizontalAlignment(horizontalAlignment: string): Slicer;
        setTitleTextStyle(
            textStyle: GoogleAppsScript.Spreadsheet.TextStyle,
        ): Slicer;
    }
    Index

    Methods

    getBackgroundColor getColumnPosition getContainerInfo getFilterCriteria getRange getTitle getTitleHorizontalAlignment getTitleTextStyle isAppliedToPivotTables remove setApplyToPivotTables setBackgroundColor setColumnFilterCriteria setPosition setRange setTitle setTitleHorizontalAlignment setTitleTextStyle

    Methods

    Settings
    Member Visibility

    On This Page
    Methods