When I try to copy a lot of data from my grid to the excel sheet, some rows are missing.
I found this solution on your forum
private void gridview_Copying(object sender, RadRoutedEventArgs e)
var obj = Clipboard.GetDataObject();
var data = obj.GetData(DataFormats.Text);
All data now are copied to excel but if into a cell there is a newline char, excel will create a new row
How can I fix it?
I read that when I copy from grid on the clipboard all data are saved as html, csv and txt
My grid has around 500 000 cells, and the coping operation is not performed at all.
I think the problem is the html, and I need only the data without any kind of formatting.
So is it possible to saved only the txt on the clipboard?