# 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 references |   | SpreadJS 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 SpreadJS. When the import encounters a cell that contains a formula or function, the corresponding cell in SpreadJS 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 |   | SpreadJS imports Excel operators. See the Formula remarks in this table. |
| Functions |   | SpreadJS 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. |