Display the decimal number provided as it is for numbers

Tags: #<Tag:0x00007f8b1dd575a0>
#1

What is the pattern to be used for the numeric data type to display the number as it is

For ex: i have provided data like 12.23223 , want to display same data.

columnDefinition.numericFormat = {

pattern: ???

};

i am using the above pattern which is working but is it correct?

Also the share the pattern examples documentation if we have any

#2

Hi @sasimarudhuri76

Suppose you do not want to format a cell in any other way than how it is defined. But you still want it to be a numeric cell type. Then you skip the format. As in this demo https://jsfiddle.net/vtfdnam4/.
As you can see, the only formatting we do is to change -.5 to -0.5. The formatting is not changed but still, if someone adds non-numeric characters cell is marked as invalid.

#3

Hi @aleksandra_budnik,

Thanks for your prompt response

I am using 1.18.1 version, where i unable to do the formatting. check the attachment for the same

image
image.png1911×900 87.8 KB

#4

We no longer have examples for version <1. But if you have an active support plan, please share your email to support@handsontable.com with the license ID, and I’ll find a person to provide you a working example.

#5

Yeah thanks @aleksandra_budnik, i mailed to the email. Can you please help me in this

#6

I’m closing this thread due to moving the conversation to the internal support system.

#7