It seems that when we upgraded from 10.2 to 11.2, indentation on groups has broken. The default Excel export when you have groups in a grid is for each group to indent by one cell. This ruins our layout, so we set band.Indentation = 0 on each band in the ExportStartedEventArgs Layout collection. This worked fine when we were on 10.2, but the setting seems to be ignored in 11.2. Has this functionality changed, or is this a bug that has been introduced?Thanks,Campbell
Hello Campbell,
I tried this and it always works fine for me so I attached my sample to this post for you. Please review it and feel free to let me know if I misunderstood you or if you have any other questions.
I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
Thanks for checking up. Your sample does indeed seem to work ok on 11.2, so I'm still trying to work out what the problem is. I'll keep you posted.
Hello,
Okay, I will be waiting for your feedback.
Meanwhile, please feel free to let me know if a question about our toolset comes up on your mind.
Hello jcwild, I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
Hi Boris,I can verify that it is indeed a problem with the grid, and the functionality has changed between 10.2 and 11.2. The issue is actually around groups rather than multiple bands, so your sample does not demonstrate the problem.To demonstrate the issue, create a single column of data, then add a sorted column to the band on this column. When you export, you should see that in 10.2 the indentation is suppressed if and only if you have set band.Indentation to 0. In 11.2 the indentation occurs regardless of this setting.
If you are not able to reproduce from the above I will attach a sample.
Thanks,Campbell
Yes, you resolved it, thanks. I had marked your previous but one response as the Answer.
Hello jcwild,
I do not believe so. I think that the functionality changed and this is the reason for this 'issue'. Please note that the 'UltraGrid' control was developing very fast in the mentioned versions as it is now. It is being constantly changed(features, fixes).
Please feel free to let me know if a question about our toolset comes up on your mind.
Perfect, thank you! So was it a bug in 10.2 that enabled the other property to work?
Thank you for all the information provided, it was very helpful and useful to me. I now believe that you should use the 'IndentationGroupByRow' over the 'Indentation' property, like this:
foreach(UltraGridBand band in e.Layout.Bands) { band.IndentationGroupByRow = 0; }
Please try the above code and let me know if it worked for you.