Formulas

SpreadJS supports built-in formulas, custom formulas, custom names, formula text box, array formulas and asynchronous functions. Users can insert formulas in cells, evaluate arithmetic expressions and return the resulting value in the cell as per their custom requirements and preferences. Users can also audit and debug formulas in the worksheet by keeping track of the precedent and dependent cells.

While using formulas in SpreadJS, you can also switch from one language to another by using the Available CalcEngine Language Packages For SpreadJS. The built-in language packages will help you work in your preferred local language by allowing you to localize CalcEngine function names, table function names, special function logic, CalcError names and boolean value resource. In case you want to work in any other language of your choice, you can create and use a custom language package.

For more information about working with formulas, refer to the following topics.

• Built-In Formulas

• Allow Users to Enter Formulas

• Create Custom Names

• Create Custom Formulas

• Formula Text Box

• Use Formula Text Box as a Control

• Formula Auditing

• Array Formulas

• Dynamic Array Formulas

• Asynchronous Functions

• Language Package

• Allow Users to Copy Formulas