Hi,
I need to disable the numeric cell formatting, but I don’t know how… I need to display the number exactly how the user enter them.
Handsontable apply by default a formatting === ‘0’, and I can have number going with like 10 decimal or more…
I looked at numbrojs but I can’t find a way to completely disable the formatting for a column…
i saw same is opened in Github but i did not find a solution
thanks in advance
if your data has a different number of decimal places you need to use text cell type. We are using Numbro library for handling numeric cells and we are fully dependent on its formatting.
we have some German number formats like 1234,45 (equal US format is 1234.45).Here we don’t want to do any formating and we don’t want use text cell type also because if we get letters in amount fields then it’s invalid number format.we want to do a number validation.I can achieve this by doing server-side validations but we don’t want wait user to come back with invalid numbers error.
You can use a text cell type with a custom made code from the beforeKeyDown hook. By the following hook you can return false is used key is not a number.
we moved this validation to server side.
Thanks for an update. I am closing this issue.