DHTMLX Spreadsheet 5.2

Released on May 20, 2025

Review of release on the blog

Breaking changes

The new release introduces some changes to the freezing/unfreezing functionality for columns and rows. Check the Migration guide to keep in step with the latest version.

Deprecated

• The leftSplit and topSplit configuration properties are removed

New functionality

• Editing cells:
  • the ability to create a styled border for a group of cells via UI
• Freezing/unfreezing columns/rows:
  • the ability to freeze/unfreeze columns and rows via UI
  • the ability to freeze/unfreeze columns and rows via API
    • new methods: freezeCols(), unfreezeCols(), freezeRows(), unfreezeRows()
    • new action: toggleFreeze
    • new freeze property for the sheets object of the parse() method
• Hiding/showing columns/rows:
  • the ability to hide/show columns and rows via UI
  • the ability to hide/show columns and rows via API
    • new methods: hideCols(), showCols(), hideRows(), showRows()
    • new action: toggleVisibility
    • new hidden property for the cols and rows configs of the sheets object of the parse() method
• Working with formulas:
  • popup with descriptions for formulas is added
  • new locale: formulas is added
• File import:
  • new afterDataLoaded event is added to indicate that data loading into Spreadsheet has been completed