We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Format Cell For percentage values

Thread ID:





123443 Mar 17,2016 03:15 PM UTC Mar 29,2016 09:59 AM UTC JavaScript 3
Tags: ejSpreadSheet
Tezcan Cirakoglu
Asked On March 17, 2016 03:15 PM UTC

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 [Syncfusion]
Replied On March 18, 2016 01:17 PM UTC

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.



Mohankumar R.

Tezcan Cirakoglu
Replied On March 28, 2016 12:11 PM UTC

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

Mohan Kumar Ramasamy [Syncfusion]
Replied On March 29, 2016 09:59 AM UTC

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.


Mohankumar R


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon