Hello;
My grid has 1 group by and the group by header row is suppressed with this property: (HeaderPlacement.FixedOnTop). But when I export the grid, the .the header row in the group by shows back up, even though it doesn't appear in the grid. (BTW, this also shifts the summary values in the groupby rows over a column in the .xls, so they stay aligned with the column headers in the groupby. I think. The groupby column headers are shifted over one relative to the main grid column header.)
That's my first question, but I went ahead to see if I could cancel the export of the header row in the HeaderRowExporting event but I could never find the right header row. The event fired 3 times, all for band[0] and all were columnHeqaderTypes. I'm stuck.
Thanks,
Bill
The same question was discussed in this thread: UltraGridExcelExporter GroupBy mode Fixed Header - Infragistics Community
Thanks Mike, moveing from 8.1 to 8.3 fixed the shifted column issue. But is it expected that the .xls has the groupby column headers when the grid doesn't. (The top column headers appear in both.)
I'm still not able to eliminate the columns header row in the group by with code in the HeaderRowExporting event.