Safe Haskell	None
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 (Int, Int) Cell

Documentation

data CellFormula #

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

Eq CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: CellFormula -> CellFormula -> Bool # (/=) :: CellFormula -> CellFormula -> Bool #
Show CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> CellFormula -> ShowS # show :: CellFormula -> String # showList :: [CellFormula] -> ShowS #
Generic CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep CellFormula :: * -> * # Methods from :: CellFormula -> Rep CellFormula x # to :: Rep CellFormula x -> CellFormula #
NFData CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: CellFormula -> () #
ToElement CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell Methods toElement :: Name -> CellFormula -> Element #
type Rep CellFormula #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep CellFormula = D1 (MetaData "CellFormula" "Codec.Xlsx.Types.Cell" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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 #

formula type with type-specific options

Constructors

NormalFormula Formula
SharedFormula SharedFormulaIndex

Instances

Eq FormulaExpression #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: FormulaExpression -> FormulaExpression -> Bool # (/=) :: FormulaExpression -> FormulaExpression -> Bool #
Show FormulaExpression #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> FormulaExpression -> ShowS # show :: FormulaExpression -> String # showList :: [FormulaExpression] -> ShowS #
Generic FormulaExpression #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep FormulaExpression :: * -> * # Methods from :: FormulaExpression -> Rep FormulaExpression x # to :: Rep FormulaExpression x -> FormulaExpression #
NFData FormulaExpression #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: FormulaExpression -> () #
type Rep FormulaExpression #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep FormulaExpression = D1 (MetaData "FormulaExpression" "Codec.Xlsx.Types.Cell" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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 #

sharedFormulaByIndex :: SharedFormulaIndex -> CellFormula #

newtype SharedFormulaIndex #

index of shared formula in worksheet's wsSharedFormulas property

Constructors

SharedFormulaIndex Int

Instances

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

data SharedFormulaOptions #

Constructors

SharedFormulaOptions
Fields _sfoRef :: CellRef _sfoExpression :: Formula

Instances

Eq SharedFormulaOptions #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool # (/=) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool #
Show SharedFormulaOptions #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> SharedFormulaOptions -> ShowS # show :: SharedFormulaOptions -> String # showList :: [SharedFormulaOptions] -> ShowS #
Generic SharedFormulaOptions #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep SharedFormulaOptions :: * -> * # Methods from :: SharedFormulaOptions -> Rep SharedFormulaOptions x # to :: Rep SharedFormulaOptions x -> SharedFormulaOptions #
NFData SharedFormulaOptions #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: SharedFormulaOptions -> () #
type Rep SharedFormulaOptions #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep SharedFormulaOptions = D1 (MetaData "SharedFormulaOptions" "Codec.Xlsx.Types.Cell" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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))] #

applySharedFormulaOpts :: SharedFormulaOptions -> Element -> Element #

data Cell #

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

Eq Cell #
Instance details Defined in Codec.Xlsx.Types.Cell Methods (==) :: Cell -> Cell -> Bool # (/=) :: Cell -> Cell -> Bool #
Show Cell #
Instance details Defined in Codec.Xlsx.Types.Cell Methods showsPrec :: Int -> Cell -> ShowS # show :: Cell -> String # showList :: [Cell] -> ShowS #
Generic Cell #
Instance details Defined in Codec.Xlsx.Types.Cell Associated Types type Rep Cell :: * -> * # Methods from :: Cell -> Rep Cell x # to :: Rep Cell x -> Cell #
Default Cell #
Instance details Defined in Codec.Xlsx.Types.Cell Methods def :: Cell #
NFData Cell #
Instance details Defined in Codec.Xlsx.Types.Cell Methods rnf :: Cell -> () #
type Rep Cell #
Instance details Defined in Codec.Xlsx.Types.Cell type Rep Cell = D1 (MetaData "Cell" "Codec.Xlsx.Types.Cell" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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) #

cellValue :: Lens' Cell (Maybe CellValue) #

cellComment :: Lens' Cell (Maybe Comment) #

cellFormula :: Lens' Cell (Maybe CellFormula) #

type CellMap = Map (Int, Int) Cell #

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'