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

Decimal Separator in Percentage Cells

Thread ID:





130595 May 19,2017 02:14 PM UTC May 22,2017 08:45 AM UTC JavaScript 2
Tags: ejSpreadSheet
Bruno Figueiredo
Asked On May 19, 2017 02:14 PM UTC

I am loading an excel file to my control like this:

        allowImport: true,
        importSettings: {
            importOnLoad: true,
            importMapper: "/api/JSXLExport/Import"
        //loadComplete: "loadComplete",
        cellClick: "cellClick",
        allowFormulaBar: true,
        showRibbon: false,
        enableContextMenu: false,
        locale: "pt-PT"

Note that the locale is setted to portuguese (where the decimal separator is comma)
and it works fine in numeric cells, but not in cells with percentage format.

Im sending a picture with the current behavior.

I want to know if this is a bug or something that I have missed.

Thank you,
Best regards

Attachment: percentage_b8a7ab78.zip

Bruno Figueiredo
Replied On May 19, 2017 03:02 PM UTC

Well it seems that the loaded excel file had an custom format in the percentage cells, so there it was the problem.

Silambarasan I [Syncfusion]
Replied On May 22, 2017 08:45 AM UTC

Hi Bruno, 
Thank you for contacting Syncfusion support. 
We have checked the reported issue with product version and we are unable to reproduce it in our end. Based on the provided code example, we have prepared a sample to demonstrate this and the same can be downloaded from the following sample link. In that, we have imported the file ‘TestFile.xlsx’(~/Files/) which contain applied percentage formatting in ‘pt-PT’ locale and its loaded properly with applied formats in Spreadsheet. Please find the below screenshot. 
Could you please check & replicate your issue in the above sample and send back to us with more information such as custom percentage formatting details or if possible please share dummy excel file to reproduce the issue so that we could able to sort out the cause of this issue and provide you a better solution quickly? The information provided would be great help for us to proceed further. 


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

or the page will be automatically redirected to 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