SpreadJS 14
GC.Spread.CalcEngine Namespace / ExcelCompatibleCalcMode type
In This Topic
    ExcelCompatibleCalcMode type
    In This Topic
    Gets or Sets the Excel Compatible Mode for CalcEngine. Default value is FALSE. When ExcelCompatibleCalcMode disabled, SpreadJS will auto convert text to number for calculation. When ExcelCompatibleCalcMode enabled, treated the text differently when provided as argument directly or in array / reference. For example, A1 is text value "1", SUM(A1, 1) will be 2 if disabled, and 1 if enabled.
    Inheritance Hierarchy

    Object
       GC.Spread.CalcEngine.ExcelCompatibleCalcMode

    See Also