We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to format the GridNumericColumn in the SfDataGrid?

In the SfDataGrid, you can display the double type values by using the GridNumericColumn. By default, it loads the TextBlock in the display mode and the DoubleTextBox in the edit mode. You can format the value of the GridNumericColumn by using its inbuilt properties. The following screenshot shows the Annual Income of the GridNumericColumn loaded with its default value without formatting.

Figure 1: Default view of the GridNumericColumn

 

The following XAML code example shows how to format the GridNumericColumn with the built-in properties.

XAML

  • NumerDecimalDigits: NumerDecimalDigits is a dependency property and its type is an Integer. It specifies the number of decimal places to use the numeric value in editor.
  • NumberDecimalSeparator: NumberDecimalSeparator is a dependency property and its default type is string. It separates the integer from the fractional digits.
  • NumberGroupSeparator: NumberGroupSeparator is a dependency property and its default type is string. It separates groups of digits to the left of the decimal in numeric values.
  • NumberGroupSizes: NumberGroupSizes is a dependency property that specifies the Int32Collection or a single digit number. It is used to specify the number of digits in each group to the left of the decimal in numeric values.

The above specified format is applied to the GridNumericColumn as shown in the following screenshot.

Figure 2: After formatting the values in GridNumericColumn

 

In the GridNumericColumn, it is not possible to format the scientific notation since the StringFormat property is applicable only for the GridTextColumn. You can achieve this behavior with the help of the converter in the DisplayBinding property and format the display of the GridNumericColumn.

The following XAML code example shows how to display the scientific notation in the GridNumericColumn by using the converter in the DisplayBinding.

XAML

The above converter is invoked for each cell in the GridNumericColumn and the display format can be customized based on the specified format provided in the converter as shown in the following code example.

C#

The above scientific notation format is applied into the GridNumericColumn as shown in the following screenshot.

Figure 3: Scientific Notation in GridNumericColumn

 

You can refer to the sample from the following location.

WPF: GridNumericColumn_WPF.zip

WRT: GridNumericColumn_WRT.zip

Article ID: Published Date: Last Revised Date: Platform: Control: .NET Framework: Product Version:
4908 05/18/2015 06/08/2015 WinRT SfDataGrid 4.5 12.4.0.24
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.