DragFill doesn't work when setting RowCount or ColumnCount

Posted by: bburba on 8 September 2017, 12:43 pm EST

  • Posted 8 September 2017, 12:43 pm EST

    Hello,


    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
    '

    End Sub
     
  • Replied 8 September 2017, 12:43 pm EST

    Hello,

    I was able to reproduce this and I've reported this as a bug. The Bug number is 20901.
  • Replied 8 September 2017, 12:43 pm EST

    Hello,

    This bug has been fixed and we're shooting to have our maintenance release completed by mid-August. :)
  • Replied 8 September 2017, 12:43 pm EST

    Hello,


    The maintenance release that Brian is mentioning will be for version 3 only of the product. The 2.5 version maintenance release will be around the end of September.

Need extra support?

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

Learn More

Forum Channels