[ooo-build-bugs] [Bug 30456] New: Function SUM() working not correctly, when using in context of merged cells

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=30456

           Summary: Function SUM() working not correctly, when using in
                    context of merged cells
           Product: LibreOffice
           Version: unspecified
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: libreoffice
        AssignedTo: ooo-build-bugs at lists.freedesktop.org
        ReportedBy: steffakasid at googlemail.com


I found out, that the SUM() function will use values in merged cells which are
not visible.

In example when I merge cell A1 with A2. Where A1 has a value of '9' which will
be visible after the merge and A2 has a value of '8' which will be "deleted"
after the merge. Maybe I've also cell A3 (value is '10') merged with A4 (value
is '1') and I make the SUM function like SUM(A1:A4) the result of this SUM() is
'28'. So even the invisible "deleted" values are used for the calculation of
the SUM() function.

See example in attachment.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.