Hi,
I'm using a few customized summary classes for my ultragrid (having implemented the ICustomSummaryCalculator). However I can't figure out how to get the ExcelExporter to export these summaries into the Excel doc. Everything is showing up except these summaries. I'm using ver 8.2 Please help!
Hi Mike,
I am facing the same issue in Ultragrid. I am also using CustomSummarySettings implemeted thru ICustomSummaryCalculator. While trying to use "Excel to Export" getting error "If summaryType is Custom, then a valid instance of ICustomSummaryCalculator must be passed in." at below line of code:
Dim activeChild As Form = Me.ActiveMdiChildDim uGrid = TryCast(activeChild.ActiveControl, UltraGrid)
UltraGridExcelExporter1.Export(uGrid, WB.Worksheets.Add(ExportTab)) 'Error at this line
Can you please share some sample code, how can i achieve the same?
Thank you. I had to reapply the summary in the BeginExport method.
Thanks,
You should not have to do anything, all summaries should be exported automatically.
Are you seeing the summary row/cells in the Excel file and the cells are just blank? Or are you not seeing the summary row or cell at all?
It's possible that maybe the grid cannot (or just is not) copying your ICustomSummaryCalculator to the cloned layout. If that is the case, it sounds like a bug to me, but no more updates are being made to v8.2. So you would have to work around it in that version.
Probably, all you have to do is re-apply the summary to the layout which is passed in to the BeginExport event of the UltraGridExcelExporter.