[Libreoffice-bugs] [Bug 133260] New: 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

            Bug ID: 133260
           Summary: FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array
                    as the third parameter correctly
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: plateauwolf at qq.com

Created attachment 161113
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161113&action=edit
Sample file using SUM(SUMIF())

This bug is forwarded and translated from a report in a Chinese user forum,
original report (in Chinese) at:
https://bbs.libreofficechina.org/thread-2459-1-1.html

The issue is that in MS Excel the function SUMIFS() allows its third parameter
"criteria1" to be an array, and the return value is also an array corresponding
the SUMIFS() result with the criteria being each member of the parameter array.

The attached example shows one usage of this by using SUM() on the SUMIFS()
result array and calculate the sum of different people's salaries.  This works
in Excel but not in Calc.  The expected value for cell D17 is 15501 (sum of D10
and D13), while in Calc (after "Recalculate Hard" if necessary) D17 is 9812
(just D10).

On the other hand, I can't find official documentation saying SUMIFS() supports
array as the third parameter, and I don't know what the specification says, so
I'm filing as an enhancement request.

The original report is for version 6.3.6 on Windows 10 and 6.4.3 on Ubuntu
20.04, I've reproduced with 6.4.4:
Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: zh-CN (zh_CN); UI-Language: en-US
Calc: threaded

-- 
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/20200522/f0621d1d/attachment.htm>