The officially official Devuan Forum!

Altoid

Member

Registered: 2017-05-07

Posts: 1,582  

[Solved] LibreOffice question

Hello:

I'm slowly starting to loathe LibreOffice almost as much as MSOffice, which I had always used till I finally moved to a Linux environment, not without a lot of grief and getting used to.

I'll make it quick as this is dangerously off-topic:

Does anyone know how to disable the Data Validation of LibreCalc?
This POS application keeps putting a number I do not want to put in a cell but I have not been able to find a way to get rid of this feature.

I'm working on a very long and complicated 20+ year monthly expense expense sheet which I have to keep up to date and I want to be able to audit it myself.
I do not trust LO to do anything but sum up columns the same way I did not trust MSO.

Thanks in advance,

A.

Last edited by Altoid (2020-10-12 16:26:32)

Altoid

Member

Registered: 2017-05-07

Posts: 1,582  

Re: [Solved] LibreOffice question

Hello:

... disable the Data Validation of LibreCalc?

It's not Data Validation, it is something else that these DHs enable by default, à la Microsoft Office.
Incredible that they have not learned anything from their nemesis' shortcomings ...

This is yet another feature called, not surpringly, autoreplace.

To answer my question: one turns off autoreplace by going to the menu bar, selecting Tools > AutoCorrect Options...
You then click on the Options tab and uncheck the "Use replacement table".

My apologies for the noise.

Cheers,

A.