excel, annoyance
it'd be ok if there was a way to move data around and say "hey, please don't update any formulas when I do this."
But you can't do that.
If you've got a spreadsheet that's got a lot of moving around going on, the only solution is to replace all of your formulas with ones that manually calculate cell offsets, so that you don't actually have any cell references.
excel, annoyance
I'm getting really really sick of the fact that excel is "smart" and redefines formulas whenever you move cells around.
It's great for when you're copy-pasting a whole table or something! But it's really frustrating when you're trying to do something with an ordering.
Even more frustrating: when the formula is part of the conditional formatting rules, and so you can't even directly see that you've moved something and now it's gone wrong.
My name is Fen and #IAmNonbinary!
I make strange games from deep in my heart, and I thrash against commercialism as best I can.
Right now I'm running a sale to raise money for another queer friend who was ambushed with debt: https://itch.io/s/26572/feathers-for-zen
Hey, UK peeps! I am selling these cute owls I hand crafted to support me and my partner. They will be £6.50, or two for £10.00, + £3 Postage&Packaging (£9.50, £13.00 total) Email: willowscraftsandcreations@protonmail.com to order or ask any questions, invoices will be sent via paypal. #art #handmade #crafts
Description in the reply to this post!
boost with cw: death
Last Fleet is live on Kickstarter!
It's a PBTA game about a rag-tag fleet, fleeing across space from the merciless inhuman foe that destroyed human civilisation. You play brave pilots, officers, engineers, politicians and journalists fighting to keep the fleet - and themselves - in one piece.
The game is focused on action, intrigue and drama in this high-pressure setting.
https://www.kickstarter.com/projects/blackarmada/last-fleet-rpg-lastfleetrpg?ref=77xqo8
hi I'm avery, a cute lizardsquid with 3 hearts full of love!
nonbinary ░ they/she ░ australia ░ 29yo
I post: silly lizardy nonsense, world building, conlangs, doctor who
polyam, demi, open. I love affection!
hugs and cuddles and such are ok, but everything else please ask first
languages: English • Welsh (very basic)
I have a private account, ask for access!
(some old accounts:
@gwyfyndraig
@liquid_lizsquid
)