Excel:...Backref(3pm)

📦
version 0.34 · 2 versions
  • 0.34 · debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking (latest)
  • 0.34 · ubuntu jammy
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

💖 Excel::Template::Element::Backref — the manual, but make it cute 💖

okay bestie, so this is the User Contributed Perl Documentation page for Excel::Template::Element::Backref, aka Excel:...Backref(3pm). yes the name is a whole mouthful, we're moving on. 🫶

✨ NAME ✨

Excel::Template::Element::Backref — and that's it. that's the name. it's giving "my parents named me after myself". iconic honestly. 💅

🎯 PURPOSE 🎯

okay so here's the tea: this little guy returns the cell location (like, B2 energy) of the last cell to name this reference.

and listen — if you want the location of the entire range of cells that name this reference instead? that's a different bestie. go see RANGE. this one's just doing the last-cell thing. no cap. ✨

🏷️ NODE NAME 🏷️

BACKREF

that's it. that's the node name. remember it, you'll need it. 💖

🧬 INHERITANCE 🧬

Excel::Template::Element

it inherits from that. family tree slay. 🌸

🎀 ATTRIBUTES 🎀

  • REF — this is the name of the reference you're looking up. that's the whole vibe. you give it a name, it goes and finds it. 🦋

👶 CHILDREN 👶

None

no babies. none. empty nest. 🙈

🌈 EFFECTS 🌈

None

zero side effects. it's just out here being a good little element and not touching anything. ✨

🔗 DEPENDENCIES 🔗

okay important one, don't skip this: this will only be used within CELL tags.

like, only inside CELL. that's not a suggestion bestie, that's the rules. 💀

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

so the formula in row 2 would be =A1+C1. and C1? that's the last one to reference "that_cell". the way that backref just knows which one came last... obsessed. 🔥

👑 AUTHOR 👑

Rob Kinyon (rkinyon@columbus.rr.com)

thank you Rob, king behavior. 🫶

👀 SEE ALSO 👀

CELL, RANGE

go read those too, they're the supporting cast and they ate. 💜

and that's the whole page bestie, you're officially a Backref expert now. 🦋

mwah 💋 — this was perl v5.34.0, dated 2022-06-13, from Excel:...Backref(3pm). see you in the next manpage, love u, bye!! 🎀✨

📦 where this page comes from