To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77973 Issue #|77973 Summary|A better way of treating numbers/dates?! Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|mawe3661
------- Additional comments from [EMAIL PROTECTED] Thu May 31 06:19:39 +0000 2007 ------- I am exporting/importing data quite a bit into/from calc and often get issues with the decimal separator (',' or '.'). I'm working on a Swedish system and ',' is the Swedish standard, however, lots of programs generate numbers with '.' as decimal separator (DS) and also want that as input. So my first want would be: * Have a option in input/output dialogs (as well as clip board inserts) where you can bypass any other settings in OOo and choose your own decimal separator out of (','/'.'). For import this exists in the MS counterpart. I also find this a problem when typing numbers i calc. I some time forget what DS I should use and write number using '.'. What then happens is that my system interprets this as a DATE, i.e. 1.22 becomes 01.01.22. This is totally illogical for a Swede, we never writes dates like that. That formatting should be removed. Coming to this, dates is a pain typing. Different countries have different ways of writing dates, and this seems to make the built in formatter go wild. * If date formatting was turned off by default, and you would have to choose a date format for the cell/range of cells, before date information is inputted, that would save some confusing I think. The old formatter could then be used to recognize could-be dates when and if the cell didn't have a date format set - show a message saying something like - please select date format for the cells you want to input dates in before inputting the dates. Having implemented the above, only one case remains for actually needing to distinguish between (','/'.') when formatting as a number. That is to distinguish between someone wanting to input 11,22 as a string number sequence instead of the decimal number 11.22. Again, this could be solved through a dialogue, showing up if you have the DS set to ','. OF course, in Sweden 11.22 could also be interpreted as 11:22 (a time), but that should also be one of the cases where the time/date dialogue above should emerge. Therefore, * treat both '.' and ',' in number strings as decimal separators, with the exceptions above. This is my suggestion, I hope it is clear enough, but please ask for clarification if it is not. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]