Custom of Datagrid Cell text string format

[Mahmut Nedim]

Hi,

I am using sfDatagrid. My code blog as follows. I set this format (#,##0.00). But for example, for a double result (ex:1234567.89) the android shows 1.234.567,89, the ios shows 1,234,567.89 result.

So the comma and dot are replacing. How can  i solve this problem

  <xforms:GridTextColumn HeaderText="Güncel Bakiye" 
                                                           HeaderTextAlignment="End" HeaderFontAttribute="Bold"
                                                           MappingName="GuncelBakiye" Format="#,##0.00" TextAlignment="End" />

[Karthikraja Kalaimani]

Hi Mahmut,

Thanks for contacting Syncfusion support,

Your requirement can achieve by using the “Format” property in “GridNumericColumn” in SfDataGrid. We have prepared the sample for the same. Please follow the below the code snippet and sample link.

 

[XAML]
<sfgrid:SfDataGrid x:Name="dataGrid" 

                               AutoGenerateColumns="false" 

                               ItemsSource="{Binding OrdersInfo}"> 

            <sfgrid:SfDataGrid.Columns> 

 

                <sfgrid:GridNumericColumn 

                                Format="#,##0.00" 

                                HeaderText="Product No" 

                                MappingName="OrderID" 

                                Width="100"/> 

            </sfgrid:SfDataGrid.Columns> 

</sfgrid:SfDataGrid> 

 

Sample link : https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataGridDemo1809364746-249862335 

 

 

 

UG link : https://help.syncfusion.com/xamarin-android/sfdatagrid/column-types#gridnumericcolumn 

We hope this helps. Please let us know, if you need any further assistance.

 

Regards,
Karthik Raja