| sidebar_label | Deprecated documentation 2.1 |
|---|---|
| title | Deprecated documentation |
| description | You can learn about deprecated documentation 2.1 of the DHTMLX JavaScript Spreadsheet library. Please, use the updated documentation. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet. |
:::info The API of version 2.1 is still available, but it is incompatible with the API starting from version 3.0. If you require the documentation for version 2.1, please contact us, and we will send it to you. :::
This list of changes will help you to migrate from the version 2.1 where DHTMLX Spreadsheet was PHP-based, to the totally renewed version 3.0, in which the component is totally built on JavaScript. Check the list below to explore all the changes.
getStyle()->spreadsheet.getStyle()- returns styles applied to a cell(s)getValue()->spreadsheet.getValue()- returns an object with the value(s) of a cell(s)setStyle()->spreadsheet.setStyle()- sets style for a cell or a range of cellssetValue()->spreadsheet.setValue()- sets value for a cell or a range of cellslock()->spreadsheet.lock()- locks a cell or a range of cellsunlock()->spreadsheet.unlock()- unlocks a locked cell or a range of cells
getCell()getCells()isCell()setSheetId()
calculate()exists()getAlign()getBgColor()getCalculatedValue()getColIndex()getColName()getColor()getCoords()getValidator()isBold()isIncorrect()isItalic()parseStyle()serializeStyle()setAlign()setBgColor()setBold()setColor()setItalic()setLocked()setValidator()