@jsfkit/types
    Preparing search index...

    Type Alias CalcProps

    Directions on how formulas should be recalculated in the workbook.

    type CalcProps = {
        calcMode?: "auto" | "autoNoTable" | "manual";
        epoch?: 1900 | 1904;
        iterate?: boolean;
        iterateCount?: integer;
        iterateDelta?: number;
    }
    Index

    Properties

    calcMode? epoch? iterate? iterateCount? iterateDelta?

    Properties

    calcMode?: "auto" | "autoNoTable" | "manual"

    The calculation mode for the workbook.

    • "auto" (default when absent): recalculate all formulas automatically.
    • "autoNoTable": recalculate automatically but exclude data tables.
    • "manual": formulas are only recalculated when explicitly triggered.
    "auto"
    epoch?: 1900 | 1904

    Which of the two date systems the workbook uses. 1900 is the default.

    Date systems in Excel

    iterate?: boolean

    Specifies whether an attempt should be made to calculate formulas that contain circular references. Defaults to false in Excel.

    iterateCount?: integer

    The maximum number of calculation iterations, when CalcProps.iterate is true. Defaults to 100 in Excel.

    iterateDelta?: number

    When a calculation iteration results in an absolute change that is less than iterateDelta, then no further iterations should be attempted. Defaults to 0.001 in Excel.

    Settings

    Member Visibility

    On This Page

    Properties