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.
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.
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
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.
I’ve looked that up before. I think you have to hold Alt while grabbing the edge of the selection.
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.
Libreoffice is dope 💪
LibreOffice 25.2 Released, This is What’s New
In addition to the comma splice?
I’ve been using LibreOffice more these days for writing, slides, and spreadsheets. I can’t remember now the last time I used a Google app for this.
All our business uses. Libreoffice is great
Libre is good but I have no idea why WPS Office isn’t discussed more. It’s essentially a functioning MS Office clone.
ONLYOFFICE (sorry about the caps, poor name choice IMO) has even better docx compatibility, and its source code is open
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 community specifically.
That makes sense, thanks for the explanation
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.
