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: [email protected]
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
