Points To Remember :
I have a column with Numeric Type and its EditType = NoEdit

I was unable to reproduce the problem by using CopyPasteMultipleRows.aspx sample file of WebGrid. Please see attached video which shows how the reported problem is evaluated in my end.

Thank you and have a nice day.

Hi Yudi,

Can you please make "UnitinStocks" Colunm as System.Decimal instead of Int and try to replicate. Because my colunm is decimal type.

Thanking You

Thank you for the hint. Instead of changing "UnitInStock" column as System.Decimal, I'm using "UnitPrice" column which by default has decimal data type.

The reported problem occurs if the following conditions are met:

• EditType of the column is NoEdit.
• DataFormatString of the column is set. For example: c2; or #,###,##; etc.

If your grid's structure met the above condition, the steps below can be used as workaround in order to avoid the problem.

1. Removes EditType="NoEdit" from the WebGridColumn definition.
   Original:
   <ISWebGrid:WebGridColumn ... Name="UnitPrice" DataFormatString="c2" EditType="NoEdit" ... />
   
   Modified to:
   <ISWebGrid:WebGridColumn ... Name="UnitPrice" DataFormatString="c2" ... />
2. In InitializeRow server-side event, enable ForceNoEdit of the cell. Enabling this property will force the cell to not allow editing (which has the same effect as set EditType to NoEdit).
   Example:
   protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
   {
       e.Row.Cells.GetNamedItem("UnitPrice").ForceNoEdit = true;
   }

I have tested this workaround and found that the exception is no longer persist when user paste multiple rows from clipboard. Please let me know whether this helps or not.