Add Listeners.
Optionaloptions: IListener.OptionsReturns the chart element selection: the elements selected inside the chart whose movable is the active selected one.
Held beside the movable selection and following it: selecting an element selects its chart's movable, and the selection empties when the movable selection moves on. Empty while no chart element is selected: a selected chart with no element selected is the chart itself.
Identifies this view.
Returns the movable selection: the drawings selected on the sheet.
Held beside the range selection, independently of it.
Return the next zoom scale based on current zoom.
A flag to indicate if zooming in true or out false.
Optionalamount: number
The amount to zoom by. If not provided the default steps will be used.
Returns a range selection.
The first VISIBLE cell — the cell sitting at the grid's top-left corner right now. A1 when
un-scrolled.
The cell-coordinate reading of getTopLeft (which is base px), resolved against the row /
column headers. Freeze-aware per axis: a frozen band is what actually occupies the corner, so on a
frozen axis the FROZEN pane's own scroll (IWorksheetView.FreezePanes.topLeft) answers — normally
leaving that axis at the sheet's start — while an unfrozen axis reads the main scroll. This is the
same split the xlsx writer emits as sheetView@topLeftCell / pane@topLeftCell.
Note this is the view's own scroll state, not a rendered measurement; a renderer mid-animation may briefly show something else.
Style of displaying default column header text.
Controls when the sheet's column headers display table column names.
Style of displaying default row header text.
Indicate whether cells whose value fails a data validation are marked.
The sheet's counterpart of Excel's Circle Invalid Data, except that the marks follow the values as they change. A cell is marked when its value fails any data validation covering it; a list cell is marked only when its value is not on the list. Not written to xlsx, where Excel keeps no such setting.
Indicate whether the cells that sheet protection locks are shaded, leaving the ranges that stay editable clear.
Indicate whether the outline symbols (the brackets, the collapse and expand buttons and the level buttons of the row and column groups) are shown.
Indicate whether the margins between pages are shown in page layout.
How the sheet is shown: as the grid, with its page breaks over it, or as printed pages.
Zoom. This is expressed as a percentage. Values can be between 10 (10%) or 400 (400%).
The zoom of the current view mode. Each mode keeps its own, as in Excel.
Persist to JSON.
Allow for a bulk update of the view properties.
Zoom in the view.
Zoom out the view.
The
IWorksheetViewprovides properties and methods for controlling how a sheet is displayed and interacted with, without affecting the underlying data itself.View settings include aspects like frozen panes, zoom level, selection, gridlines visibility, and whether formulas are displayed. but do not affect the underlying data itself.
Remarks