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.
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.
Ok, please try the following attachment. I am using latest 11.2 DLLs (11.2.20112.1010). If you remove the References, then add 10.2 DLLs (I was using 10.2.20102.2064) then you should see a difference in the indentation.
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.
Perfect, thank you! So was it a bug in 10.2 that enabled the other property to work?
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.