How to add percentage symbol in particular column cells?

Tags: #<Tag:0x00007fa9abc821f0>


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.

Prabu Kuppusamy

There are two apporaches for that Prabu.

  1. Numeric formatting
    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
    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: