[Libreoffice-bugs] [Bug 116215] New: Sum button: Calc adds wrong sum formulas if you select more than one row or column

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 5 19:49:43 UTC 2018


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

            Bug ID: 116215
           Summary: Sum button: Calc adds wrong sum formulas if you select
                    more than one row or column
           Product: LibreOffice
           Version: 6.0.2.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: alois.klotz at salzburg.at

Description:
Select more than one row or column and then press the sum button.
Calc inserts wrong formulas.

Steps to Reproduce:
1.produce a table with e.g. 4 cells from A1 to B2 - each with the value 1
2.select the 4 cells
3.press the sum button

Actual Results:  
the produced formulas are wrong:
formula in A3 is correct: =SUMME(A1:A2)
formula in B3 is wrong: =SUMME(A1:A2;B1:B2)

Expected Results:
the formular should be the sum of the column above.


Reproducible: Always


User Profile Reset: Yes



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101
Firefox/58.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/20180305/1c299426/attachment.html>


More information about the Libreoffice-bugs mailing list