How to remove non contiguous selected rows

Posted by: ghr on 8 September 2017, 2:58 pm EST

  • Posted 8 September 2017, 2:58 pm EST

    Hi, I have a spread with several non contiguous selected rows (multiselect mode), and I want to remove those selected rows, but as soon I remove a row, the selections are lost and I can't proceed with this process, and I'm becoming crazy with this issue, as I can't make this work... any advice will be greatly appreciated.

     I'm using spread version 4.0.3522.2008 for windows (as it appears in the About property in the IDE properties), visual basic .NET 2008




  • Replied 8 September 2017, 2:58 pm EST


    You can use the GetSelections method to return the all the selections made on the sheet, and later you can use the RemoveRows method to remove all the selected rows. I have attached a sample depicting the same. Kindly have a look at it. Hope it will help you. Please let me know if I missed something or if you have any queries further.


    Manpreet Kaur

  • Replied 8 September 2017, 2:58 pm EST

    Cool, I will take a look, thanks...!



Need extra support?

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

Learn More

Forum Channels