SpreadJS 13
SpreadJS Documentation / Import and Export Reference / Excel-Formatted Files Import / Formula Settings Imported
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.