Export summaries as formula? | Infragistics Forums

State Suggested Answer
Replies 4 replies
Answers 1 answer
Subscribers 6 subscribers
Views 1592889 views
Users 0 members are here

Excel Library

1934

Export summaries as formula?

Boyd posted over 14 years ago

Is it possible to export grid summaries as formulas?

Parents

469350

Suggested Answer
Offline Mike Saltzman posted over 14 years ago
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
Cancel
Reply

Reject Answer

Cancel

Reply

1934

Boyd posted over 14 years ago in reply to Mike Saltzman

So if I override the process of a user adding a summary to a column such that built-in summary types are replaced with formula summaries, i.e. Type.Sum = "SUM([source column key])", etc., then everything will be exported as a formula?
Cancel
Reply

Cancel

Children

1934

Boyd posted over 14 years ago in reply to Mike Saltzman

Thanks!
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 14 years ago in reply to Boyd

Yes, that will work with the latest version of the grid. Formula exporting support was added in a recent release. I think it was 2008 volume 2. Earlier versions will just export the value of the summary.

You should be able to handle the AfterSummaryDialog event and change the summaries into formulas.
Cancel
Reply

Cancel