Rob Kinyon > Excel-Template-0.29 > Excel::Template::Element::Backref

Download:
Excel-Template-0.29.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  4
Open  0
View/Report Bugs
Source   Latest Release: Excel-Template-0.34

NAME ^

Excel::Template::Element::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.

NODE NAME ^

BACKREF

INHERITANCE ^

Excel::Template::Element

ATTRIBUTES ^

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>=<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".

AUTHOR ^

Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO ^

CELL, RANGE

syntax highlighting: