Excel:...gZeros(3pm)

💖 Excel::Template::Container::KeepLeadingZeros ✨

okay bestie so the full name of this thing is Excel::Template::Container::KeepLeadingZeros — yes, that's a whole mouthful, it's giving "my parents named me after the family business" 😭 — and it lives in the User Contributed Perl Documentation corner of the perl world, section 3pm, iykyk. Let's get into it 🫶

---

🎀 PURPOSE 🎀

So like, the whole point? It flips on the keep_leading_zeros flag ✨ for the worksheet it's chillin' inside, or for literally any worksheets that happen to be nested inside this node. That's it. That's the job. She's a one-trick pony and she ate 💅

---

🌸 NODE NAME 🌸

KEEP_LEADING_ZEROS

that's the name you write in your template, no cap, all caps, exactly like that 👑

---

🦋 INHERITANCE 🦋

CONTAINER

she's a container girlie, she holds things, main character energy fr fr 💜

---

⭐ ATTRIBUTES ⭐

None. Zero. Nada. No attributes, no drama, she's low maintenance 🙈

---

🌈 CHILDREN 🌈

None. (the node has no children, bestie — the worksheets are a different story, keep reading 😌)

---

🔥 EFFECTS 🔥

It changes up how leading zeros get interpreted by Spreadsheet::WriteExcel. That's the whole vibe check right there ✨

---

💀 DEPENDENCIES 💀

None. She's self-sufficient, a true independent icon 👑

---

💅 USAGE 💅

so here's how you actually use her — two whole flavours, both iconic:

<worksheet>
  ... Cells here will NOT have leading-zeros preserved
  <keep_leading_zeros>
    ... Cells here will have leading-zeros preserved
  </keep_leading_zeros>
  ... Cells here will NOT have leading-zeros preserved
</worksheet>

<keep_leading_zeros>
  <worksheet>
    ... Cells here will have leading-zeros preserved
  </worksheet>
  <worksheet>
    ... Cells here will have leading-zeros preserved
  </worksheet>
</keep_leading_zeros>

see what she did there? 🧚 drop her inside a worksheet and she saves the zeros just for the cells in her lil bubble. Wrap her around whole worksheets and every worksheet inside gets the treatment. Both. Are. Valid. Periodt 💖

heads up bestie: it's a container, so where you put it literally decides which cells get the leading-zeros-preserved life and which ones don't. Nest carefully, no cap 🎀

---

🍓 AUTHOR 🍓

Rob Kinyon (rob.kinyon@gmail.com) — ty for your service king 🫶

---

🌟 SEE ALSO 🌟

• CELL
• Spreadsheet::WriteExcel

---

and that's the whole page babes ✨ this lil doc came from perl v5.34.0, dated 2022-06-13, straight out of the User Contributed Perl Documentation collection 💜 go forth and preserve those zeros, you absolute legend 👑🎀