Posted 8 September 2017, 2:08 pm ESThow to find a row whether it has data in it in the spread
how to find a row whether it has data in it
Posted by: brg on 8 September 2017, 2:08 pm EST
Replied 8 September 2017, 2:08 pm EST
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")
Hope it will help you.