How to add percentage symbol in particular column cells?

Tags: #<Tag:0x00007f0b0288ce30>

Hi,

We are using HandsonTable, and Angular 8, We have requirement like, in handsontable A column called ‘Share’, So If i type some number and move to another cell, that cell value should append with % symbol.

50% - Like this.

Is there any sample available, Kindly share.

Regards,
Prabu Kuppusamy

There are two apporaches for that Prabu.

  1. Numeric formatting
    https://jsfiddle.net/handsoncode/9L4p0jdq/
    You use the type: numeric and attach a pattern for the numericFormat. This way all the data are altered the same way.

  2. Create a custom validator
    https://jsfiddle.net/handsoncode/stL0jf68/
    You can keep numbers in different formats just the % is added

Thank you… both samples are fine for us… You really helped… Thanks again

You’re welcome.

I’m happy to help :slight_smile: