On CRUD Form numeric field (with format #,##0.00) when updated becomes zero 0 [Label: bug & feature]

[borisdj]

Describe the bug
Numeric field with thousands separator when updated gets 0.00 value instead of actual.

To Reproduce
Steps to reproduce the behavior:
IN CODE - Set Format:
c.Add(o => o.Amount).Format("{0:#,##0.00}");

ON FORM

1. Add ___________________

2. Added ________________

**

3. Update _______________

4. Updated ______________

Expected behavior
After update Amount should be 1,234.57.
Currently only way for getting correct value is when editing number with 4+ digits to always delete thousands separators in the field and then Save the Form.

Fix should parse correctly separator to number, or not to be shown in the field at all.
Also to note that when using localization de-DE and some other European languages, comma and dot are inverted:
1.234,56
But bug is the same, also goes to zero.

Additionaly it would be best if Field could be configured in such way that thousands separator is shown both when Adding or Updating on FocusOut when switching input to another field. In that case when that number is in Focus then thousands separator is removed in both cases since it can interfere with typing digits. This format is useful to avoid mistakes when typing large numbers.

• In Focus
  
• Out Focus
  

[gustavnavar]

Package 2.1.18 implements your fix.

This sample implements it for the Freight field: https://gridblazor.azurewebsites.net/crud

Thanks for your fix

[borisdj]

Glad to help.