DOKK / manpages / debian 12 / libexcel-template-perl / Excel::Template::Element::Backref.3pm.en
Excel::Template::Element::Backref(3pm) User Contributed Perl Documentation Excel::Template::Element::Backref(3pm)

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

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.

BACKREF

Excel::Template::Element

REF

This is the name of the reference to look up.

None

None

This will only be used within CELL tags.

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

Rob Kinyon (rkinyon@columbus.rr.com)

CELL, RANGE

2022-06-13 perl v5.34.0