B4J Question jPOI - How do I set and apply a filter and only get the rows affected?


Well-Known Member
Licensed User
No it's not possible. Filters in Excel just hide the data visually. That's why if you sum up a column of numbers using the SUM function in Excel and then hide some of the rows using the AutoFilter the the value of the SUM doesn't change. There is a SUBTOTAL function that excludes hidden rows but that effectively just goes down every row including the hidden ones and says if the row is hidden don't include it in the total.