Guy Voets wrote:
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 shownas20 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 thedesirednotation 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+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