Excel:...Hidden(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::Container::Hidden 💖

ok so bestie, this is Excel::Template::Container::Hidden — a lil Perl module that lives in the User Contributed Perl Documentation, and it's literally just here to hide stuff in your spreadsheet. no cap. it's giving "you can't sit with us" but for cells. 🫶

✨ NAME ✨

Excel::Template::Container::Hidden — yeah that's it, that's the name, it's the same as the package, we love a self-titled icon 👑

🎯 PURPOSE 🎯

To format all children in hidden 💅

that's the whole job. every child node inside it gets the hidden treatment. periodt.

🏷️ NODE NAME 🏷️

HIDDEN

that's what you call it in your XML. remember it. write it down. tattoo it on your arm idc. 🌸

🧬 INHERITANCE 🧬

Excel::Template::Container::Format

it's a child of Format, so it inherited the whole formatting bloodline. main character energy fr fr. 💜

📋 ATTRIBUTES 📋

None

not a single one. no options, no flags, nothing to configure. it's minimalist. it's clean. it's lowkey iconic for it. ✨

👶 CHILDREN 👶

None

nope, it doesn't define any children of its own. sorry bestie. 🙈

🌈 EFFECTS 🌈

None

no extra side effects listed. it just does the one thing. very focused. very demure.

⚠️ DEPENDENCIES ⚠️

You must have protected the worksheet containing any cells that are affected by this format. Otherwise, this node will have no effect.

ok this is the important bit, do NOT skip it 😭 if the worksheet isn't protected, this node literally does nothing. like, zero. nada. it's just gonna sit there looking pretty and accomplishing nothing. protect your sheet first, then come back. i'm serious. 🎀

🛠️ USAGE 🛠️

<hidden>
  ... Children here
</hidden>

so in that example up there ☝️ the children will be displayed (if they are displaying elements) in a hidden format. and literally everything else stays exactly the same — all other formatting is untouched. the "hidden"-ness kicks in when the tag opens and ends at the end tag. so it's scoped, it's contained, it's a moment, not a lifestyle. 💅

✍️ AUTHOR ✍️

Rob Kinyon (rob.kinyon@gmail.com)

thank you rob, king behavior, we appreciate you 🫶

👀 SEE ALSO 👀

  • WORKSHEET
  • FORMAT

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

and that's a wrap on the Excel:...Hidden(3pm) page bestie!! 🌟 this lil doc shipped as part of perl v5.34.0, dated 2022-06-13, under User Contributed Perl Documentation. mwah, go hide some cells responsibly 💖🦋✨

📦 where this page comes from