I’m searching for a way to disable the very annoying number formatting in Libre Office Calc. Whenever I enter some number or a string containing numbers, LO is trying to format a date out of it.
Pseudo-solutions:
I’ve found some so-called-solutions, but none of these works.
- Format cells to “text” – works, but only as long as one pastes or deletes from/to a specific cell. For example, if I paste some content, the formatting is lost again.
- Start typing with a single quote
'
. Not an option in daily working routine, just to enter a numeric string. - Deselect
Tools > AutoCorrect > Options > Apply Numbering
– there is no such option in Libre Office (at least not in version 3.5).
Use cases:
-
2-3
means “two to three whatever” -
5.2
is the code following 5.1 -
6.
refers to the sixth item
All those values are translated to some random date in Libre Office by default. I guess they were on drugs when implementing such a bug into the program.
Is there a global setting to turn off that featurebug?