You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/06/20 16:52:51 UTC
[Bug 59736] New: Incorrect evaluation of SUBTOTAL with composite
interval
https://bz.apache.org/bugzilla/show_bug.cgi?id=59736
Bug ID: 59736
Summary: Incorrect evaluation of SUBTOTAL with composite
interval
Product: POI
Version: 3.13-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: lucamartini@tagetik.com
Created attachment 33968
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33968&action=edit
sample workbook
The SUBTOTAL function is not ignoring nested subtotals when the second argument
is specified as disjoint interval with the semicolon.
Sample case:
Cell | Contents
A1 | 1
A2 | =SUBTOTAL(9;A1)
A3 | =SUBTOTAL(9;A1;A2)
A3 should evaluate to 1, instead the result is 2. If the formula in cell A3 is
written as =SUBTOTAL(9;A1:A2) the evaluation is correct (1).
I attach a simple workbook that reproduces the case.
Best regards,
Luca
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59736] Incorrect evaluation of SUBTOTAL with composite interval
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59736
Luca Martini <lu...@tagetik.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |major
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59736] Incorrect evaluation of SUBTOTAL with composite interval
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59736
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
This was fixed via r1754674, previously it did not work for LazyRefEval, which
"lost" the "isSubtotal()" information prior to being passed to the Subtotal
class. We now look up this information as well to exclude those subtotals from
the sum/avg/...
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org