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.