excel::template::container::hidden(3pm) [debian man page]

Excel::Template::Container::Hidden(3pm) 		User Contributed Perl Documentation		   Excel::Template::Container::Hidden(3pm)

NAME

       Excel::Template::Container::Hidden - Excel::Template::Container::Hidden

PURPOSE

       To format all children in hidden

NODE NAME

       HIDDEN

INHERITANCE

       Excel::Template::Container::Format

ATTRIBUTES

       None

CHILDREN

       None

EFFECTS

       None

DEPENDENCIES

       You must have protected the worksheet containing any cells that are affected by this format. Otherwise, this node will have no effect.

USAGE

	 <hidden>
	   ... Children here
	 </hidden>

       In the above example, the children will be displayed (if they are displaying elements) in a hidden format. All other formatting will remain
       the same and the "hidden"-ness will end at the end tag.

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       WORKSHEET, FORMAT

perl v5.14.2							    2010-06-17				   Excel::Template::Container::Hidden(3pm)

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)