1. Home
  2. Forum
  3. Angular - EJ 2
  4. Cell has incorrect value than in the original MS Excel file after opening multiple files in certain order

Cell has incorrect value than in the original MS Excel file after opening multiple files in certain order

Hello,

I would like to report a bug where a specific cell has an incorrect value when the multiple MS Excel files are opened one after one in certain order. For example, if I just open FileB.xlsx in empty Spreadsheet component the bug doesn't occur, however when I open first FileA.xlsx and then FileB.xlsx, the cell (F13) has a totally different value which isn't present in the original file FileB.xlsx.

I have attached a screenshot and the ​two MS Excel files which I have described above for your convenience.

Also, we are using the Spreadsheet component v. 19.4.43 on front-end side and Syncfusion.EJ2.Spreadsheet.AspNet.Core v. 19.4.0.50 on our ASP.NET Core backend project.

Best Regards,

Ignacy Mielniczek


Attachment: Cell_has_incorrect_value_bug_3309a4d8.zip

4 Replies
SP Sangeetha Priya Murugan Syncfusion Team April 21, 2022 02:49 PM UTC

Hi Ignacy,


We have checked your reported issue and we have confirmed this as defect and the fix will be available in our May 4th, 2022, patch release, we appreciate your patience until then. You can track the status of this defect using below link from our feedback portal, 


Feedback Portal Link:  https://www.syncfusion.com/feedback/34355/to-clear-the-formula-dependencies-from-calculate-instance-while-importing-excel


Regards,

Sangeetha M


SP Sangeetha Priya Murugan Syncfusion Team May 6, 2022 09:19 AM UTC

Hi Ignacy,


We are glad to announce that our weekly patch release (20.1.52) is rolled out. And we have fixed your reported issue in this release. So, kindly upgrade your package versions to the latest to avail these changes (20.1.52). 


Package:  https://www.npmjs.com/package/@syncfusion/ej2-angular-spreadsheet/v/20.1.52 


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


Feedback Portal Link:  https://www.syncfusion.com/feedback/34355/to-clear-the-formula-dependencies-from-calculate-instance-while-importing-excel


Please let us know if you need further assistance on this. 


Regards,

Sangeetha M


IM Ignacy Mielniczek May 16, 2022 02:39 PM UTC

Hello Sangeetha,

Thank you very much for the update. I will check and let you know soon if the issue was resolved on our side.

Best Regards,

Ignacy Mielniczek


SP Sangeetha Priya Murugan Syncfusion Team May 17, 2022 12:00 PM UTC

Hi Ignacy,


Thanks for your update, take your time and we will wait to hear from you.


Regards,

Sangeetha M


Loader.
Up arrow icon