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)

Title: Incomplete Turkish Translations in LibreOffice 26.8 on Windows and Linux

Hello everyone,

I am using LibreOffice version 26.8 with Turkish selected as the interface language. However, some interface elements are still displayed in English on both Windows and Linux.

For example, “Delete Columns” appears in the right-click context menu, while “Extensions” appears in the status bar.

I would like to request that missing or incorrect Turkish translations be reviewed and corrected across all LibreOffice applications, including Base, Calc, Draw, Impress, Math, and Writer, as well as the main menus, context menus, status bars, and other interface elements.

Please ensure that all interface text is displayed consistently in Turkish when Turkish is selected, on both Windows and Linux.

Thank you for your work on LibreOffice.

Konu: LibreOffice 26.8 Linux Sürümünde Türkçe Arayüzde Görünen İngilizce İfadelerin Düzeltilmesi Talebi

Sayın LibreOffice Geliştirme ve Türkçe Yerelleştirme Ekibi,

Linux işletim sisteminde LibreOffice 26.8 sürümünü Türkçe arayüzle kullanıyorum. Ancak arayüz dili Türkçe olarak seçilmiş olmasına rağmen programın bazı bölümlerinde İngilizce ifadeler görüntülenmektedir.

Örneğin, Calc uygulamasında bir sütuna sağ tıklandığında açılan menüde “Delete Columns” ifadesi, durum çubuğunda ise “Extensions” ifadesi İngilizce olarak görünmektedir. Bu durum, programın genel arayüz dili Türkçe olmasına rağmen kullanıcı arayüzünde dil bütünlüğünün sağlanamadığını göstermektedir.

Düzeltilmesini talep ettiğim bölümler şunlardır:

LibreOffice Base

LibreOffice Calc

LibreOffice Draw

LibreOffice Impress

LibreOffice Math

LibreOffice Writer

Dosya, Düzen, Görünüm, Ekle, Biçim, Araçlar, Pencere ve Yardım gibi üst menüler ve bunların alt menüleri

Sağ tıklama ile açılan bağlam menüleri

Durum çubuğu ve bu çubukta yer alan ifadeler

İletişim pencereleri, sekmeler, düğmeler ve diğer kullanıcı arayüzü öğeleri

Türkçe arayüz seçildiğinde, yukarıdaki tüm uygulamalarda ve menülerde kullanıcıya gösterilen ifadelerin eksiksiz ve tutarlı biçimde Türkçe görüntülenmesini rica ediyorum.

Özellikle çevirisi eksik kalan veya yanlışlıkla İngilizce görüntülenen ifadelerin tespit edilerek Türkçe çeviri dosyalarının ve ilgili arayüz metinlerinin düzeltilmesini talep ediyorum.

Bu iyileştirmenin yalnızca tek bir uygulamayla sınırlı kalmayıp Base, Calc, Draw, Impress, Math ve Writer dâhil olmak üzere LibreOffice paketinin tamamında uygulanması, Türkçe kullanan kullanıcıların programdan daha kolay ve verimli yararlanmasını sağlayacaktır.

Gereğinin değerlendirilmesini ve ilgili çeviri eksikliklerinin giderilmesini rica ederim.

Saygılarımla.

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

I recently switched from MS Word to LibreOffice, but sometimes I forget to open the menu to open it with LibreOffice. I'd like to have Word (and .odt, ideally) documents open in LibreOffice by default, but I can't remember how. I'm using a MacBook Pro with Tahoe 26.6.2; do I need to change this in my system settings or LibreOffice settings?

Edit: TalkToHoro's instructions worked! I'm going to ELI5 for the benefit of any hypothetical future reader with the same problem.

I had already tried right clicking the file and using "Open with…", which I was already doing to open the files in LibreOffice, but that menu didn't have an option for making LibreOffice the default. What worked was going to "Get Info" in the menu (or using the ⌘i keyboard shortcut) and going down to the "Open with" menu; underneath, it said "Use this application to open all documents like this one" above a button reading "Change All…", which became clickable after I used the menu to change it to LibreOffice. This is what it looked like.

Finished a book, which is great. But I added a table of contents, but it isn't showing in epub readers.

I see it in Libre, set it to find the chapters by having it set to the TITLE HEADING.

Any suggestions?

Edit I exported as an epub in Libre.

Happens when i zoom out of an object in Writer, i have tried enabling hardware acceleration and it doesn't fix it. Happens both in fedora and windows.

As the title says, this strange box randomly appeared in the ruler bar above my document. It puts a hard stop on where my text can go, and the margin indicators shift with it for some reason. I haven't been able to find what it's called or how to get rid of it, so any help is greatly appreciated.

Thanks!