A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.
Rules
This is a science community. We use the Dawkins definition of meme.
PowerPoint is somewhat awesome though, yar.
Everything it does can be done better elsewhere, but it does so much that you can use one thing rather than learn several new tools separately.
You just have to get past and ignore the "Microsoft" part, to see that Office is a legit achievement bc of all the work they put into that.
Ofc it doesn't compare to Latex, but that's like a different class of tool entirely so it's okay:-).
I have started learning LaTeX (about to dive back in actually) as I edit my thesis together into something that resembles something more than a ranting tangent. It is scratching my probable undx autism obsession itch hella hard. Overleaf is actually a really great tool when you have purpose.
Overleaf is the shit, I love that site so goddamned much
I like Overleaf but it completely fucked up the LaTeX templates my university provided.
Fortunately mine already had one on there, unofficially. It works!
I had to switch to a different editor to use these templates.
I've spend so much time on learning latex instead of writing my thesis haha (in my department no one ever even heard of latex). But yes, same with the autism connection. It's just so nice to have a certain structure and order in everything :)
PowerPoint is ridiculously capable, like to an unnecessary degree.
I HATE Microsoft, it is evil, and moreover it was evil long before Apple and Google etc. became thus (and before Facebook, Twitter/X, etc. existed).
But ngl, Office is solid. I've run Office products on any personal machine I've been on - Windows, Mac OSX, and Linux (Wine) - and every time I have tried to switch to an open-source version I keep going back.
If I had to do heavy math then I would invest the time to learn to use Beamer, but for everything else, PowerPoint does so much with ease.
Office is solid
Excel and Powerpoint are solid. And Powerpoint gets a bad reputation because it entice users to do things they shouldn't do.
The rest of MS Office is a piece of shit.
I forget that the rest of Office even exists, so yeah:-P.
it entice users to do things they shouldn’t do.
I feel like the same could be said of all 3 of those, but more importantly of any software package? Histograms for instance require some effort to make in Excel b/c there should be no spacing between the bars, also the built-in statistical packages have issues e.g. median iirc just picks one (or perhaps uses floor()?) rather than when there is an odd number use the average between the upper and lower valuation. An example using Powerpoint could be to use flashy animations that may work well in the boardroom, but have little place in science where the content should always have the sole focus. Even so, you can use Powerpoint to get the job done, and when used properly it works well?
Nothing in life is free & easy - everything requires effort, especially for it to be done well, b/c of entropy. Anything LaTeX, though I have never personally used Beamer, would do better for math formulas, but Office is an option, that many people around the world choose daily.
Could use libre office
Nope. LO Impress doesn't support inline equations, something quite annoying if you're going to prepare slides for scientific stuff.
Just latex to svg your math for impress.
For real though, it's such a miss for impress to not have in line math
Powerpoint is what made me originally vow to try to never use word or powerpoint again, about 15 years ago. I was making a mathematically-dense presentation and became so frustrated with it that I wanted to throw my computer out the window. I still was somewhat new to latex at the time but figured there had to be some way to make presentations in latex. Found beamer and have never used pp for a real presentation again.
Yeah, PowerPoint is made for "business presentations", and its auto-alignment makes it useful for layout tasks like e.g. Adobe Illustrator replacement, plus it has some picture editing features though ofc nowhere close to Photoshop (or gimp, or ImageMagic, etc.), plus its presentation mode is good e.g. like Acrobat but far easier to use iirc.
But it's definitely of the WYSIWYG class, whereas for math I believe you want LaTeX, at which point it's probably easier to just do the layout from within that than to take pictures of the formulas and present from within PowerPoint.
PowerPoint can be a nice tool for many, but not for that purpose, agreed.
Yeah I don't like Microsoft but like Office, I just run offline pirated version of their main programs. It's like how I avoid Google for 70% of options but absolutely love Google Maps and Google Translate.
There are different teams that work on different products. Devs != Marketing for one I guess. Anyway those are all legit achievements that we can recognize, and still know that the corporation is evil, or even if it was not that we don't want to rely on a for-profit corp for everything important that we need.:-)
I haven't used Google translate since I discovered Deepl, and it gets better all the time
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:-).
Do you have an alternative to suggest?
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:-(.
I don't use gVim, but for work stuff that I don't have to share (mosly just notes), I use markdown in Obsidian w/ vi mode :) It's not FOSS and Electron is bloat, but it is really slick, and my boss approved expensing the $50 seat license for business. I might check out logseq in the future, but Obsidian was a lot more mature back when I was looking around. My only beef is that Markdown doesn't natively support sub/superscripts, which are kinda important for chemistry. Most editors implement extensions, but they're not always portable.
Obligatory joke warning, incoming in 3... 2... 1...
Do you want to know something that can handle subscripts? And superscripts too? MSO!:-) That's why it's hard to replace - it just does so very much, it has solid foundationals, even if like you said every tiny little aspect of it can drive us nuts.
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.
Try latex-beamer through pandoc. That's the way.
All I need is Marp.