[libreoffice-users] Re: date acceptance patterns not sticking

Am 14.10.2014 um 22:20 schrieb bunk3m:
> 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.

Modify your default template for spreadsheets if you have any.
Add a German cell style for the dates.
Apply number format code TT.MM.JJJJ which means 2-digit Tag(day),
2-digit month and 4_digit Jahr (year)
Use that style for all cells where you want to use this input method:
25. => 25.11.2014 (this month's 25th day)
25.12 => 25.12.2014 (this year's 25th of December).
This can not work with any English locale because the point conflicts
with the decimal point.

Save this as your default template for your new spreadsheets:
File>Templates>Save... [some name]
FIle>Templates>Organize... pick your new spreadheet and choose "Set
Default" from the command button on the right.

Additionally you may define a custom shortcut to apply this style
(Tools>Customize>Keyboard, category "Styles".


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