I've added parent columns to sum child columns so that I can summarize the child columns in the parent summary as Mike and I talked about in this thread:
http://forums.infragistics.com/forums/p/19857/73136.aspx#73136
But now I'm noticing that although I've lined up the new parent columns in the grid with the corresponding columns in the child, after I export the child is indented one column due to the Excel grouping. The indent is fine in Excel and makes it readable, but since the grid indents children differently (just a handful of pixels but still in the same column position as column 1), they are in different positions after export.
Any way to get them lined up in Excel?
----
I just answered my question: I already had to add a couple empty columns in the child band to line them up in the grid: just before the export I hide one of those empty columns, export, and unhide that column.
Works for me. Although let me know if there is a built in way of dealing with this.
The solution you've used seems to be a good one.
WinGridExcelExporter puts in empty columns in child rows to handle indentation. Thus, the first level of depth will start in column B, the second in column C, and so on.
You likely don't even have to unhide the column you hid, depending on where you do the hiding. If use the BeginExport event of the WinGridExcelExporter, then the changes you make to e.Layout are being performed on a clone of your grid's DisplayLayout and won't affect what's being displayed on the screen.