- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Import and Export Reference
- Formula Reference
- Frequently Used Events
- API Documentation
- Release Notes
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 reference style | If Excel’s reference style is R1C1, when Spread imports the spreadsheet, the | |
Formulas | Formulas are imported from Excel into SpreadJS. “Cell references”, “Operators”, and “Functions” from Excel settings are also imported as part of the formula. | |
Hidden Formula | Imports Excel files with hidden formula cells. Note that hidden attributes do not affect the formulas accessed through the APIs. |