[libreoffice-users] Re: scalc 3.6 date format problem

Am 17.08.2012 22:12, Tinkerer wrote:
> I am using Libre Office 3.6.0.4 on an iMac 10.8
> if I enter the date as 17/08/12 it is displayed as 17/08/2012.
> No doubt whatsoever that the date is being accepted using ddmmyy


OK, we could collect valid input pattern for dates in 180 different locales.

1) German:
Input of 1/8/12 gives a text. All spreadsheets I know treat 1/8/12 as a 
number of subtype date. Same with 1/8/ or 1/8 or even 1/ but not LibO 3.6

2) English(UK):
1/8/12 yields the day number of 1st of August 2012, 1/8/ yields this 
year's 1st of August, 1/8 and 1/ yield text.

3) English(US):
1/8/12 yields the day number of 8th of January 2012, 1/8/ yields this 
year's 8th of January, 1/8 and 1/ yield text.

I believe that the OP's date entry is not recognized because the "-" is 
not the one and only date separator for the locale he is using.


--
For unsubscribe instructions e-mail to: users+help@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