To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77821
User pinfeng changed the following:
What |Old value |New value
================================================================================
Status|RESOLVED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|WORKSFORME |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat May 26 13:27:09 +0000
2007 -------
Hi,
I want to explain my point better. Formatting a cell can include two objectives.
First, I want to limit the lenght of the displayed number for space reasons.
Second, I want to round the number to fewer positions after decimal point.
This gives to objectives and not always one has both in mind...
If you have a table with several numbers - some smaller, some larger - you don't
want to show the full-lenghted number because it would't fit into the table you
have. So, you format it to a limited amount of positions after decimal point.
This obviously rounds the number - which is mathematically correct. For me, this
is just a displaying issue. The original number is left untouched in the cell -
only diplayed differently. Now, changing the sign due to rounding is
mathematically not correct IMHO. Because the original number shouldn't be
changed... Everybody looking at the formated table knows for instance that there
is no absolute zero value ('cause iof calculation reasons). He or she expects
the number to go on after the visible number of the after decimal point zeros.
What I mean is, the original number is different from zero - even after
displaying it in a 0.000 format or so. You can't kill the sign of the original
number just because of rounding!!! You can't round a negative number positive!!!
If the original number would be absolut zero - I would agree with you simonaw
and crolidge.
I know Excel is doing it the same way. But I recon this is not the correct way
to do!!!
For interpretation reasons it is significant whether a number is negative or
positive - even if they look close to zero. ... they are NOT zero!!!
Sincerely,
pinfeng
---------------------------------------------------------------------
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]
