Formatting data values in cells

[Christopher]

Hi

I have a Grid Grouping Control bound to a DataTable.  I would like the double-type values in a column to be displayed as thousands, for example 1500.15 should display as 1.5K.  Any help would be much appreciated.  Many thanks.

[Arulpriya Ramalingam]

Hi Christopher, 

 

Greetings from Syncfusion. 

 

In order view the value of a column value with some arithmetic operation, the ExpressionFields can be used based on your requirement. To add the ‘K’ in the modified value, the Format property of the GridStyleInfo can be used. We have created a simple sample as per your scenario and please refer below code with example. 

 

Example code 

 

//To create the expression for the column. 

 ExpressionFieldDescriptor expression = new ExpressionFieldDescriptor("Salary", "([Source_Salary] /1000)", "System.Double"); 

 

 //Adds expression fields to the grid table. 

 this.gridGroupingControl1.TableDescriptor.ExpressionFields.Add(expression); 

 //To set the format for Expression column. 

 this.gridGroupingControl1.TableDescriptor.Columns["Salary"].Appearance.AnyRecordFieldCell.Format = "##.0 K"; 

 gridGroupingControl1.TableDescriptor.VisibleColumns.Remove("Source_Salary"); 

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Expression_field-961720592  

 

Please get back to us, if you have any other queries. 

 

Regards, 

Arulpriya 

[Christopher]

Perfect!  Thank you.

[Arulpriya Ramalingam]

Hi Christopher, 

 

Thank you for the update. Please get back to us, if you need any further assistance. 

 

Regards, 

Arulpriya