Spread.Sheets Documentation
Worksheet API Changes
Spread.Sheets Documentation > Developer's Guide > Getting Started > API Changes > Worksheet API Changes

The following table lists the changes in the worksheet:

V11 V9
  activeRowViewportIndex
  activeColViewportIndex
  checkingChanges
  keyMap
  removeKeyMap(keyCode, ctrl, shift, alt, meta)
  addKeyMap(keyCode, ctrl:, shift, alt, meta, action)
suspendPaint()/resumePaint() isPaintSuspended(value)
name() getName()/setName()
options.allowCellOverflow allowCellOverflow(value)
  allowUndo(value)
  allowEditorReservedLocations(value)
options.sheetTabColor sheetTabColor(value)
options.frozenlineColor frozenlineColor(value)
options.clipBoardOptions clipBoardOptions(value)
options.gridline setGridlineOptions(options)/getGridlineOptions()
options.rowHeadervisible setRowHeaderVisible(visible)/getRowHeaderVisible()
options.colHeaderVisible setColumnHeaderVisible(visible)/getColumnHeaderVisible()
options.rowHeaderAutoText setRowHeaderAutoText(autoText)/getRowHeaderAutoText()
options.colHeaderAutoText setColumnHeaderAutoText(autoText)/getColumnHeaderAutoText()
options.rowHeaderAutoTextIndex setRowHeaderAutoTextIndex(autoTextIndex)/getRowHeaderAutoTextIndex()
options.colHeaderAutoTextIndex setColumnHeaderAutoTextIndex(autoTextIndex)/getColumnHeaderAutoTextIndex()
options.isProtected setIsProtected(isProtected)/getIsProtected()
options.protectionOptions protectionOption(value)
options.selectionBackColor selectionBackColor(value)
options.selectionBorderColor selectionBorderColor(value)
frozenColumnCount(colCount) setFrozenColumnCount(colCount)/getFrozenColumnCount()
frozenRowCount(rowCount) setFrozenRowCount(rowCount)/getFrozenRowCount()
frozenTrailingRowCount(rowCount) setFrozenTrailingRowCount(rowCount)/getFrozenTrailingRowCount()
frozenTrailingColumnCount(colCount) setFrozenTrailingColumnCount(colCount)/getFrozenTrailingColumnCount()
  undoManager()
  doCommand(action)
  referenceStyle()  //Moved to workbook options.
getDeletedRows() getDeleteRows()
setDataValidator(row, col, rowCount, colCount, value, sheetArea) setDataValidator(row, col, value)