This table summarizes how the cell settings related to formulas are handled when Spread imports data from an Excel file. The properties are members of the Cell class unless specifically noted otherwise. They are also members of the Column class and Row class if you needed to set the cells of an entire column or entire row.
| Excel Setting | Related Spread Property | Remarks |
|---|---|---|
| Cell references | Spread imports these from Excel as part of formulas. See the remarks on Formulas in this table. | |
| Cell reference style | If Excel’s reference style is R1C1, when Spread imports the spreadsheet, the ColumnHeaderAutoText property is set to 1 (Display Numbers). See the note on Formulas in this table. | |
| Formulas | Formulas are imported from Excel into Spread. When the import encounters a cell containing a formula or function, the corresponding cell in Spread 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. For more details on the functions in Spread, refer to the Formula Reference. | |
| Maximum number of iterations | Sets the value of the MaximumIterations property. See the note on Formulas in this table. | |
| Maximum change per iteration | SheetView.MaximumChange | Sets the value of the MaximumChange property. |
| Operators | Spread imports Excel operators. See the note on Formulas in this table. | |
| Functions | Spread supports many of the functions provided in Excel. A list of the functions Spread supports is in the Formula Reference. 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 note on Formulas in this table. | |
| User-defined function | Custom function feature | Spread imports custom functions as it does any function. |
For other cell-related settings, refer to Cell Settings Imported.
