Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012/7/23 Johnny Rosenberg <gurus.knugum@gmail.com>

> 2012/7/23 Guy Voets <nimantuis@gmail.com>:
> > Hi folks,
> >
> > A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past).
> >
> >    - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown
> as
> >    20 Jul 12.
> >    - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell.
> >
> > If I enter 20-7-12, the date is inverted into 12 Jul 2020.
> > So instead of entering 20-7, I now need to enter 12-7-20 to get the
> desired
> > notation 20 Jul 12.
> >
> > Is this a new feature, or a bug?
>
> I am a user, not a developer, so I don't know for sure, but it looks
> to me as a feature rather than a bug, or maybe a combination of both.
> 20-7-12 means 2020-july-12 (12th July 2020) according to ISO 8601, and
> I guess it could be a point adapting to this international standard
> (some countries already adapted most of ISO 8601, some of them decades
> ago). Maybe this behaviour should be more dependent of the current
> language settings?
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ

Hi Johnny, thanks.

I get your point...
The language/country setting is Dutch/Belgium, which normally should give
20-7-2012, and I liked the practicality of just having to type 20-7 to get
this date entered in the spreadsheet.
I suppose I'll have to get used to the ISO standard behaviour.
-- 
Guy
using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

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