What's New

Version 4.1.3

Released on August 31, 2021

Fixes

  • Fix the incorrect behavior of the undo operation when reverting the row/column after its removing
  • Fix the incorrect work of the "mask" property specified in the number format object
  • Fix the issue which caused empty cells/rows at the top of the selection to be trimmed after pasting the data from Excel to the spreadsheet
  • Fix the issue which caused the cells the absolute formula refers to not being marked
  • Fix the issue with the "afterSelectionSet" event which caused the event to occur twice after a range of cells is selected
  • Fix the issue with TypeScript definitions
  • Fix the issues with the "text" number format

Version 4.1.2

Released on June 3, 2021

Fixes

  • Fix the incorrect auto-filling of the cells that contain math functions when applying auto-filling to several columns at once
  • Fix the issue that caused the selected cell not to become unselected after the next click on this cell using "Ctrl + Click"
  • Fix the issue with applying the math formula to the cell after choosing the formula with the help of key navigation
  • Fix the issue with locking/unlocking the cells if they are selected using "Ctrl + Click"
  • Fix the issue with the "serialize()" method that caused "0" values not to be serialized
  • Fix the issue with the auto adjustment of the width of the column after clicking on the header border between the columns
  • Fix the issue with the display of zero values in the edit line
  • Fix the issue with the editing of long content of the cell
  • Fix the issue with the export of the spreadsheet into the Excel file
  • Fix the issues with incorrect behavior of the horizontal scrollbar and display of columns when working with the spreadsheet that contains a lot of columns
  • Fix the script error that appears after using key navigation in the empty spreadsheet

Version 4.1.1

Released on April 14, 2021

Fixes

  • Fix the issue with TypeScript definitions
  • Fix the issues with absolute references
  • Fix the issues appeared when working with data loaded from the file with the ".xlsx" extension
  • Fix the issue with incorrect pasting of the data copied from the Excel file
  • Fix the issue that caused the wrong result to return when summing float numbers

Version 4.1

Released on March 24, 2021

New functionality

Updates

Version 4.0.5

Released on February 3, 2021

Fixes

  • Fix the performance issue
  • Fix the script error that happened when the user reverted the latest action in the cell
  • Fix the script error thrown after calling the destructor
  • Fix the issue that caused values from a range of cell to be truncated after inserting into a single cell
  • Fix the issue with recognition of the format of a cell after the cell is cut and then pasted for a second time

Version 4.0.4

Released on January 12, 2021

Fixes

  • Fix the incorrect work of the "SUM" function when working with more than 2 numbers
  • Fix the issue with initialization of the spreadsheet after calling "destructor()"
  • Fix the issue with types

Version 4.0.3

Released on December 28, 2020

Fixes

  • Fix the issue with setting the format for the value of a cell within a data set
  • Fix the error that occurred when attaching the spreadsheet to the layout
  • Fix the issue which caused the formula set for a cell not being edited after the result was calculated
  • Fix the incorrect work of the setFocusedCell() method
  • Fix the incorrect behavior of focus when working with formulas
  • Fix the issue with selecting a range of cells using the "ctrl" key
  • Fix the issue with adding a range of cells via "ctrl+click" to a cell with a formula
  • Fix the incorrect work of Math functions
  • Fix the issue with the SUM() formula when selecting it via the popup and a mouse click

Version 4.0.2

Released on December 21, 2020

Fixes

  • Fix the incorrect behavior of key navigation when creating 2 or more spreadsheet objects on the page
  • Fix the issue with the error thrown from the types.d.ts file
  • Fix issues with copying and pasting a range of cells

Version 4.0.1

Released on December 2, 2020

Fixes

  • The incorrect displaying of the tooltips when hovering over the Undo/Redo buttons in the toolbar
  • The issue which happened when removing the last column of the spreadsheet after importing the data bigger than the size of the spreadsheet
  • The issue with the setSelectedCell() method which caused the formula of the selected cell not to be shown in the formula bar
  • The incorrect generation of the typescript definitions
  • The visual issue with the alignment of the cell content
  • The issue with serializing of empty cells or cells with zero value

Version 4.0

Released on October 19, 2020

New functionality

Fixes

  • Fix the incorrect work of the colorpicker when applying the background color to the range of cells
  • Fix the incorrect parsing of numbers when importing Excel files
  • Fix the issue which caused all data copied from a Google or Excel table to be inserted into one cell of the spreadsheet
  • Fix the incorrect work of the editLine:false property that caused the edit operation to finish with an error in the console
  • Fix the issue with the AfterValueChange event which caused the event to be called twice

Version 3.1.4

Released on September 19, 2019

Fixes

  • Styles fixes

Version 3.1.3

Released on September 19, 2019

Fixes

  • Issue with focus on a cell when Spreadsheet is attached to Layout

Version 3.1.2

Released on March 25, 2019

Fixes

  • Issues with text styles in Excel export
  • Issue with underlining right-aligned text

Version 3.1.1

Released on March 25, 2019

Fixes

  • Issues with export to Excel

Version 3.1

Released on March 21, 2019

New functionality

Updates

Fixes

  • Issues with hotkeys on the active cell

Version 3.0.3

Released on December 13, 2018

Fixes

  • Incorrect behavior in the custom read-only mode
  • Issues with methods of removing a column/row
  • Issues with loss of focus on the edit line
  • Issues with hotkeys on the active cell

Version 3.0.2

Released on December 6, 2018

Fixes

  • Issues with hotkeys behavior
  • Issues with placement of the selection handle
  • Issues with loss of focus on the active cell
  • Incorrect behavior of selection on the active cell
  • Incorrect behavior of hotkeys on the active cell
  • Incorrect behavior of scrolling by arrow keys

Version 3.0.1

Released on November 8, 2018

Fixes

  • Incorrect behavior of the undo operation
  • Incorrect behavior of the cut-paste operation on a group of cells

Version 3.0

Released on October 25, 2018

Breaking change

API of the version 3.0 is not compatible with API v2.1.

In comparison to the previous PHP-based version, dhtmlxSpreadSheet of version 3.0 is a completely client-side JavaScript component.

Check the Migration article to get information about the usage of new API. If you feel like keep using the previous version for a while, the documentation for dhtmlxSpreadSheet v2.1 is still available.

New functionality

The API of SpreadSheet has been changed and became more handy to work with. One more significant update is the total redesign of the component which gave a modern look to the interface of SpreadSheet. Together with the fresh appearance the usability of dhtmlxSpreadSheet is greatly enhanced.

Back to top