gridview Copying and Pasting

[Erdem]

   Hi I write this code and I m trying someting . But when i click copying event then 3 times show messagebox "a" but  when i click pasting event then messagebox show 1 times "a".. Why copying event show 3 times ??

       private void radGridView1_Copying(object sender, GridViewClipboardEventArgs e)
        {
            MessageBox.Show("a");
            

        }

        private void radGridView1_Pasting(object sender, GridViewClipboardEventArgs e)
        {
            MessageBox.Show("a");
        }

[Stefan]

Hi Erdem,

Thank you for writing.

Here is a quote from our documentation regarding the copying event:
RadGridView introduces Copying event which occurs when the grid has prepared appropriate data formats that represent the copy selection. This event is fired once for each supported format: DataFormats.Text, DataFormats.HTML, DataFormats.CommaSeparatedValue. You can cancel this event if the data is not allowed to be stored to Clipboard in a specific format, e.g. HTML format:

 

I hope this clear things up. Let me know if you have any additional questions.

Regards,
Stefan
Telerik

 

 

[Karl B]

This appears to happen when pasting directly from Excel. If I copy from excel and paste into the grid it will fire Pasting for HTML, Text AND CSV. 

 Is there any way to suppress this behavior?

[Stefan]

Hi Karl,

The observed behavior is desired and expected and cannot be suppressed. We are checking what is the format of the data in the clipboard and we are firing the event for the respective formats. You could do the same if you want to limit to just one format.

I hope this helps.

Regards,
Stefan
Telerik

[Karl B]

Is there a way to control what format is copied from a Telerik grid row?  It appears to be coming in as HTML by default. 

I want to be able to handle copying from a text file, excel, and another grid row. If I could count on the grid data being in text format I could ignore the other formats.

[Karl B]

Disregard my last post. I am now seeing all three formats pasted in.  I'm not sure what was going on before.