[]
• 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;