Hidden columns are copied to Clipboard

[Praveen]

Hi,

My Grid consists of 5 columns in which 2 of them are hidden. When an entire grid (including column header) is highlighted and copied into an Excel spreadsheet, it shows hidden columns also.

Is there any one to guide and send me sample code to copy only visible columns in grid when highlighted.

Thanks & regards
-Praveen

[haneefm]

Hi Praveen,

Here is forum link that discusses how you might do this and has code snippets.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=9906

Best regards,
Haneef

[Praveen]

Thanks Haneef, it helped me.

[Praveen]

Hi Haneef,

This is working fine if entire grid is selected, but if desired columns/rows (say alternate) are selected then only the last selected column/row is pasted in excel sheet. This bug raised only when I put your supplied code.

FYI: Hidden columns are not copied in this case.

Thanks and regards
-Praveen

[haneefm]

Hi Praveen,

Here is a forum thread that modify the copy behavior in a grid.
http://www.syncfusion.com/support/Forums/message.aspx?&MessageID=44369

Best regards,
Haneef