1. Home
  2. Forum
  3. Angular - EJ 2
  4. Issue with formatted excel file.

Issue with formatted excel file.

Hello,

I have issue with spreadsheet component. When I try to open excel file which has some formatted cells I get an error:

Also sometimes when I open spreadsheet component it loads endlessly. Can you help me with that?

Kind regards
Damian Szwajkos


13 Replies
TS Thaneegairaj Sankar Syncfusion Team December 21, 2021 10:32 AM UTC

Hi Damian,


Thanks for the patience.


We have checked your reported issue and Spreadsheet loads endlessly while importing an formatted excel file. We have logged this as a bug report and this fix will be available on 12th January 2022.We appreciate your patience until then. You can also track the status of this issue fix by using our feedback portal link.


Feedback Link: https://www.syncfusion.com/feedback/31360/spreadsheet-loads-endlessly-while-importing-an-formatted-excel-file


Regards,

Thaneegairaj S


TS Thaneegairaj Sankar Syncfusion Team January 12, 2022 10:06 AM UTC

Hi Damian,


We are glad to announce that our weekly patch release (19.4.42) is rolled out. We have included the fix for your issue in this release. So, we suggest you upgrade our Syncfusion packages to our latest version to resolve this issue in your end. (19.4.42).

Release Notes: https://ej2.syncfusion.com/angular/documentation/release-notes/19.4.42/?type=all#spreadsheet


Feedback Link: https://www.syncfusion.com/feedback/31360/spreadsheet-loads-endlessly-while-importing-an-formatted-excel-file


Please let us know, if you need further assistance.


Regards,
Thaneegairaj S


DS Damian Szwajkos January 18, 2022 01:01 PM UTC

Hello, 

I have updated spreadsheet to latest version and issue with formatted file is resolved however still I have issue that sometimes Spreadsheet loads endlessly files. There is also error in console which occurs from time to time: 

Kind regards
Damian Szwajkos


TS Thaneegairaj Sankar Syncfusion Team January 19, 2022 05:13 PM UTC

Hi Damian, 
 
We are unable to reproduce the script error in our end. For your reference we have created a video demonstration, please find the below link. 
 
 
Before proceeding further, we would like to know the following details to replicate the issue in our end. 
 
·         If possible, please share the issue reproducible sample or please share us the dummy issue replicable excel file. 
·         Please share us the video demonstration of this issue. 
 
Please provide the above requested information, based on that we will check and provide you a better solution quickly. 
 
Regards, 
Thaneegairaj S 


DS Damian Szwajkos February 3, 2022 07:56 AM UTC

Hello,


Still I have issue that Spreadsheet loads endlessly files. Moreover I have issue with offsetting the lines with the numbering data in the sheet like in screenshot below:


Kind regards

Damian Szwajkos


TS Thaneegairaj Sankar Syncfusion Team February 8, 2022 04:10 AM UTC

Hi Damian, 
 
We are unable to replicate the issue with importing the excel file in spreadsheet. Before we proceed further, please share the below details. 
 
·         If possible, please share the issue reproducible sample or please share us the dummy issue replicable excel file. 
·         Please share us the video demonstration of this issue. 
 
Please provide the above requested information, based on that we will check and provide you a better solution quickly. 
 
Regards, 
Thaneegairaj S 


DS Damian Szwajkos February 10, 2022 08:45 AM UTC

Hello, 

I have latest version 19.4.50 of Syncfusion components but issue with not properly aligned row numbering with rows is still there.

In the attachments you can find file which I have used for testing and simple GIF to demonstrate the issue.

Kind regards
Damian Szwajkos


Attachment: Rows_issue_ca1acc17.zip

AS Aravinthan Seetharaman Syncfusion Team February 14, 2022 04:36 AM UTC

Hi Damian, 
 
We have checked your query in the mentioned version 19.4.0.50 with 100% and 150% system resolution and we are not facing row alignment issue in our end. For your reference we have prepared video demo here. 
 
 
 
