SheetXL - v0.3.20
    Preparing search index...

    Interface Properties

    A set of values that can be set on a ISheetView.

    ISheetView

    interface Properties {
        columnHeaderStyle?: HeaderTextStyle;
        freezePanes?: FreezePanes;
        gridLineColor?: string | IColor;
        rowHeaderStyle?: HeaderTextStyle;
        selection?: SelectionCoords;
        showColumnGridlines?: boolean;
        showColumnHeaders?: boolean;
        showFormulas?: boolean;
        showRowGridlines?: boolean;
        showRowHeaders?: boolean;
        showZeros?: boolean;
        topLeft?: Partial<TopLeft>;
        zoomScale?: number;
    }
    Index

    Properties

    columnHeaderStyle? freezePanes? gridLineColor? rowHeaderStyle? selection? showColumnGridlines? showColumnHeaders? showFormulas? showRowGridlines? showRowHeaders? showZeros? topLeft? zoomScale?

    Properties

    columnHeaderStyle?: HeaderTextStyle

    Style of displaying default row header column Note - This does not affect how formulas are resolved

    freezePanes?: FreezePanes

    The freeze panes.

    gridLineColor?: string | IColor

    The color of the gridline on the sheet.

    GridLine color is a sheet view attribute but in Excel is a workbook attribute. If null then use the app theme.

    rowHeaderStyle?: HeaderTextStyle

    Style of displaying default row header text Note - This does not affect how formulas are resolved

    selection?: SelectionCoords

    The selection coords.

    showColumnGridlines?: boolean

    Show/Hide column gridlines.

    showColumnHeaders?: boolean

    Show/Hide columns headers.

    showFormulas?: boolean

    Indicate if view is showing formulas or values

    showRowGridlines?: boolean

    Show/Hide row gridlines.

    showRowHeaders?: boolean

    Show/Hide row headers.

    showZeros?: boolean

    Indicate whether the sheet should show 0 (zero) or blanks in cells containing zero values.

    When false, cells with zero value appear blank instead of showing the number zero.

    topLeft?: Partial<TopLeft>

    The default top left corner accounting for scrolling.

    zoomScale?: number

    Zoom. This is expressed as a percentage. Values can be between 10 (10%) or 400 (400%).

    Settings

    Member Visibility

    On This Page

    Properties