Hello!

I have succeeded in export column based Formulas but I cannot get the summaries to be exported in the same way.

If we look at the columns, I have written a formula like this:

e.Layout.Bands(0).Columns.Item("Price").Formula = "Sum([Quantity] * [UnitPrice])"

When I use the UltraGridExcelExport, I set the property "ExportFormulas" to true and it works perfectly.

In my grid, the data is grouped into different levels so there are summaries in a lot of places.

Is it possible to export those as Formulas sonehow, so that the ending excel-file is more workable?

I have added the summaries like this:

e.Layout.Bands(0).Summaries.Add(SummaryType.Sum, e.Layout.Bands(0).Columns("Price"), SummaryPosition.UseSummaryPositionColumn)

I read some earlier post that it didn't work with the built in summary types like "sum", but what to do?

/Henrik