[sc-issues] [Bug 118342] Irregular rounding displays where rounding is not in effect

http://openoffice.org/bugzilla/show_bug.cgi?id=118342





--- Comment #1 from [email protected]  2011-07-28 13:26:34 ---
Having looked into this further, I see that this has been introduced at version
3.3

Here are the development notes explaining the introduction of the feature to
which you refer:
http://wiki.services.openoffice.org/wiki/Calc/Features/Automatic_decimal_place_adjustment.

Menu Tools > Options > OpenOffice.org Calc > Calculate, Limit decimal for
general number format.

Where this feature explains WHY the display performs the way it does (in
particular the ossue with the figure being less than 0.0001), I still maintain
that something is wrong when software on a computer cannot calculate
56.25+35.96-92.21 and conclude its something that ISNT zero. (A simple
calculation that a child can do).  Where I acknowledge that in this world of
BINARY calculations we would have to deal with minute decimal fractions to a
certain degree, it is incumbent on software creators to tailor for this
problem.

However, I have just tested the exact scenario in Excel and that too also shows
SIMILAR properties in its results (I say similar because it doesnt calculate
the same decimal figure!).

Given that excel also does a similar, and that clearly OOo have moved towards
performing the same way as Excel (ouch!) in a form of 'standardisation' then I
guess I will concede to the fact that this is the way it is to be if I choose
to go with OOo3.3 or above (which I am not prepared to do). It does mean, of
course, that installing and implementing any new OOo onto machines means I have
to go in to the options and IMMEDIATELY CHANGE THE DEFAULTS (using this option)
to prevent this unsightly mess happening every time a spreadsheet is opened.
(Something is wrong if you have to change the defaults straight away before
even opening a sheet for the first time).

Therefore my suggestion would be to rather than have column width determine
what level of decimalisation can be shown, actually have the option set AS
DEFAULT to a high number of places (say 10) which would allow for these
inabilities for computers to compute perfectly by still showing Zero when it
clearly should be, and yet give users the opportunity to change/format the cell
IF they know that the numbers they are dealing within that cell are REALLY true
low fraction numbers (and not 'Zero errors').

Im sure there are other considerationsa to make in reviewing my suggestions and
this issue which i will gladly listen and be open to, but SOMETHING should be
done as it JUST ISNT RIGHT that every spread sheet that has a calculation
resulting in zero gets automatically filled with the scientific notation is
displayed.  (The business workplace likes clear and clean readable numbers).

-- 
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help