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

    <P>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?</P>
    <P>Example:</P>
    <P>
    <TABLE style="WIDTH:372pt;BORDER-COLLAPSE:collapse;" cellSpacing=0 cellPadding=0>






    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;WIDTH:127pt;HEIGHT:15pt;BORDER-TOP:windowtext 0.5pt solid;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>Step 1 - Inpt Data in Sheet</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;WIDTH:120pt;BORDER-TOP:windowtext 0.5pt solid;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>Step 2 - Filter on A and C</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;WIDTH:77pt;BORDER-TOP:windowtext 0.5pt solid;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>Step 3 - Paste G</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:windowtext 0.5pt solid;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>Step 4 - Unfilter</FONT></TD></TR>
    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;HEIGHT:15pt;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri><STRONG>Col1</STRONG></FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri><STRONG>Col1</STRONG></FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri><STRONG>Col1</STRONG></FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri><STRONG>Col1</STRONG></FONT></TD></TR>
    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;HEIGHT:15pt;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>A</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>A</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD></TR>
    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;HEIGHT:15pt;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>B</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>C</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD></TR>
    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;HEIGHT:15pt;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>B</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri> </FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri> </FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD></TR>
    <TR style="HEIGHT:15pt;">
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext 0.5pt solid;BACKGROUND-COLOR:transparent;HEIGHT:15pt;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>C</FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri> </FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri> </FONT></TD>
    <TD style="BORDER-BOTTOM:windowtext 0.5pt solid;BORDER-LEFT:windowtext;BACKGROUND-COLOR:transparent;BORDER-TOP:windowtext;BORDER-RIGHT:windowtext 0.5pt solid;" class=xl65><FONT size=3 face=Calibri>G</FONT></TD></TR></TABLE></P>
  • Replied 10 September 2017, 10:56 am EST

    <p>Hello,</p><p>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.</p><p> </p><p>Thanks, <br></p>
Need extra support?

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

Learn More

Forum Channels