To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97949
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P1 |P3
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from reg...@openoffice.org Sun Jan 11 18:40:39
+0000 2009 -------
There are two problems. One is the conversion between binary and decimal, the
other is subtracting nearby numbers. If the application works with the same
accuracy of floating point numbers for input and output, then there is no way to
solve it.
If you need guaranteed accuracy to a specific amount of decimal places, you
should not use a spreadsheet.
It is the normal way spreadsheet applications handle decimal values. If you cut
the decimal places with INT, you cannot expect to get a accurate result. If you
want to have a result which is accurate to 2 decimal places, you have to use
=ROUND(B2-A2;2).
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
