Workbook opens while in XLSX format. Doesn't open when converted to XLSB

[baxius]

Hello,

I have a workbook which is stored in .xlsx format. I want to turn it into the .xlsb format and still use it with Syncfusion.XlsIO.WinForms. I'm converting it by saving .xlsx file as .xlsb using Excel.

An exception is thrown at app.Workbook.Open:

inputFileName = "C:\\Users\\user\\Desktop\\Reagentai\\test.xlsb";

IWorkbook workbook = app.Workbooks.Open(inputFileName, ExcelOpenType.Automatic);

Syncfusion.XlsIO.WinForms version : 22.1.34 (with NuGet manager)

Microsoft Visual studio 2022 C# WinForm Application.

I have license for Essential Studio Enterprise Edition.

Stack trace, workbooks are in test.rar

Attachment: test_5b6f3ed0.rar

[MohamedyusufKhan AhamedMusthafa]

Hi Baxius,

 

We are able to reproduce the reported issue at our end and validating it currently. We will share the validation details on July 14th, 2023.

 

 

Regards,

Mohamed Yusuf Khan.

[MohamedyusufKhan AhamedMusthafa]

Hi Baxius,

 

We have confirmed the issue in which the ArgumentOutOfRange exception is thrown while parsing the cells style record in XLSB format and logged a defect report. We will include the fix for this issue in our upcoming weekly NuGet release scheduled for Aug 1, 2023.

 

You can track the status of the defect report through the following feedback link.

 

Track Status: https://www.syncfusion.com/feedback/45407/argumentoutofrange-exception-is-thrown-while-parsing-the-cells-style-record-in 

 

Regards,

Mohamed Yusuf Khan.

[MohamedyusufKhan AhamedMusthafa]

Hi Baxius,

Due to technical difficulties, we are unable to provide the fix for this issue in today's Weekly NuGet release. We will include the fix on our upcoming weekly NuGet scheduled on August 8th, 2023.

 

We appreciate your patience until then.

Regards,

Mohamed Yusuf Khan.

[MohamedyusufKhan AhamedMusthafa]

Hi Baxius,

 

While we try to resolve the issues, we found that the Excel document uses shared formulas that are not supported by XlsIO for .xlsb format. Currently, we are working on parsing the shared formulas from the Excel document. Due to this, we need some more time to implement this feature. So, we will include the issue fix in the weekly NuGet which will be rolled out on 22nd August, 2023.

 

Regards,

Mohamed

[Mohan Chandran]

Hi Baxius,

Due to complexities in the shared formula implementation, we could not include the fix for the issue. This issue fix will be included in the upcoming 2023 VOL 4 release which is planned to be rolled out at the end of December 2023.

Regards,

Mohan.