We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Saving an xlsb as xlsm creates corrupted file

Aspose.Cells Product Family
#1

Dear Aspose team,

We have an xlsb file that we try to save as xlsm, but it gets corrupted.
We use the following code and save options:

OoxmlSaveOptions saveOptions = new OoxmlSaveOptions(SaveFormat.Xlsm);
saveOptions.ExportCellName = true;
Workbook doc = new Workbook(inputFilePath);
doc.Save(outputFilePath, saveOptions);

After that opening the xlsm file in Excel, it needs a repair.
Also if we try to open that workbook in code, we get the following exception:
“Aspose.Cells.CellsException: 'Error in Cell: C1-Invalid formula:”“Just “TODAY()&(,‘Project Info’!B17&” day(s) left!”)".’"

I am attaching the sample file. test.zip (37.2 KB)

Please let us know if we can provide any more details to help you fix the issue.

Best regards,

Daniel Lengyel
32382

#2

@gergelyv

Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will update you asap.

This issue has been logged as

  • CELLSNET-46104 - Saving Xlsb to Xlsm creates corrupt Excel file

Screenshot of Error:

#3

@gergelyv,

This is to inform you that we have fixed your issue “CELLSNET-46104” now. We will soon provide the fix after performing QA and including other enhancements and fixes.

#4

@gergelyv

Thanks for using Aspose APIs.

Please download and try the following fix for your issue CELLSNET-46104 and let us know your feedback.

#5

The issues you have found earlier (filed as CELLSNET-46104) have been fixed in this update. Please also check the document/article for your reference: https://docs.aspose.com/display/cellsnet/Installation