Copy and Paste Excluding Hidden Columns

[Shawn Tyler]

Hi,

When I copy and paste in the grid, how can I get it to ignore hidden columns?

As of now, if I paste a group of cells that span a few columns and then paste those cells in to another range of columns, in which one of those within that range (or more) are hidden, the pasted cells will also paste the data into the hidden columns. I want any columns that are hidden to be excluded from copy/paste operations and that when pasted they would skip the hidden columns and continue to paste the cells in to the next available non-hidden column.

[Piruthiviraj Malaimelraj]

Hi Shawn, 

Thanks for your interest in Syncfusion products. 

We could able to understand your scenario and we have analyzed our source deeply and with excel sheet also. The copied values will be pasted in hidden columns also, this is the default behaviour of the grid and excel also. It could not be achieved by any workaround. If you want to exclude the hidden columns from pasting the values, remove that columns instead of hiding. But the values of that column will be deleted. Please let us know if you have any other queries. 

Regards, 

Piruthiviraj