In those four examples we (in 0,0.0
format) support 2 of them: 5000
> 5,000
and 10.50
> 10.5
. Demo for tests https://jsfiddle.net/sj9x05k8/
Everything that contains a comma is tread as a string. We do not have a numericFormat
that would meet all those requirements. So in this case, I recommend checking those threads
- How to change numeric format dynamically?
- Use numericFormat option with custom renderer
- https://github.com/handsontable/handsontable/issues/4706
- https://github.com/handsontable/handsontable/issues/9611
And if you have a higher support plan I can also recommend writing to support@handsontable.com and request help in constructing the custom logic by providing the full list of requirements for the numericFormat
.