# Formula Settings Imported

## Content

This table summarizes how the cell settings related to formulas are handled when SpreadJS imports data from an Excel file.

| **Excel Setting** | **SpreadJS Setting** | **Remarks** |
| ------------- | ---------------- | ------- |
| Cell reference style | [referenceStyle](/spreadjs/api/v17/enums/GC.Spread.Sheets.ReferenceStyle) | 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 | [CellRange.formula](/spreadjs/api/v17/classes/GC.Spread.Sheets.CellRange#formula) | Formulas are imported from Excel into SpreadJS.<br>“Cell references”, “Operators”, and “Functions” from Excel settings are also imported as part of the formula. |
| Hidden Formula | [Style.hidden](/spreadjs/api/v17/classes/GC.Spread.Sheets.Style#hidden)<br>[CellRange.hidden](/spreadjs/api/v17/classes/GC.Spread.Sheets.CellRange#hidden) | Imports Excel files with hidden formula cells. <br>Note that hidden attributes do not affect the formulas accessed through the APIs. |