In This Topic

Formula Settings Imported

In This Topic

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. |