[Libreoffice-bugs] [Bug 144896] New: problem with SUMIF, SUBTOTAL and AUTO FILTER leaving trace numbers when total should be 0

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144896
           Summary: problem with SUMIF, SUBTOTAL and AUTO FILTER leaving
                    trace numbers when total should be 0
           Product: LibreOffice
           Version: 7.2.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kknorthon at gmail.com

Created attachment 175480
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175480&action=edit
screenshot

When I add a column of numbers the SUM is correct, but if I use a filter,
SUBTOTAL or SUMIF on that same column of numbers there are traces of numbers
left about 12 decimal places to the right.  It's hard to explain, but I have
attached a sample.

-- 
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/20211003/45226ad3/attachment-0001.htm>