I need the data to be aligned when it shows on the bands as well as in Excel
In the attached image, you can see how it shows on the band (correct) but how poorly it shows on Excel (lower part of the image)
Hello,
Thank you for contacting Infragistics.
The behavior you're seeing is the correct and expected behavior. Excel doesn't provide the ability to indent rows the way the UltraGrid does, so in order to show that rows are children of other rows, they are indented by a column.
The ability to disable the indenting of child rows is a new product idea and should be submitted at http://ideas.infragistics.com. This will enable other users to vote on the idea and will let our product management team know that our users would like to see this feature in the product.
Try this:
private void ultraGridExcelExporter1_ExportStarted(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.ExportStartedEventArgs e) { foreach (UltraGridBand band in e.Layout.Bands) { band.Indentation = 0; } }