1. *** New version of B4J is available ***
    B4J v7.8
    Dismiss Notice

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

Discussion in 'B4J Questions' started by Mashiane, Jul 11, 2019.

  1. Mashiane

    Mashiane Expert Licensed User

    Hi there

    I want to be able to apply a filter on a particular column, let's say C and then apply a filter that excludes all blanks on that column and then the rows that I will access are only the ones applicable to that filter?

    Is that possible?

  2. keirS

    keirS 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.
  3. Mashiane

    Mashiane Expert Licensed User

    Hard pill to swallow hey.. ta!
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice