Programmer Humor

22400 readers

2675 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

[email protected]

1155

Excel (lemmy.ml)

submitted 1 day ago by [email protected] to c/[email protected]

69 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] wise_pancake 7 points 1 day ago* (last edited 1 day ago) (1 children)

100%.

what the hell is going on with “Tables” vs filter views vs slices vs named ranges.

That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)

The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.

Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.

Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.

[–] [email protected] 1 points 1 day ago* (last edited 1 day ago)

I love filter views, no real complaints there except that other people can’t manage to figure out the difference between filtering the whole sheet and setting up a filter view.

Tables seem kind of pointless but better than a separate database app I guess?

Not sure about “little pills”, do you mean the drop downs? That’s in validation, and it’s a little odd but better both in interface and function than Excel. There’s really only one version and two ways to do it: “data validation” and “insert drop-down” (the latter is just a shortcut to the former, but with relevant options selected). Checkboxes are the same (both live in the insert menu).

I’ve never known the “paste style” menu, I mostly use keyboard shortcuts when pasting. I might be misunderstanding what you’re describing there.