[]
        
(Showing Draft Content)

Formula Settings Imported

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.