table of contents
Excel::Template::Element::Range(3pm) | User Contributed Perl Documentation | Excel::Template::Element::Range(3pm) |
NAME¶
Excel::Template::Element::Range - Excel::Template::Element::RangePURPOSE¶
Returns a range of cell locations (i.e. B2:C2) that contains all calls using this reference. To return the location of the last cell, use BACKREF.NODE NAME¶
RANGEINHERITANCE¶
Excel::Template::ElementATTRIBUTES¶
- •
- REF
This is the name of the reference to look up.
CHILDREN¶
NoneEFFECTS¶
NoneDEPENDENCIES¶
This will only be used within CELL tags.USAGE¶
In the example...<row> <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell"> </row> <row> <formula>=SUM(<range ref="that_cell">)</formula> </row>
The formula in row 2 would be =SUM(B1:C1).
AUTHOR¶
Rob Kinyon (rkinyon@columbus.rr.com)SEE ALSO¶
CELL, BACKREF2012-04-29 | perl v5.14.2 |