Hi I am having a grid which was binded with a hierarchical data and the number of maximum bands expected are 4.
On screen this is looking fine with a expanded +/- symbol. I am using UltraGridExcelExporter control to export to excel.
after I export to excel, in the excel sheet only the first band data are in proper places. the second or further band data (i.e child band data) or skipping one column from the parent row and the readability is lost.
attached the screenshot for your reference.
What we want is the + symbol should be expanded in the excel but all the child bands should be plotted from column A.this is applicable for all child bands. i.e all the child bands should be plotted from Column A.
any suggestion please.
Thanks,
Arun.K.S
sarunmphil,
Were you able to get this working? I'm having the same problem... in the export to excel, we would like to be able to expand/collapse the child rows but would like all child rows to start in column A and not be indented one column.
I tried the suggested solution, namely, handling the BeginExport event and looping through all the bands in the Layout and setting the indentation to 0, but this has not resolved the issue. In the resulting excel file, each child band is still indented by 1 column.
If anyone knows how to resolve this, please let me know!!
I'm sure this works. Can you post the code you used? Are you using the correct layout - make sure you are using the layout passed into the event and not the grid's DisplayLayout.