- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- ReportSheet
- Data Charts
- 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
- Incremental Calculations
- Asynchronous Functions
- Calculating Formulas Outside Worksheets
- Language Package
- Serialization
- Keyboard Actions
- Shapes
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- AI Assistant
- SpreadJS Designer
- SpreadJS Designer Component
- SpreadJS Collaboration Server
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Language Package
SpreadJS supports the CalcEngine language package by providing different language packages that allow users to use functions and formulas in their own language. Each language in the language package contains localized functions that can be used for both simple and advanced calculations.
For example - The "SUM" function in the English language package is defined as the "SOMME" function in French Language Package.
Language Package allows users to work with SpreadJS in their preferred local language. Whenever you switch from one language package to another, all the words and phrases of formulas, functions, and table formula keywords will be translated to the desired language.
While working with spreadsheets, you can either choose from the list of 18+ available language packages in SpreadJS or you can create your own custom language package and use it as per your specific requirements.
For more information on using language packages, refer to the following topics: