Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Boyd
1934
Export summaries as formula?
posted

Is it possible to export grid summaries as formulas?

Parents
No Data
Reply
  • 469350
    Suggested Answer
    Offline posted

    Hi,

    If you have the latest version of the grid, then any formulas in the grid will be exported as formulas in Excel.With a few exceptions:

    • This will not work in older versions of the grid.
    • It only works for formula summary, not for built-in summary types like UltraGridSummaryType.Average, Sum, etc.
    • Also, it can't work for summaries when they are displayed as part of the summary caption in the GroupByRow - since this includes a bunch of text along with the value and there's no way to handle that in Excel. So the GroupBySummaryDisplayStyle has to be set to SummaryCells or SummaryCellsAlwaysBelowDescription
Children