Sliverlight Spreadsheet Copy and Paste Broken when Filtering

Posted by: shield2008 on 10 September 2017, 10:56 am EST

  • Posted 10 September 2017, 10:56 am EST

    Hello,  I created a simple SpreadSheet with filtering enabled.  When I filter a column and then paste (ctrl+V) the text in the hidden rows are also updated. Do you have any recommended work around for this?


    Example:







































    Step 1 - Inpt Data in SheetStep 2 - Filter on A and CStep 3 - Paste GStep 4 - Unfilter
    Col1Col1Col1Col1
    AAGG
    BCGG
    B  G
    C  G

  • Replied 10 September 2017, 10:56 am EST

    Hello,

    This is the default behavior, when you select a range of cells which contains filtered out rows  and paste some data the data gets pasted to these rows as well. As a work around you may cancel the default paste and customize it. You may get the visible rows only by using IsFilteredOutRow( ) method and then paste the data in this range of cells/rows.

     

    Thanks,

Need extra support?

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

Learn More

Forum Channels