The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
I don't remember the exact procedure I used, and do keep in mind I mentioned this was last year...they could very well have fixed that problem already.
I sort data before it gets to the presentation layer normally
These are somewhat unsophisticated folks, and this is just stuff they had typed in and (I think) they just kept adding to the table willy-nilly over time, until they realized it would have made sense to keep things sorted.
Anyway, my point was, despite existing for years, I was surprised LibreOffice could still experience an outright hard crash (as in, exit the program altogether, with no proper exception handler to at least try to handle it somewhat gracefully). I would like to recommend alternatives to the pay-for Office for friends/relatives, but that one just left a bad taste in my mouth.
Same for me. I've been using OpenOffice and then LibreOffice for years, at the begining just because it was free. Recently I had to install Office in my work to fill a .doc template, and LibreOffice messed it up. I found absolutely terrible what they have done to that program. I had to restart it many times because sometimes I moved an image an suddenly the content of the pages dissapeared or became strange characters. Unexpected behaviors, commands overlapping. Or try to resize an image inside a text box when the margins of the objects disappear. Commands that I could never found, other ones hidden in unexpected places... What a mess! This application was not so bad last time I used it. While LibreOffice became better and better with time, I see that Word followed the opposite direction.
Dislike the Ribbon-UI introduced in Office 2007.
Don't care much for any of the new features (except spark-lines in Excel, *sigh*).
2003 can read / write later versions' XML-based fileTypes docx / xlsx / etc. albeit only after installing the Compatibility-pack-update.
But the main benefit, the icing on the cake:
Starting ye olde Excel 2003 takes as little time as starting the calculator or notepad
While even on a very powerful, up-to-date PC with NVMe-SSD, many cores and all bells and whistles starting one of the later MS Office programs takes forever, thanks to all the bloat (and animated splash-screens and stuff).
Current LibreOffice isn't much better either in that respect.
My real need is for an Outlook replacement for the Mac, email and calendar working off of Microsoft Exchange Online. Using Office 2011 today but it has quirks in the current macOS High Sierra and Mojave.
Some of the files I work with are streams, and I can use a macro in UltraEdit to separate a .csv into X12 fields or database entries. The column mode is nice as I usually end up reformatting SQL from entry level developers in order to be able to read their code.