so imagine a column that should be filling with percentages with the suffix “%”.
for example a user comes and he wants to write 12.5% ,so i want to displays the sign % once he starts to type so :
Before he starts to type, the cell displays null.
And when he starts to write “1” , the cell shows “1%”.
Then when he types “2” the cell shows “12%”.
And when he types “.” the cell shows “12.%”.
And when he types “5” the cell shows “12.5%”
I used afterChange and afterValidate to display the suffix % , but these events triggers once the user clicks enter, so i want it to display while the user is typing like in Excel when we fills percentages . i thought by using beforeKeyDown event but i couldn’t do it