xlsx-1.1.2.2: Simple and incomplete Excel file parser/writer

Safe Haskell | Safe-Inferred
Language | Haskell2010

Codec.Xlsx.Types.SheetViews

Contents

- Structured type to construct `SheetViews`
- Lenses
  - SheetView
  - Selection
  - Pane

Synopsis

- 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 {
  - _selectionActiveCell :: Maybe CellRef
  - _selectionActiveCellId :: Maybe Int
  - _selectionPane :: Maybe PaneType
  - _selectionSqref :: Maybe SqRef
  }
- data Pane = Pane {
  - _paneActivePane :: Maybe PaneType
  - _paneState :: Maybe PaneState
  - _paneTopLeftCell :: Maybe CellRef
  - _paneXSplit :: Maybe Double
  - _paneYSplit :: Maybe Double
  }
- data SheetViewType
  - = SheetViewTypeNormal
  - | SheetViewTypePageBreakPreview
  - | SheetViewTypePageLayout
- data PaneType
  - = PaneTypeBottomLeft
  - | PaneTypeBottomRight
  - | PaneTypeTopLeft
  - | PaneTypeTopRight
- data PaneState
  - = PaneStateFrozen
  - | PaneStateFrozenSplit
  - | PaneStateSplit
- 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 SqRef)
- 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`

data SheetView Source #

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

- _sheetViewColorId :: Maybe Int

  Index to the color value for row/column text headings and gridlines. This is an 'index color value' (ICV) rather than rgb value.

- _sheetViewDefaultGridColor :: Maybe Bool

  Flag indicating that the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId.

- _sheetViewRightToLeft :: Maybe Bool

  Flag indicating whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.

- _sheetViewShowFormulas :: Maybe Bool

  Flag indicating whether this sheet should display formulas.

- _sheetViewShowGridLines :: Maybe Bool

  Flag indicating whether this sheet should display gridlines.

- _sheetViewShowOutlineSymbols :: Maybe Bool

  Flag indicating whether the sheet has outline symbols visible. This flag shall always override SheetPr element's outlinePr child element whose attribute is named showOutlineSymbols when there is a conflict.

- _sheetViewShowRowColHeaders :: Maybe Bool

  Flag indicating whether the sheet should display row and column headings.

- _sheetViewShowRuler :: Maybe Bool

  Show the ruler in Page Layout View.

- _sheetViewShowWhiteSpace :: Maybe Bool

  Flag indicating whether page layout view shall display margins. False means do not display left, right, top (header), and bottom (footer) margins (even when there is data in the header or footer).

- _sheetViewShowZeros :: Maybe Bool

  Flag indicating whether the window should show 0 (zero) in cells containing zero value. When false, cells with zero value appear blank instead of showing the number zero.

- _sheetViewTabSelected :: Maybe Bool

  Flag indicating whether this sheet is selected. When only 1 sheet is selected and active, this value should be in synch with the activeTab value. In case of a conflict, the Start Part setting wins and sets the active sheet tab.

  Multiple sheets can be selected, but only one sheet shall be active at one time.

- _sheetViewTopLeftCell :: Maybe CellRef

  Location of the top left visible cell Location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).

- _sheetViewType :: Maybe SheetViewType

  Indicates the view type.

- _sheetViewWindowProtection :: Maybe Bool

  Flag indicating whether the panes in the window are locked due to workbook protection. This is an option when the workbook structure is protected.

- _sheetViewWorkbookViewId :: Int

  Zero-based index of this workbook view, pointing to a workbookView element in the bookViews collection.

  NOTE: This attribute is required.

- _sheetViewZoomScale :: Maybe Int

  Window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.

- _sheetViewZoomScaleNormal :: Maybe Int

  Zoom magnification to use when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.

- _sheetViewZoomScalePageLayoutView :: Maybe Int

  Zoom magnification to use when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.

- _sheetViewZoomScaleSheetLayoutView :: Maybe Int

  Zoom magnification to use when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.

- _sheetViewPane :: Maybe Pane

  Worksheet view pane

- _sheetViewSelection :: [Selection]

  Worksheet view selection

  Minimum of 0, maximum of 4 elements

#### Instances

Instances details

Generic SheetView Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep SheetView :: Type -> Type Source # Methods from :: SheetView -> Rep SheetView x Source # to :: Rep SheetView x -> SheetView Source #
Show SheetView Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> SheetView -> ShowS Source # show :: SheetView -> String Source # showList :: [SheetView] -> ShowS Source #
Default SheetView Source # | NOTE: The `Default` instance for `SheetView` sets the required attribute `_sheetViewWorkbookViewId` to `0`.
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods def :: SheetView #
NFData SheetView Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: SheetView -> () Source #
Eq SheetView Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: SheetView -> SheetView -> Bool Source # (/=) :: SheetView -> SheetView -> Bool Source #
Ord SheetView Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

Methods

compare :: SheetView -> SheetView -> Ordering Source #

(<) :: SheetView -> SheetView -> Bool Source #

(<=) :: SheetView -> SheetView -> Bool Source #

(>) :: SheetView -> SheetView -> Bool Source #

(>=) :: SheetView -> SheetView -> Bool Source #

max :: SheetView -> SheetView -> SheetView Source #

min :: SheetView -> SheetView -> SheetView Source #

FromCursor SheetView Source # | See `CT_SheetView`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromCursor :: Cursor -> [SheetView] Source #
FromXenoNode SheetView Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromXenoNode :: Node -> Either Text SheetView Source #
ToElement SheetView Source # | See `CT_SheetView`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toElement :: Name -> SheetView -> Element Source #
type Rep SheetView Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep SheetView = D1 ('MetaData "SheetView" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "SheetView" 'PrefixI 'True) ((((S1 ('MetaSel ('Just "_sheetViewColorId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_sheetViewDefaultGridColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_sheetViewRightToLeft") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: (S1 ('MetaSel ('Just "_sheetViewShowFormulas") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_sheetViewShowGridLines") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))))) :*: ((S1 ('MetaSel ('Just "_sheetViewShowOutlineSymbols") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_sheetViewShowRowColHeaders") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_sheetViewShowRuler") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: (S1 ('MetaSel ('Just "_sheetViewShowWhiteSpace") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_sheetViewShowZeros") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))))) :*: (((S1 ('MetaSel ('Just "_sheetViewTabSelected") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_sheetViewTopLeftCell") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellRef))) :*: (S1 ('MetaSel ('Just "_sheetViewType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe SheetViewType)) :*: (S1 ('MetaSel ('Just "_sheetViewWindowProtection") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_sheetViewWorkbookViewId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)))) :*: ((S1 ('MetaSel ('Just "_sheetViewZoomScale") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: (S1 ('MetaSel ('Just "_sheetViewZoomScaleNormal") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_sheetViewZoomScalePageLayoutView") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)))) :*: (S1 ('MetaSel ('Just "_sheetViewZoomScaleSheetLayoutView") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: (S1 ('MetaSel ('Just "_sheetViewPane") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Pane)) :*: S1 ('MetaSel ('Just "_sheetViewSelection") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [Selection])))))))

data Selection Source #

Worksheet view selection.

Section 18.3.1.78 "selection (Selection)" (p. 1864)

Constructors

Selection |

Fields

- _selectionActiveCell :: Maybe CellRef

  Location of the active cell

- _selectionActiveCellId :: Maybe Int

  0-based index of the range reference (in the array of references listed in sqref) containing the active cell. Only used when the selection in sqref is not contiguous. Therefore, this value needs to be aware of the order in which the range references are written in sqref.

  When this value is out of range then activeCell can be used.

- _selectionPane :: Maybe PaneType

  The pane to which this selection belongs.

- _selectionSqref :: Maybe SqRef

  Range of the selection. Can be non-contiguous set of ranges.

#### Instances

Instances details

Generic Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep Selection :: Type -> Type Source # Methods from :: Selection -> Rep Selection x Source # to :: Rep Selection x -> Selection Source #
Show Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> Selection -> ShowS Source # show :: Selection -> String Source # showList :: [Selection] -> ShowS Source #
Default Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods def :: Selection #
NFData Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: Selection -> () Source #
Eq Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: Selection -> Selection -> Bool Source # (/=) :: Selection -> Selection -> Bool Source #
Ord Selection Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

Methods

compare :: Selection -> Selection -> Ordering Source #

(<) :: Selection -> Selection -> Bool Source #

(<=) :: Selection -> Selection -> Bool Source #

(>) :: Selection -> Selection -> Bool Source #

(>=) :: Selection -> Selection -> Bool Source #

max :: Selection -> Selection -> Selection Source #

min :: Selection -> Selection -> Selection Source #

FromCursor Selection Source # | See `CT_Selection`, p. 3914
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromCursor :: Cursor -> [Selection] Source #
FromXenoNode Selection Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromXenoNode :: Node -> Either Text Selection Source #
ToElement Selection Source # | See `CT_Selection`, p. 3914
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toElement :: Name -> Selection -> Element Source #
type Rep Selection Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep Selection = D1 ('MetaData "Selection" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Selection" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_selectionActiveCell") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellRef)) :*: S1 ('MetaSel ('Just "_selectionActiveCellId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))) :*: (S1 ('MetaSel ('Just "_selectionPane") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe PaneType)) :*: S1 ('MetaSel ('Just "_selectionSqref") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe SqRef)))))

data Pane Source #

Worksheet view pane

Section 18.3.1.66 "pane (View Pane)" (p. 1843)

Constructors

Pane |

Fields

- _paneActivePane :: Maybe PaneType

  The pane that is active.

- _paneState :: Maybe PaneState

  Indicates whether the pane has horizontal / vertical splits, and whether those splits are frozen.

- _paneTopLeftCell :: Maybe CellRef

  Location of the top left visible cell in the bottom right pane (when in Left-To-Right mode).

- _paneXSplit :: Maybe Double

  Horizontal position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of columns visible in the top pane.

- _paneYSplit :: Maybe Double

  Vertical position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of rows visible in the left pane.

#### Instances

Instances details

Generic Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep Pane :: Type -> Type Source # Methods from :: Pane -> Rep Pane x Source # to :: Rep Pane x -> Pane Source #
Show Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> Pane -> ShowS Source # show :: Pane -> String Source # showList :: [Pane] -> ShowS Source #
Default Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods def :: Pane #
NFData Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: Pane -> () Source #
Eq Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: Pane -> Pane -> Bool Source # (/=) :: Pane -> Pane -> Bool Source #
Ord Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods compare :: Pane -> Pane -> Ordering Source # (<) :: Pane -> Pane -> Bool Source # (<=) :: Pane -> Pane -> Bool Source # (>) :: Pane -> Pane -> Bool Source # (>=) :: Pane -> Pane -> Bool Source # max :: Pane -> Pane -> Pane Source # min :: Pane -> Pane -> Pane Source #
FromCursor Pane Source # | See `CT_Pane`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromCursor :: Cursor -> [Pane] Source #
FromXenoNode Pane Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromXenoNode :: Node -> Either Text Pane Source #
ToElement Pane Source # | See `CT_Pane`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toElement :: Name -> Pane -> Element Source #
type Rep Pane Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep Pane = D1 ('MetaData "Pane" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Pane" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_paneActivePane") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe PaneType)) :*: S1 ('MetaSel ('Just "_paneState") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe PaneState))) :*: (S1 ('MetaSel ('Just "_paneTopLeftCell") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellRef)) :*: (S1 ('MetaSel ('Just "_paneXSplit") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Double)) :*: S1 ('MetaSel ('Just "_paneYSplit") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Double))))))

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

Instances details

Generic SheetViewType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep SheetViewType :: Type -> Type Source # Methods from :: SheetViewType -> Rep SheetViewType x Source # to :: Rep SheetViewType x -> SheetViewType Source #
Show SheetViewType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> SheetViewType -> ShowS Source # show :: SheetViewType -> String Source # showList :: [SheetViewType] -> ShowS Source #
NFData SheetViewType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: SheetViewType -> () Source #
Eq SheetViewType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: SheetViewType -> SheetViewType -> Bool Source # (/=) :: SheetViewType -> SheetViewType -> Bool Source #
Ord SheetViewType Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

Methods

compare :: SheetViewType -> SheetViewType -> Ordering Source #

(<) :: SheetViewType -> SheetViewType -> Bool Source #

(<=) :: SheetViewType -> SheetViewType -> Bool Source #

(>) :: SheetViewType -> SheetViewType -> Bool Source #

(>=) :: SheetViewType -> SheetViewType -> Bool Source #

max :: SheetViewType -> SheetViewType -> SheetViewType Source #

min :: SheetViewType -> SheetViewType -> SheetViewType Source #

FromAttrVal SheetViewType Source # | See `ST_SheetViewType`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrVal :: Reader SheetViewType Source #
FromAttrBs SheetViewType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrBs :: ByteString -> Either Text SheetViewType Source #
ToAttrVal SheetViewType Source # | See `ST_SheetViewType`, p. 3913
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toAttrVal :: SheetViewType -> Text Source #
type Rep SheetViewType Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep SheetViewType = D1 ('MetaData "SheetViewType" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "SheetViewTypeNormal" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "SheetViewTypePageBreakPreview" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "SheetViewTypePageLayout" 'PrefixI 'False) (U1 :: Type -> Type)))

data PaneType Source #

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.

#### Instances

Instances details

Generic PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep PaneType :: Type -> Type Source # Methods from :: PaneType -> Rep PaneType x Source # to :: Rep PaneType x -> PaneType Source #
Show PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> PaneType -> ShowS Source # show :: PaneType -> String Source # showList :: [PaneType] -> ShowS Source #
NFData PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: PaneType -> () Source #
Eq PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: PaneType -> PaneType -> Bool Source # (/=) :: PaneType -> PaneType -> Bool Source #
Ord PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods compare :: PaneType -> PaneType -> Ordering Source # (<) :: PaneType -> PaneType -> Bool Source # (<=) :: PaneType -> PaneType -> Bool Source # (>) :: PaneType -> PaneType -> Bool Source # (>=) :: PaneType -> PaneType -> Bool Source # max :: PaneType -> PaneType -> PaneType Source # min :: PaneType -> PaneType -> PaneType Source #
FromAttrVal PaneType Source # | See `ST_Pane`, p. 3914
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrVal :: Reader PaneType Source #
FromAttrBs PaneType Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrBs :: ByteString -> Either Text PaneType Source #
ToAttrVal PaneType Source # | See `ST_Pane`, p. 3914
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toAttrVal :: PaneType -> Text Source #
type Rep PaneType Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep PaneType = D1 ('MetaData "PaneType" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((C1 ('MetaCons "PaneTypeBottomLeft" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PaneTypeBottomRight" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PaneTypeTopLeft" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PaneTypeTopRight" 'PrefixI 'False) (U1 :: Type -> Type)))

data PaneState Source #

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.

#### Instances

Instances details

Generic PaneState Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Associated Types type Rep PaneState :: Type -> Type Source # Methods from :: PaneState -> Rep PaneState x Source # to :: Rep PaneState x -> PaneState Source #
Show PaneState Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods showsPrec :: Int -> PaneState -> ShowS Source # show :: PaneState -> String Source # showList :: [PaneState] -> ShowS Source #
NFData PaneState Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods rnf :: PaneState -> () Source #
Eq PaneState Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods (==) :: PaneState -> PaneState -> Bool Source # (/=) :: PaneState -> PaneState -> Bool Source #
Ord PaneState Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

Methods

compare :: PaneState -> PaneState -> Ordering Source #

(<) :: PaneState -> PaneState -> Bool Source #

(<=) :: PaneState -> PaneState -> Bool Source #

(>) :: PaneState -> PaneState -> Bool Source #

(>=) :: PaneState -> PaneState -> Bool Source #

max :: PaneState -> PaneState -> PaneState Source #

min :: PaneState -> PaneState -> PaneState Source #

FromAttrVal PaneState Source # | See `ST_PaneState`, p. 3929
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrVal :: Reader PaneState Source #
FromAttrBs PaneState Source # |
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods fromAttrBs :: ByteString -> Either Text PaneState Source #
ToAttrVal PaneState Source # | See `ST_PaneState`, p. 3929
Instance details Defined in Codec.Xlsx.Types.SheetViews Methods toAttrVal :: PaneState -> Text Source #
type Rep PaneState Source # |

Instance details

Defined in Codec.Xlsx.Types.SheetViews

type Rep PaneState = D1 ('MetaData "PaneState" "Codec.Xlsx.Types.SheetViews" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "PaneStateFrozen" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PaneStateFrozenSplit" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PaneStateSplit" 'PrefixI 'False) (U1 :: Type -> Type)))

# Lenses

## SheetView

sheetViewColorId :: Lens' SheetView (Maybe Int) Source #

sheetViewDefaultGridColor :: Lens' SheetView (Maybe Bool) Source #

sheetViewRightToLeft :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowFormulas :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowGridLines :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowOutlineSymbols :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowRowColHeaders :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowRuler :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowWhiteSpace :: Lens' SheetView (Maybe Bool) Source #

sheetViewShowZeros :: Lens' SheetView (Maybe Bool) Source #

sheetViewTabSelected :: Lens' SheetView (Maybe Bool) Source #

sheetViewTopLeftCell :: Lens' SheetView (Maybe CellRef) Source #

sheetViewType :: Lens' SheetView (Maybe SheetViewType) Source #

sheetViewWindowProtection :: Lens' SheetView (Maybe Bool) Source #

sheetViewWorkbookViewId :: Lens' SheetView Int Source #

sheetViewZoomScale :: Lens' SheetView (Maybe Int) Source #

sheetViewZoomScaleNormal :: Lens' SheetView (Maybe Int) Source #

sheetViewZoomScalePageLayoutView :: Lens' SheetView (Maybe Int) Source #

sheetViewZoomScaleSheetLayoutView :: Lens' SheetView (Maybe Int) Source #

sheetViewPane :: Lens' SheetView (Maybe Pane) Source #

sheetViewSelection :: Lens' SheetView [Selection] Source #

## Selection

selectionActiveCell :: Lens' Selection (Maybe CellRef) Source #

selectionActiveCellId :: Lens' Selection (Maybe Int) Source #

selectionPane :: Lens' Selection (Maybe PaneType) Source #

selectionSqref :: Lens' Selection (Maybe SqRef) Source #

## Pane

paneActivePane :: Lens' Pane (Maybe PaneType) Source #

paneState :: Lens' Pane (Maybe PaneState) Source #

paneTopLeftCell :: Lens' Pane (Maybe CellRef) Source #

paneXSplit :: Lens' Pane (Maybe Double) Source #

paneYSplit :: Lens' Pane (Maybe Double) Source #