Deprecated documentation 2.1

note

The API of version 2.1 described in the deprecated documentation is still available, but it is incompatible with the API starting from version 3.0.

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()