I mean, it’s okay… I feel like I run into inconveniences in MSO every day. Off the top of my head (solutions welcome):
Absurd startup times for opening documents. Worse if there isn’t an instance of the app already open. Part of the blame goes to my company’s antivirus software, but Excel and PowerPoint are easily my slowest-starting apps, and Word is the runner-up. All UI animations are also stupidly slow, though I think that was a design choice.
A pasted graphic goes to the center of the slide in ppt regardless of the current zoom or view. Annoying for making large posters, exacerbated by delayed rendering of lots of graphics.
Likewise, zooming occurs relative to slide’s center, not the current zoomed view or from the mouse pointer.
No easily accessibly horizontal scroll outside of using a touchpad (i.e., scrollbar only). Tilting the mouse wheel (if I even have access to such a mouse) either doesn’t work or only slightly nudges the view. Also makes posters tedious in combination with pasting issue. Something like shift+mousewheel would be nice.
Dragging a scroll bar does not update the view until you release it.
Sometimes the amount of space between a bullet point and text in a PPT text box changes when all others are remain the same. Possibly a skill issue related to styles. Still frustrating.
Dragging objects autoaligns them to seemingly everything except what I want it to. I now run with snapping turned off.
Pasting charts between documents changes to destination formatting/styling by default.
Pasting text from external sources keeps formatting by default. Never have I ever wanted to copy a web page’s or email’s font, color, and size into my own docs. I could have sworn that there were also circumstances where ctrl+alt+v doesn’t work properly, but I can’t seem to remember/reproduce that at the moment.
Dates in Excel. It’s a meme, but also true.
Excel seems to have a “root” window (the doc opened first), and it does not play nice with virtual desktops. If you try to open a spreadsheet from Windows Explorer or some other app (e.g. web browser) on VD B while the root window is on VD A, you are forcibly switched to VD A, where the doc actually opens (after a complimentary delay, of course). Then I have to find the freaking window in Task View and move it back to VD B. There is a reason I wasn’t adding more windows to VD A to begin with. Incidentally Word and other MSO apps do not have this issue for some reason.
If one doc window freezes/stops responding, they all do.
Aligning things in Word
A few common color palettes are not colorblind-friendly.
Okay so all true but… genuinely, do you have an alternative to suggest? I have thought about switching to a more LaTeX layout style editing platform even not for mathematical formulas, since part of the issue is simply using WYSIWYG. PowerPoint at least has workarounds for most things - e.g. in the details panel (click click, click click click - it used to be a direct menu item but now it is quite buried, at least in my current version) you can input a numerical value for the x and y position relative to the slide’s upper left corner i.e. its absolute position). That requires a significantly lower barrier to entry than editing source code but if the latter offers superior functionality with less hassle…
As for Word and Excel, the same thought applies: what else even comes close? I spent quite some time learning R and therefore hate it with a burning passion - especially the existing libraries like ggplot (granted I am several years out of date there so there’s a slim possibility that literally everything about it has changed and it is awesome now?). There I believe a solid alternative would be Python libraries e.g. MatPlotLib (+SciPy + NumPy), but even that I would guess depends on what you want to do, like it would replace the plotting part, but if you still wanted that more visual exploration, or a “view” of the data to send to someone, the visual spreadsheet is kinda neat?
More than a decade of effort went into making MSO, and unfortunately even more would need to be done still in order to improve further as you pointed out, but at this point even if FOSS catches up to all of that, I am still going to respect MSO for having done it first to blaze the trail (even while I switch to the FOSS alternative for daily use:-).
For the general user? Not really, I’m just venting :) I have the unsubstantiated, possibly irrational belief that MSO UX ought to be far more polished after having existed for so long. Like you said, most of my frustrations have workarounds, even if they are buried or tedious (though the tedium is part of my contention).
For making slides or posters, someone in school recommended to lay out a poster or each slide completely in ChemDraw (basically a specialized, widely used vector-based WYSIWYG editor for organic chemistry) and paste the lot onto a PPT slide. That works reasonably well and makes everything have a consistent look, especially since most slides of mine contain chemdraws of molecules anyway. ChemDraw does have its own warts and somewhat limited functionality beyond drawing molecules and text. Also, since like 2019 the rendering and UI have gotten so much slower. For posters and basic diagraming, I currently use Inkscape, pasting things as needed. Inkscape also has its quirks, but its interface is so much more powerful and the UI so much more responsive than either ChemDraw or PPT that it is the clear winner for me. Though, it is also not winning any startup races.
For Excel, you’re unfortunately correct; there is no suitable WYSIWYG spreadsheet replacement. While I can do essentially all of the typical numerical hacking I do in Excel with (IMO) a better experience in LibreOffice Calc, it falls down when I need to show it to someone else. The charting in Calc is lackluster, and it doesn’t play nice with Office file formats. Also, my workplace (though not me personally) makes heavy use of Excel UI + VBA + fortran (!) DLLs for reactor modeling…
LO Writer is probably the closest to Word in usability, but compatibility with Word files is still subpar, mostly to do with styling and formatting. Both are bloated for probably 50% of my use (e.g., writing up informal procedures or meeting minutes). Wordpad (RIP) is nice in that regard.
it used to be a direct menu item but now it is quite buried…
My colleague swears that UI in MSO before Office 2007 was so much better, but I can’t comment much on that.
Oh the actual UX is horrible, and ironically I confirm what your colleague said that it used to be better than now. It has suffered from the enshittification process the same as everything else these days in our terminal stages of capitalism. Imagine if there was actually competition! Instead, Microsoft went around purchasing any competing product, and rather than absorb the new features simply remove it from the market - bc one implementation of the evolutionary strategy of survival of the fittest is to be better than others, but a far cheaper move is to simply kill off everything else so that you are all that’s left. In the authoritarian sense that “you’ll take what we offer and like it”, it works, bc people are unwilling or unable to put in the time & effort to do better, with FOSS.
Ironically for an unbloated editor for quick stuff, I use gVim, if I am on my own machine.:-) Wordpad would be good if you have to be on a generic Windows machine though - I think it can even do bulleted lists?
Furthermore, on a Mac the implementation of MSO is even less optimal, especially irt battery. So it’s not even like I “like” it, it just seems the least horrible option available:-(.
The sheets themselves are usually unproblematic, but the charts often don’t render properly when viewed in MSO. This is relevant because the other party usually does not have LO installed.
I mean, it’s okay… I feel like I run into inconveniences in MSO every day. Off the top of my head (solutions welcome):
Okay so all true but… genuinely, do you have an alternative to suggest? I have thought about switching to a more LaTeX layout style editing platform even not for mathematical formulas, since part of the issue is simply using WYSIWYG. PowerPoint at least has workarounds for most things - e.g. in the details panel (click click, click click click - it used to be a direct menu item but now it is quite buried, at least in my current version) you can input a numerical value for the x and y position relative to the slide’s upper left corner i.e. its absolute position). That requires a significantly lower barrier to entry than editing source code but if the latter offers superior functionality with less hassle…
As for Word and Excel, the same thought applies: what else even comes close? I spent quite some time learning R and therefore hate it with a burning passion - especially the existing libraries like ggplot (granted I am several years out of date there so there’s a slim possibility that literally everything about it has changed and it is awesome now?). There I believe a solid alternative would be Python libraries e.g. MatPlotLib (+SciPy + NumPy), but even that I would guess depends on what you want to do, like it would replace the plotting part, but if you still wanted that more visual exploration, or a “view” of the data to send to someone, the visual spreadsheet is kinda neat?
More than a decade of effort went into making MSO, and unfortunately even more would need to be done still in order to improve further as you pointed out, but at this point even if FOSS catches up to all of that, I am still going to respect MSO for having done it first to blaze the trail (even while I switch to the FOSS alternative for daily use:-).
For the general user? Not really, I’m just venting :) I have the unsubstantiated, possibly irrational belief that MSO UX ought to be far more polished after having existed for so long. Like you said, most of my frustrations have workarounds, even if they are buried or tedious (though the tedium is part of my contention).
For making slides or posters, someone in school recommended to lay out a poster or each slide completely in ChemDraw (basically a specialized, widely used vector-based WYSIWYG editor for organic chemistry) and paste the lot onto a PPT slide. That works reasonably well and makes everything have a consistent look, especially since most slides of mine contain chemdraws of molecules anyway. ChemDraw does have its own warts and somewhat limited functionality beyond drawing molecules and text. Also, since like 2019 the rendering and UI have gotten so much slower. For posters and basic diagraming, I currently use Inkscape, pasting things as needed. Inkscape also has its quirks, but its interface is so much more powerful and the UI so much more responsive than either ChemDraw or PPT that it is the clear winner for me. Though, it is also not winning any startup races.
For Excel, you’re unfortunately correct; there is no suitable WYSIWYG spreadsheet replacement. While I can do essentially all of the typical numerical hacking I do in Excel with (IMO) a better experience in LibreOffice Calc, it falls down when I need to show it to someone else. The charting in Calc is lackluster, and it doesn’t play nice with Office file formats. Also, my workplace (though not me personally) makes heavy use of Excel UI + VBA + fortran (!) DLLs for reactor modeling…
LO Writer is probably the closest to Word in usability, but compatibility with Word files is still subpar, mostly to do with styling and formatting. Both are bloated for probably 50% of my use (e.g., writing up informal procedures or meeting minutes). Wordpad (RIP) is nice in that regard.
My colleague swears that UI in MSO before Office 2007 was so much better, but I can’t comment much on that.
Oh the actual UX is horrible, and ironically I confirm what your colleague said that it used to be better than now. It has suffered from the enshittification process the same as everything else these days in our terminal stages of capitalism. Imagine if there was actually competition! Instead, Microsoft went around purchasing any competing product, and rather than absorb the new features simply remove it from the market - bc one implementation of the evolutionary strategy of survival of the fittest is to be better than others, but a far cheaper move is to simply kill off everything else so that you are all that’s left. In the authoritarian sense that “you’ll take what we offer and like it”, it works, bc people are unwilling or unable to put in the time & effort to do better, with FOSS.
Ironically for an unbloated editor for quick stuff, I use gVim, if I am on my own machine.:-) Wordpad would be good if you have to be on a generic Windows machine though - I think it can even do bulleted lists?
Furthermore, on a Mac the implementation of MSO is even less optimal, especially irt battery. So it’s not even like I “like” it, it just seems the least horrible option available:-(.
What’s your issue with showing libreofficd spreadsheets to others?
The sheets themselves are usually unproblematic, but the charts often don’t render properly when viewed in MSO. This is relevant because the other party usually does not have LO installed.