Bug 106987 - SUM not using round up for Total
Summary: SUM not using round up for Total
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.6.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Sum
  Show dependency treegraph
 
Reported: 2017-04-06 12:13 UTC by gDaKatz
Modified: 2018-03-02 10:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Rounding error, not using $ sign added to column using $. (203.68 KB, image/bmp)
2017-04-06 12:24 UTC, gDaKatz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gDaKatz 2017-04-06 12:13:52 UTC
Description:
Rounding error on CALC
Previous total is $ 4,400.00  (3rd column, picture attachment (?) will show these actions)
784.51 (price) is added correctly for $ 5,184.31 (3rd column)
784.51 is multiplied by 2% for (4th column) product, which
15.69  is added from 1st column to new total in 3rd, SHOWING INCORRECT ROUNDING ERROR Total of $ 5,199.99 (SHOULD BE $ 5,200.00)
previously happened, so I show the product below original to 10 decimal places.
I can clip picture, to show here in attachment.

Steps to Reproduce:
1.just a rounding error, I am unable to replace (?) with Format (s).
2.
3.I check against my BANK, I must add a penney ( .01 ).

Actual Results:  
Previous total is $ 4,400.00  (3rd column, picture attachment (?) will show these actions)
784.51 (price) is added correctly for $ 5,184.31 (3rd column)
784.51 is multiplied by 2% for (4th column) product, which
15.69  is added from 1st column to new total in 3rd, SHOWING INCORRECT ROUNDING ERROR Total of $ 5,199.99 (SHOULD BE $ 5,200.00)
previously happened, so I show the product below original to 10 decimal places.
I can clip picture, to show here in attachment.



Expected Results:
correct amount added, .01 + .09 should equal .10 (penney), not .09, 
as in
784.31 + 15.69 should be $ 800.00,
not $ 799.99


Reproducible: Sometimes

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Builds ID: LibreOffice 5.2.6.2


User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36
Comment 1 gDaKatz 2017-04-06 12:24:48 UTC
Created attachment 132367 [details]
Rounding error, not using $ sign added to column using $.

unable to paste, after using copy and paste from MWSnap,
bitmap attachment same.
for the setup, same here if possible with spaces:
previous total    $  4,400.00
price    784.31   $  5,184.31
interest  15.69   $  5,199.99      Int=prod(784.31,0.02) {which equals below}
                                 15.6862000000
  above should be $  5,200.00
titles not shown on CALC
Comment 2 m.a.riosv 2017-04-06 23:49:37 UTC
Please attach a file with only the cells needed to reproduce the problem.
Comment 3 QA Administrators 2018-01-29 10:27:07 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2018-03-02 10:05:17 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20180302