MenuOptions

Which entries of the cell and heading menus to keep, by id, in the order the editor has them; leave a list out to keep that menu whole. Keeping a submenu keeps all of it; keeping some of its entries keeps the submenu with just those. A plugin command is kept by pluginId/commandId. Separators between groups left empty are dropped, and a menu left empty doesn’t open.

An entry’s shortcut (Ctrl+C for Copy, Shift+F2 for a note) works while either menu keeps the entry, or shortcuts lists its id. Shortcuts with no entry, such as undo or save, aren’t changed.

Properties

Property	Type	Description
cell?	readonly MenuEntryId[]	The cell menu’s entries to keep.
header?	readonly MenuEntryId[]	The row and column headings’ menu’s entries to keep.
shortcuts?	readonly ( | "menu.cut" | "menu.copy" | "menu.paste" | "menu.pasteSpecial" | "menu.pasteValues" | "menu.pasteFormulas" | "menu.pasteFormats" | "menu.pasteTransposed" | "menu.fillDrag" | "menu.fillDown" | "menu.fillRight" | "menu.newNote" | "menu.editNote" | "menu.deleteNote" | "menu.newComment" | "menu.showComments" | "menu.deleteThread" | "menu.insertCells" | "menu.deleteCells" | "menu.columnWidth" | "menu.autofitColumnWidth" | "menu.rowHeight" | "menu.autofitRowHeight" | "menu.rows" | "menu.columns" | "menu.freeze" | "menu.unhideRows" | "menu.unhideColumns" | "menu.freezePanes" | "menu.freezeTopRow" | "menu.freezeFirstColumn" | "menu.unfreeze" | "menu.merge" | "menu.unmerge" | "menu.sortAscending" | "menu.sortDescending" | "menu.filter" | "menu.filterOn" | "menu.clearFilter" | "menu.find" | "pivot.menu.refresh" | "pivot.menu.refreshAll" | "pivot.menu.insert" | "pivot.menu.fieldList" | "core.chartType.bar" | "core.chartType.column" | "core.chartType.line" | "core.chartType.pie" | "core.chartType.doughnut" | "core.chartType.area" | "core.chartType.scatter" | "charts.menu.insert" | "cf.menu" | "cf.menu.gallery" | "cf.menu.clearSelection" | "cf.menu.clearSheet" | "cf.menu.manage" | "cf.quick.greaterThan" | "cf.quick.lessThan" | "cf.quick.between" | "cf.quick.equal" | "cf.quick.textContains" | "cf.quick.duplicate" | "cf.quick.top" | "cf.quick.topPercent" | "cf.quick.bottom" | "cf.quick.bottomPercent" | "cf.quick.aboveAverage" | "cf.quick.belowAverage" | "cf.quick.formula" | "validation.menu" | "sort.menu.custom" | "outline.menu.groupRows" | "outline.menu.groupColumns" | "outline.menu.ungroupRows" | "outline.menu.ungroupColumns" | "outline.menu.hideDetail" | "outline.menu.showDetail" | "outline.menu.showLevel" | "outline.menu.clearRows" | "outline.menu.clearColumns" | "fill.menu.series" | "links.menu.open" | "links.menu.link" | "links.menu.insert" | "links.menu.edit" | "names.menu.define" | "names.menu.manager" | "menu.insertRowsAbove" | "menu.insertRowsBelow" | "menu.deleteRows" | "menu.hideRows" | "menu.insertColumnsLeft" | "menu.insertColumnsRight" | "menu.deleteColumns" | "menu.hideColumns" | "links.menu.remove")[]	Entries whose shortcuts stay on although neither menu keeps them.