1Excel::Template::ElemenUts:e:rFoCromnutlrai(b3u)ted PerlExDcoeclu:m:eTnetmaptliaotne::Element::Formula(3)
2
3
4

NAME

6       Excel::Template::Element::Formula - Excel::Template::Element::Formula
7

PURPOSE

9       To write formulas to the worksheet
10

NODE NAME

12       FORMULA
13

INHERITANCE

15       Excel::Template::Element::Cell
16

ATTRIBUTES

18       All attributes a CELL can have, a FORMULA can have, including the
19       ability to be referenced using the 'ref' attribute.
20

CHILDREN

22       None
23

EFFECTS

25       This will consume one column on the current row.
26

DEPENDENCIES

28       None
29

USAGE

31         <formula text="=(1 + 2)"/>
32         <formula>=SUM(A1:A5)</formula>
33
34         <formula text="$Param2"/>
35         <formula>=(A1 + <var name="Param">)</formula>
36
37       In the above example, four formulas are written out. The first two have
38       the formula hard-coded. The second two have variables. The third and
39       fourth items have another thing that should be noted. If you have a
40       formula where you want a variable in the middle, you have to use the
41       latter form. Variables within parameters are the entire parameter's
42       value.
43

AUTHOR

45       Rob Kinyon (rob.kinyon@gmail.com)
46

SEE ALSO

48       CELL
49
50
51
52perl v5.36.0                      2022-07-2E2xcel::Template::Element::Formula(3)
Impressum