SpreadJS 13
SpreadJS Documentation / Developer's Guide / Get Started / API Changes / Worksheet API Changes
In This Topic
    Worksheet API Changes
    In This Topic

    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)