Copy/Paste Row from Grid Fails If Not All Columns Are Showing?

[Emmett]

Hello, and thank you in advance for any and all help.

I do not know if this is a known bug, something I have discovered, or something I am simply doing wrong.

.Selectable(selectable => selectable
        .Mode(GridSelectionMode.Multiple)
        .Type(GridSelectionType.Row))
.Resizable(resize => resize.Columns(true))
.AllowCopy(true)

 

This is how I have my grids set up. However, I notice copy/paste will fail from the grid unless all columns are showing. I use hideColumn() and showColumn() to allow a user to dynamically select what columns they wish to see. Is this a known issue, or is it a strict requirement that all columns have to be showing for copy/paste to work? Is there a workaround, if that is the case?

Thank you again!

[Stefan]

Hello Emmett,

I was not able to reproduce the mentioned issue on my end.

I made an example using the provided code snippet and the values are successfully copied and paste in Excel file.

If I missed important details, please modify the provided example and I will gladly assist.

Regards,
Stefan
Telerik by Progress

[Emmett]

How odd, I wonder if it's something with my computer then - Once again, even with your example, I can copy and paste just fine when all columns are showing, but not when I hide a column. This example is exactly what I meant, it's just not working for me.

[Emmett]

And thank you very much for your time in helping me try to solve this, it's much appreciated! 

[Stefan]

Hello Emmett,

I noticed that the issue may occur because when the button is clicked, the focus is lost, and the user needs to click on the Grid before copy.

Check the video to observe the scenario:

https://www.screencast.com/t/rhKkfpJrkupS

Regards,
Stefan
Progress Telerik

[Emmett]

I apologize about how long it took me to reply back to you. 

The problem seemed to be sporadic, even when the grid had focus. In the meantime, we switched to the Excel Export feature, which has been much more reliable. I hope this helps those in the future who have a similar problem. 

Thank you once again for all of your help. 

[Stefan]

Hello Emmett,

I'm glad to hear that a solution was found using the Kendo UI Grid functionalities.

I hope that the export feature is helpful enough to achieve the desired result.

Regards,
Stefan
Progress Telerik