导入表单的时候可以通过一些设置来控制是否要计算表单中的公式,默认情况下导入表单如果带有公式会重新计算,
- var jsonOptions = {
- ignoreFormula: true, // indicate to ignore style when convert json to workbook, default value is false
- ignoreStyle: true, // indicate to ignore the formula when convert json to workbook, default value is false
- frozenColumnsAsRowHeaders: true, // indicate to treat the frozen columns as row headers when convert json to workbook, default value is false
- frozenRowsAsColumnHeaders: true, // indicate to treat the frozen rows as column headers when convert json to workbook, default value is false
- doNotRecalculateAfterLoad: true // indicate to forbid recalculate after load the json, default value is false
- }
复制代码
doNotRecalculateAfterLoad 设置为true时,不重新计算公式
具体可参考:
https://demo.grapecity.com.cn/sp ... omJSONToJSON/purejs |