DHTMLX Spreadsheet 4.3

Released on May 23, 2022

Breaking changes

Version 4.3 doesn't bring any breaking changes but introduces a new way of handling actions performed in the spreadsheet. Check the details in the Migration article.

New functionality

• The ability to add a drop-down list of options into the cells via the setValidation() method or via UI
• The ability to fix rows on the top of the spreadsheet via the topSplit property
• The ability to sort data via the sortCells() method or via UI
• The ability to split long text into multiple lines (Text wrapping button is added into the toolbar)
• Significantly extended list of supported Date, Financial, Math, String functions (marked with added in v4.3 label)
• Support for Lookup functions
• Time format is added
• The ability to define the format of times in the spreadsheet cells via the timeFormat property
• The ability to enter time in a cell via a time picker
• Export to JSON
• Import from JSON
• New events are added: beforeAction and afterAction
• New Actions system

Updates

• The parse() method is updated. New editor attribute of a cell object is added