NullReferenceException saving workbook to XLSB. Aspose.Cells 8.4.1

Aspose.Cells Product Family
1

Scenario: Aspose.Cells 8.4.1. I open XLSB file; convert it to the XLSM; do some work and convert file back to XLSB.


Issue: NullReferenceException is thrown during backward conversion.

var wbx = new Workbook(@“lmd3B30.xlsb”);
wbx.Save(@“lmd3B30.xlsb.xlsm”, SaveFormat.Xlsm);

wbx = new Workbook(@“lmd3B30.xlsb.xlsm”);
wbx.Save(@“lmd3B30.xlsb.xlsm.xlsb”, SaveFormat.Xlsb);

Thanks,
Alex Shloma

2

Hi,


Thanks for providing us some details and sample code.

Could you provide us the template XLSB file here, we will check your issue soon.

Thank you.
3

Here you are.

4

Hi,


Thanks for the template file.

After an initial test, I observed the issue as you mentioned. I found the following exception when I re-save to XLSB file format back (XLSB --> XLSM --> XLSB):
“Object reference not set to an instance of an object”.
I am using the following sample code with your template file:
e.g
Sample code:

var wbx = new Workbook(@“e:\test2\lmd3B30.xlsb”);
wbx.Save(@“e:\test2\lmd3B30.xlsb.xlsm”, SaveFormat.Xlsm);

wbx = new Workbook(@“e:\test2\lmd3B30.xlsb.xlsm”);
wbx.Save(@“e:\test2\outlmd3B30.xlsb.xlsm.xlsb”, SaveFormat.Xlsb);//Exception

I have logged a ticket with an id “CELLSNET-43564” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.
5

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.4.1.1 and let us know your feedback.

6

The issues you have found earlier (filed as CELLSNET-43564) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
7

Tested Cells 8.4.2.


No NullReferenceException is thrown now.

Thanks,
Alex Shloma
8

Hi Alex,


Its good to know that you are up & running again. Please feel free to contact us back in case you need our further assistance with Aspose APIs.