We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Copy and Paste Excluding Hidden Columns

Thread ID:





129339 Mar 14,2017 03:36 AM UTC Mar 15,2017 03:33 PM UTC WinForms 1
Tags: GridDataBoundGrid(Classic)
Shawn Tyler
Asked On March 14, 2017 03:36 AM UTC


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 [Syncfusion]
Replied On March 15, 2017 03:33 PM UTC

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. 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon