This table summarizes how the cell settings related to formulas are handled when SpreadJS imports data from an Excel file. The properties are members of the Cell class unless specifically noted otherwise.
| 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. |