LibreOffice - how to get rid of an overwriting bug in Calc?
Thread poster: Zea_Mays
Zea_Mays
Zea_Mays  Identity Verified
Italy
Local time: 01:12
English to German
+ ...
Nov 16

For some clients I need to work on sometimes also longer text in calculations sheets.
Since I switched from OpenOffice to LibreOffice, a very annoying bug is driving me crazy in Calc (Excel equivalent).
When typing text in a cell, as soon as I approach the cell border, the overwrite feature is often enabled automatically, meaning part of what I was writing is deleted. Same happens when using the Delete features in both directions - after deleting text, the overwrite feature is enable
... See more
For some clients I need to work on sometimes also longer text in calculations sheets.
Since I switched from OpenOffice to LibreOffice, a very annoying bug is driving me crazy in Calc (Excel equivalent).
When typing text in a cell, as soon as I approach the cell border, the overwrite feature is often enabled automatically, meaning part of what I was writing is deleted. Same happens when using the Delete features in both directions - after deleting text, the overwrite feature is enabled. If you don't leave the cell, it can be restored with command+z, otherwise it is gone.
Has anyone else experienced the same, and if so, how did you get rid of this really irritating behaviour?
Thanks a lot for any help!
▲ Collapse


 
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
German to Dutch
+ ...
OS Nov 16

Zea_Mays wrote:

For some clients I need to work on sometimes also longer text in calculations sheets.
Since I switched from OpenOffice to LibreOffice, a very annoying bug is driving me crazy in Calc (Excel equivalent).
When typing text in a cell, as soon as I approach the cell border, the overwrite feature is often enabled automatically, meaning part of what I was writing is deleted. Same happens when using the Delete features in both directions - after deleting text, the overwrite feature is enabled. If you don't leave the cell, it can be restored with command+z, otherwise it is gone.
Has anyone else experienced the same, and if so, how did you get rid of this really irritating behaviour?
Thanks a lot for any help!


That’s the Mac version? Can you make a screen recording?


 
Zea_Mays
Zea_Mays  Identity Verified
Italy
Local time: 01:12
English to German
+ ...
TOPIC STARTER
@Hans Nov 16

Yes, on a Mac. It is very difficult to reproduce as it happens randomly. Maybe I also type too fast for the rendering engine
After some research - seems to be a known bug -, I've found among others this method: Tools > Options > LibreOffice > View and uncheck 'Use Skia for all rendering', then restart Calc. Let's see if it works (tomorrow).
Next would be some preference change in the Expert mode but I hope th
... See more
Yes, on a Mac. It is very difficult to reproduce as it happens randomly. Maybe I also type too fast for the rendering engine
After some research - seems to be a known bug -, I've found among others this method: Tools > Options > LibreOffice > View and uncheck 'Use Skia for all rendering', then restart Calc. Let's see if it works (tomorrow).
Next would be some preference change in the Expert mode but I hope this is enough.
▲ Collapse


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

LibreOffice - how to get rid of an overwriting bug in Calc?







Draftsmith
Edit Translations Faster With Affordable AI You Can Trust

Draftsmith is an affordable AI editing tool for busy translators. It works directly in Microsoft Word, supporting the way you work ProZ members receive a 20% discount on a single user subscription of Draftsmith.

More info »
PerfectIt
Check translations faster for consistency, quality and style guide compliance

PerfectIt helps professional translators deliver error-free documents in Microsoft Word and PowerPoint. It helps improve consistency, ensure quality, and enforce style guides. ProZ members receive a 30% discount off individual purchases of PerfectIt.

More info »