how to find a row whether it has data in it

Posted by: brg on 8 September 2017, 2:08 pm EST

  • Posted 8 September 2017, 2:08 pm EST

    how to find a row whether it has data in it in the spread
  • Replied 8 September 2017, 2:08 pm EST

    Hello,

    You may check for the Cell's Value in EnterCell event to know if there is some Data in it.e.g.

         Private Sub FpSpread1_EnterCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EnterCellEventArgs) Handles FpSpread1.EnterCell
            If Not FpSpread1.ActiveSheet.Cells(e.Row, e.Column).Value = Nothing Then
                MsgBox("Cell has Data")
            End If
        End Sub

    Hope it will help you.

    Thanks,

Need extra support?

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

Learn More

Forum Channels