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.
Unfortunately, activation email could not send to your email. Please try again.

Format Cell For percentage values

Thread ID:

Created:

Updated:

Platform:

Replies:

123443 Mar 17,2016 11:15 AM Mar 29,2016 05:59 AM JavaScript 3
loading
Tags: ejSpreadSheet
Tezcan Cirakoglu
Asked On March 17, 2016 11:15 AM

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 09:17 AM

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
Replied On March 28, 2016 08:11 AM

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

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

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


CONFIRMATION

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.

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.

;