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.
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.
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 thanks for your reply. With your tip i got it to run :)