I have parent-child grid rows that are exported to Excel with ultraGridExcelExporter.BandSpacing = 0. The bottom rows are band 0 as totals, so it looks like:
Band 0 rows
Band 1 rows
Band 2 rows
I would like to skip 1 line before the bottom Band 0 rows. Is that possible? Thanks.
Ron
Hi Ron,
I think you should be able to achieve this by handling the RowExporting event and changing the e.CurrentRowIndex. You can set the property on the event args and just add 1 to move the row down one.
The tricky part will be detecting when to do this. I guess you will need to get the grid row (it's on the event args, also) and find out if it has a previous row and if so, if that sibling has any child rows.
That works. Thanks for your help.