Since our latest update of Infragistics (2010v2 2109) the excel exporting has been a bit strange.
Column Header Rows are displayed on every row. I've attached an image to show this.
I've added a temporary work around for this for the moment.
After looking through export events I found the "GridExportCache.BandZeroHeaderExportedForGroupIsland" boolean was never flagged as true.
Another variable that is seemlingly helpful is the "PlacedHeadersOnTop" boolean..Anyway. Is there a flag that needs to be set for this to occur?
Thanks.
Hi,
We recently updated the UltraGridExcelExporter to honor the HeaderPlacement property on the grid's Override object. It did not previously honor this property setting, which was a bug.
So this is probably what caused the change in behavior you are seeing here. But I can't be sure if this behavior is a bug we introduced or if this is just a result of the situation you have in your application.
Does your grid have multiple bands? Is there a child band in the data source? Are you setting HeaderPlacement? If so, what are you setting it to?
Most grids have multiple bands and to my knowledge no header placements have been set anywhere in the system. We use the default value.
I've modified the code the set the band header placement and it works as expected. Thanks!
One more question while I'm on the subject. Every row in an exported grid is expanded regardless of my efforts to stop it from doing so. What needs to be set to do this?
I just wanted to know if you were able to solve your issue based on my or Mike's suggestions or you still need help? Just let me know.
Thank you.
I did solve the problem, thank you!
As for Excel row expansion.. I decided it would be easier to navigate using the layers rather than the expansion indicators.
Cheers.