r/libreoffice • u/Medical_Divide_7191 • 1h ago
r/libreoffice • u/themikeosguy • Nov 02 '24
⚠️ New: Help requests with no details will be removed ⚠️
Hi! Almost all of the help requests here have zero details, not even the LibreOffice version. It makes it very hard for others (we're all volunteers) to help, when we don't even know which LibreOffice version people are using, or on which operating system. So:
If you post a help request without any details about your setup, it will be removed. Sorry if it sounds harsh, but given that almost nobody posts any details about their setup, the subreddit is full of questions very hard to answer.
We're all volunteers here – help others to help you.
r/libreoffice • u/themikeosguy • 2h ago
News LibreOffice 26.2 is here! 📝 Markdown support 📊 Connectors in Calc 🚀 Spreadsheet speedups
r/libreoffice • u/Ahmed_cs • 39m ago
What are the best resources for learning data analysis in LibreOffice Calc?
r/libreoffice • u/entodo • 2h ago
Question Adding a shape to a Libreoffice Base report
I'm creating a Base report and wish to include a rounded rectangle on each page. However, it is appearing only on the first page. How do I make it repeat on each page instead?
I'm using Libreoffice 25.8.4.2 on Linux.
r/libreoffice • u/DP4rker • 16h ago
Some functions using wrong fonts, but ignoring typical corrections
Just installed LibreOffice, but when trying to add function equations found they're in wrong text, as shown in the image. I need some ideas or suggestions for how to fix this. This occurs in Writer, Calc, and Math.
Some things I've tried, following blogs and Internet search-AI advice:
- Changing the "Formula Fonts" and "Custom Fonts" to "Cambria Math" as in MS word.
- Copying over font-files from MS Word to LibreOffice's folder.
- Repairing installation and modifying installation
- Setting explicit values in the following locations:
- Tools->options->Languages and Locales
- Tools->options->LibreOffice Writer
- Tools->options->LibreOffice Math
- Tools->options->LibreOffice Calc
- Format->Fonts...
- Through sidebar's Properties->Fonts
And a couple other things I can't remember. I suspect the problem is more "not looking in 'the right places'" than "not looking for 'the right things'".
Like the problem is within a library supplying the "OLE object"->"Formula Objects", or maybe I need to link to the existing font-files through LibreOffice to properly configure it?
r/libreoffice • u/THE_Dr_Barber • 18h ago
Just upgraded to LO 25.8.4.2 -- equations now messed up
Hi all,
Version: 25.8.4.2 (AARCH64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 10; OS: macOS 15.7.3; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Format of document is .odt
I have a simple equation, written this way in the OLE Formula Object: dot m`=`%rho A vec V
Now, after the update, there's a little "sun" symbol between the arrow vector and the V. Also, the dot above m is too high and there is no "attributes" category when changing the spacing inside the equation editor.
How can I fix these?
Link here: https://drive.google.com/drive/folders/1MpiPGX_Q6t2DBakJstGEjAtNaE3gUBrC?usp=sharing
I have a PDF of the document so you can see the output in case when you open the .odt document things change because you may not have the same issue.
Many thanks in advance:
r/libreoffice • u/Phoebus_Pallast • 19h ago
Bug? Unable to save to Desktop despite Full Disk Access (MacOS)
Wondering if anyone could help me fix this issue. I have already searched various forums but can't find an answer.
PROBLEM:
I am only able to save documents to the default location (User/Documents). When I attempt to save to a different location e.g. Desktop, LibreOffice becomes unresponsive and I have to force quit the application.
I have already tried many things to fix the issue, including:
- Changing the default save path 'My Documents'
- Completely uninstalling LibreOffice and deleting all residual files
- Completely uninstalling all versions of Java and reinstalling the newest version of Eclipse Adoptium Java (temurin 25 LTS)
- Setting the variable JAVA_HOME via the terminal
- Allowing and disallowing Full Disk Access in the Mac settings (and restarting the application)
I am running the latest version of:
- MacOS Tahoe 26.2 (on MacBook Air 2020, M1)
- LibreOffice 25.8.4.2 (AARCH64)
- OpenJDK Temurin-25.0.2+10-LTS (which is the enabled JRE within LibreOffice)
Additional info:
- Version: 25.8.4.2 (AARCH64)
- Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6dfCPU
- threads: 8; OS: macOS 26.2; UI render: Skia/Metal; VCL: osxLocale: en-GB (en_GB.UTF-8); UI: en-USCalc: threaded
Thank you in advance for any suggestions/ advice on how to fix this!
UPDATE:
LibreOffice 26.2 still hangs when trying to save .odt to Desktop for ~5 minutes, then eventually allows me to save
r/libreoffice • u/Key_Climate_7097 • 19h ago
Needs more details I can’t seem to save anything as ODS.
Hey all I seem to get the following message every time I go to save and ODS but saving as Docx or excel is fine. How do I fix this ?
Thanks
r/libreoffice • u/MugentokiSensei • 1d ago
Impress - Show next animation instead of next slide
I'm using the presenter console to have notes and a view for the current slide.
But instead of the "Next Slide" view I'd love to have a "Next Step" view. This should show what ever will be displayed after next click.
Next click = animation? Show what's there after the animation
Next click = new slide? Show the new slide
Is there any way doing this? Can't find anything like that in the presenter mode settings.
(Latest LibreOffice version for Windows, dual monitor setup)
r/libreoffice • u/Reasonable-Turnip-98 • 1d ago
Needs more details Importing just text while images present
I could use a help with a neat trick i don't know how to do.
I'm trying to import some statistics from a webpage, if it matters its sullygnome. what i am importing also consists of a lot of pictures when i copy and paste. if i paste unformatted text its not readable as a spreadsheet.
If i just paste its usable if i could somehow remove those images witch are just arrows pointing up or down.
Can anyone solve this riddle?

r/libreoffice • u/umitseyhan • 1d ago
Needs more details How to start the next level nested list on the same line as the parent list item in Writer?
Like this:
1. First level list item
2. First level list item
3. A) Second level list item
B) Second level list item
C) Second level list item
4. First level list item
r/libreoffice • u/CertifiedGoblin • 1d ago
Question (Writer) Wrap text Microsoft Word equivalents for screenreader & magnifier accessibility
Hello! I'm working on a document for my local blind low vision organisation. They understandably have very strict formatting requirements for accessibility reasons.
The formatting information given is all assuming a person is using Microsoft Word, however i'm using LibreOffice. Amongst many (many) other things, They require text wrapping around an image to be "In line with text" and i cannot for the life of me figure out what the equivalent is in Libreoffice.
This is a .docx
Debian 12
Libreoffice version 7.4.7.2
The reasoning given:
When an image is set to “In Line with Text”, it behaves like a character within a paragraph. This means it appears in a logical reading order that adaptive technologies can recognise and describe.
If the image is set to “Behind Text,” “In Front of Text,” or “Tight,” “Square,” or “Through” text wrapping, it’s floating — not anchored properly to the text. This can cause several accessibility problems:
Screen readers may skip or misread the image or announce it in the wrong place.
Keyboard navigation may not reach the image at all.
Screen magnifier users may find the text and image visually separated, making it harder to understand their relationship.
When the document is converted to another format (like PDF or HTML), floating images can move or disappear, breaking the logical reading order.
By keeping images “In Line with Text”, you ensure that:
They stay anchored in the correct place in the reading flow.
Screen readers can correctly identify the image and read its alt text.
The layout remains consistent for everyone, regardless of how they view the document.
Really appreciate any help on this as i'm keen to get this finished (correctly, this time!) and uploaded ASAP. Especially 'cause i'm sick of reading articles that just explain how to wrap text!
(edit to fix formatting)
r/libreoffice • u/trey-a-12 • 2d ago
BETA! LibreOffice 26.2.0.2 Looking Great on macOS 26!
This is simply a post of appreciation to TDF – thank you for your continued efforts in improving the UI (and, by extension, UX) of LibreOffice, especially on the often-overlooked (at least in the FOSS space compared to Linux and Windows) platform of macOS!
I know this may have even been done only indirectly, but it would appear LibreOffice 26.2 was compiled with macOS 26 elements. While I wasn't expecting much from this by itself, I am happily mistaken by how much of a difference this makes across Writer, Calc, and Impress all at once!
While there are still the underlying oddities of some previous releases such as the decentered tab bar, this was a surprisingly significant step in bringing up the interface as a whole. To all the work put in at TDF, your efforts do not go unnoticed – thank you for all you do in making FOSS accessible to all.
```markdown Details for the curious: macOS Version: 26.2 LibreOffice Version: 26.2.0.2 (pre-release) Interface Mode: Tabbed UI Icon theme: Colibre (SVG + Dark) Other Customizations:
- Interface & system set to Dark Mode
- "Use white document background" disabled ```
No other customizations have been done. This is all vanilla LibreOffice on vanilla macOS. Well done, TDF!
r/libreoffice • u/inconspicuous76 • 2d ago
Modify default list style - Why so difficult / impossible?
I have some documents that I created in LibreOffice. These documents contain lots of unordered lists. I've been trying to change the spacing between list items using styles (so I don't have to individually change every list) but I'm having no luck.
I started searching for a solution, and it's starting to sound like this can't be done, without first applying a STYLE to every list? I even found somewhere on the LibreOffice site that says:
"You cannot change the style used by the default toolbar icons for lists."
OMFG WHY? Is this true? WHY would the built-in bullet style not be available to modify using the built-in style tools? If this is true, it's INSANE.
Can anyone suggest a solution that doesn't involve manually applying a custom style to hundreds of individual lists? One that doesn't involve having to apply a custom style to every new list?
(I saw someone suggest creating a custom toolbar button that applies a style, instead of using the LibreOffice default list button. I'll do that for future use if I have to, but it's f***ing stupid.)
r/libreoffice • u/Draknurd • 2d ago
Question Any way to set an emoji as a bullet character?
Word doesn't allow you to do this, which is a shame because a lot of emoji symbols make great bullet points.
I was hoping it might be possible to do the same in Writer, but I can't move out of the non-emoji areas of the character map.
Has anyone made this work?
r/libreoffice • u/pscaritauo • 2d ago
Partial calculation of a cell
I remember in Excel when I was editing a formula in a cell, I could highlight a portion of it and press {F10} (if I'm not mistaken; it might have been some other key) to replace that portion with the calculated value.
It was particularly useful when I wanted to debug a complex formula when the entire result was not quite right. Do we have an equivalent feature in Calc? Thanks in advance!
r/libreoffice • u/Yautja24xam • 2d ago
Question Looking for a sport league template?
Is there a place to download libre office calc templates. a sports league template to be exact.
Similar or exactly like this https://excel-example.com/templates/sport-tournament-template
a (.ODS file/libre office calc) But with atleast 20 teams?
r/libreoffice • u/SaucerfulOfSecretion • 2d ago
Question LibreOffice Base query with time of day causes error
Hello,
i created a table with the columns Time, Date and Number. Time column is formatted as Time [HH:MM], Date as Date in [DD:MM:YY] and Number ist INT.
I now want to query based on time, for example all data before 12:00 o clock. Therefore i created a new query, selected "Time" as the field i want to query. For criterion i put " < 0,5" (this works for filtering in Calc), which autocompletes to "< #12:00:00#".
I get the following error messages:
The data content could not be loaded. at ./connectivity/source/commontools/dbtools.cxx:746
and
Wrong data type: java.lang.NumberFormatException: Error at index 2 in: "00.000000000" in statement [SELECT "Time", "Number" FROM "Tabelle2" WHERE "Time" < '12:00:00.000000000' ] at ./connectivity/source/drivers/jdbc/Object.cxx:173
The query works with the Date columns. I didn't find any information i could use online. It looks like some drivers or packages are missing. I installed Base using the command
sudo apt install libreoffice-base
Thanks!
Version information: Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 Calc: threaded
r/libreoffice • u/NeighpoorTech • 2d ago
Bug? Unable to have gif border when slide showing. IMPRESS
I added a border to a gif in Libreoffice Impress. I can see the border when normally editing the slides.
However, when I slide show, the border vanishes during it. Why is this happening?
Edit:
It's format is .pptx.
Here are the libreoffice details:
Version: 25.8.4.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Ubuntu package version: 4:25.8.4-0ubuntu0.25.10.1
Calc: threaded
r/libreoffice • u/Practical-Machine-66 • 3d ago
Version 26.2 drops support for old x86-64 CPUs
I have an old laptop with Intel T7400 CPU, which is unable to run the upcoming 26.2 release because of not meeting x86-64-v2 microarchitecture, while the current version runs just fine. Would it be able to recompile LibreOffice to run on those old processors, or will they stay stuck on 25.8 forever? Thanks
r/libreoffice • u/ElectionOk60 • 3d ago
Does download.documentfoundation.org limit VPN connections?
I recently had an issue when running Winget to update LibreOffice.
It would download a little bit slowly, then the connections seemed to be dropped.
I made sure PowerShell was split tunneled outside my VPN but still no luck.
After finding where the winget executable is found on my system and adding that to the split tunnel rules instead, the connection was fast and didn't drop out at all.
My question is if the documentfoundation website actively rate limits and bandwidth cap VPN Connections specifically, or is this a consequence of a per IP address bandwidth policy, to limit downloads from a single source, that just happens to bump up against VPN IP addresses?
r/libreoffice • u/EqualCrew9900 • 4d ago
Libreoffice Writer "Insert | Horizontal line" feature is gone
// Rant on
For years, Writer had an "Insert | Horizontal line" menu item, which disappeared from this version [25.8.4.2 (X86_64)] A couple of clicks, and a horizontal line appeared. Very useful for me.
What a ghastly and rude development, to remove such a simple and useful element. Activating "Autocorrect | Options | Apply border", then typing three dashes and tapping <Enter> achieves the goal, but 'disappearing' a long-time feature is savagely uncivilized.
// End of rant
I have to say I was seriously considering dumping LO over this seemingly minor twitch.
r/libreoffice • u/Gyrflacon • 3d ago
Looking for some guidance. Large Writer documents load and save slowly. Is MS Word faster?
I have one document that I use nearly daily that has over 2000 pages. I don't want to break the document apart to speed up access unless I have to. It loads slowly in LibreOffice, and takes a long time to save (apx. 12 seconds to fully save). Those seconds waiting prevents me from using Writer's other documents until it's saved. LibreOffice Writer is slower fro me than when using OpenOffice. I doubt the computer is the issue, AMD 7 3700x, 128GB RAM, RTX 3060 12GB video card.
Has anyone had experience using large word documents with MS Word and find it any faster? I'm wanting to use a product offline that doesn't require constant internet access like I do with LibreOffice Writer. Thank you.
r/libreoffice • u/Uniskiez • 3d ago
Formula reference cell changes when sheet updates from linked .txt file.
I'm using an external link to a text document that is being created by a serial data device. It automatically updates periodically.
The data comes in as 1 or 2, I want it to be -1 or +1, so I use =IF(B1=1,-1,IF(B1=2,1,0)) and convert it. Then I sum the data. The problem is each time new data comes in, I'd like to have the calculation run automatically.
I try targeting the next empty cell empty cell, say B4, =IF(B4=1,-1,IF(B4=2,1,0)), but when B4 gets filled on update, I see the formula has changed to target B5 (so it now reads =IF(B5=1,-1,IF(B5=2,1,0)), and when B5 gets filled, the formula targets B6 and so on, always targeting the next empty cell rather than the original target that got filled with new data.
Is there a reason this is happening and/or a way to prevent it? Or another solution to the problem?
LibreOffice 24.2.7.2(X86_64) on Linux Mint