[Libreoffice-bugs] [Bug 143362] Different results between Calc and Excel for SUMIFS formula

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jul 14 16:52:03 UTC 2021


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

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
The document is not an original Excel document but was stored using a
LibreOfficeDev/7.2.0.0.alpha1 version. The stored values don't match the actual
calculation, hence the (wrong) cached values are displayed until recalculated.
My slightly behind 7.2.0.0.beta1+ calculates as expected. As does
7.3.0.0.alpha0+ and my slightly behind 7.1.5.0.1+

I think there's nothing to fix, the document has stored wrong values and needs
to be recalculated.

-- 
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/20210714/dbbc46d2/attachment.htm>


More information about the Libreoffice-bugs mailing list