Style of displaying default row header column Note - This does not affect how formulas are resolved
HeaderTextStyle.One
// TODO - allow a function callback (but this won't be persisted)
The drawing selection
The freeze panes.
The color of the gridline on the sheet.
null (adopts the app theme color)
gridLine color is a sheet view attribute but in Excel is a workbook attribute. If null then use the app theme
Style of displaying default row header text Note - This does not affect how formulas are resolved
HeaderTextStyle.A1
// TODO - allow a function callback (but this won't be persisted)
The current cell selection for the sheet.
Show/Hide column gridlines.
true;
Show/Hide columns headers.
true;
Indicate if view is showing formulas or values
false
Show/Hide row gridlines.
true;
Show/Hide row headers.
true;
Indicate whether the sheet should show 0 (zero) or blanks in cells containing zero values.
true
When false, cells with zero value appear blank instead of showing the number zero.
The default top left corner accounting for scrolling.
Zoom. This is expressed as a percentage. Values can be between 10 (10%) or 400 (400%)
100
// TODO - support zoomScaleNormal, zoomScalePageLayout, zoomScaleSheetLayoutView,
Add a listener. This is very similar to default javascript listeners except the offer a few additional options and there is no remove listener.
These add listeners return a function that can be called to remove the listener. Additionally they honor transactional boundaries.
Listeners are fired in the order that they are added.
Optional options: ListenerOptionsAdd a drawing to the selection.
Optional addToSelection: booleanReturns the drawing from the selection.
View settings for a single sheet. Sheets Views in Excel have sheetViews and CustomSheetViews
TODO/Note - Excel has lots of SheetViews concepts. It seems to be due to evolution SheetView - Supports an unnamed list but only the first view seems to be used. This has embedded panes
customWorkbookViews/customSheetViews - Names for SheetViews is managed as the customWorkbookViews level but creates a point via guid to customSheetViews. These are subclasses of sheetView that add hiddenColumns/hiddenRows and filters And ExcelOnline views (365 SheetViews)
Note - We allow a sheet to contain one ISheetModel. All remaining sheetViews must be managed somewhere else. We allow Workbooks to manage sheetViews