DHTMLX Spreadsheet 5.0

Released on November 21, 2022

Review of release on the blog

Breaking changes

The new release introduces some changes to the toolbarBlocks property. Check the Migration article to keep in step with the latest version.

New functionality

• Data search:
  • the ability to search for data via UI
  • the ability to search for data via API:
    • new methods: search() and hideSearch()
• Filtering data
  • the ability to filter data via UI
  • the ability to filter data via API:
    • new methods: setFilter() and getFilter()
    • new action: filter
• Merging/splitting cells:
  • the ability to merge/split cells via UI
  • the ability to merge/split cells via API:
    • new property of the sheet object : merged
    • new method: mergeCells()
    • new actions: merge and unmerge
• AutoFit column width:
  • the ability to autofit column width via UI
  • the ability to autofit column width via API:
    • new method: fitColumn()
    • new action: fitColumn
• Inserting a hyperlink:
  • the ability to insert a hyperlink into a cell via UI
  • the ability to insert a hyperlink into a cell via API:
    • new method: insertLink()
    • new action: insertLink
• Strikethrough format of data

Updates

• Extended list of locale options
• Extended list of hotkey combinations:
  • for data search
    • Ctrl (Cmd) + F
    • Ctrl (Cmd) + G
    • Ctrl (Cmd) + Shift + G
  • for selecting the whole column/row
    • Ctrl (Cmd) + Space
    • Shift + Space
  • for aligning the content of a cell left/right/center
    • Ctrl (Cmd) + Shift + L
    • Ctrl (Cmd) + Shift + R
    • Ctrl (Cmd) + Shift + E
  • for crossing out the content of a cell
    • Alt + Shift + 5 (Cmd + Shift + X)
  • for adding new sheets and switching between them
    • Shift + F11
    • Alt + Arrow Up/ Arrow Down
  • for inserting a hyperlink in a cell
    • Ctrl (Cmd) + K