Grid with floating numbers changes decimal point during editing

Question

Hi support,I'm using a number column, formatted with "N2".My culture is globally set to "de" withej.base.setCulture('de');so the number is displayed with a decimal comma as a decimal point.So far so good.But when I double-click to enter edit mode (inline), the format of the number changes to a decimal point.If I save and the edit mode is finished, the decimal comma appears again as it should be.The column is defined as:{ field: 'priceperday', headerText: 'Price per day', width: 80, textAlign: 'Left', allowEditing: true, format: 'N2'},What can I do?Regards,Stephan

Pavithra Subramaniyam · Answer

Hi Stephan, 

Thanks for contacting Syncfusion support. 

You can apply the ‘de’ culture format while editing by setting the ‘column.editType’ property as ‘numericEdit’ for the number columns. Please refer to the below code example, documentation and sample link for more information. 





 
{ field: 'Freight', headerText: 'Freight', textAlign: 'Right', editType: 'numericedit', width: 140, format: 'N2', validationRules: { required: true}} 


Documentation : https://ej2.syncfusion.com/documentation/grid/edit/#cell-edit-type-and-its-params 

Sample               : https://stackblitz.com/edit/8okhsl?file=index.ts 

Please get back to us if you need any further assistance on this. 

Regards, 
Pavithra S

Stephan Schrade · Answer

Many thanks.This works!Regards,Stephan

Pavithra Subramaniyam · Answer

Hi Stephan,  

We are happy to hear that the provided solution works! Please get back to us if you need any further assistance on this. We are always happy to assist you!  

Regards,  
Pavithra S