Grid – copying data from excel

[hurricaneParticipant]

Hi ,

I want to copy data from excel to grid. One of my columns is an ID column and it is having property editable :false . When I copy and paste one single row over another single existing row, I have no way to control what happens to the destination row other than commit or reject the entire change. I don’t mind all the other values being updated (just not the id). I am finding difficult to find a way to restrict that one ID column being copied. Is there a way available to fix this problem ?

[ivailoParticipant]

Hi hurricane,

There is no built-in option to restrict single cell.
Instead, you can get the value of the cell and revert it when the process is finished.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[hurricaneParticipant]

I tried using cellvaluechanging event with each cell, but while copying data it is not getting triggered.Hence, I am not able to get the value to revert. Please guide if I am overlooking something.

[Peter StoevKeymaster]

Just an idea I wanted to share with you guys. clipboard property can be set to a Grid column, too. Set clipboard: false to disable clipboard operations of a given Grid column.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[hurricaneParticipant]

Thanks guys for your inputs!

@Peter : I tried this option. But in my case, I am doing a row copy. I still not able to achieve what I wanted using clipboard property. Given solution works well if we do cell copying of the data. In my case, I am doing a row copy. It is still overwriting columns value in grid. Some other work around, do you think of ?

[hurricaneParticipant]

Hi Peter,

I have used clipboard property with grid columns by customizing event pasteselection. I have added restriction to copy field while copying if it sets to property as false.
It did work for me. Though, Need your inputs if this logic could break anywhere else unknowingly.

Appreciated your help!

Thanks

[Author]

Posts