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]
