| Summary: | Incorrect evaluation of SUBTOTAL with composite interval | ||
|---|---|---|---|
| Product: | POI | Reporter: | Luca Martini <lucamartini> |
| Component: | SS Common | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | ||
| Priority: | P2 | ||
| Version: | 3.13-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
| Attachments: | sample workbook | ||
Created attachment 33968 [details] 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