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

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

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