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