- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
-
Formulas
- Built-In Formulas
- Allow Users to Enter Formulas
- Allow Invalid Formulas
- Set Formulas
- Calculation Mode
-
Show Cell Formulas
- Create Custom Names
- Create Custom Formulas
- Formula Text Box
- Use Formula Text Box as a Control
- Formula Editor Panel
- Formula Auditing
- Array Formulas
- Dynamic Array Formulas
- Asynchronous Functions
- Language Package
- Serialization
- Keyboard Actions
- Shapes
- Form Controls
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Show Cell Formulas
Users can view all the formulas in the cells and easily copy and paste these formulas between cells in a spreadsheet. SpreadJS provides the showFormulas property, which enables the user to see the formula in a cell. Once the formula is visible, it can be copied and pasted into any application.
The following code sample sets the options.showFormulas property.
// set showFormulas to true to enable users copy the formulas into other application
activeSheet.options.showFormulas = true;Limitations
The reference cells of the formula are not highlighted when the formula cell is selected.
The array formulas cannot be copied to Excel or SpreadJS correctly since the input array formula needs a Ctrl+Shift+Enter key combination.