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.
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
Thank you for your feedback.
I am waiting for your results.
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.
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! ;)