I have a WinGrid with several columns. Each column has a header and the grid has several rows. When a user clicks on the column header I have code the changes the background color to indicate the column was selected. I also have a right click popup menu defined.
When a user right clicks on the column header, I want to copy the entire column, header and data, so the data can paste into Excel. But this isn't working. I can see the column in the Selected.Columns collection, but nothing on the clipboard.
Any suggestions or exmaple links? Thanks.
Hello,
There is a suitable event in the grid - DoubleClickHEader and you'll need a variable of type UltraGridColumn to store the copied column:
private void ultrGrid1_DoubleClickHeader(object sender, DoubleClickHeaderEventArgs e)
{
UltraGridColumn copiedColumn = e.Header.Column;
}
Hope this helps.
Sincerely,
Petar Monov
Developer Support Engineer,
Infragistics, Inc
Thank you for replying. However, I need to copy the data from a selected column when right clicking on the Header of the column, to the Windows clipboard so I can then paste it into Excel. Any suggestions there?
Just to make things clear. You want to do Copy/Paste from ultraGrid to Excel right?
Right, so I have a grid with header and cell data. When a user clicks on the header and chooses my Copy option from a popup menu, the all the data from the header down, all cells, are copied to the clipboard, so that I can then go to excel and paste the data into a spreadsheet.
Works fine on cell and row data with the PerformAction method, but not on Columns (even though I show columns selected in the MyGrid.Selected.Columns property.