NAME

Excel::Template::Element::Formula - Excel::Template::Element::Formula

PURPOSE

To write formulas to the worksheet

NODE NAME

FORMULA

INHERITANCE

Excel::Template::Element::Cell

ATTRIBUTES

• TEXT

  This is the formula to write to the cell. This can either be text or a parameter with a dollar-sign in front of the parameter name.

• COL

  Optionally, you can specify which column you want this cell to be in. It can be either a number (zero-based) or an offset. See Excel::Template for more info on offset-based numbering.

There will be more parameters added, as features are added.

CHILDREN

None

EFFECTS

This will consume one column on the current row.

DEPENDENCIES

None

USAGE

<formula text="=(1 + 2)"/>
<formula>=SUM(A1:A5)</formula>

<formula text="$Param2"/>
<formula>=(A1 + <var name="Param">)</formula>

In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use the latter form. Variables within parameters are the entire parameter's value.

AUTHOR

Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO

ROW, VAR, CELL