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

some more details about my problem - add column with string datatype , the style is Drop dwon list, the style is Drop dwon list,
 try pasting valid values from excel to that column in ultragrid

Hi,

The paste functionality in the grid will act as though the user is typing into the cell. So if you copy a value from some other application, such as Excel, the text that is pasted into the grid cell has to be valid as though the user is entering it. In the case of a DropDownList cell, the text would have to match an item in the DisplayMember field of the dropdown. Are you attempting to paste the DisplayText into the grid or the DataValue?

I beleive that only the DisplayText will work and DataValue will result in an error. But I could be wrong.

If that does not help, can you post a small sample project demonstrating the behavior you are seeing?

Thanks Mike for the quick reply.

Please find below my code to bind ultra drop down to ultra grid column.

I am just setting the data binding to dropdown, so i think i am trying to paste display test.

Can you please go through the code and point of problem if any?

Also, please suggest if there is some better way to bind data set to ultra drom down.

private void gridSelectionRules_InitializeLayout(object sender, InitializeLayoutEventArgs e)

        {

            foreach (UltraGridColumn column in this.gridSelectionRules.DisplayLayout.Bands[0].Columns)

            {

                if (column.EditorComponent == null)

                {

                    UltraDropDown dropDown = new UltraDropDown();

                        DataSet valueSet = GetValidValues(column.Key);// some function that returns me dataset with valid values.

                        if (valueSet != null)

                        {

                           dropDown.SetDataBinding(valueSet, null);

                        }

                    }

                    if (dropDown.DataSource != null)

                    {

                        column.ValueList = dropDown;

                        column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                    }

                }

            }

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 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?

Hi Mike,

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.

Is there an item on the list with no DisplayText so the user can select an empty item? If not, then this will not be possible. In DropDownList style, only values that exist on the list are valid.

Hi Mike,

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.

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.