[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 #5 from zh_CN User Community Liaison <plateauwolf at qq.com> ---
(In reply to Eike Rathke from comment #4)
> Can we please have an original Excel sample file attached, not a WPS
> generated one, to see what Excel actually stores for this case? Thanks.
Sure, asked the original reporter for one on the Chinese forum.

[...]
> Btw, can someone please check if Excel forces array mode whenever an inline
> array is present as argument where the parameter expects a scalar value
> (like SUMIFS() 3rd parameter)? For example
> =SUM(ABS({-2,-4}))
> does that yield 2 or 6?
This is easier to test.  According to two users with "Microsoft Office Home and
Student 2019" and "Microsoft 365" respectively, Excel returns 6 for that
formula.

So does this mean the scope of the issue is much larger than just SUMIFS()?

-- 
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/20200526/a0add64e/attachment.htm>