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
Hi,
It's very hard to build a project out of a code snippet like this - there's too much missing information like what version of Visual Studio you are using and what version of the controls.
So I created a small test project of my own to try this out and it works just fine for me. I am attaching my test project here.
All I did was run it, select the text in the TextBox ("Grape") and press CTRL+C to copy it. Then I clicked on a cell in Column 1 of the grid and pressed CTRL+V and it works.
I have already mentioned that I am using VS2010, Infragistics 10.2 in earlier posts.
I saw the sample sent by you, which does not give error.
Some change was required in the code itself.
1. To ultra grid, the dataset containing valid values was assigned which has white spaces at the end of string. When I export the data from grid to excel, the spaces remained untouched but while pasting it from excel to grid, the spaces trimmed. I trimmed the values copied it in a list if string and attached the list as data source.
2. The data type of column is set to string.
This resolved my problem. Please check attached sample to reproduce the behavior. Copy first row and paste on second row.
Okay, that all makes sense, then. The text you were trying to paste into the cell was not matching the text of the items on the list because of the trailing spaces.
I am stuck with a small copy paste issue in UltraGrid.
For a column in ultra grid whose ValueList is UltraDropDown, its datatype is string, and the default value is string.empty.
The valid values for column are say "" and "ABC", when i copy row with "ABC", the paste does not give any error.
When i copy row with "" , and paste a row, it gives me error for that column as "Unable to convert the value ' ' to the column's data type: Illegal data value"
Can u please help with this.
I am using .net 4.0 and net advantage 2010.2.
Did you get chance to look into the copy paste issue when the string.empty is valid value for a column?
Please reply asap. I am stuck with this.
I have not looked at this issue since my last reply, since no one replied with the information I needed.
Are you using DropDownList style? If there an item on the list with no DisplayText?