NAME

       Excel::Template::Element::Range - Excel::Template::Element::Range

PURPOSE

       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

       RANGE

INHERITANCE

       Excel::Template::Element

ATTRIBUTES

       •   REF

           This is the name of the reference to look up.

CHILDREN

       None

EFFECTS

       None

DEPENDENCIES

       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, BACKREF

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