Codec.Xlsx.Types.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

Generic CellFormula

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

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> CellFormula -> ShowS

show :: CellFormula -> String

showList :: [CellFormula] -> ShowS

NFData CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: CellFormula -> ()

Eq CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

(==) :: CellFormula -> CellFormula -> Bool

(/=) :: CellFormula -> CellFormula -> Bool

ToElement CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

toElement :: Name -> CellFormula -> Element

type Rep CellFormula

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

formula type with type-specific options

Constructors

NormalFormula Formula

SharedFormula SharedFormulaIndex

Instances

Generic FormulaExpression

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

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> FormulaExpression -> ShowS

show :: FormulaExpression -> String

showList :: [FormulaExpression] -> ShowS

NFData FormulaExpression

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: FormulaExpression -> ()

Eq FormulaExpression

Defined in Codec.Xlsx.Types.Cell

Methods

(==) :: FormulaExpression -> FormulaExpression -> Bool

(/=) :: FormulaExpression -> FormulaExpression -> Bool

type Rep FormulaExpression

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

sharedFormulaByIndex :: SharedFormulaIndex -> CellFormula

newtype SharedFormulaIndex

index of shared formula in worksheet's wsSharedFormulas property

Constructors

SharedFormulaIndex Int

Instances

Generic SharedFormulaIndex

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

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> SharedFormulaIndex -> ShowS

show :: SharedFormulaIndex -> String

showList :: [SharedFormulaIndex] -> ShowS

NFData SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: SharedFormulaIndex -> ()

Eq SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

(==) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool

(/=) :: SharedFormulaIndex -> SharedFormulaIndex -> Bool

Ord SharedFormulaIndex

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

Defined in Codec.Xlsx.Types.Cell

Methods

fromAttrVal :: Reader SharedFormulaIndex

FromAttrBs SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

fromAttrBs :: ByteString -> Either Text SharedFormulaIndex

ToAttrVal SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

toAttrVal :: SharedFormulaIndex -> Text

type Rep SharedFormulaIndex

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

Constructors

SharedFormulaOptions

Fields

• _sfoRef :: CellRef
• _sfoExpression :: Formula

Instances

Generic SharedFormulaOptions

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

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> SharedFormulaOptions -> ShowS

show :: SharedFormulaOptions -> String

showList :: [SharedFormulaOptions] -> ShowS

NFData SharedFormulaOptions

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: SharedFormulaOptions -> ()

Eq SharedFormulaOptions

Defined in Codec.Xlsx.Types.Cell

Methods

(==) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool

(/=) :: SharedFormulaOptions -> SharedFormulaOptions -> Bool

type Rep SharedFormulaOptions

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))]

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

Generic Cell

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

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> Cell -> ShowS

show :: Cell -> String

showList :: [Cell] -> ShowS

Default Cell

Defined in Codec.Xlsx.Types.Cell

Methods

def :: Cell

NFData Cell

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: Cell -> ()

Eq Cell

Defined in Codec.Xlsx.Types.Cell

Methods

(==) :: Cell -> Cell -> Bool

(/=) :: Cell -> Cell -> Bool

type Rep Cell

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)

cellValue :: Lens' Cell (Maybe CellValue)

cellComment :: Lens' Cell (Maybe Comment)

cellFormula :: Lens' Cell (Maybe CellFormula)

type CellMap = Map (RowIndex, ColumnIndex) 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'