To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104596
User jes changed the following:
What |Old value |New value
================================================================================
Summary|math error |math error
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Aug 29 14:13:04 +0000
2009 -------
The "Cost per sq foot is 3 (cell A2)" is not actually 3.0, but =248/(8*12), or
31/12, or 2.583...
The number format for cell A2 is rounding the result /displayed/ to the nearest
integer, but the calculations use A2's more precise internal value to get the
answer you see in C2.
So, Calc's arithmetic looks reasonable to me.
If you really want the total price to be calculated using the value "3" as
shown, you can set the option Tools > Options > OOo Calc > Calculate > Precision
as shown: YES
---------------------------------------------------------------------
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]
