ASPxGridViewExporter - Custom formatting is not applied to summary cells in the XlsxExportOptionsEx.CustomizeCell event

Hello,

Here is the project created based on my previous suggestion, where custom formatting is applied for the summary cells. See the attached screencast demonstrating it in action. Please note that e.Formatting.NumberFormat has no effect if e.Formatting.FormatString is defined.

Hi Nataly,
you don't understand my requirements. Your example not contain formula in exported cell.
Thera are my requirements:

1. Export summary cell over time column with formula (not replace formula with value, this approch is not much dataaware)
2. Use custom format [h]:mm over this cell
   Code in my example which calculating custom summary is neccesary because your grid does not allow summary over time column.
   Export of time column with summary formula could be done by this two ways
3. Set summary SummaryType="Sum" (like in my current example). Note: Summary is not displayed bellow grid, but export contains correct formula with incorrect formating.
4. Set summary SummaryType="Custom" (like in my previous example in other report). Consequently, it is necessary to change  e.SummaryItem.SummaryType = DevExpress.Export.Xl.XlSummary.Sum in CustomizeCell in code behind.
   First and second approach produces the same output.
   Same requirements was in my first problem
   https://www.devexpress.com/Support/Center/Question/Details/T280404
   Unfortunately, it was not understood and then was created this clone.
   Thank you

Hello,

Please accept my apologies for missing that. You are right, the workaround is not effective under such conditions. We will do our best to find another solution and are actively researching its source now.