Deprecated documentation 2.1

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.

Changed API

• 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 cells
• setValue() -> spreadsheet.setValue() - sets value for a cell or a range of cells
• lock() -> spreadsheet.lock() - locks a cell or a range of cells
• unlock() -> spreadsheet.unlock() - unlocks a locked cell or a range of cells

Removed API

Spreadsheet class

• getCell()
• getCells()
• isCell()
• setSheetId()

SpreadsheetCell

• calculate()
• exists()
• getAlign()
• getBgColor()
• getCalculatedValue()
• getColIndex()
• getColName()
• getColor()
• getCoords()
• getValidator()
• isBold()
• isIncorrect()
• isItalic()
• parseStyle()
• serializeStyle()
• setAlign()
• setBgColor()
• setBold()
• setColor()
• setItalic()
• setLocked()
• setValidator()