I thought it was totally absent, which is why I went to Tools ► Customize and looked for it, but once I found where it would normally be put, it was apparently already checked! Yet I don't see it... I have no idea of what to do.
And no, it's not in the drop-down arrow by the "U," which is only more customization of the underline.
I thought in other word processors you could simply right-click them and find a "delete" button, but there seems to be no such thing in LO Writer. Does anyone have any leads? Much appreciated!
Solved by u/[email protected] Thanks!
A setting: Choose Data - Calculate - AutoCalculate.
Hi all,
I’m experiencing an issue in LibreOffice Calc where I have several columns that check a single column for any value (i.e., not blank) before showing their own values. Whenever I make changes, I need to press F9 to correctly update and show the edited values.
For example, I’m using the following formula:
=IF(s1+"","",IF(n1>5,"big","little"))
Instead of showing "big" or "little," it shows "0" until I press F9. After pressing F9, it updates to "big" or "little" based on the condition for s1.
Some context:
undefined
My setup: LibreOffice Calc 7.4.7.2, running on Linux Debian
My wife's setup: LibreOffice Calc 7.3.4.2, running on Windows, and her spreadsheet works as expected without needing to press F9.
This issue started about 11 days ago, and it used to work correctly before.
Has anyone experienced a similar issue or know how to fix it? Any help would be greatly
Next Wednesday, on March 26, we will celebrate Document Freedom Day 2025. During the day, we will mainly talk about the ISO Open Document Format, which was approved in 2005 by OASIS and in 2006 by ISO. Due to the global scale of the LibreOffice project, our events will be online. There will be three...
LibreOffice 25.2 is our new major stable release, with many new features. This video which shows a few of them (also available on PeerTube) is in English but has subtitle translations in 17 languages, thanks to our awesome localisation communities! (You can see their work on this wiki page.) Join th...
Nearly a year ago, we posted about the German state of Schleswig-Holstein’s plan to move 30,000 PCs from Microsoft Office/365 to LibreOffice. Now, Stephane Fermigier from EuroStack – which promotes European technological sovereignty and open source – has posted an update, citing an article in the Ge...
My native language support is not working on libre office. It's a small country so the person who added support long time ago probably didn't look back after the version changes so the files no longer are compatible (i think that's why it's not working). I can offer to maintain the dictionary file for my language, as well as add more words and such. How do I go about that?
I also am a bit afraid of having to compile the whole suit to test for changes on dictionary. But if there's no other options I can do it.
With videos describing new features on YouTube and PeerTube Berlin, 27 February 2025 – LibreOffice 25.2.1, the first minor release of the new LibreOffice 25.2 volunteer-supported office suite for Windows (Intel, AMD and ARM), macOS (Apple Silicon and Intel) and Linux is available for download from o...
In one month, on March 26, we will celebrate Document Freedom Day 2025. For the first time in a while, the LibreOffice project will play a major role in organizing the event. During the day, we will mainly talk about the ISO Open Document Format, which was approved in 2005 by OASIS and in 2006 […]
I remember first hearing about it a few years back but after that I didn't hear anything about it again so I decided to check. Seems like its still under development. I would have built it but the source code is ~6 gb which is probably too much for my relatively dated computer (to build).
The new major release provides many user interface and accessibility improvements, plus the usual interoperability features Berlin, 6 February 2025 – LibreOffice 25.2, the new major release of the free, volunteer-supported office suite for Windows (Intel, AMD and ARM), macOS (Apple Silicon and Intel...
The histogram says it all. First, rapid growth between 2011 and 2014 to 30 million downloads, despite the fierce hostility of the project created to kill LibreOffice. Then a few years of stagnation, at a time when it seemed that desktop office suites were destined to die, and fashion was driving use...
Dione Maddern and The Documentation Team are proud to announce the immediate availability of the LibreOffice Calc Guide 24.8, an update of the existing Calc Guide 24.2 with enhancements taken from the current LibreOffice 24.8 Calc module. The book was reviewed for clarity, readability and content ad...
LibreOffice 25.2 will be released as final at the beginning of February, 2025 ( Check the Release Plan ) being LibreOffice 25.2 Release Candidate 1 (RC1) the third pre-release since the development of version 25.2 started in mid Juny, 2024. Since the previous release, LibreOffice 25.2 Beta1, 175 com...