Posted 8 September 2017, 12:43 pm EST
<FONT face=Arial>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.</FONT>
<FONT face=Arial>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.</FONT>
<FONT face=Arial>Is this a bug?</FONT>
<SPAN class=kwd>Private Sub</SPAN> Form1_Load(<SPAN class=kwd>ByVal</SPAN> sender <SPAN class=kwd>As Object</SPAN>, <SPAN class=kwd>ByVal</SPAN> e <SPAN class=kwd>As</SPAN> System.EventArgs) <SPAN class=kwd>Handles Me</SPAN>.Load
' Allow the user to drag & fill
<SPAN class=kwd>Me</SPAN>.FpSpread1.AllowDragFill = <SPAN class=kwd>True</SPAN>
' 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.
<SPAN class=kwd>Me</SPAN>.FpSpread1_Sheet1.RowCount = 5
<SPAN class=kwd>End Sub</SPAN>