Apple to GNU/Linux Journal: Food and exercise tracking with LibreOffice Calc

Transitioning my health tracking from proprietary apps on Apple devices to Free Software on GNU+Linux has proven fairly easy. The result is a simple spreadsheet that is private, future-proof, easy to update and back-up.

#Apple#Computing#Health#Fitness#FreeSoftware#GNU + #Linux#LibreOffice

https://beardystarstuff.net/posts/2025-07-17.html

New update – #LibreOffice 25.2.5 is now available: https://blog.documentfoundation.org/blog/2025/07/17/tdf-announces-libreoffice-25-2-5/ #foss#OpenSource

Then, when you come back to edit the document, hit Ctrl+Shift+m three times. (read-only -> read/write -> read-only -> read/write), because it will only load changes to the document when switching from read/write mode to read-only mode.

More good news! Another government is freeing itself from tech giants and vendor lock-in. The Danish Ministry of Digitalisation is dropping Microsoft Office/365 and moving to #LibreOffice, to get back control: https://blog.documentfoundation.org/blog/2025/07/08/danish-ministry-switching-from-microsoft-office-365-to-libreoffice/ #foss#OpenSource #freesoftware

Wie entkommt man Google Drive und sichert sensible Dokumente dennoch komfortabel online?

Überlege gerade, Dokumente zum Berliner Unternehmen @mailbox_org umzuziehen. 🇪🇺 Problem: Das 2FA-Login wird gerade erst verbessert und wurde bei mir noch nicht ausgerollt. https://mailbox.org/de/post/der-neue-login

Google & Co sichern ja Logins auf neuen Geräten durch second device ab. 🔒

Dokumente kann man außerdem mit Mailbox-Guard schützen, meines Wissens sind diese dann aber lokal auf dem Laptop nicht mehr mit OXDrive-Client nutzbar.

Pragmatischer Mittelweg: #LibreOffice Dokumente mit Passwort schützen? 🤔 (PDFs - ?)

Ich finde auch Lösungen wie Cryptomator oder Boxcryptor smart, aber ist ein zusätzlicher Layer technische Komplexität. Und wenn der fehl schlägt, sind die Dateien futsch (?) 🤔

I just tried exporting a story I'm working on from #LibreOffice to an ePub file, and it worked beautifully. It used to be that you had to get a plug-in to do this, but now it's built right into the app. I even added metadata and some random image as a cover, just to see what would happen, and it worked perfectly.

I cannot figure out why more #writers don't use LibreOffice. Every single time I go to do something in it that I want to do for writing either fiction or nonfiction, it's way ahead of what you can do in Microsoft Word, and definitely way ahead of what you can do in Google Docs. Yeah you have to learn the app, but it's not like that's too difficult for what most writers need to get going.

Good software needs good documentation. But how do we define "good" in this sense? And what does the future hold? Find out in episode 4 of the #LibreOffice Podcast: https://peertube.opencloud.lu/w/nMTL4VhSpKSLQsntK6youq #foss#OpenSource

Explanation:
"Array/matrix mode formulas calculate differently than in “normal” mode."

Thanks to @efialto for your attempt to help me!

#LibreOffice

https://ask.libreoffice.org/t/copy-formula-not-working/24756

Open Document Format – the native format of #LibreOffice – is built on XML. But how does XML help with interoperability? Find out on our blog: https://blog.documentfoundation.org/blog/2025/07/11/the-role-of-xml-in-interoperability/ #foss#OpenSource #openstandards

Apparently Libre Office is free and contains no AI.

#AI#Microsoft#LibreOffice

We're making tabs in #LibreOffice dialog boxes vertical, to improve navigation. This is just one of the many changes our QA and Development communities worked on in June: https://qa.blog.documentfoundation.org/2025/07/07/qa-dev-report-june-2025/ #foss#OpenSource #freesoftware

I was performing those actions at the top of the spreadsheet. If I scroll to the bottom and add a new row there and do the exact same thing, it works.

It's as though the application does not realize that I've entered a formula and is just treating it as text? I must be overlooking something.

Creating a new row at various points in the document and trying the formula sometimes works, sometimes not.

#LibreOffice

Okay, entering formulas into LibreOffice Calc fails way too often. I never know if it's going to work.

- I make a new row. Sometimes I can copy a formula from the previous row and paste in and it works. Other times, no.
- It didn't work today so I tried manually entering in formula. It just shows the formula in the cell but does not calculate the result.
- Delete row, try a new row.
- Confirm that formula is correct multiple times.

What incantation am I missing?

#LibreOffice @libreoffice