And, we suspect that this issue due to your code customization, so please share the below details to provide resolution quickly. 
 
·         Please replicate the issue in the above sample or share the issue replicate sample. 
·         Please share your Spreadsheet code customization 
·         Please share your browser details, and also check this issue after clear the browser cache. 
·         Please share the System resolution & OS details. 
 
Please provide the above requested information, based on that we will check and provide you a better solution quickly.  
  
Regards, 
Aravinthan S 


DS Damian Szwajkos March 1, 2022 06:20 PM UTC

Hello, 

Thank you for reply. I will check code customization and in case any issue I will let you know. 
Despite this issue I would like to let you know that I tried to open file from attachment at your documentation site without success. All I had was white space inside component and below error in console:

Link to documentation site which I used: https://ej2.syncfusion.com/angular/demos/?_gl=1*s1j0x2*_ga*MTUzMzE2MjgzLjE2NDU4MDA1Mzg.*_ga_WC4JKKPHH0*MTY0NTgwMDUzNi4xLjEuMTY0NTgwMDkzMC4w&_ga=2.39006880.2035587992.1645800539-153316283.1645800538#/material/spreadsheet/default


Furthermore I would like to ask a few questions:

1. What mathematical formulas are possible to use in the excel component ?
2. Is there currently any work on extending the available formulas in this component? We are especially interested in the formula for calculating the standard deviation
3. Where I can download a set of documentation for individual formulas that can be selected in a component. We are especially interested in mathematical equations that are performed in specific formulas


Kind regards
Damian Szwajkos


Attachment: Spreadsheet_issue_23924b50.zip

DS Damian Szwajkos March 4, 2022 09:00 PM UTC

Hello,
I have question directly about formulas at SpreadSheet component.

  1. If there is any chance for imported data (i.e. numbers) from file to component to keep commas (",") instead of dots (".")? - Commas should be kept after import.  As example you can use file from the attachments.
  2. Does the SpreadSheet component have  formula for calculating the standard deviation and T-Tests formula?

Kind regards
Damian Szwajkos

Attachment: layoutt_130b646a.zip

GK Gayathri KarunaiAnandam Syncfusion Team March 10, 2022 02:46 PM UTC

Hi Damian, 

Query 1: white space inside component and below error in console 

Currently, we don’t have support to import custom date formats with ;@. However, we have logged this as an improvement, and it will be available in any of our upcoming releases. You can track the status of this improvement using the below link from our feedback portal. 


As of now, we will fix the console error and the fix will be available in our upcoming patch release which is scheduled for March 30th,2022. 


Query 2: What mathematical formulas are possible to use in the excel component? 

Please find the below link which shows the list of supported formulas. 


Query 3: We are especially interested in the formula for calculating the standard deviation, 
Query 4: Does the SpreadSheet component have formula for calculating the T-Tests formula? 

Currently, we don’t have support for Standard deviation and T formula. However, we have logged this as an improvement, and it will be available in any of our upcoming releases. You can track the status of this improvement using below link from our feedback portal. 



Regards, 
Gayathri K 
 


DS Damian Szwajkos April 8, 2022 12:40 PM UTC

Hello, 

What is the best excel file format to import into spreadsheet? The point here is to avoid issues like this below with more complex files.



Kind regards
Damian Szwajkos


GK Gayathri KarunaiAnandam Syncfusion Team April 11, 2022 07:01 AM UTC

Hi Damian,


We have supported the below formats in spreadsheet. Please check the below documentation link.


https://ej2.syncfusion.com/angular/documentation/spreadsheet/open-save/#supported-file-formats


Could you please share the below details,


  • Share excel file which caused the issue.
  • Share the excel file version.
  • Share how you open the excel file (either excel file or JSON data).
  • Share the Essential studio version you are using.


This will be helpful for us to validate further.


Regards,

Gayathri K


Loader.
Up arrow icon