Formula Settings Imported

This table summarizes how the cell settings related to formulas are handled when SpreadJS imports data from an Excel file.

Excel Setting	SpreadJS Setting	Remarks
Cell references		SpreadJS imports these from Excel as part of the formula. See the Formula remarks in this table.
Cell reference style		If Excel’s reference style is R1C1, when Spread imports the spreadsheet, the Sheet.setColumnHeaderAutoTest function is set to 1 (Display Numbers). See the Formula remarks in this table.
Formulas		Formulas are imported from Excel into SpreadJS. When the import encounters a cell that contains a formula or function, the corresponding cell in SpreadJS is set to the appropriate cell type. If the import encounters a cell with a formula that it does not support, the cell may be left empty or given an error value.
Operators		SpreadJS imports Excel operators. See the Formula remarks in this table.
Functions		SpreadJS supports many of the functions provided in Excel. If the import encounters a cell with a function that it does not support, the cell may be left empty or given a #NAME? error value. See the Formula remarks in this table.