[libreoffice-users] date acceptance patterns not sticking

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 dd.mm.yyyy. (OSX 10.9.x)

For some reason Libreoffice (4.3.1.2) 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
D.M.YYYY;DD-MM-YYYY;D-M

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.
B.

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

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted