[Libreoffice-bugs] [Bug 131541] New: Calc seems to miscalculate when using subtotals but not with sum

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Mar 24 16:15:52 UTC 2020


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

            Bug ID: 131541
           Summary: Calc seems to miscalculate when using subtotals but
                    not with sum
           Product: LibreOffice
           Version: 6.3.5.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: energo at gmx.net

Description:
CHF 4.50        s
CHF 9.00        s
CHF 3.90        s
CHF 0.95        s
CHF 5.70        s
CHF 2.60        s
22.15   s Sum
Calc seems to miscalculate when using subtotals but not with sum 
CHF 4.50        s
CHF 9.00        s
CHF 3.90        s
CHF 0.95        s
CHF 5.70        s
CHF 2.60        s
CHF 26.65       s Sum


Steps to Reproduce:
1. Refer to cut and paste in the description.
2. Calculate using subtotal
3. Calculate using sum

Actual Results:
see first cut and paste

Expected Results:
see second cut and paste


Reproducible: Always


User Profile Reset: No



Additional Info:
I don't know what else I can add. One way it is incorrect and another way it
works. For me it means that libre office calc is not reliable.

-- 
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/20200324/347e3f35/attachment.htm>


More information about the Libreoffice-bugs mailing list