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

Methods

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

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

Show CellFormula

Methods

showsPrec :: Int -> CellFormula -> ShowS

show :: CellFormula -> String

showList :: [CellFormula] -> ShowS

Generic CellFormula

Associated Types

type Rep CellFormula :: * -> *

Methods

from :: CellFormula -> Rep CellFormula x

to :: Rep CellFormula x -> CellFormula

NFData CellFormula

Methods

rnf :: CellFormula -> ()

ToElement CellFormula

Methods

toElement :: Name -> CellFormula -> Element

type Rep CellFormula

type Rep CellFormula = D1 * (MetaData "CellFormula" "Codec.Xlsx.Types.Cell" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) (C1 * (MetaCons "CellFormula" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellfExpression") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * FormulaExpression)) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellfAssignsToName") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_cellfCalculate") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)))))

data FormulaExpression

formula type with type-specific options

Constructors

NormalFormula Formula

SharedFormula SharedFormulaIndex

Instances

Eq FormulaExpression

Methods

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

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

Show FormulaExpression

Methods

showsPrec :: Int -> FormulaExpression -> ShowS

show :: FormulaExpression -> String

showList :: [FormulaExpression] -> ShowS

Generic FormulaExpression

Associated Types

type Rep FormulaExpression :: * -> *

Methods

from :: FormulaExpression -> Rep FormulaExpression x

to :: Rep FormulaExpression x -> FormulaExpression

NFData FormulaExpression

Methods

rnf :: FormulaExpression -> ()

type Rep FormulaExpression

type Rep FormulaExpression = D1 * (MetaData "FormulaExpression" "Codec.Xlsx.Types.Cell" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) ((:+:) * (C1 * (MetaCons "NormalFormula" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "SharedFormula" PrefixI False) (S1 * (MetaSel (Nothing 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

Methods

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

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

Ord SharedFormulaIndex

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

Methods

showsPrec :: Int -> SharedFormulaIndex -> ShowS

show :: SharedFormulaIndex -> String

showList :: [SharedFormulaIndex] -> ShowS

Generic SharedFormulaIndex

Associated Types

type Rep SharedFormulaIndex :: * -> *

Methods

from :: SharedFormulaIndex -> Rep SharedFormulaIndex x

to :: Rep SharedFormulaIndex x -> SharedFormulaIndex

NFData SharedFormulaIndex

Methods

rnf :: SharedFormulaIndex -> ()

FromAttrBs SharedFormulaIndex

Methods

fromAttrBs :: ByteString -> Either Text SharedFormulaIndex

FromAttrVal SharedFormulaIndex

Methods

fromAttrVal :: Reader SharedFormulaIndex

ToAttrVal SharedFormulaIndex

Methods

toAttrVal :: SharedFormulaIndex -> Text

type Rep SharedFormulaIndex

type Rep SharedFormulaIndex = D1 * (MetaData "SharedFormulaIndex" "Codec.Xlsx.Types.Cell" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" True) (C1 * (MetaCons "SharedFormulaIndex" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int)))

data SharedFormulaOptions

Constructors

SharedFormulaOptions

Fields

• _sfoRef :: CellRef
• _sfoExpression :: Formula

Instances

Eq SharedFormulaOptions

Methods

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

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

Show SharedFormulaOptions

Methods

showsPrec :: Int -> SharedFormulaOptions -> ShowS

show :: SharedFormulaOptions -> String

showList :: [SharedFormulaOptions] -> ShowS

Generic SharedFormulaOptions

Associated Types

type Rep SharedFormulaOptions :: * -> *

Methods

from :: SharedFormulaOptions -> Rep SharedFormulaOptions x

to :: Rep SharedFormulaOptions x -> SharedFormulaOptions

NFData SharedFormulaOptions

Methods

rnf :: SharedFormulaOptions -> ()

type Rep SharedFormulaOptions

type Rep SharedFormulaOptions = D1 * (MetaData "SharedFormulaOptions" "Codec.Xlsx.Types.Cell" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) (C1 * (MetaCons "SharedFormulaOptions" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_sfoRef") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * CellRef)) (S1 * (MetaSel (Just Symbol "_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

Methods

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

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

Show Cell

Methods

showsPrec :: Int -> Cell -> ShowS

show :: Cell -> String

showList :: [Cell] -> ShowS

Generic Cell

Associated Types

type Rep Cell :: * -> *

Methods

from :: Cell -> Rep Cell x

to :: Rep Cell x -> Cell

Default Cell

Methods

def :: Cell

NFData Cell

Methods

rnf :: Cell -> ()

type Rep Cell

type Rep Cell = D1 * (MetaData "Cell" "Codec.Xlsx.Types.Cell" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) (C1 * (MetaCons "Cell" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cellStyle") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_cellValue") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe CellValue)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellComment") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Comment))) (S1 * (MetaSel (Just Symbol "_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'