[Libreoffice-bugs] [Bug 141153] New: A basic SUM function doesn't work

Sun Mar 21 21:02:26 UTC 2021

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

            Bug ID: 141153
           Summary: A basic SUM function doesn't work
           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: hallesyjd at gmail.com

A basic sum function does not work. The zero number reported below is the
result of the SUM function SUM -(C2:C40)

If I run this spreadsheet on Google Sheets, the formula correctly reports
$1716.10

Please address this basic issue.  I have lost faith in the accuracy of
LibreOffice tools.

Date    Description     Amount  AccountType
2021-03-11      796229 POS CHCKING SIG 03/10 09:43 WALGREENS #6111 LAFAYETTE CO
06284676 796229 $-339.99        HSA
2021-03-03      225730 POS CHCKING PIN 03/03 15:31 WALGREENS 1830 30TH BOULDER
CO 02482T32 22573        $-15.23 HSA
2021-03-03      202207 POS CHCKING PIN 03/03 15:18 KING SOOP 1650 30TH BOULDER
CO 11006165 20220        $-21.22 HSA
2021-03-03      703007 POS CHCKING PIN 03/03 10:20 WALGREENS 1600 COAL SUPERIOR
CO 06467T41 7030        $-4.39  HSA
2021-02-16      443543 POS CHCKING SIG 02/13 05:11 BRIOVARX 800-562-6223 IL
20040269 443543     $-5.00  HSA
2021-02-11      45227 POS CHCKING SIG 02/11 05:19 OPTUMRX 800-562-6223 CA
84821867 045227       $-136.51        HSA
2021-01-27      314425 POS CHCKING SIG 01/26 04:55 COLO MEDICAL PSYCHI BOULDER
CO 10100130 31442        $-299.85        HSA
2021-01-26      127354 POS CHCKING PIN 01/26 14:42 KING SOOP 1650 30TH BOULDER
CO 11006167 12735        $-11.16 HSA
2020-12-22      845846 POS CHCKING SIG 12/22 04:53 BRIOVARX 800-562-6223 IL
94833831 845846     $-5.00  HSA
2020-12-22      139291 POS CHCKING PIN 12/21 18:02 WALGREENS 1600 COAL SUPERIOR
CO 06467T41 1392        $-11.32 HSA
2020-11-20      396753 POS CHCKING SIG 11/20 04:39 BRIOVARX 800-562-6223 IL
18416229 396753     $-5.00  HSA
2020-11-18      44971 POS CHCKING PIN 11/17 17:01 WALGREENS 1600 COAL SUPERIOR
CO 06467T41 04497        $-11.32 HSA
2020-11-05      677055 POS CHCKING SIG 11/04 04:46 BOULDER EYE SURGEON
303-4443000 CO 06849800 6        $-23.04 HSA
2020-10-29      942276 POS CHCKING SIG 10/29 04:48 BRIOVARX 800-562-6223 IL
78966422 942276     $-5.00  HSA
2020-10-15      881186 POS CHCKING SIG 10/14 05:12 COLO MEDICAL PSYCHI BOULDER
CO 13400052 88118        $-17.18 HSA
2020-10-01      135482 POS CHCKING PIN 10/01 15:24 KING SOOP 1650 30TH BOULDER
CO 11006167 13548        $-13.75 HSA
2020-09-29      696255 POS CHCKING SIG 09/28 01:54 PHR*COLORADORETINA
303-2611600 CO 67382042 69        $-23.25 HSA
2020-09-23      760696 POS CHCKING SIG 09/23 05:25 OPTUMRX 800-562-6223 CA
80365775 760696      $-87.66 HSA
2020-09-23      683284 POS CHCKING SIG 09/23 05:37 OPTUMRX 800-562-6223 CA
80347492 683284      $-28.78 HSA
2020-09-15      74752 POS CHCKING SIG 09/14 01:30 PHR*COLORADORETINA
303-2611600 CO 19295201 074        $-23.25 HSA
2020-09-15      588986 POS CHCKING SIG 09/14 05:07 COLO MEDICAL PSYCHI BOULDER
CO 11200070 58898        $-34.37 HSA
2020-09-14      146706 POS CHCKING SIG 09/12 04:59 BRIOVARX 800-562-6223 IL
95931843 146706     $-5.00  HSA
2020-08-20      787932 POS CHCKING SIG 08/19 04:55 COLO MEDICAL PSYCHI BOULDER
CO 19600058 78793        $-17.19 HSA
2020-08-20      259651 POS CHCKING PIN 08/19 16:36 KING SOOP 1650 30TH BOULDER
CO 11006167 25965        $-11.58 HSA
2020-08-05      117176 POS CHCKING PIN 08/05 15:47 KING SOOP 1650 30TH BOULDER
CO 11006166 11717        $-1.30  HSA
2020-07-23      10539 POS CHCKING PIN 07/22 18:11 KING SOOP 1650 30TH BOULDER
CO 11006166 010539        $-11.56 HSA
2020-07-23      648252 POS CHCKING SIG 07/22 05:04 COLO MEDICAL PSYCHI BOULDER
CO 17800050 64825        $-34.36 HSA
2020-07-15      896136 POS CHCKING SIG 07/14 09:56 ASSOCIATES IN FAMIL FORT
COLLINS CO 98696979 $-162.54        HSA
2020-07-06      89576 POS CHCKING SIG 07/05 04:03 PHR*COLORADORETINA
303-2611600 CO 73878933 089        $-23.25 HSA
2020-06-23      656255 POS CHCKING SIG 06/23 04:55 OPTUMRX 800-562-6223 CA
99640363 656255      $-87.55 HSA
2020-06-22      375126 POS CHCKING SIG 06/20 04:42 OPTUMRX 800-562-6223 CA
12670827 375126      $-11.44 HSA
2020-06-17      41341 POS CHCKING PIN 06/16 18:13 WALGREENS 1600 COAL SUPERIOR
CO 06467T41 04134        $-12.29 HSA
2020-05-07      59695 POS CHCKING PIN 05/06 18:03 WALGREENS 1600 COAL SUPERIOR
CO 06467T42 05969        $-5.54  HSA
2020-05-04      256624 POS CHCKING SIG 05/02 01:51 PHR*COLORADORETINA
303-2611600 CO 91499877 25        $-23.25 HSA
2020-04-09      EARNINGS ON EXCESS CONTRIBUTION 2019    $-2.32  HSA
2020-04-09      335894 POS CHCKING PIN 04/08 17:45 WALGREENS 1600 COAL SUPERIOR
CO 06467T41 3358        $-3.21  HSA
2020-04-09      EXCESS CONTRIBUTION DISTRIBUTION 2019   $-1487.55       HSA
2020-03-25      232962 POS CHCKING SIG 03/25 04:45 BRIOVARX 800-562-6223 IL
39222775 232962     $-5.00  HSA
2020-03-23      111585 POS CHCKING PIN 03/23 15:31 KING SOOP 1650 30TH BOULDER
CO 11006167 11158        $-3.68  HSA

                0

-- 
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/20210321/c36e7b87/attachment-0001.htm>