hidden rows

Posted by: ytheaudin on 8 September 2017, 1:54 pm EST

  • Posted 8 September 2017, 1:54 pm EST

     


    HI 


    I would hide all rows of column 1 which contains "dudu"


     Have you an example ?


    Thanks


    Yvan Theaudin

  • Replied 8 September 2017, 1:54 pm EST

    hi where is ?


     


    [Visual Basic]


    FpSpread1.Sheets(0).Columns(0).ShowFilterIndicator = False


     

  • Replied 8 September 2017, 1:54 pm EST

    Hello,


    You can use the Search method of Spread to find all the rows that have this value in the first column and hide those rows.


      Dim ri As Integer = -1
      Dim ci As Integer = 0
      Do
       FpSpread1.Search(0, "dudu", False, False, True, False, True, False, False, ri + 1, 0, ri, ci)
       If ri <> -1 And ci = 0 Then
        FpSpread1.Sheets(0).Rows(ri).Visible = False
       End If
      Loop While ri <> -1 And ci = 0

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels