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

Eq CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

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

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

Show CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> CellFormula -> ShowS

show :: CellFormula -> String

showList :: [CellFormula] -> ShowS

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

NFData CellFormula

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: CellFormula -> ()

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.0.0.1-inplace" '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

Defined in Codec.Xlsx.Types.Cell

Methods

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

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

Show FormulaExpression

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> FormulaExpression -> ShowS

show :: FormulaExpression -> String

showList :: [FormulaExpression] -> ShowS

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

NFData FormulaExpression

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: FormulaExpression -> ()

type Rep FormulaExpression

Defined in Codec.Xlsx.Types.Cell

type Rep FormulaExpression = D1 ('MetaData "FormulaExpression" "Codec.Xlsx.Types.Cell" "xlsx-1.0.0.1-inplace" '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

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

Show SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> SharedFormulaIndex -> ShowS

show :: SharedFormulaIndex -> String

showList :: [SharedFormulaIndex] -> ShowS

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

NFData SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: SharedFormulaIndex -> ()

FromAttrBs SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

fromAttrBs :: ByteString -> Either Text SharedFormulaIndex

FromAttrVal SharedFormulaIndex

Defined in Codec.Xlsx.Types.Cell

Methods

fromAttrVal :: Reader 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.0.0.1-inplace" '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

Defined in Codec.Xlsx.Types.Cell

Methods

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

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

Show SharedFormulaOptions

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> SharedFormulaOptions -> ShowS

show :: SharedFormulaOptions -> String

showList :: [SharedFormulaOptions] -> ShowS

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

NFData SharedFormulaOptions

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: SharedFormulaOptions -> ()

type Rep SharedFormulaOptions

Defined in Codec.Xlsx.Types.Cell

type Rep SharedFormulaOptions = D1 ('MetaData "SharedFormulaOptions" "Codec.Xlsx.Types.Cell" "xlsx-1.0.0.1-inplace" '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

Defined in Codec.Xlsx.Types.Cell

Methods

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

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

Show Cell

Defined in Codec.Xlsx.Types.Cell

Methods

showsPrec :: Int -> Cell -> ShowS

show :: Cell -> String

showList :: [Cell] -> ShowS

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

NFData Cell

Defined in Codec.Xlsx.Types.Cell

Methods

rnf :: Cell -> ()

Default Cell

Defined in Codec.Xlsx.Types.Cell

Methods

def :: Cell

type Rep Cell

Defined in Codec.Xlsx.Types.Cell

type Rep Cell = D1 ('MetaData "Cell" "Codec.Xlsx.Types.Cell" "xlsx-1.0.0.1-inplace" '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'