| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types.SheetViews
- data SheetView = SheetView {
- _sheetViewColorId :: Maybe Int
- _sheetViewDefaultGridColor :: Maybe Bool
- _sheetViewRightToLeft :: Maybe Bool
- _sheetViewShowFormulas :: Maybe Bool
- _sheetViewShowGridLines :: Maybe Bool
- _sheetViewShowOutlineSymbols :: Maybe Bool
- _sheetViewShowRowColHeaders :: Maybe Bool
- _sheetViewShowRuler :: Maybe Bool
- _sheetViewShowWhiteSpace :: Maybe Bool
- _sheetViewShowZeros :: Maybe Bool
- _sheetViewTabSelected :: Maybe Bool
- _sheetViewTopLeftCell :: Maybe CellRef
- _sheetViewType :: Maybe SheetViewType
- _sheetViewWindowProtection :: Maybe Bool
- _sheetViewWorkbookViewId :: Int
- _sheetViewZoomScale :: Maybe Int
- _sheetViewZoomScaleNormal :: Maybe Int
- _sheetViewZoomScalePageLayoutView :: Maybe Int
- _sheetViewZoomScaleSheetLayoutView :: Maybe Int
- _sheetViewPane :: Maybe Pane
- _sheetViewSelection :: [Selection]
- data Selection = Selection {}
- data Pane = Pane {}
- data SheetViewType
- data PaneType
- data PaneState
- renderSheetViews :: [SheetView] -> Node
- sheetViewColorId :: Lens' SheetView (Maybe Int)
- sheetViewDefaultGridColor :: Lens' SheetView (Maybe Bool)
- sheetViewRightToLeft :: Lens' SheetView (Maybe Bool)
- sheetViewShowFormulas :: Lens' SheetView (Maybe Bool)
- sheetViewShowGridLines :: Lens' SheetView (Maybe Bool)
- sheetViewShowOutlineSymbols :: Lens' SheetView (Maybe Bool)
- sheetViewShowRowColHeaders :: Lens' SheetView (Maybe Bool)
- sheetViewShowRuler :: Lens' SheetView (Maybe Bool)
- sheetViewShowWhiteSpace :: Lens' SheetView (Maybe Bool)
- sheetViewShowZeros :: Lens' SheetView (Maybe Bool)
- sheetViewTabSelected :: Lens' SheetView (Maybe Bool)
- sheetViewTopLeftCell :: Lens' SheetView (Maybe CellRef)
- sheetViewType :: Lens' SheetView (Maybe SheetViewType)
- sheetViewWindowProtection :: Lens' SheetView (Maybe Bool)
- sheetViewWorkbookViewId :: Lens' SheetView Int
- sheetViewZoomScale :: Lens' SheetView (Maybe Int)
- sheetViewZoomScaleNormal :: Lens' SheetView (Maybe Int)
- sheetViewZoomScalePageLayoutView :: Lens' SheetView (Maybe Int)
- sheetViewZoomScaleSheetLayoutView :: Lens' SheetView (Maybe Int)
- sheetViewPane :: Lens' SheetView (Maybe Pane)
- sheetViewSelection :: Lens' SheetView [Selection]
- selectionActiveCell :: Lens' Selection (Maybe CellRef)
- selectionActiveCellId :: Lens' Selection (Maybe Int)
- selectionPane :: Lens' Selection (Maybe PaneType)
- selectionSqref :: Lens' Selection (Maybe [CellRef])
- paneActivePane :: Lens' Pane (Maybe PaneType)
- paneState :: Lens' Pane (Maybe PaneState)
- paneTopLeftCell :: Lens' Pane (Maybe CellRef)
- paneXSplit :: Lens' Pane (Maybe Double)
- paneYSplit :: Lens' Pane (Maybe Double)
Structured type to construct SheetViews
Worksheet view
A single sheet view definition. When more than one sheet view is defined in the file, it means that when opening the workbook, each sheet view corresponds to a separate window within the spreadsheet application, where each window is showing the particular sheet containing the same workbookViewId value, the last sheetView definition is loaded, and the others are discarded. When multiple windows are viewing the same sheet, multiple sheetView elements (with corresponding workbookView entries) are saved.
TODO: The pivotSelection and extLst child elements are unsupported.
See Section 18.3.1.87 "sheetView (Worksheet View)" (p. 1880)
Constructors
| SheetView | |
Fields
| |
Worksheet view selection.
Section 18.3.1.78 "selection (Selection)" (p. 1864)
Constructors
| Selection | |
Fields
| |
Worksheet view pane
Section 18.3.1.66 "pane (View Pane)" (p. 1843)
Constructors
| Pane | |
Fields
| |
data SheetViewType Source
View setting of the sheet
Section 18.18.69 "ST_SheetViewType (Sheet View Type)" (p. 2726)
Constructors
| SheetViewTypeNormal | Normal view |
| SheetViewTypePageBreakPreview | Page break preview |
| SheetViewTypePageLayout | Page layout view |
Instances
| Eq SheetViewType Source | |
| Ord SheetViewType Source | |
| Show SheetViewType Source | |
| ToAttrVal SheetViewType Source | See |
| FromAttrVal SheetViewType Source | See |
Pane type
Section 18.18.52 "ST_Pane (Pane Types)" (p. 2710)
Constructors
| PaneTypeBottomLeft | Bottom left pane, when both vertical and horizontal splits are applied. This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the bottom pane. |
| PaneTypeBottomRight | |
| PaneTypeTopLeft | Top left pane, when both vertical and horizontal splits are applied. This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the top pane. This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the left pane |
| PaneTypeTopRight | Top right pane, when both vertical and horizontal splits are applied. This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the right pane. |
State of the sheet's pane.
Section 18.18.53 "ST_PaneState (Pane State)" (p. 2711)
Constructors
| PaneStateFrozen | Panes are frozen, but were not split being frozen. In this state, when the panes are unfrozen again, a single pane results, with no split. In this state, the split bars are not adjustable. |
| PaneStateFrozenSplit | Panes are frozen and were split before being frozen. In this state, when the panes are unfrozen again, the split remains, but is adjustable. |
| PaneStateSplit | Panes are split, but not frozen. In this state, the split bars are adjustable by the user. |
renderSheetViews :: [SheetView] -> Node Source
Render sheet views
The list should be non-empty to be conform to the spec.
See Section 18.3.1.88 "sheetViews (Sheet Views)" (p. 1704)