Excel::Template::Element::Backref - Excel::Template::Element::Backref

Attributes

       •   REF

           This is the name of the reference to look up.

Author

       Rob Kinyon (rkinyon@columbus.rr.com)

Children

       None

Dependencies

       This will only be used within CELL tags.

Effects

       None

Inheritance

       Excel::Template::Element

Name

       Excel::Template::Element::Backref - Excel::Template::Element::Backref

Node Name

       BACKREF

Purpose

       Returns the cell location (i.e. B2) of the last cell to name this reference.  To return the location of
       the entire range of cells to name this reference see RANGE.

Usage

       In the example...

         <row>
           <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
         </row>
         <row>
           <formula>=<backref ref="this_cell">+<backref ref="that_cell"></formula>
         </row>

       The formula in row 2 would be =A1+C1.  C1 is the last to reference "that_cell".