Moving multiple (selected) rows

Posted by: c12008 on 8 September 2017, 2:04 pm EST

  • Posted 8 September 2017, 2:04 pm EST

    Hi all,

    I have Farpoint Spread v2.5 VS2005 and I want to move multiple rows.

    My spread is configured like this:

    ...

                fpSpread1_Sheet1.SelectionPolicy = SelectionPolicy.MultiRange;
                fpSpread1_Sheet1.SelectionUnit = SelectionUnit.Row;

    ...

    and

     ...

              fpSpread1.AllowRowMove = true;

    ...

    So I want to select multipe rows and want to move them by dragging them (all) with the mouse.

    Currently I can select multiple rows but if I want to move them all only the row I press the mouse cursor on stays selected and is moved. The other prev. selected rows are unselected and not moved.

     Second question: The "selection highlighting" is not moved with the row being moved. E.g. I want to move row 4 (line 4) to row 2 (line 2). After the moving the data of row 4 has moved to row 2, the data of row 2 moved to row 3 and the data of row 3 has moved to row 4. Now I would expect that the new row 2 (with the data of the former row 4) is selected/highlighted but still row 4 is selected/highlighted.

    How can I move multiple rows incl. the selection highlighting in one go by dragging the mouse cursor?

    Additionally I want to move some selected rows using the up/down arrow keys. How can I do this?

     

    Best regards

    Matthias

  • Replied 8 September 2017, 2:04 pm EST

    Matthis,

    I do not have the version 2.5 to test the issue with. It seems you would like to implement the Drag/Drop behavior. I have tested the same with Spread4 and it is working fine. You can use the AllowDragDrop along with AllowDragFillto get the desired behavior. You may download the Spread4 from following location:

    http://www.clubfarpoint.com/FarPointSupportSite/Modules/Download/updates.aspx

    Thanks

  • Replied 8 September 2017, 2:04 pm EST

    Hi Suresh,

    I downloaded the Spread 4 and set the properties you told me. But the behavior is still the same. I cannot move multiple rows in one go. I select e.g. three rows, but the drag operation only moves one row. especially this one row I press the mouse cursor on to start the drag operation.

     Best regards

    Matthias

  • Replied 8 September 2017, 2:04 pm EST

    Matthias,

    Sorry, I misunderstood the requirement there in not a way to move multiple rows in Spread at one time.There is RowDragMoveCompleted event to check the row which has been moved and then you can move the other rows programatically e.g. using MoveRows method.

    Thanks

  • Replied 8 September 2017, 2:04 pm EST

    Is this feature available in Spread 6.0?

    It is according to the website feature  http://www.farpointspread.com/netproducts/spreadwin/whatsnew.aspx

     

     

     

  • Replied 8 September 2017, 2:04 pm EST

    Yes, in Spread 6 with these two properties set you can select and drag/drop multiple rows.

    fpSpread1.AllowRowMove = true;

    fpSpread1.AllowRowMoveMultiple = true;

  • Replied 8 September 2017, 2:04 pm EST

    Excellent, that worked great!

    Thanks 

Need extra support?

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

Learn More

Forum Channels