Content in Imported excel sheet is not showing properly

[Manu]

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]

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. 

 

https://help.syncfusion.com/js/release-notes/v17.1.0.38?type=all#ejspreadsheet 

 

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