Downloading the latest spread and a question

Posted by: dotnetuser on 8 September 2017, 2:13 pm EST

  • Posted 8 September 2017, 2:13 pm EST

    Trying to download Spread for Windows forms Framework 3.5 release 04.00.3515 and looks like it's a dead link. Can you please verify it?


    Also my question is when having locked cell in the spread is there a property or an easy way to skip those cells when navigating, and if it happens that the cells at the end of the row are locked, to skip those and move to the next line? This is helpful for the user since those cells can not be entered so it will make the DATA entry faster...


     


     


     

  • Replied 8 September 2017, 2:13 pm EST

    Hello,

    The issue for the broken link has already been raised and it is being corrected.

    If you have Locked cells in the last column of the of the Spread , you may use the EnterCell event to check the for the cell's locked property and if it returns true you may move the focus to Next Row and first column.

    e.g.

    Private Sub FpSpread1_EnterCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EnterCellEventArgs) Handles FpSpread1.EnterCell
            If FpSpread1.ActiveSheet.Columns(e.Column).Locked = True Then
                FpSpread1.ActiveSheet.SetActiveCell(e.Row + 1, 0)
            End If
    End Sub

    Here I have the set the locked property at Column level.Using this code,

     FpSpread1.ActiveSheet.ColumnCount = 6
     FpSpread1.ActiveSheet.Columns(4, 5).Locked = True

    If you have set the Locked property at cell level you may modify the above code as , 

    Private Sub FpSpread1_EnterCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EnterCellEventArgs) Handles FpSpread1.EnterCell
            If FpSpread1.ActiveSheet.Cells(e.Row, e.Column).Locked = True Then
                FpSpread1.ActiveSheet.SetActiveCell(e.Row + 1, 0)
            End If

    End Sub

    I 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