Formula Settings Imported

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.