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.
Unfortunately, activation email could not send to your email. Please try again.

Copy and Paste Excluding Hidden Columns

Thread ID:

Created:

Updated:

Platform:

Replies:

129339 Mar 13,2017 11:36 PM Mar 15,2017 11:33 AM Windows Forms 1
loading
Tags: GridDataBoundGrid(Classic)
Shawn Tyler
Asked On March 13, 2017 11:36 PM


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 [Syncfusion]
Replied On March 15, 2017 11:33 AM

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 


CONFIRMATION

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.

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.

;