Hi community,
This is my problem: I have a Ultragrid in which I've used RowLayout to group Column Headers and all works fine in my grid, however when I copy the data by selecting all rows and then I paste them in excel 2007 sp2 the headers are pasted in only one row all columns including the "group columns", but one after the other (in sequence) without to reproduce the RowLayout :(.
In Grid (UltraWinGrid.v7.2):
Column 1 | Group 1 | Group 2 |
| Detail 1.1 | Detail 1.2 | Detail 1.3| Detail 2.1 | Detail 2.2 | Detail 2.3|
But in excel I have:
Colum 1 | Group 1| Group 2 | Detail 1.1 | Detail 1.2 | Detail 1.3| Detail 2.1 | Detail 2.2 ...
Is there any solution?
Thanks for your help.
Hello,
When you select the all rows and you copy them to clipboard, what we are doing is to flattened out any column information to a single row, so currently is not possible to put any complex layout data to the clipboard.
I will submit a feature request for this functionality.
Sincerely,
Danko Valkov
Developer Support Engineer
Infragistics, Inc.
This can be done programatically using the datatable methods.
dataset.Tables("TABLENAME:").WriteXmlSchema(Replace(strFileName, ".XML", ".XSL"))
dataset.Tables("TABLENAME").WriteXml(strFileName, True)
Thanks for your answer and your atention
I'm sorry Elfmanne but my problem is not related to the data in the grid instead it is refered to the headers (using row layout) of the grid. I want to get the same in excel as I see in the grid.
However, thanks for your time.
Correction for my Grid Layout: