We are happy to introduce a new version of our JavaScript/PHP spreadsheet widget, dhtmlxSpreadsheet 2.0. This update adds a lot of new features and improvements, including cell validation, the ability to lock cells, Undo/Redo operations, and more.
Data Validation
New version supports data validation in cells. It allows you to define the cell type and use its parameters to validate entered values. Supported cell types include: number, email, positive, or not empty. When a user types an incorrect value into a cell, a red triangle appears in the upper-right corner of the cell, indicating that the value should be corrected.
Lock/Unlock Cells
We have added the ability to lock cells to prevent them from being changed. You can easily lock/unlock individual cells using the context menu.
6 comments » 