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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
Unmerge the cells. Then merge again. Note the dialog that pops up when you
merge the cells, which asks you if you want to keep the values in hidden cells,
or merge all text into one cell, or to remove it. Click "Help" button in the
dialog, which will open up
https://help.libreoffice.org/7.1/en-US/text/scalc/01/05060000.html, telling you
that in case of "Keep the contents of the hidden cells" "the results of
formulas referring to the hidden cells will not change", which means that if a
SUM was referring the range with values, after merge those cells, even hidden,
will still be counted in the SUM.

It is a decision of spreadsheet creator to keep the values in hidden cells,
thus it's expected that the decision will affect formulas accordingly.

Closing NOTABUG.

-- 
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/042c01d8/attachment.htm>