Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Libreoffice is driving me nuts.

I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD.

I have my Mac set dates to (OSX 10.9.x)

For some reason Libreoffice ( will only accept dates in the YYYY-MM-DD format.

I'm happy that I can format the date to look DD.MM.YYYY but entering in the YYYY-MM-DD is totally unnatural for me.

Actually, I only usually type the DD.MM and expect the YYYY to show up automatically in Excel. I'd like the same behaviour in LO if possible.

The date acceptance patterns will not accept anything except what is loaded by default ... which is

I don't want to have to type the YYYY each time for D.M.YYYY.

I've tried to add D.M to the acceptance pattern but the text turns red and won't save. The D.M is always gone after trying to save.

So if the date acceptance patterns are supposed to be customizable by the user ...

what do I have to do to get this to work?

Thanks in advance.

PS I'm on digest mode.  Please CC me directly

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.