Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
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 ジョニー・ローゼンバーグ -- 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 -- 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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
Guy Voets wrote: 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 just downloaded LO 3.6.2 and installed it. Then I opened Calc. I also entered 20-7 in a cell and got 20-7. It seems that Calc considered that to be text because the window to the right of the = was showing '20-7. Then I right clicked a column and formatted it using Dutch (Netherlands) as the local. I also selected 31 dec 99 from the format list. Then when I entered 20-7 I got 20 jul 2012. 14-7 gave me 14 jul 2012. It may be a new feature in that you have to format cells, rows, or columns for the type of formatting you want in them. --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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
El 23/07/12 16:51, Dan escribió: Guy Voets wrote: 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 just downloaded LO 3.6.2 and installed it. Then I opened Calc. I also entered 20-7 in a cell and got 20-7. It seems that Calc considered that to be text because the window to the right of the = was showing '20-7. Then I right clicked a column and formatted it using Dutch (Netherlands) as the local. I also selected 31 dec 99 from the format list. Then when I entered 20-7 I got 20 jul 2012. 14-7 gave me 14 jul 2012. It may be a new feature in that you have to format cells, rows, or columns for the type of formatting you want in them. --Dan And maybe is refined to be interpreted as date using the system separator, the same separator as in the date cell format. In my Spanish Winx64Ult: / If I enter: 20/7 I get: 20/07/12 If I enter: 20-7 I get: 20-7 (text) Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
Hi, The changed behavior cold be related to this feature: http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html Cheers, Leif Lodahl 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? -- 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 -- 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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
2012/7/23 Leif Lodahl leiflod...@gmail.com Hi, The changed behavior cold be related to this feature: http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html Cheers, Leif Lodahl Thanks Leif, I'll try adapt my 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
Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation
Hi :) I find that is often the way too. It's a bit contra-intuitive to type-in a / when you know you want it to display a - and that makes it very hard to explain to people that need to enter data into your spreadsheet. Saying it's the same in Excel doesn't help. Regards from Tom :) --- On Mon, 23/7/12, MiguelAngel mari...@miguelangel.mobi wrote: snip / And maybe is refined to be interpreted as date using the system separator, the same separator as in the date cell format. In my Spanish Winx64Ult: / If I enter: 20/7 I get: 20/07/12 If I enter: 20-7 I get: 20-7 (text) Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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 -- 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
