Thanks for the quick reply. Unfortunaly this is not the issue. I will make an sample:

The Grid looks like:

H1 H2 H3
D1 D2 D3
D4 D5 D6

H* are the headers; D* are the data cells

If I click on Header H2, which selects the column, press <Strg><C> and past into Excel. The pasted values are these:

H1 H2 H3
D1 D2 D3

This is not what I expected.

The selection (blue highlighted, except the header of course) in the grid looks OK. Like the expected result:

H2
D2
D5

 Any other ideas?

I try to create a striped code sample.

Hi,

After looking into this in some detail, it turns out not to be as simple as it seems.There are a great many questions and issues surrounding what to do in certain situations.

Like what happens if you have both columns and rows selected?

What if you select a column in a child band in when the grid is grouped?

And how do we handle memory usage if you select a column in a grid with a large number of rows since this would force the creation of every cell in the row.

These and other issues are why this feature was not implemented originally, and so this has been entered as a feature request and may be implemented in a future release.

Hmm,

Sorry, but that's a lame answer.  Nothing is easy in programming :)  Note that Excel doesn't allow copy if both a row and column are selected.  As for memory issues or other technical issues, as a "user" I don't care, just make it so that whatever is selected on screen is what gets put into the clipboard (boy, it feels great to be a user and say that, hah!)

Here's my workaround that I implemented in my application:

private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
{
    TransformColumnSelectionToCellSelection();
}

private void TransformColumnSelectionToCellSelection()
{
    if (ultraGrid1.Selected.Columns.Count > 0 && ultraGrid1.Selected.Cells.Count == 0)
    {
        ultraGrid1.Selected.Cells.Clear();
        var columns = ultraGrid1.Selected.Columns.Cast<ColumnHeader>().Select(i => i.Column);
        var cells = ultraGrid1.Rows.Cast<UltraGridRow>().SelectMany(i => i.Cells.Cast<UltraGridCell>().Where(j => columns.Contains(j.Column)));
        ultraGrid1.Selected.Cells.AddRange(cells.ToArray());
    }
}

robarch, I used your code but got error message  "cannot resolve symbol 'Column'  "   when getting the value of columns.  Do you have any idea why  ?

I can only assume that the version of the UltraGrid doesn't have the same properties as the version I was using.  The code is essentially using Linq to get an IEnumerable list of the column names currently selected here:

var columns = ultraGrid1.Selected.Columns.Cast<ColumnHeader>().Select(i => i.Column);

Then, it uses Linq to get a list of all the cells for every row for the selected columns.

var cells = ultraGrid1.Rows.Cast<UltraGridRow>().SelectMany(i => i.Cells.Cast<UltraGridCell>().Where(j => columns.Contains(j.Column)));

This is essentially doing the same thing as a SQL "IN" statement and it's getting all of the cells which have a column named the same as the selected columns.  I'm assuming this is the line you're getting the error and I'm guessing it's coming from one of two problems:

1. A null columns list.  I don't do a test to ensure that this list isn't null and perhaps you need to.

2. Inside the Where clause.  I'm using WinGrid 2009.2 and an UltraGridCell has a Column property with the name of the column in it.  Does your UltraGridCell have the Column property in it?

Good luck!

Thank you ! I use 2009.1, I guess it doesn't support the Column property.  I will need to find the right property for column name.