1 package Excel::Template::Element::Formula;
7 @ISA = qw(Excel::Template::Element::Cell);
9 use Excel::Template::Element::Cell;
12 sub render { $_[0]->SUPER::render( $_[1], 'write_formula' ) }
17 # return $self->SUPER::render( $context, 'write_formula' );
25 Excel::Template::Element::Formula - Excel::Template::Element::Formula
29 To write formulas to the worksheet
37 Excel::Template::Element::Cell
41 All attributes a CELL can have, a FORMULA can have, including the ability to be
42 referenced using the 'ref' attribute.
50 This will consume one column on the current row.
58 <formula text="=(1 + 2)"/>
59 <formula>=SUM(A1:A5)</formula>
61 <formula text="$Param2"/>
62 <formula>=(A1 + <var name="Param">)</formula>
64 In the above example, four formulas are written out. The first two have the
65 formula hard-coded. The second two have variables. The third and fourth items
66 have another thing that should be noted. If you have a formula where you want a
67 variable in the middle, you have to use the latter form. Variables within
68 parameters are the entire parameter's value.
72 Rob Kinyon (rob.kinyon@gmail.com)