Hi Peryan,
To achieve this, you must handle the keydown event, look for 'Ctrl+V' keys, check for data in the clipboard and for multiple selected cells. Once all the former conditions are met, you have to set the selected cell values with the clipboard data.
I have a code snippet that would do what you need:
Private Sub ugMain_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ugMain.KeyDown Select Case e.KeyCode Case Keys.V ' check for control key down If e.Control = True Then ' retrieve data from clipboard Dim doClipboard As DataObject = DirectCast(Clipboard.GetDataObject(), DataObject) ' test for CSV data available If doClipboard.GetDataPresent(DataFormats.Text, True) Then ' retrieve CSV data into a memory stream Dim msClipboard As String msClipboard = DirectCast(doClipboard.GetData(DataFormats.Text, True), String) Dim str() As String = msClipboard.Split(New String() {vbCrLf}, StringSplitOptions.RemoveEmptyEntries) ' Paste one cell to multiple cells If str.Length = 1 AndAlso Me.ugMain.Selected.Cells.Count > 1 Then For Each cell As Infragistics.Win.UltraWinGrid.UltraGridCell In Me.ugMain.Selected.Cells cell.Value = str(0) ' Does not seem to work: cells are deactivated/reactivated after this sub cell.Selected = True Next End If End If End If End Select End Sub
Refer to the following help article from NetAdvantage for .NET 2007 Volume 3:WinGrid - Turn On Clipboard Operations
Please remember that these forums area a peer-to-peer resource to share issues and ideas with other Infragistics users. If you require official support from Infragistics, such as if you need further help with this question, please submit a support request to Infragistics Developer Support from this page of our website.