Hello,
How to input cell numeric like:
1k --> 1,000
1.2k --> 12,000
1m —> 1000,000
1b-> 1000,000,000
I remember old version support this way. but current version, i don’t know how.
maybe i forget setting something ?
Thank you
Hello,
How to input cell numeric like:
1k --> 1,000
1.2k --> 12,000
1m —> 1000,000
1b-> 1000,000,000
I remember old version support this way. but current version, i don’t know how.
maybe i forget setting something ?
Thank you
Previous behavior was a byproduct of the library used internally by Handsontable.
It’s still possible, it just needs a little more code from you. Use any library to parse strings into numbers with beforeChange
hook. Here’s an example with numbro that is bundled with Handsontable: https://jsfiddle.net/1wk2macL/1/
@wojciech.czerniak
wow! Thanks for reply.
Works like a charm. Thank you