Active sheet index is incorrect

[Ngoc Hoang]

Hi team. 

The active sheet is in sheet A before I download it.  When I open that file after the download success, the active sheet is in Sheet B. Is this a problem when I set sheet state as hidden in sheet C?
Here is my code: https://stackblitz.com/edit/react-yu8m9t-fafdbu?file=index.js

[Babu Periyasamy]

Hi Ngoc Hoang,

We have checked your reported issue based on your shared details and sample. And we are able to replicate your reported issue in our end. So, we have confirmed the issue as "The activeSheet is incorrect while saving the Spreadsheet with hidden sheets" and logged a bug report and the fix will be available in our September 03, 2024, patch release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose: https://www.syncfusion.com/feedback/60625/the-activesheet-is-incorrect-while-saving-the-spreadsheet-with-hidden-sheets

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization”.

[Ngoc Hoang]

Hi, thank you for your hard work.

Has this bug been fixed yet?

[Babu Periyasamy]

Hi Ngoc Hoang,

 

Sorry for the inconvenience.

 

We are glad to announce that our weekly patch release (26.2.12) is rolled out. And we have included the fix for the reported "The activeSheet is incorrect while saving the Spreadsheet with hidden sheets" issue in this release. So, kindly upgrade your Nuget package version to the latest to avail of these changes (26.2.12).

 

Nuget package Link:  https://nuget.info/packages/Syncfusion.EJ2.Spreadsheet.AspNet.Core/26.2.12

 

Feedback Link:  https://www.syncfusion.com/feedback/60625/the-activesheet-is-incorrect-while-saving-the-spreadsheet-with-hidden-sheets

 

Rootcause:

 

While saving an Spreadsheet, we have set the active state of the Sheet before setting the hidden state of the Sheets present in the workbook in our server library. So, that the activeSheetIndex have been changed based on the number of hidden sheets.

 

Solution:

 

Now, we have set the active state of the Sheet in the workbook properly after processing all the Sheets in the workbook.

 

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