[]
        
(Showing Draft Content)

GC.Spread.CalcEngine

Namespace: CalcEngine

GC.Spread.CalcEngine

Table of contents

Namespaces

Enumerations

Classes

Variables

Variables

ExcelCompatibleCalcMode

ExcelCompatibleCalcMode: boolean

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.

example

GC.Spread.CalcEngine.ExcelCompatibleCalcMode = true;