Hey,
I want to copy data from an excel sheet to my Grid using CTRL-C and CTRL - V.
Please anybody tell me the complete method to do so. I have read the formums and blogs but still unable to copy-paste.
As people are telling to use: e.Layout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All
this line still does not helped me.
Regards
Mudassar
There's currently no way to do this. You should Submit a feature request to Infragistics
I'm also trying to accomplish this and am having problems.
For example, my grid currently contains a total of 5 rows. I've copied 6 from Excel, and try to paste them into my UltraGrid. I end up getting an Infragistics dialog box stating:
---------------------------Paste Error---------------------------Error performing Paste operation. Further information: Contents being pasted have more rows than what's available starting from the anchor cell. Paste contents have 6 rows where as the available rows starting from the anchor cell are 5.
---------------------------OK ---------------------------
I would expect that there should be a setting to allow pasting of additional rows, but I have yet to find it.
Thanks
Hi,
I'm also trying to paste the content from Excel to ultragrid, its allowing to paste only the same number of rows present in ultragrid not more than that. So can you please tell me how to add any number of rows from excel to ultragrid at runtime.
Hi Pablo,
I still don't understand the problem. Pressing CTRL+C will not have any visible effect, it's just a copy. So how do you know it's not working? I thought you were talking about pasting from Excel into the grid, not copying FROM the grid.
Hello Mike,
I set the property UltraGrid1.DisplayLayout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All but when I select any row and then I click CTRL-C nothing ocurrs.
Why it can posibly?
I need this functionality.
Thank in advance.
Pablo Lammardo