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.
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.
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.
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.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:||.NET Framework:||Product Version:|