DHTMLX Spreadsheet 5.1

Released on December 7, 2023

Review of release on the blog

New functionality

• Support for new themes: Dark, Light High Contrast and Dark High Contrast
• Extended support for number, date, time and currency format localization
• Integration with the Svelte framework
• Ability to provide a custom name for an exported .xlsx file
• Ability to save the "locked" cell status and specify a link for a cell in a data set

Updates

• Renewed integrations with React, Angular and Vue.js
• Automatic conversion of lowercase letters to upper case in formulas
• Auto closing of formulas

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

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