r/libreoffice

Hello, I want to have a basic sum table with the last row as the sum of column values.

If I want to add a new value, I want to add a new row right above the sum row and I want the sum formula to adapt, e.g.:

https://preview.redd.it/6bze8kg50dwg1.png?width=359&format=png&auto=webp&s=bca802481e2e488a4f970e1bd4857ceec4f495dd

Now if I add a new row at line 5 (sum then row 6), I want the sum formula to adapt to B2:B5. Then with another new value to B2:B6 and so on.

I tried to make it automatic with including the =ROW function, but I couldn't get it work ...

Hi everyone,

I'm trying to automate the conversion of excel files to PDF using the LibreOffice CLI.

My Goal: I want the PDF output to behave exactly like the "Fit All Columns on One Page" setting in Excel or the "Shrink to width" option in LibreOffice Calc.

Horizontally: All columns must fit into a single page width (no side-scrolling or split columns).
Vertically: The rows should flow naturally to multiple pages as needed.

The Problem: When using the standard CLI commands;

It uses the default scaling, which often cuts off columns and puts them on separate pages. I am aware of environment variable tweaks, but I haven't found a specific flag for "Fit width to 1 page / height to automatic."

What I've tried:

1. Changing the user profile settings in the GUI before running CLI (inconsistent results).
2. Looking for a specific --convert-to pdf:calc_pdf_Export filter configuration, but the documentation is a bit sparse on scaling parameters.

Question: Is there a way to pass scaling arguments directly via CLI, or perhaps a way to inject a "Page Style" into the document during conversion that forces the width to 1 page while allowing vertical overflow?

Any help would be greatly appreciated!

I setup custom paragraph styles in Word and am now starting to use Libre office. Can the paragraph styles be imported / copied from word to Writer?

Thanks

(L.O. version info at the end)

I wanted to add a glossary of terms/words/abbreviations at the end of my book.

For example, I'm writing a Police Procedural, set in 2015, and I reference the "FBI's AFIT System". Now, most casual readers might think I made an error and meant "AFIS system".
But, the FBI replaced the "AFIS system" in 2011 with the "AFIT System" which is a part of their "NGI (Next Generation Identification) System".

So, what I'd like do is something like this. Suggestions welcome.

In the text is where I say "We'll submit the print to the FBI's AFIT System^(1)" (adding the superscript number) and then have a glossary at the end of the book with a more detailed explanation. I'd like the superscript numbers to auto increment and keep track of the terms. Then insert the glossary at the appropriate spot.
I can imagine a two column table with the term, and a box for the explanation.

I can easily add a footnote, but I thought a glossary would be less intrusive.
I will have multiple terms, but most probably more than 1 per chapter, so footnotes are my fallback.

Version: 26.2.1.2 (AARCH64)
Build ID: 8399f6259d8c87f40e7255cdb3c9b958f5e08948
CPU threads: 16; OS: macOS 26.4.1; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

https://preview.redd.it/qumwiv7p38wg1.png?width=510&format=png&auto=webp&s=3f33b39cd8548710dee71375fdfd1d5b48619470

Can the latest libreoffice version convert HTML to DOCX? How about --headless too? And how to make sure the <IMG src=...> files don't disappear?

Does Libreoffice Impress have a background remover for inserted images?

Yesterday I decides to try Libre Base. I created a small database and already once had my file mysteriously wiped out (0 length) but discovered the backup folder and recovered it. I don't mind it making automatic backups, and as you see it's already saved me some work but the backup folder now contains over 10,000 backup copies, timestamped 10 *seconds* apart. I looked through the settings and found one setting that was at 10 minutes. In any case how do I slow this down to something more reasonable?

Looking around the portable download for LibreOffice, it appears there's only an x86-64 version for Windows. Is there a way to get the Windows ARM version of the portable install?

https://download.documentfoundation.org/libreoffice/portable/

Was looking for a microsoft office alternative on linux and came across libreoffice first. seemed like the obvious choice, but after digging a bit, seeing how some parts depend on collabora and its ecosystem kinda made me unsure about long term sustainability…

Maybe im overthinking it, but it feels a bit too tied instead of fully independent.

then found onlyoffice, and honestly it looks more appealing in that sense. built from scratch (not a fork), free, no ads, good ms file compatibility, and proper cross platform apps + web version. just feels more “complete” overall.

Curious what others think… is the collabora thing actually a concern or not really?

also any other good alternatives on linux worth trying?

Since installing LibreOffice on Mac OS, I've had consistent hangs on first save of any document.

I eventually figure out it was because I had aliases to network drives on my Desktop which could only be accessed if I was VPN'd into work. If not VPN'd, the hangs occurred, presumably because it was trying to open/access the network drives and failing.

The workaround I came up with was removing the aliases from the Desktop.

But, is there a better way to prevent LibreOffice from attempting to access network drives via aliases on the Desktop?

In any case, I'm glad I finally figured out why LO kept on hanging...

Affinity Publisher 2.6.5

After switching from Microsoft Office to Libre Office (26.1.2.1), I noticed something annoying with copy/pasting text to Affinity Publisher.

If I paste a text from MS Office to Publisher the pasted text adopts the paragraph style in Publisher immediately.

If I do the same from Libre Office, then the style from the text in Libre Office is also copied to Publisher and overwrites the existing style. So I have to apply the style in Publisher manually.

It's a long shot, but has anyone noticed this and found a way to solve this?