---
name: "Excel::Template::Element::Backref"
section: "3pm"
platform: "linux"
package: "libexcel-template-perl"
version: "0.34-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Excel::Template::Element::Backref"
---

# Excel::Template::Element::Backref(3pm)

Excel::Template::Element::Backref

## NAME

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

- •

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