Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Excel::Template::ElemeUserFContributed PerExcel::Template::Element::Formula(3)

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.32.1			  2010-06-Excel::Template::Element::Formula(3)

NAME | PURPOSE | NODE NAME | INHERITANCE | ATTRIBUTES | CHILDREN | EFFECTS | DEPENDENCIES | USAGE | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Excel::Template::Element::Formula&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help