[Libreoffice-bugs] [Bug 139413] New: Severe Bug - CALC cumputes sum wrong!

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139413
           Summary: Severe Bug - CALC cumputes sum wrong!
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: VistaMail1 at web.de

Description:
Not sure, HOW I generated the file, which I will attach.

There you will find two colums which are summed up each.
The result ist WRONG.
The sum checked by a pocket calculator will show you.

It took me long to find out the reason:
The moment, I remove the "huge" ("merged") cell formation and place them into
an one-line-cell, the addition works.

Not sure, how I generated this merge.
However it shall never happen, that the result of a sum becomes false.


Steps to Reproduce:
my version is 7.0.0.2 wich is not listed abve

1. open the attached file
2. go to the very last line, which shows the 2 sum formulas
3. figure out in your head, that the results must be wrong or take a calculator

Actual Results:
give the correct result!

(this will be done, if the "merged" cell is "solved" into a single line)

Expected Results:
Give at least out a warning, the sum-calculation may be fuzzy


Reproducible: Always


User Profile Reset: No



Additional Info:
figure correctly

-- 
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/20210104/afc3d90b/attachment.htm>