LibreOffice 25.2 Released, This is What's New

[programmingsocks@pawb.social]

Because it's not free software. It's proprietary, so you're still putting everything into the hands of some random corporation.

[parlamint@lemmy.ml]

I'm excited about themes. That's a nice addition.

[474d@lemmy.world]

That makes sense, thanks for the explanation

[vort3@lemmy.ml]

Could you please ELI5 what are spill ranges?

[corsicanguppy@lemmy.ca]

LibreOffice 25.2 Released, This is What's New

In addition to the comma splice?

[pushbutton@lemmy.world]

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

[canihasaccount@lemmy.world]

ONLYOFFICE (sorry about the caps, poor name choice IMO) has even better docx compatibility, and its source code is open

[maniii@lemmy.world]

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.

[daniskarma@lemmy.dbzer0.com]

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.

[jenseitsjens@lemmy.world]

I've looked that up before. I think you have to hold Alt while grabbing the edge of the selection.

[scrollone@feddit.it]

Some bugs are so old that they can drive or drink.

[justfudgnwork@sh.itjust.works]

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.

[fine_sandy_bottom@discuss.tchncs.de]

Click the column header to select the column, then click and drag the selected cells to wherever you want.

Note that dragging cells in this way is the same as copy & paste, so it will not insert the column at your destination and move the existing columns along, it will leave a gap where you dragged it from and overwrite the column wherever you leave it.

[treczoks@lemmy.world]

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.