I have a grid which has several hidden columns (setColumnHidden()).
When I copy the entire grid (gridToClipboard()) or copy several columns (copyBlockToClipboard()), all the data of hidden columns are copied together.
I don’t want to copy the data of hidden columns. How can I make it work?
I have just found out the following post, and tried to work on it with the serialization. It works fine with both gridToClipboard and copyBlockToClipboard. viewtopic.php?f=14&t=9227
However, when I paste the copied values to the same columns, the value of hidden column has changed…
Here is the steps what I did.
Suppose that I have a grid which has column A, B, C and B is the hidden column.
I use enableBlockSelection to select Column A to C and copy, it only copies A and C (that’s correct).
Then I select a cell, which is the first row of Column A, to paste, the values of Column C overwrites the hidden column, Column B, instead of Column C.