You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2019/04/02 17:00:36 UTC
[Issue 128081] New: spread sheet calcuation error
https://bz.apache.org/ooo/show_bug.cgi?id=128081
Issue ID: 128081
Issue Type: DEFECT
Summary: spread sheet calcuation error
Product: Calc
Version: 4.1.6
Hardware: Mac
OS: macOS 10.14
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: jim4turner@gmail.com
Target Milestone: ---
Created attachment 86660
--> https://bz.apache.org/ooo/attachment.cgi?id=86660&action=edit
simple spreadsheet illustrating error
Simple spread sheet organic calculation error??? See attached.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128081] spread sheet calcuation error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128081
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128081] spread sheet calcuation error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128081
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOT_AN_OOO_ISSUE
Status|UNCONFIRMED |RESOLVED
Severity|Critical |Normal
OS|macOS 10.14 |All
Hardware|Mac |All
--- Comment #1 from Marcus <ma...@apache.org> ---
Please have a look for the digits. You are using only 2.
When you add 1 or 2 more then you will see that the result doesn't end at 2 but
more. So, it's just a rounding effect you are seeing.
Example with cell A18:
- You are expecting $1,401.38
- For OO Calc it's $1.401,3850
- With rounding it's $1.401,39
When you want to have a higher precision, then you need to work with more
digits than just 2. Click the right mouse button on cell A18 and from the
context menu choose "Format cells". In the upcoming dialog choose "Numbers".
The currently used number format is pre-selected. Here you can add more digits
with the "Decimal places" option.
You can slect al lthe cells that should get more digits and repeat the last
steps.
--
You are receiving this mail because:
You are the assignee for the issue.