Work with Functions

Starting from v4.0, the package of dhtmlxSpreadSheet includes a set of predefined formulas that can be used for different types of calculations of strings and numbers. The formulas are compatible with Excel and Google Sheets.

Related sample:  Formulas cheat sheet - DHTMLX Spreadsheet


Here's a list of all the available functions with detailed descriptions.

Math functions

String functions

Getting cell formula

Starting with v4.1, you can get the formula applied to a cell via the getFormula() method. The method takes the id of the cell as a parameter:

var formula = spreadsheet.getFormula("B2");
// -> "ABS(C2)"
Back to top