Posted 8 September 2017, 12:43 pm EST
I came across a problem with DragFill whenever I set the RowCount or the ColumnCount in code. If I create a basic VB 2005 project with nothing but a form and a FarPoint Spread control, I can type in a cell and drag both directions with no problems.
When I add .RowCount = 5 or .ColumnCount = 5, it breaks the DragFill feature in the control. If I set .RowCount, I can no longer drag and fill down most of the time. If I set .ColumnCount, I can no longer drag and fill across. If I keep trying several times by typing in other cells and going back to the original cell, sometimes it will let me fill. Most of the time, it will not.
Is this a bug?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' Allow the user to drag & fill
Me.FpSpread1.AllowDragFill = True
' Limit the grid to 5 rows.
' This keeps me from being able to drag down most of the time.
' Drag down works fine if this line of code is removed.
Me.FpSpread1_Sheet1.RowCount = 5