LibreOffice 25.2 Released, This is What's New
LibreOffice 25.2 Released, This is What's New
LibreOffice 25.2 has been released, this year's first major update to the leading open-source office software for Windows, macOS, and Linux. Image: The
Sun Microsystems, thank you for your legacy.
I'm excited about themes. That's a nice addition.
I wanna make LO look exactly like MSOFF and troll the hell outta every MSOFF user.
Also I wanna go back to IBM Lotus Symphony look. It was the best interface for me.
Does someone know how to move columns around in Calc?
A colleague was telling me the other day that feature is missing. I tested it, like grab the column from the top and drag and drop... to no avail.
I am not an office expert, so maybe you guys could help out?
Thanks
I've looked that up before. I think you have to hold Alt while grabbing the edge of the selection.
Libreoffice is dope 💪
I would like to be able to download and swap out keyboard bindings with community-produced variants
Did they fix this bug when you put writer in Fullscreen it won't actually be fullscreen and let a border of one pixel all around? It has been there ages.
Some bugs are so old that they can drive or drink.
I just need spill ranges from excel before I can fully ditch the microsoft office suite, so many of my spreadsheets rely on them.
Could you please ELI5 what are spill ranges?
Sure! Basically, certain formulas in excel affect more than one cell. For example, there is a function called "sequence". "=SEQUENCE(5)" puts a 1 in the cell where it is, a 2 in the cell below, 3 below that etc. up to 5. I.e. it "spills" out of its cell.
I mostly use this feature when A) designing spreadsheets where I need to update the number of rows of data during operation, or where the number of rows is truly dynamic (a real example is a sheet that goes through my asset purchases and bundles them into buy-sell chunks for tax) B) Where I want to do anything with filters that excel doesn't have by default - since one of the spill-enabled functions is "FILTER"
I know the 'right' way to perform these tasks is with an actual programming language but I want to be able to share these sheets with others and have them be vaguely happy to have them.
Libre is good but I have no idea why WPS Office isn't discussed more. It's essentially a functioning MS Office clone.
Because it's not free software. It's proprietary, so you're still putting everything into the hands of some random corporation. Software freedom is important, and important to this forum specifically.
That makes sense, thanks for the explanation
ONLYOFFICE (sorry about the caps, poor name choice IMO) has even better docx compatibility, and its source code is open
Thanks, I'll definitely check it out
I wonder when I can set default options for importing images. I'm using Open/LibreOffice since nearly the beginnings as StarOffice (I think I still have the CD somewhere), and one thing really irks me: Whenever I import an image (which I do rather regularly), it always imports the image as "Anchor->To Character". For me, this is the wrong default, I always need "Anchor->As Character". For thousands of images, I have to set this manually.