[Libreoffice-bugs] [Bug 136953] New: Viewing: Error Adding up columns with percents

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136953

            Bug ID: 136953
           Summary: Viewing: Error Adding up columns with percents
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: susan at susans.org

Description:
I have a spreadsheet with a 2 datasets with a header 97 counties, cases,
deaths, and positive ratio for each.

One is today and one is yesterday. The center column tracks the day's changes

Each day i zero it out by copying today to yesterday before updating today's.

Today I decided to track the increase or decrease in the positive ratio and
decided to sum the total, with the spreadsheet in it's zero'd state I did not
get 0% like I expected. 

I got 0.01%.

I removed the percent formatting and saw I had 7.22573e-05. as the total from
adding up a column of what should have been 0% numbers. So I took off
formatting on the columns.

Subtracting 8.65% from 8.65% gave me 3.84615e-05
Subtracting 13.33% from 13.33% gave me 3.3333e-05
Subtracting 9.09% from 9.09% gave me -9.0909e-06 

See attached image in the actual results section.


Steps to Reproduce:
1.See Description
2.
3.

Actual Results:
image: https://imgur.com/a/EF4UHOa

Expected Results:
0 when formatted as a number and 0.00% when formatted as a percent.


Reproducible: Always


User Profile Reset: No



Additional Info:
I was having the error on 6.4 so upgraded to the latest release and the problem
still occurs on it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200922/7bc075d9/attachment.htm>