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.

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.