Excel:...Locked(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::Locked πŸ’–

okay bestie, this is the manual page for Excel::Template::Container::Locked β€” it's a Perl module, it lives in the User Contributed Perl Documentation section (that's the 3pm part, iykyk), and it's here to make your spreadsheet cells go πŸ”’ locked mode. let's get into it πŸ’…


✨ NAME ✨

Excel::Template::Container::Locked β€” literally just Excel::Template::Container::Locked, that's the whole name, no notes πŸ’€


πŸŽ€ PURPOSE πŸŽ€

to format all of its children in locked πŸ”

that's it. that's the job. main character energy fr fr.


πŸ¦‹ NODE NAME πŸ¦‹

LOCKED

yep, all caps, that's the vibe. when you see LOCKED in your template, that's this node showing up πŸ’–


🌸 INHERITANCE 🌸

Excel::Template::Container::Format

so it's inheriting from Format β€” it's giving nepo baby but make it legit, because all that formatting DNA is coming along for the ride 🧚


⭐ ATTRIBUTES ⭐

None

like, zero. none. not a single one. it's minimal, it's clean, it's ✨ unbothered ✨


🌈 CHILDREN 🌈

None

no children of its own, it just adopts the ones you put inside it 🫢


πŸ‘‘ EFFECTS πŸ‘‘

None

no side effects, no sneaky surprises. we love a low-drama node πŸ’œ


πŸ’€ DEPENDENCIES πŸ’€

okay this one actually matters, so listen up:

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

🚨 no cap, if the sheet isn't protected, this whole thing does absolutely nothing. it's just gonna sit there looking cute and doing zero. protect the worksheet first, bestie, or don't bother πŸ™ˆ

πŸ“ USAGE πŸ“

  <locked>
    ... Children here
  </locked>

so in the example above, the children will be displayed (if they're displaying elements) in a locked format. all other formatting stays exactly the same, and the "locked"-ness ends at the end tag β€” it does not leak out past </locked>, periodt πŸ”₯


πŸ’œ AUTHOR πŸ’œ

Rob Kinyon (rob.kinyon@gmail.com)

ty for your service king πŸ‘‘


πŸ”₯ SEE ALSO πŸ”₯

  • WORKSHEET
  • FORMAT

and that's the whole page!! this one came from perl v5.34.0 and it's dated 2022-06-13 β€” so yeah, shoutout to the 2022 era for this absolute gem πŸ’–βœ¨πŸŽ€

πŸ“¦ where this page comes from