Hi, again a question . With the following Code i add the summary
For Each oColumn In oBand.Columns
oBand.Summaries.Add(Infragistics.Win.UltraWinGrid.SummaryType.Sum, oColumn, Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn)
oColumn.Width = ((Len(oColumn.Header.Caption) + 2) * nSchriftgroesse) + (4 * nSchriftgroesse)
oColumn.PerformAutoResize(PerformAutoSizeType.AllRowsInBand)
Next
now i have the following result
sum = 128,250000000023
but i want only have sum=128,25 (only with two decimal places) how can i set this ?
i want remark that now every column need decimal places. only a few. it is column independent
When you add the Summary, it will return a SummarySettings object. You can set the DisplayFormat to format the text.
Hello,
Can I have optional decimals or add regular expression to mySummarySettings..DisplayFormat = "";. I have rounded the sum in summary to four decimal places but I don't want to show value like this: 234.5600, rather I want to show value as 234.56.
Thanks
Hi Disha,
I'm sure there are numeric formats that allow for optional trailing zeroes. Microsoft lists the possible formats here:
Standard Numeric Format Strings
Custom Numeric Format Strings
I think what you want is the "g" or general format.