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. Image for the cookie policy date

Content in Imported excel sheet is not showing properly

Hello Sir

I am facing a problem while importing excel file.
1.) The negative values are not proper. They are like (0.43-). It is showing  (-) after the value. 
2.)The value of the cells where formula is applied is not showing. It is showing '?Name# '.

My code snippet is :--
                   var  data =myUrl;
                        showRibbon: false,
                        allowFormulaBar: false,
                        allowSelection: false,
                        importSettings: {
                            importUrl: data,
                            importMapper: window.baseurl + "api/Spreadsheet/Import"

Please look in to it asap.

Thanks & Regards 
Manu Sharma

Attachment: Docs_de8c1b62.zip

1 Reply

VK Vinoth Kumar Sundara Moorthy Syncfusion Team September 11, 2019 05:55 AM

Hi Manu, 
Thank you for contacting Syncfusion support. 
We have checked your reported issue in the version ( and the file imported properly in our end without any error. Also, we would like to let you know that we have provided the custom format support for negative valued cell while importing in our ( version. Please refer the below release notes link. 
We recommend you use latest version for scripts in your project and ensure whether you have referred the same version for both assemblies and scripts. Could you please check the above details and get back to us with more details including Essential studio product version, if still issue persists? 
Vinoth Kumar S 

Live Chat Icon For mobile
Up arrow icon