Hi,
I just upgraded from LibreOffice 3.6 to 4.4, in Ubuntu Linux 12.04. Now when I type a date, Calc does not accept it as a date. In the older version, I could type “4mar” and then as soon as I clicked Enter, in the cell would appear “04-Mar-15” (assuming that’s how I’ve formatted that cell). Now, in the cell I just see “4mar”. As far as I can tell, the program has kept all the same settings as before. How do I fix this problem, or get around it?
Have a look to Tools→Options→Languagesettings→Language→Date-patterns
I’ve added the Patterns …;D+M;D+
Input 4+5 expands from pattern D+M to Date 2015-05-04
Input 4+ expands from pattern D+ to Date 2015-03-04
(missing Input-values are always substituted with Current Month or Year )
Additional Observations:
input Daynumber<space>abbreviated Monthname works also for me, except for March wich is in German Locale März … so Calc seems to fail on german Umlauts
Okay. Thank you, Karolus!
So I just have to type “4 mar” [Enter] now instead of “4mar” [Enter]. That works fine for me, without having to change any settings. But it’s helpful to know that those settings do exist.
I’m totally glad that I upgraded to version 4.4.