https://bugs.documentfoundation.org/show_bug.cgi?id=149392
Bug ID: 149392
Summary: Simple calculation error
Product: LibreOffice
Version: 3.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I create monthly reports for my club. We use a credit card processor to accept
payments for dues and other items.
Last month, I noticed an error when reconciling the report against the bank
statement. Thankfully, it was a small error.
This month the error was larger since more dues were paid.
By comparing the CC processor's data with the report, there was a discrepancy
in the calculation for $25.00. There was no error for more or fewer sums. Just
$25.00
I've included a link to the simple calc sheet that describes the error.
https://bit.ly/3abVtZe
Steps to Reproduce:
1. Four columns (no labels)
2. First column enter 25
3. Second column enter =A1*0.029+0.3
4. Second column calculates the number 1.03
5. Third column subtract value =A1-A2
Actual Results:
The third column should be 23.97, yet it calculates to equal 23.98
Expected Results:
The third column should be 23.97
Reproducible: Always
User Profile Reset: No
Additional Info:
How to attach file?
See my calc sample: https://bit.ly/3abVtZe
DOES NOT WORK:
https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
https://wiki.documentfoundation.org/OpenGL#How_to_enable.2Fdisable_OpenGL
--
You are receiving this mail because:
You are the assignee for the bug.
