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

    <p>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.</p><p> 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</p><p> thanks</p><p> </p><p> </p>
  • Replied 8 September 2017, 2:58 pm EST

    <p>Hello,</p><p>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.</p><p>Thanks,</p><p>Manpreet Kaur <br></p>
    2012/07/RemoveSelectedRows.zip
  • Replied 8 September 2017, 2:58 pm EST

    <p>Cool, I will take a look, thanks...!</p><p> </p><p> </p>
Need extra support?

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

Learn More

Forum Channels