So i downloaded libreoffice for work on windows 11 (Yes I'm too dumb to install linux mint on my pc)
And i noticed the icons look pixelated. Tried looking for an answer online but couldn't.
Hi All
I have a spreadsheet with a stack formatting some of which is direct e.g. various borders but a lot of which is conditional using vlookups involving named ranges in a separate sheet
Ultimately I want to lift a completely standalone copy of the sheet so that all the values are static and all the formatting is direct cell formatting so there's no reliance on any other data source
Making the values static is easy (Paste special > values) but I not been able to find a way to convert conditional formatting to direct cell formatting
I've done some research and found a downloadable set of add-on tools that includes a conditional convert feature but that same set of tools also includes features that I know are built into Calc e.g. converting character cases which makes me think the conditional convert tool is using an existing built in feature but is making it easier to access in some way
Before I go digging into the conditional convert tool to work out how it works can anyone tell me if I'm missing something and that there is already a convert feature built in but I'm just not seeing it
tia
Version: 26.2.4.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 32; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Ubuntu package version: 4:26.2.4.2-0ubuntu0.24.04.1~lo1
Calc: threaded
So when I try to open any document or even libreoffice itself, I get a splash page for like two seconds, then nothing. Nothing is in task manager.
What I've already tried:
Uninstall and Reinstall
Install the most updated version (26.2.4)
Uninstall updated version (26.2.4), install older version (24.8.4)
Try to repair installation (both versions)
Update graphics drivers on windows -as far as I can find, all my graphics stuff is up to date
Uninstall random updates on other apps that occurred same day the issue started (yesterday, July 3rd)
Run a virus scan (malwarebytes)
Open in safe mode via command prompt- this works with both new and old versions. Problem is nothing I change in settings stays changed and the next time I open in safe mode they're all unchecked again. After closing safe mode, or even saying "reopen in normal mode" I get a splash page for a few seconds, then nothing.
Change user folder to different name - all that happened was a new user folder was created, but nothing opened past the splash page still
I don't know what to try next or even what the issue might be. Any ideas? Is it truly a bug? Is it fixable?
Edit to add: all docs were saved in word 95/97 format as far as I know, and all calc sheets should be the equivalent. I'd never had an issue opening them with libreoffice till yesterday. It's not any one doc or calc sheet that won't open, it's all of them. Can't open them from file explorer, and can't get libreoffice open to open documents from there. Even the libreoffice home won't open.
The older version currently installed is: Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26200); UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Lately, I've seen a lot of people observing that LibreOffice is "lagging" for them. Unfortunately, this is a very ambiguous term. Could I get a quick thread running to ask what performance issues people are seeing?
So, for instance, you might have "lagging" affecting:
I am genuinely interested in knowing what specific performance issues people are experiencing.
I installed Collabora for Android on my GrahpeneOS phone. I also use Proton Drive for my cloud storage/device sync.
I can open a file from my Proton Drive in Collabora (.ods) and I can edit it but the changes are not saved to the file. I can't find a user guide but based on other posts I believe that the changes should be saved automatically when the file is closed. If this isn't the case, how are changes saved?
I've set the file to be available offline in Proton Drive and I can't find any file permission settings that may be an issue.
Any suggestions on what I'm doing wrong?
As in the title. I am using Calc as a spreadsheet to track achievements in a game, and one of the things in the game is to get "KOs" as in "Knock Outs" - but Libreoffice Calc is automatically turning the "KOs" into "Kos" with an autocorrect feature, even though I have literally turned off every possible autocorrect I could find.
There was no "autocorrect" check boxes or options I could find anywhere in Calc - All I could find was being able to turn off languages and spellcheck functions, which I have done, but it still changes the KOs into something else, even though I have specifically typed it as KOs.
Additionally, every time I untick the "Standard All" dictionary, it turns itself back on.
Is there a secret hidden option to obliterating the capitalisation "fixing" in the autocorrect that is hidden from all view?
Some screenshots of the settings menus;
Hey all, I'm not sure what I did, but today Libreoffice writer started being weird about em-dashes. I used to just type word--word and I would get word—word. The only trick was that the em-dash would only correct once I hit space after the second word.
Today, that has changed. Now it only corrects after I hit ENTER, which grinds my writing to an absolute halt. What have I done wrong? Did I change a setting?
Here's the information I can share:
From the About panel:
Version: 26.2.4.2 (X86_64)
Build ID: 0229ac93fcf0d7cbc6376066c6f35021cef002dc
CPU threads: 12; OS: Linux 7.0; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
More info:
In the tools menu, Autocorrect While Typing is checked:
Also, in the review tab, Auto Spellcheck is turned on.
Also, the problems I'm experiencing are happening in all documents, even new ones.
What do you think? Did I change something? What can I do to get it back the way it was?
Thanks in advance!
I deleted a row in a document and suddenly my document went down to 3 pages. It will not comeback with redo however I confirmed with Google docs that the information is still inside and will expand to several pages. What do I do?
Hi! I'm pretty new to using LibreOffice. I tried to figure this out on my own, but it's difficult when I don't even know what functions to be looking for.
The first image is the key to the cipher that I'm working on; the coded text is in green, and the decoded letters are to the right of them in white. The second image is the actual text I'm trying to decode. When I type a letter into the key, I would like the sheet to automatically fill in each spot in the ciphertext where the coded letter appears. Is it possible to do this using functions, and if so how?
Problem with "FIND". CELL "E"
E1 =IF(FIND("PAY",A1<>0)B1,0) Answer 113.75. Correct
E2 =IF(FIND("PAY",A2<>0)B2,0). Answer #VALUE. Should be "0"?
A B E
| TESCO PAY AT PUMP | 113.75 | 113.75 | ||
|---|---|---|---|---|
| B & Q 1179 | 79.76 | #VALUE! |
I am writing a guide/manual/handbook of sorts in writer on mac. I want the page numbers to reflect the chapter and page, in this specific format: chapter number - page number. So, chapter 1, page 3 is: 1-3, chapter 4 page 12 is: 4-12. Ideally the TOC would reflect that as well with:
Chapter 1
Info...1-1
more info...1-3
Is there a way to do that or a template or something? Thanks.
My Windows 11 installation of LibreOffice updated automatically this morning. After the update, the interface of all the services are messed up. Menus, dropdowns etc all have a series of 5 random characters folled by || then english (eg the document title bar in Calc reads: 9FEe5||Untitled 1GUUwt|| - LibreOffice Calc)
See the attached images. Is this a result of a setting I may have inadvertently changed?
When I say improve, I mean make them actually usable. Most of them the contrast is such that it's almost impossible to see what they represent.
I was going to say it's dark mode (cos it is dark) but the settings are set to light mode. It's definitely not light.
Can I get some guidance on how to make it default to a usable toolbar?
Automod requested info:
Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.5 Calc: threaded
Libre Calc .ODS if that matters
Not a document issue
First pic is the symbol that appears when I press option and drag and drop. Screenshot is what happens. It duplicates the row, instead of the 2 swapping places. I just want to rearrange my rows, I feel like it shouldn't be hard. What am I missing?
I'm keeping track of characters in my story using bullet points: high level is the name, then subordinate bullet points are characteristics, history, etc, all things related to that character and thus, should be indented under the name.
Problem is, hitting 'tab' does not indent and select a new bullet type. It only cycles through the bullet types on the same level of indentation. How do I change this behavior with a minimum of fuss?
file format is .odt
Version: 26.2.3.2 (X86_64) Build ID: 70e089b17412e4cb7773e41413306b17a2328c34 CPU threads: 12; OS: Windows 10 X86_64 (build 19044); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Hey everyone,
Don't get me wrong, I love LibreOffice Calc and use it daily. But let's be honest about one specific thing that drives keyboard power-users crazy: Formula Autoinput & Autocomplete.
If you've ever used Google Sheets or Excel, you know how smooth it is: you type =IF, a beautiful vertical dropdown appears, you navigate with the Arrow Keys, hit Tab, and boom—it's autocompleted.
In Calc?
I think it's time Calc's formula workflow got a modern UX/UI overhaul.
I just submitted a formal Request for Enhancement (RFE) on LibreOffice Bugzilla to address this and propose a clean, scrollable vertical dropdown with proper keyboard navigation and modern styling.
If you've also struggled with this or want to see a better formula entry workflow in Calc, please visit the bug report, add your thoughts/use-case in the comments, or cast your vote! The more engagement it gets, the higher it goes on the UX team's radar.
👉 Link to Bugzilla Report: https://bugs.documentfoundation.org/show_bug.cgi?id=172606
Let's show the devs some love but also push for the modern features Calc deserves! What are your thoughts on the current formula entry?
There is a sophisticated mechanism by which proprietary technology ecosystems maintain their grip on users and institutions, even when those users and institutions believe they are making free choices, using open standards, and building independent digital infrastructure.
The mechanism does not work through force, but through a subtler and more durable strategy: the layering of dependencies, in which each layer obscures the one beneath it, so that when the system fails the apparent cause is something other than the real one.
It is a structural pattern with identifiable components and predictable failure modes, and with a single political consequence: the systematic attribution of interoperability failures to open alternatives rather than to the proprietary dependencies that actually cause them.
Understanding all of this is essential for anyone working on a genuine interoperability policy, because without it even the best-intentioned policy interventions address the visible symptom while leaving untouched the larger problem of the underlying architecture, which goes on working exactly as designed.
#libreoffice #odf #ooxml
Hey everyone,
I'm running LibreOffice on KDE Plasma 6.6 with a 27" 1440p monitor scaled at 130%.
The problem: When running LibreOffice, the UI elements are way too small. Setting QT_QPA_PLATFORM=xcb fixes the UI sizing, but now the text quality is noticeably worse/blurry.
Here's what I've tried:
SAL_USE_VCLPLUGIN=qt5/6 without xcb → UI elements too smallQT_QPA_PLATFORM=xcb → This fixed the UI and it looks correct but text is blurryQT_SCALE_FACTOR=1.33 → just makes everything bigger, no sharpness improvementQT_AUTO_SCREEN_SCALE_FACTOR=0 → no visible differenceMy setup:
I need to stay at 130% scaling for readability. Has anyone solved this issue? Thank you in advance guys!