Safe Haskell	Safe-Inferred
Language	Haskell2010

Codec.Xlsx.Types.Cell

Synopsis

data CellFormula = CellFormula {
- _cellfExpression :: FormulaExpression
- _cellfAssignsToName :: Bool
- _cellfCalculate :: Bool
}
data FormulaExpression
- = NormalFormula Formula
- | SharedFormula SharedFormulaIndex
simpleCellFormula :: Text -> CellFormula
sharedFormulaByIndex :: SharedFormulaIndex -> CellFormula
newtype SharedFormulaIndex = SharedFormulaIndex Int
data SharedFormulaOptions = SharedFormulaOptions {
- _sfoRef :: CellRef
- _sfoExpression :: Formula
}
formulaDataFromCursor :: Cursor -> [(CellFormula, Maybe (SharedFormulaIndex, SharedFormulaOptions))]
applySharedFormulaOpts :: SharedFormulaOptions -> Element -> Element
data Cell = Cell {
- _cellStyle :: Maybe Int
- _cellValue :: Maybe CellValue
- _cellComment :: Maybe Comment
- _cellFormula :: Maybe CellFormula
}
cellStyle :: Lens' Cell (Maybe Int)
cellValue :: Lens' Cell (Maybe CellValue)
cellComment :: Lens' Cell (Maybe Comment)
cellFormula :: Lens' Cell (Maybe CellFormula)
type CellMap = Map (RowIndex, ColumnIndex) Cell

Documentation

data CellFormula Source #

Formula for the cell.

TODO: array, dataTable formula types support

See 18.3.1.40 "f (Formula)" (p. 1636)

Constructors

CellFormula
Fields _cellfExpression :: FormulaExpression _cellfAssignsToName :: Bool Specifies that this formula assigns a value to a name. _cellfCalculate :: Bool Indicates that this formula needs to be recalculated the next time calculation is performed. [Example: This is always set on volatile functions, like =RAND(), and circular references. end example]

Instances

Instances details

Generic CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep CellFormula :: Type -> Type # Methods from :: CellFormula -> Rep CellFormula x # to :: Rep CellFormula x -> CellFormula #
Show CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> CellFormula -> ShowS # show :: CellFormula -> String # showList :: [CellFormula] -> ShowS #
NFData CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: CellFormula -> () #
Eq CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: CellFormula -> CellFormula -> Bool # (/=) :: CellFormula -> CellFormula -> Bool #
ToElement CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods toElement :: Name -> CellFormula -> Element Source #
type Rep CellFormula Source #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep CellFormula = D1 ('MetaData "CellFormula" "Codec.Xlsx.Types.Cell" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "CellFormula" 'PrefixI 'True) (S1 ('MetaSel ('Just "_cellfExpression") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 FormulaExpression) :: (S1 ('MetaSel ('Just "_cellfAssignsToName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :: S1 ('MetaSel ('Just "_cellfCalculate") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool))))

data FormulaExpression Source #

formula type with type-specific options

Constructors

NormalFormula Formula
SharedFormula SharedFormulaIndex

Instances

Instances details

Generic FormulaExpression Source #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep FormulaExpression :: Type -> Type # Methods from :: FormulaExpression -> Rep FormulaExpression x # to :: Rep FormulaExpression x -> FormulaExpression #
Show FormulaExpression Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> FormulaExpression -> ShowS # show :: FormulaExpression -> String # showList :: [FormulaExpression] -> ShowS #
NFData FormulaExpression Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: FormulaExpression -> () #
Eq FormulaExpression Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: FormulaExpression -> FormulaExpression -> Bool # (/=) :: FormulaExpression -> FormulaExpression -> Bool #
type Rep FormulaExpression Source #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep FormulaExpression = D1 ('MetaData "FormulaExpression" "Codec.Xlsx.Types.Cell" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "NormalFormula" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "SharedFormula" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SharedFormulaIndex)))

simpleCellFormula :: Text -> CellFormula Source #

sharedFormulaByIndex :: SharedFormulaIndex -> CellFormula Source #

newtype SharedFormulaIndex Source #

index of shared formula in worksheet's wsSharedFormulas property

Constructors

SharedFormulaIndex Int

Instances

Instances details

