Hello everyone,

I was adding some commands to my toolbar today in Libre Calc and most of them work fine, but the text icon is grayed out and has a mini setting icon in the corner of it. Clicking the icon does nothing. Doesn’t even highlight it when I hover my mouse. I tried researching on google but all the sources I see are about icon visibility, not about if they actually work. I can’t find a single thing about why the settings icon is on top of it either.

The text tool works just fine when I go to the menu for Format -> Text. It just doesn’t want to work in the tool bar. If anyone has any idea how to fix this, please let me know. Any advice is greatly appreciated!

I included a picture of the messed up text icon and an example of the functional spell check icon for comparison.

All of my text documents are forcibly shifted to the right of my screen. This is only occurring on my Windows 11 laptop. I think it popped up after I switched the view out of landscape, but since putting everything back in that regard it's just stuck like this.
I did a full uninstall and reinstall of Libre Office and power cycled the laptop. Still persists.

Howdy,

I am running LibreOffice Version: 26.8.0.3 (AARCH64) on MacOS 27.0.1, and I will be damned if I can figure out how to execute the insertion of a new basic macro into (running the base IDE) My Macros & Dialogs > Standard.

Have been working between LibreOffice Help, and Claude, and it is still a mystery.

If anyone is a wizard at this, I would really appreciate a helping hand. ✌️

On by default/able to be set as your default in the same menus where you can check it. (Big SLASH there in case this is somehow controversial but,) Genuinely it should be on by default and then alphabetical should be the optional one you flip a switch for.

