Hi to all, after using UltraGrid from years one customer tell me that the ExcelExport functionality doesnt export the Summaries!!!
Going deep to know why the Summaries will no be exported I found that:
UltraGridExcelExporter export ONLY the Summaries of deeper Band in Layout!!!
My tests report that this happen with versions from 2009.2.20092 to 2012.2 Sr1.
Before that I open one support issue, anyone have had the same problem and have resolved it?
Thanks
DavidePS: for Infrangistics Support: may be an internal flag that mark that summaries are exported? Because no Exporter event summaries-related was be called for other bands rather the depper.
an example. On the the UltraGrid and on the RIGHT the Excel Result. NOTE ROWS: 136 and 137.
If I remove the summaries from the last band, the next time that export I will see the summaries of band 1, and so on.
Hello,
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.
Hi, yes we need further assistance.
I'm sorry but i saw just now that your superb forum has cropped the my image letting out the Exce result!!!!
You have right noted the summaries in row 137, and they are ok and came from Band 2.
BUT where are the summaries of Band 0 and 1 ?? There is not! the Excel end at row 157.
In our sw we use an our fraework and cannot send you a sample project, but is too esay to reproduce the bug: put an UG in a form set up datas and Layout for 2 bands and add one summary to each band and export in Excel.
Thank you for your time and keep me updated.PS: is not the first BUG that I found in years that I use IG object; please trust me.
Hello,
I’ve opened a support thicket for you in our system. The id of the ticket is CAS-110801-S1Q4J6, so I will update you for the progress of my investigation trough the case.
Sorry ... one note on my test with your Project:
I've used .Net 4 Client profile and Infrtagistics CLR 4 2012.2 [12.2.20122.2027]
Thanks again for your time.
Davide.
another confirm about the link between NOT Exported Summaries and RowLayoutStyle.
In debug I changed the Band[0].RowLayoutStyle to NONE just before exporting and the SUMMARIES in Band 0 APPARED! ;)
Hi Hristo,thank you very much for your valuable time and project.
I saw that in your PRJ all woks fine.I tried to set the UG and the Summaries in the same manner in wich they are setted by our Framework ...
... and I found one set that "hide" the summaries in the XLS!
insert this line at line 54 of Form1.cs:band.RowLayoutStyle = RowLayoutStyle.ColumnLayout;and try it. in the Excel file the summaries are not exported.
I'll go ahead with my test settings the UG bands Layout similar that used in the real apps, meanwhile can you tell me about this issue with ColumnLayout? it's normal?
Thanks very much for you professional help.Davide.