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
60
UltraGridExcelExporter Summary values are formatted as text in Excel
posted

Using :

this.ultraGridExcelExporter1.Export(this.ultraGrid1, fileName);

having a summery defined as:

SummarySettings sumSetting = e.Layout.Bands[0].Summaries.Add(SummaryType.Sum, e.Layout.Bands[0].Columns["Qty"], SummaryPosition.UseSummaryPositionColumn);

sumSetting.DisplayFormat = "{0:0.00}";

sumSetting.Appearance.TextHAlingn = HAlign.Right;

makes the cell in Excel containing the summary value formatted as string, not a numeric value... Removing the formatting in SummaryCellExporting event has noe effect:

e.Summary.SummarySettings.Appearance.TextHAlign = HAlign.Default;

e.Summary.SummarySettings.DisplayFormat = string.Empty;

All other cell values are formatted correctly, is this a known issue?