GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  EXCEL::TEMPLATE::ELEMENT::FORMULA (3)

.ds Aq ’

NAME

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

CONTENTS

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
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 EXCEL::TEMPLATE::ELEMENT::FORMULA (3) 2010-06-17

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.