I am trying to copy and paste rows from my RadGridView to Excel. It works as expected when the first and last columns are visible, but if the first column is hidden the opening TABLE/TR tags in the HTML format on the clipboard are lost, and if the last column is hidden the matching closing tags are lost.
Repro: (VS2012, RadGridView Q1 2014)
Add a datasource with three columns. Right click on row header -> Copy, Paste into Excel.
Expected: The data spans three columns.
Actual: The data spans three columns. Yay!
Clipboard contents:
Version:1.0
StartHTML:00000097
EndHTML:00000239
StartFragment:00000133
EndFragment:00000203
<
HTML
>
<
BODY
>
<!--StartFragment-->
<
TABLE
><
TR
><
TD
>3</
TD
><
TD
>Tools</
TD
><
TD
>Electronics</
TD
></
TR
></
TABLE
>
<!--EndFragment-->
</
BODY
>
</
HTML
>
Hide the first column. Right click on row header -> Copy, Paste into Excel.
Expected: The data spans two columns.
Actual: All data is in a single cell.
Clipboard contents: No <TABLE><TR>.
Version:1.0
StartHTML:00000097
EndHTML:00000216
StartFragment:00000133
EndFragment:00000180
<
HTML
>
<
BODY
>
<!--StartFragment-->
<
TD
>Books</
TD
><
TD
>Chocolate</
TD
></
TR
></
TABLE
>
<!--EndFragment-->
</
BODY
>
</
HTML
>