Hi all,
In my ultrawingrid I turned on AllowMultiCellOperation, and have am having trouble copying/pasting rows. The cols that are really just text paste in just fine. But 3 of my cols are int valued, with text displayed to the user. When the paste operation gets to these cols, I receive the error:
"Error performing Paste operation. Further information: Unable to convert the value [displayedtexttouser] to the column's data type: Illegal data value. Continue with the remaining cells?"
Is there a way I can get the row Copy process to copy the value, and not the display text? Or from the other end: is there a way I can get the Paste process to internally translate the display text into the int values of the column?
Thanks for any suggestions,
cdj
Hi,
I am using net adv 10.2 service release, with net 4.0 (c#)
Its gives me the same error when i paste string data from excel to grid, the columns which have value list assigned to them, it gives error for them.
The values being pasted are valid values still it gives me the data type error.
Hi Richard,
If the grid's are appearing in the component tray, it means that Visual Studio can't find the grid's Design assembly. Make sure your application does not have a reference to Infragistics2.Win.Design.
You might also want to check and make sure the project references are all correct and that your project isn't referencing other versions of the assemblies - in the licx file, for example.
Hi Mike,
After installing the latest service release, all of my grids have become grayed-out and icons for them have appeared in the component tray. The ultrawindropdowns have vanished from the form area completely and icons for them have appeared in the component tray. This is the case for all forms in my project.
I have tried the utility for creating the IG toolbox, but it didn't help. Can you please suggest how to recover my project.
Thanks,
Richard
Get the latest service release. This sounds like a bug that was fixed a long time ago.
How to get the latest service release - Infragistics Community
I am using version 8.3.20083.1009 and have a similar problem ie I'm attempting to paste data from Excel into a grid that uses ValueLists (from ultrawindropdown controls) to display text but stores numerical values, and Excel only has the text available.
I have narrowed the problem down a bit. It seems that if Excel has a number or date formatted as text, somewhere between when it is copied and pasted into the grid, it is being re-formatted as number or date, and, as the grid is expecting text, a paste error occurs.
The fact that ValueLists are being used doesn't seem to be a factor.
Is there a way to interrupt the paste routine to ensure that correct datatypes will be used?