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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
(In reply to Eike Rathke from comment #6)
> Your screenshots show different data content, make at least sure you are
> comparing the same documents.
So that's actually because the value in B1 is already different, Excel 41831,
Calc 41466 (date value of 2013-07-11); which in the Calc case is the value of
LifeCycle.K2421 and thus the first date is 2014-03-31 whereas in the Excel case
it is 2015-03-31 (unknown origin) and thus one data point less.

Where's the 41831 cell content taken from in MIN(LifeCycle.K:K) in Excel?

-- 
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/1338d400/attachment.htm>