[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from zh_CN User Community Liaison <plateauwolf at qq.com> ---
Created attachment 161512
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161512&action=edit
Same sample file as 161113, saved by MS Excel

Sample file saved by Excel attached.

Also,
(In reply to Eike Rathke from comment #6)
> Question remains what happens if it is not an
> inline array but an array/matrix returned from a function that itself is not
> in a forced array context. The results of these examples could be
> interesting:
> 
> =SUM(ABS(MUNIT(2)))
> 
> =SUM(ABS(MUNIT(2)*-1))
> 
> If both behave the same as with the inline array the result should be 2 for
> both, otherwise 1 (for one or both expressions).
Excel returns 2 for both formula.

-- 
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/20200602/81504bb1/attachment-0001.htm>