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.
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
Sorry, I should have said add a sorted column with groupBy set to True.
Hello jcwild,
I must have messed up the steps or something like that because I was not able to reproduce this. Could you please attach the mentioned sample and also tell me what version of 10.2 are you using exactly?
I will wait for your feedback.
Yes, you resolved it, thanks. I had marked your previous but one response as the Answer.
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.