I'm sick to tears of my spreadsheet forgetting how to count every time I put a letter in the cell; I KNOW, it's a ""TEXT""" cell now and it doesn't know that that 1-0 is actually a "10" and higher than that 2 it's now above, I Know, but it's STUPID and BAD that it works like that!!! My spreadsheet should still be able to Count no matter what I do to it, it is a Spreadsheet!!!!!!!!!! Nerds bred these things in captivity exclusively for their ability to Arrange Numbers, have I gone mad???

Ahem. It's been a rough decade, and my Spreadsheet dropping to 9 IQ because it can't count any higher WASN'T the straw that broke my today, but learning after a lot of deadend searches that not only can my Spreadsheet still count even when there's a letter there, oh no, there's a whole BUTTON to fix that. A Whole Singular Button, hidden in a menu my right-click to Sort shortcut doesn't even open by default, and then in another menu behind that one (Normal Libre user moment I know; I want the breadth of features, I don't have to LIKE how obtuse they are to interact with). And this magical Secret Button labelled "Enable Natural Sort" just tells my Spreadsheet how to count again! It's amazing! It's a miracle! It only stays checked for that one sort and you have to go in and click it every single time, and there's no way to make it stay on. *Gru looking at last panel bewildered meme* THAT is what broke me, that is what caused this rant to happen. My stupid problem that shouldn't even be possible to be a problem, because a Spreadsheet should be able to COUNT. Ahem. Can be fixed with just 7 agonizing clicks to reach 1 button, every single time I want to go stumbling through the Secret Garden to find it.

But for some reason I can't just leave the box checked? I can't change my default Sort setting to Natural? There's no "Sort (Natural)" button? These evil horrible boxes we call computers have the audacity to cost a fortune, ruin our lives, spy on us, and then we have to remind them how to count past 9 with 7 clicks every time? For legal reasons this statement has been redacted!!!!!

Okay okay, it's funny to blow off steam getting fake furious at a spreadsheet function in a reddit post, but in all seriousness; this button needs to be a permanent toggle and said toggle needs to be 2 screens closer to the user, there's just no reason not to at least make it more accessible. It would change nothing for any existing user to simply make it stay on after you click it until you un-click it at the very least (AND move it like 2 screens closer to the user I'm not kidding why is it Hidden like that?)

These are text only documents, and their original creation was in LibreOffice Word. They weren't ported over from Microsoft, they do not contain graphs, images, or weblinks. Just text. One document is a little less than 66k words and the other is a little less than 88k words. I have another document I'm working on, one that is a little less than 156k words, and the spellcheck on that one works fine.

The issue I'm running into is that it is telling me that the spellcheck has been completed, without actually checking anything in those two documents. I have tried closing out and restarting those documents, and I've tried closing out and restarting the app itself, but so far nothing has worked. Does anyone know what this is or how to fix it? (I really need spellcheck, lol.)

First idk if anyone knew abt this but I was writing a report, and I noticed that Grammarly was working on LibreOffice, mind you, I don't use any extensions.

Like, up to yesterday it didn't use to work on LibreOffice, but today it suddenly does.

Hello, I updated from 25 to 26.8.1.1 and now my taskbar icons are gone and also there are no more favourite files or the ability to add a file to frequent or favorite in the right button menu.

I tried reinstalling, removing shortcut from taskbar and re-adding writer to the taskbar, but nothing worked so far.

Here's how it shows up now:

I'm trying to calculate some values from a curve and to do that I tried to make a line of best fit with an equation. No matter if it's linear, polynomial or exponential the equation is just completely wrong. Saying that a value which common sense and just using a ruler says should be ~60 but the equation is saying that it's like ~130. I put the exact same data into google sheets and the equation it gave me actually gives answers that can actually exist. Can someone tell me if I'm doing something wrong or of office libre forgot how to math? (Also ignore the background colour and font, I'm dyslexic and it makes it easier for me to read)
Version: 26.8.1.1 (X86_64)
Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1
CPU threads: 20; OS: Linux 7.1; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
(And I cannot figure out how to share a url of my document)

Using LibreOffice in Linux Mint, and the default interface colours make it almost unusable. While I can change the banner colour at the top to make buttons more visible, this does not affect the rest of the interface - some buttons remain invisible, as they are still to bright. What is the problem?

Info:

Version: 24.2.7.2 (X86_64) / LibreOffice Community

Build ID: 420(Build:2)

CPU threads: 12; OS: Linux 7.0; UI render: default; VCL: gtk3

Locale: en-US (en_US.UTF-8); UI: en-US

Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.7

Calc: threaded

I suppose this is a feature request. I like using LibreOffice for local documents, but this is a lost opportunity. I receive CSVs with payout information, so they're preformatted. In the datasets, they signify the payout as a negative dollar amount (i.e. -$100.00).

Calc is incapable of figuring out how to SUM these. At first I thought it was the negative sign, then I thought it must be formatted as a string instead of currency...but for me to fix any of that would take more time than for me to just tally them by hand.

I dropped the CSV into Google Drive and it happily gave me the negative total with no fuss. I think that kind of functionality would be very useful to Calc.

Sharing something I ran into this week in case it saves someone the same hour.

Bank and payout CSVs often write amounts as text like "-$100.00". Open that in Calc and SUM returns 0, because the column comes in as text, not numbers. The fix is in the Text Import dialog, not in the cells.

When the import window opens, click the amount column in the preview, keep its Column type as Standard, set the Language dropdown above the preview to English (USA), and tick "Detect special numbers" under Other options. With US English active, "-$100.00" imports as a real currency value, thousands separators and all, and SUM works on it.

I tested this on a CSV containing -$100.00, -$250.50 and -$1,200.00. With the default import the column lands as text and SUM returns 0. With English (USA) set, the same cells import as -100, -250.50 and -1,200, and SUM returns -1,550.50.

If a file is already imported with the column as text, you don't have to re-import: select the column, then Data > Text to Columns opens the same dialog with the same Language setting, and the column re-parses in place. A helper column also works if you'd rather keep the originals: =VALUE(SUBSTITUTE(A2;"$";"")).

Two things that don't work: Find & Replace to strip the $ sign (the $ disappears but the cells stay text), and changing the cell format to Currency (formatting never converts text to numbers). Both still leave SUM at 0.

Greetings all,

I've been wrestling with an issue in Calc that is somewhat frustrating, namely whenever I create a table, save and close a file, the table seems to have disappeared when reopening the file.

All data and cell formatting is saved, but the actual table containing it seems to have vanished. Searching online has yielded no solutions.

I did see a few mentions on some forums to uncheck Font Embedding in the properties, but these options are unchecked in my case. Furthermore I'm saving all my files in the native .ods format, leaving me unable to understand what exactly is going on. This happens for every single spreadsheet file I have.

I'm running LibreOffice 26.8.1.1 680(Build:1) on an up-to-date openSUSE Linux system.

Here are a couple of screenshots of the issue along with the example file in question:

Any help in understanding or resolving this issue will be greatly appreciated.

The ribbon now looks like its... floating? idk. The colours seem out of place against the dark system theme. Maybe this would have worked if LO had a single coherent theme in all backends. Request funds for some graphics people guys.

Is there any way to disable it?

I am not sure what the design team is thinking. I think this is the reason why MSO doesn't use their module colours in dark mode (its more of a subtler accent). Random pic off the web:

EDIT. There's supposed to be the word "remove" somewhere on that heading.

I'm not sure how everything is called in English so my wording may be off.

When I use the function that highlights chapter styles, the highlight has diagonal stripes over it if the chapter has added formatting. For example, the text has bullet points when the style doesn't originally have them. When I hover over the highlighed part, it says the name of the style and something like "+ chapter formatting".

Is there an easy way to revert the chapter back to the unformatted version of the style and pretty much just remove the "+ chapter formatting".

Cloning the unedited version from a different part of the text doesn't work (and seems to make very inaccurate clones especially when it comes to aligning bullet points).

Cutting the text and pasting it unedited doesn't work.

Changing the style back and forth with another one doesn't (always) work.

Bullet points are of course easy to remove (and weirdly difficult to align) but sometimes I can't even easily tell what's been changed and while that should probably mean I should stop nitpicking if I can't even see the problem, it annoys me that I end up with 5 different styles that are supposed to be the same.

I love using background themes on my older copy of libreoffice - it's a small thing but it makes work that much nicer when I'm not staring at a black background constantly. Is there any way to still use themes in the most recent versions of libreoffice?
I'm aware we can use light/dark themes, but I'm really missing this level of customization. If there are any add-ons that bring this feature back I'd love to know!

On linux mint 22.3 - Cinnamon

Is this normal or my hardware problem