This table summarizes how the cell settings related to formulas are handled when Spread.Sheets imports data from an Excel file.
| Excel Setting |
Spread.Sheets Setting |
Remarks |
| Cell references |
|
Spread.Sheets 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 Spread.Sheets. When the import encounters a cell that contains a formula or function, the corresponding cell in Spread.Sheets 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 |
|
Spread.Sheets imports Excel operators. See the Formula remarks in this table. |
| Functions |
|
Spread.Sheets 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. |