NullReferenceException saving workbook to XLSB. Aspose.Cells 8.4.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

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.

Here you are.

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.

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.

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.

Tested Cells 8.4.2.


No NullReferenceException is thrown now.

Thanks,
Alex Shloma

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.