Format Cell For percentage values

[Tezcan Cirakoglu]

Hi there,

How can we format any cell to display percentage values via code? 

I mean

When i update cell value as 23, it will display %23

Thanks for further help 

[Mohan Kumar Ramasamy]

Hi Tezcan,

Thank you for using Syncfusion products.

Query 1: “How can we format any cell to display percentage values via code?”

We have prepared a sample using “format” method and please refer to the below code example,

Sample: http://jsplayground.syncfusion.com/rvm2vwrh

Documentation link: http://help.syncfusion.com/js/api/ejspreadsheet#methods:xlformat-format

Code example:

function loadComplete() {

      this.XLFormat.format({ "type": "percentage" }, "D2:D7"); 

//arg1 - Object -To pass the which type format

//arg2- string – To pass the range.

}

Query 2: “When i update cell value as 23, it will display %23”

We considered this “Custom format support for cells with string” as an issue and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents

Regards,

Mohankumar R.

[Tezcan Cirakoglu]

Thanks alot, first query solved my issue, localisation would be solved after than i hope :)

[Mohan Kumar Ramasamy]

Hi Tezcan,

We are happy that the issue has been solved at your end. Please get back to us if you have any other query.

Regards,

Mohankumar R