次の表は、ワークシートに関する変更点の一覧を示します。
| V10 | 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() // ワークブックオプションに移動 | |
| getDeletedRows() | getDeleteRows() |