Copy-Paste Excel multiline cells to grid

[Thomas Stubbe Teglbjaerg]

Hi,

Is it possible to copy-paste (CTRL+C/V) Excel multiline cells to a gridcontrol and keep the linebreaks ?

As it is now each line from the Excel cell is pasted into its own grid cell...

Ex.: The Excel cell could be:

abc
def
ghi

that is, 1 cell with 3 lines. Performing a CTRL+C in Excel and a CTRL+V in the gridcontrol, results in three separate grid cells:

"abc

def

ghi

Is it possible to do a copy-paste that keeps the contents in one cell ?

Regards,
Thomas.

[Administrator]

Hi Thomas,

You could try handling ClipboardPaste event as shown in the following code:

gridControl1.ClipboardPaste+=new GridCutPasteEventHandler(gridControl1_ClipboardPaste);
private void gridControl1_ClipboardPaste(object sender, GridCutPasteEventArgs e)
{
 GridCurrentCell cc=this.gridControl1.CurrentCell;
 if (cc.HasCurrentCell)
 {
     DataObject data = (DataObject) Clipboard.GetDataObject();
     if(data.GetDataPresent(DataFormats.Text))
     {
	string s = (string)data.GetData(DataFormats.Text);
					this.gridControl1[cc.RowIndex, cc.ColIndex].Text = s;
					e.Handled = true;
     }
 }
}

Please let me know if you need further assistance.

Regards,
Srividhya R

[Administrator]

I think that did the trick :-)

Thank you, Thomas.