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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

Content in Imported excel sheet is not showing properly

Thread ID:

Created:

Updated:

Platform:

Replies:

147426 Sep 10,2019 10:45 AM UTC Sep 11,2019 10:55 AM UTC jQuery 1
loading
Tags: ejSpreadSheet
Manu
Asked On September 10, 2019 10:45 AM UTC

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;
                    $("#Spreadsheet").ejSpreadsheet({
                        showRibbon: false,
                        allowFormulaBar: false,
                        enableContextMenu: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

Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On September 11, 2019 10:55 AM UTC

Hi Manu, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported issue in the version (17.2.0.34) 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 (17.1.0.38) 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? 
 
Regards, 
Vinoth Kumar S 


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.

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

Live Chat Icon For mobile
Live Chat Icon