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.
What can I say? It's not the best looking, it's not the smoothest - but it works.
One of my neighbors had me over last year because there's a few things he wanted my help with his computer for a few things. Among one of them, one of his MS-hating buddies (you know the type) got him to use LibreOffice, and he had a simple document with a table with two columns, and he wanted to sort of by one the columns. Should be straightforward enough, found some forums where someone had asked the exact same thing, tried to do the same...and it promptly crashed. Restarted it, reloaded his document, retried...same thing.
Found that his copy wasn't at the latest version, so I upgraded it, retried...same crash again.
I ended up copying his table to the clipboard, went to word.office.com, pasted everything in, found the equivalent command to sort by a column, which worked, copied his table back to the clipboard, replaced the one in his original document.
Bottom line...I had to use a new-ish web version of Word to do something the long-established LibreOffice crashed trying to do.
My neighbor then understood why I don't necessarily always recommend "free alternatives".
Strange. It's not something I do normally - I sort data before it gets to the presentation layer normally - but I just tried it and it worked.
Opened a new Writer document. Added a 2 column by 6 row table.
Highlight the whole table (i.e. all rows and columns) then select "Sort..." from teh Table menu.
Up pops a dialog. Deselect column 1 as key, add column 2 as key, Press OK:
Works for me, with V22.214.171.124 (x64)
Mind you, the upgrades annoy me: they lose the toolbar files list, including all pinned items. And since I pin my most frquest DOCX and XLSX files to it that's a PITA. Reported, but ...
Sent from my Amstrad PC 1640 Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
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.