Excel:...Formula(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::Formula ✨

okay bestie, welcome to the manual page for Excel::Template::Element::Formula, from the User Contributed Perl Documentation collection 💖 it's a Perl module (that's the (3pm) energy) and it's literally just here to put formulas on your worksheet. no cap.

🌸 NAME 🌸

Excel::Template::Element::Formula — yep, that's the whole name, it's giving "I contain multitudes but also I'm just this one thing" 💅

🎀 PURPOSE 🎀

to write formulas to the worksheet. that's it. that's the job. and it ate. 🔥

👑 NODE NAME 👑

FORMULA

that's the node name, remember it, iykyk ✨

🦋 INHERITANCE 🦋

it inherits from Excel::Template::Element::Cell — so it's got the family tree going on, main character energy but with a lineage 🌈

💜 ATTRIBUTES 💜

every single attribute a CELL can have? a FORMULA can have it too. periodt. and yes, that includes the ability to be referenced using the 'ref' attribute 🫶

🧚 CHILDREN 🧚

None

no children. it's childless and thriving. 🙈

⭐ EFFECTS ⭐

this will consume one column on the current row. one column, that's the toll, pay up 💀

🍓 DEPENDENCIES 🍓

None

zero dependencies, self-sufficient queen 👑

✨ USAGE ✨

okay so here's how we do:

<formula text="=(1 + 2)"/>
<formula>=SUM(A1:A5)</formula>

<formula text="$Param2"/>
<formula>=(A1 + <var name="Param">)</formula>

so in the above example, four formulas are written out 💖

the first two have the formula hard-coded. the second two have variables. and the third and fourth items have another thing that should be noted: if you have a formula where you want a variable in the middle, you have to use the latter form. variables within parameters are the entire parameter's value — like, the whole thing, no bits left over, fr fr 🌸

don't come for me if you put a variable in the middle of a parameter and it doesn't do what you want — use the latter form, bestie, that's the whole point 😭

🌈 AUTHOR 🌈

Rob Kinyon (rob.kinyon@gmail.com) — thank you for this, king 🫶

🎀 SEE ALSO 🎀

CELL — go read that one too, it's the parent, it's iconic 💜

and that's the whole page bestie!! this doc is from perl v5.34.0 and it's dated 2022-06-13, and the page itself is Excel:...Formula(3pm) 💖 slay, go write some formulas ✨🦋

📦 where this page comes from