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

Free Support Forum - aspose.com

Saving an xlsb as xlsm creates corrupted file

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

@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:

@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.

@gergelyv

Thanks for using Aspose APIs.

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

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