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