excel::template::element::formula(3pm) [debian man page]

Excel::Template::Element::Formula(3pm)			User Contributed Perl Documentation		    Excel::Template::Element::Formula(3pm)

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

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

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 (rob.kinyon@gmail.com)

SEE ALSO

       CELL

perl v5.14.2							    2010-06-17				    Excel::Template::Element::Formula(3pm)

Excel::Template::Element::Cell(3pm)			User Contributed Perl Documentation		       Excel::Template::Element::Cell(3pm)

NAME

       Excel::Template::Element::Cell - Excel::Template::Element::Cell

PURPOSE

       To actually write stuff to the worksheet

NODE NAME

       CELL

INHERITANCE

       ELEMENT

ATTRIBUTES

       o   TEXT

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

       o   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.

       o   REF

	   Adds the current cell to the a list of cells that can be backreferenced.  This is useful when the current cell needs to be referenced
	   by a formula. See BACKREF and RANGE.

       o   WIDTH

	   Sets the width of the column the cell is in. The last setting for a given column will win out.

       o   TYPE

	   This allows you to specify what write_*() method will be used. The default is to call write() and let Spreadsheet::WriteExcel make the
	   right call. However, you may wish to override it. Excel::Template will not do any form of validation on what you provide. You are
	   assumed to know what you're doing.

	   The legal types (taken from Spreadsheet::WriteExcel) are:

       o   COMMENT

	   Add a comment to the cell

	   o   blank

	   o   formula

	   o   number

	   o   string

	   o   url

	   o   date_time

	   other write_* methods as defined defined Spreadsheet::WriteExcel would be integrated by request

CHILDREN

       FORMULA

EFFECTS

       This will consume one column in the current row.

DEPENDENCIES

       None

USAGE

	 <cell text="Some Text Here"/>
	 <cell>Some other text here</cell>

	 <cell text="$Param2"/>
	 <cell>Some <var name="Param"> text here</cell>

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

       Please see Spreadsheet::WriteExcel for what constitutes a legal formula.

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       ROW, VAR, FORMULA

perl v5.14.2							    2012-04-29				       Excel::Template::Element::Cell(3pm)