# Formula Settings Imported

Learn how Spread handles cell settings and formula imports from Excel in this comprehensive guide.

## Content

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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) class unless specifically noted otherwise. They are also members of the [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html) class and [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html) 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.ColumnHeaderAutoText.html) 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](https://developer.mescius.com/spreadnet/docs/latest/online-formula/overview.html). |
| 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.MaximumChange.html) | 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](https://developer.mescius.com/spreadnet/docs/latest/online-formula/overview.html). 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](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-cell).

## See Also

[Workbook Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-workbk)
[Chart Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-chart)
[Sheet Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-sheet)
[Row and Column Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-rowcol)
[Cell Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-cell)
[Border Styles Substituted](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-border)
[Print Settings Imported](/spreadnet/docs/latest/online-win/overview/spwin-impexpref/spwin-excelimport/spwin-excelimport-print)