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 have tried to reproduce your issue on my end, and I found that similar issue occurs in Infragistics 9.2 if the grid has more than 4 bands, and for the very inner band summaries are not exported. However I have tested the same sample with Infragistics 12.1 service release 2105 (the latest service release of 12.1, I have used 12.1 because I have assumed that you are using .NET 3.5 or earlier version) and this issue is fixed. In the attached zip you will find the sample which I have tested and on the following link you will find a video that shows what happens on my end.
http://youtu.be/wqWTXFbvJEg
So if your issue is the same, the I suggest you to use latest service release of 12.1 or 12.2.
Please let me know If you have any further questions.
Tahnks for reply and sorry for the late ...
I'm using .Net 4 and Infragistics 2012.2 Sr1.
Tomorrow I will follow your link and I will reply better.
Have a nice week-end.
Davide
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.