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: lucamart...@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-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org