This might be the funniest MS Office thing I have encountered yet:
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I remember working in QA for Microsoft on MS project ages ago. We had to take direction from Office on features including the UI. I was testing undo redo in Project and logged bugs about it undoing things in other docs silently. I was told that's the way Office did it, so it was by design.
I tried. I hate that design decision to this day.
-
@Canageek @MatthewPCooke @aesthr All Office programs were MDI, but Excel was always special (the global Undo thing didn't apply to any other program, nor did a bunch of other things that Excel still does weirdly, especially when working with multiple documents).
@jernej__s @Canageek @aesthr to be fair, I have genuinely seen a lot of inter-document linking and data loading amongst finance teams where as word documents are usually separate. That might also go some way to explaining why word went SDI about 15 years before Excel…
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
yeah... with excel, UI/UX really stands for User Interface Universally eXcrement...
-
@aesthr Gods. This explains -so- much.
I thought Excel was broken, somehow.. (well, it is, but that is beside -this- point). Who in their right mind ok'ed this..
@tofticles @aesthr It possibly made more sense back when it was an MDI application. Having GUIs make logical sense stopped being a design requirement around Windows 8 at the latest.
-
@aesthr I use excel daily, and I hate this "Feature".
I only want to modify the excel in the active screen, if it does anything else it's wrong.
This site has some options for work arounds, but the best one the registry edit can't be done on corporate machines.
https://spreadsheetplanet.com/open-multiple-instances-excel/ -
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Back in my Excel VBA programming days, it took me two weeks to realize that opening another workbook clears the clipboard.
️ -
@aesthr I remember working in QA for Microsoft on MS project ages ago. We had to take direction from Office on features including the UI. I was testing undo redo in Project and logged bugs about it undoing things in other docs silently. I was told that's the way Office did it, so it was by design.
I tried. I hate that design decision to this day.
@Sablebadger @aesthr Seems to be to break the "principle of least surprise." I always thought you needed a *really* good reason to do that.
-
@tante welcome to my regular workday in a MS equipped office
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr i have similar issues with undo in Logic Pro X. If i undo a recording, it also deletes the lyrics. It also sometimes does an undo as 2 things to be undone. Other times, like after a recording, it will not undo the recording, but undoes the thing that happened before the recording. I have had to unlearn my undo hand gestures. This was not a problem a few years ago by the way… but thanks to AI, it is now!
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I seem to recall this isn't limited to Excel but every Office program combined since they started bundling them together in the 1990s.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr utterly bonkers
-
@c0dec0dec0de @aesthr @tante Sweet mother of mohair that's BAD. I just proved it to myself. How the FUCK did that get out the door?
Word does NOT do this. What about Powerpoint? Nope, doesn't do it there either
That's fucking insane.
-
@c0dec0dec0de @aesthr @tante Sweet mother of mohair that's BAD. I just proved it to myself. How the FUCK did that get out the door?
Word does NOT do this. What about Powerpoint? Nope, doesn't do it there either
That's fucking insane.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Hahahaha, that's a laughably bad design decision but I cannot say I am at all surprised, because Excel, and M$.
It reminds me of when Excel won't let me open a new document for no apparent reason, no warnings or anything, until I close the current document. Because random wtf.
And people wonder why I curse all day while using Windows for work...
-
@Sablebadger @aesthr Seems to be to break the "principle of least surprise." I always thought you needed a *really* good reason to do that.
@TimWardCam @aesthr the guys in Office were arrogant douchebags if I remember correctly. You DID NOT question them... Ever.
I remember mixing it up with them a few times, and getting slapped down every time. Entitled tech bro bullshit.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr yes, I've noticed it at work, too! then promptly forgot about it in the bliss of using MS products...
(at least the IT department listened to my desperate plea and removed or turned off everything copilot-related from my machine & license, so there's that)
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr Eeeek! Make it go away!
Just kiddin. It already went away. I use something else, and I'd take a lot of persuasion to go back.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
@aesthr I "love" how every time someone discovers this crap, everyone else is shocked and a few people get really anxious about having fucked up at least one important file by this anti-feature without noticing it.
Everyone hates it, but MS won't even add an opt-out setting like they did for their overzealous data conversions (everything is a date!)related to this bullshit: excel can't open two files with the same name (but different paths), but it can have multiple windows for the same file.
-
@c0dec0dec0de @aesthr @tante Yea, looks like they made Excel into a single context, with each open file in that one context. Which probably makes it easier to do cross-file stuff, but the cost in user surprise is way too high.
-
This might be the funniest MS Office thing I have encountered yet:
Excel has global undo/redo, so if you work on multiple files and hit undo a few times. it may change things in a different file. Good luck reconstructing that, if you don't immediately notice.
An absurd design decision imo
I understand why, and if you don’t want to be traumatised, I suggest you stop reading now.
A spreadsheet is not actually the document unit for Excel. Any open sheet can refer to cells in any other open sheet (hmm, I wonder if anyone has exploited that with sheets that fetch from external data sources to extract other information). By default, any cell reference is in the current sheet, but you can include other files by name and their cells will be used but only if they are open. This means that any editing operation may affect any other open sheets and so, logically, it follows that undo should apply to the document (all open sheets) and not simply one sheet.
This is also why Excel does not let you open two sheets with the same file name at the same time. If you do, cross-sheet references would be ambiguous. Remember, they don’t refer to files as paths or some kind of unique document identifier, they reference other sheets by file name from the set of open files.
