SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface ColumnProperties

    interface ColumnProperties {
        calculatedColumnFormula?: string;
        id?: string;
        name: string;
        totalsRowFormula?: string | number;
        totalsRowLabel?: string;
    }

    Hierarchy (View Summary)

    Index
    calculatedColumnFormula? id? name totalsRowFormula? totalsRowLabel?
    calculatedColumnFormula?: string

    The formula a calculated column gives its rows, without its leading =, as it reads in the column's first body row.

    ITable.IColumn.getCalculatedFormula

    id?: string

    The unique ID of the column.

    name: string

    A string representing the unique caption of the table column. This is what shall be displayed in the header row in the UI, and is referenced through functions. This name shall be unique per table.

    totalsRowFormula?: string | number

    What this column totals: a SUBTOTAL function number (101 to 110; 109 is sum) that totals this column, or a formula without its leading =.

    ITable.IColumn.setTotalsRowFormula

    totalsRowLabel?: string

    The text shown in the totals row for this column. A column with a totalsRowFormula shows that instead.

    Settings
    Member Visibility

    On This Page
    Properties