Dear Infragistics helpers,
my UltraWinGrid contains 2 Bands. Band(0) shows customer data, band(1) shows order data (per customer in band(0)).
When exporting to excel, the bands are automatically translated to outline levels. So in the Excel-Worksheet, I see only the customer data and these '+'-Buttons at the left. To see the order data in excel, I have to click on the '+' to open the grouped rows.
But I do not want to have the data in excel in hierarchical groups. Everything should be visible in the excel-sheet, and I don't need those '+'-buttons.
So I tried things like:
e.CurrentWorksheet.Rows(e.CurrentRowIndex).OutlineLevel = 0 in the InitializeRow-event, but with no effect.
Can you help me?
How can I prevent the excel-exporter from creating hierarchical outline levels?
Thank you
Liz
Hi Liz,
If think the problem might be that you are using InitializeRow. This event will fire when the rows are being created in the layout.I think you need to use RowExported, instead. YIt think you might have to use CurrentRowIndex -1 inside that event, also, because it may have already been incremented.
Dear Mike,
thanks for your help.
at least all rows show now, with this code:
e.CurrentWorksheet.Rows(e.CurrentRowIndex - 1).Expanded = True
But the hierachical outlining itself doesn't change, neither with:
e.CurrentWorksheet.Rows(e.CurrentRowIndex - 1).OutlineLevel = 1
not with OutlineLevel = 0.
I assume there is no way to get rid of it completely?
Maybe you need to change the OutlineLevel in RowExporting?
Another option might be to remove the indentation on the layout. Use the BeginExport and loop through the e.Layout.Bands and set the Indentation on each band to 0.