Customise the NumberFormatInfo used in a GridSummaryColumn

[Anas El Hallabi]

Hello,

Is there a way to cutomize the NumberFormatInfo(NumberDecimalSeparator, NumberGroupSeparator, NumberDecimalDigits, NumberGroupSizes) used in a GridSummaryColumn Format property ? by default, it is using the CultureInfo of the application.

What i'm trying to do is allow the user to change NumberFormatInfo of the displayed GridSummaryColumn in a GridTableSummaryRow.

Many thanks,

Anas

[Jayapradha S]

Hi Anas,

Thank you for using Syncfusion products.

We have analyzed your requirement and you can use NumberFormatInfo properties to apply the format for Summary columns by overriding the GridTableSummaryCellRenderer as shown in the below code snippet,

Code Snippet:

  public override void OnUpdateEditBinding(Syncfusion.UI.Xaml.ScrollAxis.RowColumnIndex cellRowcolumnIndex, Syncfusion.UI.Xaml.Grid.GridTableSummaryCell element, Syncfusion.UI.Xaml.Grid.GridColumn column, object dataContext)

        {

            base.OnUpdateEditBinding(cellRowcolumnIndex, element, column, dataContext);

            var record = dataContext as SummaryRecordEntry;

            if (dataContext is SummaryRecordEntry)

            {

                foreach (ISummaryColumn summaryColumn in record.SummaryRow.SummaryColumns)

                {

                    if (summaryColumn.MappingName.Contains(column.MappingName))

                    {

                        if (record.SummaryRow.ShowSummaryInRow)

                            element.Content = SummaryCreator.GetSummaryDisplayTextForRow(record, this.DataGrid.View);

                        else

                            element.Content = SummaryCreator.GetSummaryDisplayText(record, column.MappingName, this.DataGrid.View);

                        NumberFormatInfo format = new NumberFormatInfo();

                        format.NumberDecimalDigits = 3;

                        format.NumberDecimalSeparator = ",";

                        format.NumberGroupSeparator = "*";

                        if (element.Content != string.Empty)

                            element.Content = Convert.ToDouble(element.Content).ToString("C", format);

                    }

                }
            }

We have prepared  a sample for your requirement and please find the sample from the below location,

Sample Link:  CustomNumberFormat_Summary


Kindly let us know if you require any further assistance on this.

Regards,
Jayapradha

[Anas El Hallabi]

Hello Jayapradha,

Thank your for your answer. I was able to modify the NumberFormatInfo properties for summary columns.

Anas

[Jayapradha S]

Hi Anas,

Thank you for your update.

Please let us know if you have any other queries.

Regards,
Jayapradha