Is it possible to export grid summaries as formulas?
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:
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?
Thanks!
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.