2012/7/23 Johnny Rosenberg <gurus.knu...@gmail.com> > 2012/7/23 Guy Voets <nimant...@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+h...@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