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
If the copy and paste are working inconsistently like that, then it's a bug. I'm pretty sure something like this was recently fixed, though. Are you using the latest Service Release?
Hi Mike,
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?
Thanks,
Richard
Thanks for the reply, Mike.
The assembly version of our Infragistics2.Win.UltraWinGrid.v7.3 is 7.3.20073.1054 . I don't know when we last updated our infragistics stuff (just a worker bee).
If this has been fixed in a later release, could you please point me to the release's changelog, so that I can verify that it is in fact the same issue as mine?
Thanks again for the reply,