Guy Voets wrote: > 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.
Looking at the date formats available for Dutch/Belgium, there is no DD-MM-JJ. If you create a user defined format with this, you will be able to enter your dates as you always have. You just have to format the cells or columns first using this format. --Dan -- 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