Generic SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep SharedFormulaIndex :: Type -> Type # Methods from :: SharedFormulaIndex -> Rep SharedFormulaIndex x # to :: Rep SharedFormulaIndex x -> SharedFormulaIndex #
Show SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> SharedFormulaIndex -> ShowS # show :: SharedFormulaIndex -> String # showList :: [SharedFormulaIndex] -> ShowS #
NFData SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: SharedFormulaIndex -> () #
Eq SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool # (/=) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool #
Ord SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods compare :: SharedFormulaIndex -> SharedFormulaIndex -> Ordering # (<) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool # (<=) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool # (>) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool # (>=) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool # max :: SharedFormulaIndex -> SharedFormulaIndex -> SharedFormulaIndex # min :: SharedFormulaIndex -> SharedFormulaIndex -> SharedFormulaIndex #
FromAttrVal SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods fromAttrVal :: Reader SharedFormulaIndex Source #
FromAttrBs SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods fromAttrBs :: ByteString -> Either Text SharedFormulaIndex Source #
ToAttrVal SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods toAttrVal :: SharedFormulaIndex -> Text Source #
type Rep SharedFormulaIndex Source #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep SharedFormulaIndex = D1 ('MetaData "SharedFormulaIndex" "Codec.Xlsx.Types.Cell" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'True) (C1 ('MetaCons "SharedFormulaIndex" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)))

data SharedFormulaOptions Source #

Constructors

SharedFormulaOptions
Fields _sfoRef :: CellRef _sfoExpression :: Formula

Instances

Instances details

Generic SharedFormulaOptions Source #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep SharedFormulaOptions :: Type -> Type # Methods from :: SharedFormulaOptions -> Rep SharedFormulaOptions x # to :: Rep SharedFormulaOptions x -> SharedFormulaOptions #
Show SharedFormulaOptions Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> SharedFormulaOptions -> ShowS # show :: SharedFormulaOptions -> String # showList :: [SharedFormulaOptions] -> ShowS #
NFData SharedFormulaOptions Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: SharedFormulaOptions -> () #
Eq SharedFormulaOptions Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool # (/=) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool #
type Rep SharedFormulaOptions Source #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep SharedFormulaOptions = D1 ('MetaData "SharedFormulaOptions" "Codec.Xlsx.Types.Cell" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "SharedFormulaOptions" 'PrefixI 'True) (S1 ('MetaSel ('Just "_sfoRef") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CellRef) :*: S1 ('MetaSel ('Just "_sfoExpression") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))

formulaDataFromCursor :: Cursor -> [(CellFormula, Maybe (SharedFormulaIndex, SharedFormulaOptions))] Source #

applySharedFormulaOpts :: SharedFormulaOptions -> Element -> Element Source #

data Cell Source #

Currently cell details include cell values, style ids and cell formulas (inline strings from <is> subelements are ignored)

Constructors

Cell
Fields _cellStyle :: Maybe Int _cellValue :: Maybe CellValue _cellComment :: Maybe Comment _cellFormula :: Maybe CellFormula

Instances

Instances details

Generic Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep Cell :: Type -> Type # Methods from :: Cell -> Rep Cell x # to :: Rep Cell x -> Cell #
Show Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> Cell -> ShowS # show :: Cell -> String # showList :: [Cell] -> ShowS #
Default Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods def :: Cell #
NFData Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: Cell -> () #
Eq Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: Cell -> Cell -> Bool # (/=) :: Cell -> Cell -> Bool #
type Rep Cell Source #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep Cell = D1 ('MetaData "Cell" "Codec.Xlsx.Types.Cell" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "Cell" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_cellStyle") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :: S1 ('MetaSel ('Just "_cellValue") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellValue))) :: (S1 ('MetaSel ('Just "_cellComment") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Comment)) :*: S1 ('MetaSel ('Just "_cellFormula") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellFormula)))))

cellStyle :: Lens' Cell (Maybe Int) Source #

cellValue :: Lens' Cell (Maybe CellValue) Source #

cellComment :: Lens' Cell (Maybe Comment) Source #

cellFormula :: Lens' Cell (Maybe CellFormula) Source #

type CellMap = Map (RowIndex, ColumnIndex) Cell Source #

Map containing cell values which are indexed by row and column if you need to use more traditional (x,y) indexing please you could use corresponding accessors from 'Lens'