[Bug 65059] New: wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 65059] New: wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

            Bug ID: 65059
           Summary: wrong evaluation of SUMPRODUCT when nested SUMIFS use
                    ranges
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 37689
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37689&action=edit
test case for reproduction

I'm managing an XFFS workflow within which I have a formula cell with a SUMIFS
nside a SUMPRODUCT. But its evaluation give a bad result: it is different from
Excel of Office 365.

The nested SUMIFS uses ranges as criteria. For example:
SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D1:D3))

The evaluation is done via FormulaEvaluator.evaluateAll().



I'm providing a test case for more details.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

--- Comment #1 from [hidden email] ---
Created attachment 37690
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37690&action=edit
expected output if workbook written on file system

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |65058

--- Comment #2 from Dominik Stadler <[hidden email]> ---
Is there a difference to this bug-report to bug #65058?


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=65058
[Bug 65058] SUMPRODUCT evaluation error with some SUMIFS cases
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

--- Comment #3 from [hidden email] ---
Yes.

The bug #65058 is about an error occuring with some parameter management. It
seems that this happens when a criteria range is starting at a different column
*and* row from the initial formula.
This bug is more about the evaluation providing wrong results when we avoid the
above parameters. Having done some more analysis, I have noticed that SUMIFS
evaluations are not providing an array result when some criteria are
multi-valued.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #37689|0                           |1
        is obsolete|                            |

--- Comment #4 from [hidden email] ---
Created attachment 37715
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37715&action=edit
simplified test case for bug reproduction

New test case to focus on pure formula evaluation.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]