[Libreoffice-bugs] [Bug 124669] Error in the function SUM (LibreOffice Calc)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 12 06:06:50 UTC 2019


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

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #5 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
My question re auto-calculate in comment 2 is about the use of Calc at the time
the cells where filled with formulas and/or its contents altered.
Once a document with a non-recalculated formula cell is saved, another setting
becomes important : Options - Calc - Formula - Recalculate on opening document.
When this setting is on, the document in  attachment 150673 opens with the
correct value in cell E6. 
When this setting is of the document in  attachment 150673 opens with the
incorrect value in cell E6 (the value as stored in the document).

I still think there is nothing wrong with Calc, but that the document was saved
with a non-recalculated cell E6, i.e. with an incorrect value in E6.

To all that opened the document in attachment 150673 : please check the setting
for recalculate on opening document and include that in your reports.

Also: can any one reproduce the behaviour from a new, blank, document?

-- 
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/20190412/b085bed6/attachment-0001.html>


More information about the Libreoffice-bugs mailing list