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.

Decimal Separator in Percentage Cells

Thread ID:

Created:

Updated:

Platform:

Replies:

130595 May 19,2017 10:14 AM May 22,2017 04:45 AM JavaScript 2
loading
Tags: ejSpreadSheet
Bruno Figueiredo
Asked On May 19, 2017 10:14 AM

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

 $("#Spreadsheet").ejSpreadsheet({
        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 11:02 AM

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 04:45 AM

Hi Bruno, 
 
Thank you for contacting Syncfusion support. 
 
We have checked the reported issue with product version 15.1.0.37 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. 
 
Regards, 
Silambarasan 


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.

;