Hello,
we are using the Ultra win grid to show some values and such, like for instance the balance of a bank account. And when we export it theres always a grandtotal appearing at the bottom of the excel sheet with the totals of *all* columns. How can we disable that?
Hi,
Neither the grid nor the exporter automatically add any summaries. So if you are seeing summaries in the export that are not displayed in the grid, then your code must be adding those summaries into the layout somewhere. Check your code for calls to the Summaries.Add method, which is the typical method by which you would add a summary in code.
It's also possible to add summaries by loading a Layout into the grid. So if you don't see "Summaries.Add" anywhere, check for places where you might be calling grid.DisplayLayout.Load.
If none of that helps, then you could try handling the ExportStarted event of the UltraGridExcelExporter and explicitly calling Summaries.Clear on each band in e.Layout.Bands to remove all summaries from the export layout.