LibreOffice Calc, typing in a cell constantly overwrites the same character over and over?

Work fine in my system

Version: (X86_64) / LibreOffice Community
Build ID: 420(Build:3)
CPU threads: 16; OS: Linux 6.7; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded

Please, always send your version of LibreOffice and OS

As the top/left part of the screenshot reveals, I’m under macOS Sonoma. Also, I forgot to add the LibreOffice version, but it’s

Sorry, I don’t know macOS

Alright, so today I have updated to macOS Sonoma 14.4 and re-tried under the same version ( and the bug is still very much there. I then gave in and replaced by AARM and the bug is exactly the same.

At the bottom of the LibreOffice Calc window, you should see, in the Status bar, Overwrite. Click it to change to Insert mode.

1 Like

Hi, thanks for your suggestion, but it’s never on “Overwrite” and always seems to be on “Insert”. Here’s a video proving it. Click on the “broken” canvas to open it directly in a new tab (this forum does not allow large GIF pictures)

Does it exhibit the same behaviour in Safe mode? Click Help - Restart in Safe mode - Continue in Safe mode

Yup, same exact behaviour in safe mode. If nobody knows, I’ll wait a couple days/weeks until 24.2.x gets in stable release and I’ll upgrade and re-test then.

Try pressing Fn+Enter once to toggle Insert mode in Mac.

Possible bug, see Bug 82599 - Insert and overwrite mode reversed in cell while editing on the Calc Formula bar

If it is not resolved by toggling Insert mode or by restarting computer then report a bug. If the developers don’t know about it, they cannot fix it, see How to Report Bugs in LibreOffice - The Document Foundation Wiki

FN+Enter does nothing except to validate the cell and then it selects the cell underneath it. But just so we’re clear, what do you mean by “toggling” the insert mode? It’s constantly in insert mode already as you can see in my animated GIF from yesterday. I also discovered that you don’t even have to type “123.45 total”. You can repeat the bug with any 2 words, e.g. “abc abc” does the same bug when you try to highlight the first “abc” and type over it.

The bug I referred to shows Insert when it has switched to Overwrite mode.

Please file a bug report and give the bug number here in the form tdf#1234567 so it creates the link. Cheers, Al

i think i have seen the same / very similar behavior on my system
but for me it is not reproducable - it just occures sometimes -
and is gone if i restart libreoffice…

Version: (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.5-0ubuntu0.23.10.1
Calc: threaded

Just clicking Overwrite in the status bar at the bottom or pressing the Insert key should fix it.

If not then try these steps before submitting a bug report, First steps to take before submitting a bug - The Document Foundation Wiki

There’s no such thing as “Overwrite” in the status bar when this happens, at least on my side. I kindly ask you to please read the thread carefully before replying. You reply a lot in this thread, but it doesn’t make much sense. Look at the GIF animation at the top of the thread to see my whole screen.

It was intended for the previous, new comment for whom it happens only occasionally so is unlikely to be the issue you encounter. The normal way of switching between Insert and Overwrite will probably work for them.

Did you report a bug? Please post the bug number in the form tdf#123456. Cheers, Al

1 Like

I have a related problem. From time to time Libreoffice switches randomly in replace mode while typing inside of a cell. It might be related to special characters in the german (ö,ä etc.) but it ist not reproducible.
It is definitely not related to the toggle insert/ replace button.

Then open a new topic and put a link to this thread, if you think it is related. You may have noticed @marctremblay don’t like other topics in “his” thread:

You’re entitled to being wrong and make a fool of yourself by quoting me completely out of context, but know that I don’t appreciate you trying to make me look like an idiot. Read the thread and then perhaps you’ll understand the context of the sentence that you blindly quoted (or perhaps not).

In any case, please refrain from speaking for me, especially if you’re going to arrogantly warp my quotes. After seeing Wanderer’s reply, I’m now 100% sure this forum is definitely not a place to report bugs. Looks like a kindergarten.

You are absolute correct, this is not the place to report bugs. See This is the guide - How to use the Ask site? - #3 by Hrbrgr

The correct place has already been posted here, How to Report Bugs in LibreOffice - The Document Foundation Wiki

But please report the bug number back here

AFAIK nobody has bothered to report a bug yet.

Check the context yourself. I quoted from your reaction to the first “similiar problem” question by s-light1. So I guess it fits as a warning for the next questioneer.