We have a business requirement to use Aspose to add macros to Excel files and send them to others for operations. Once the operations are completed, the files are returned to us, and we use Aspose to remove the macros.
Recently, we found that during the file format conversion process (XLSX → XLSM → XLSX), some special formatting and content in the files changed. Could you please let us know what specific steps might be causing this?
企业微信截图_17745828855355.png (275.5 KB)
Current Aspose.Cells version: 26.3.0
Attached are the test code and the original Excel file.
AsposeTestProject.zip (21.5 KB)
@lkf77081
Thank you for providing the sample project and the original Excel file. We have successfully reproduced the issue using the latest version of Aspose.Cells.
Our analysis confirmed that data integrity was compromised during the conversion from XLSX to XLSM and back to XLSX. Specifically, columns containing statistical calculations (such as ‘Nvidia’ and ‘S&P 500 index’) returned ’ #VALUE !’ errors, and the ‘End Date’ field displayed overflow characters.
It appears that the complex array formulas and LINEST functions used in your template failed to be properly recalculated or have their values preserved during these format conversions. We are investigating the root cause in the calculation engine to determine why these specific formulas are failing during macro removal.
We have opened the following new work order in our internal issue tracking system and will provide a fix in accordance with the terms mentioned in the Free Support Policies.
Issue ID: CELLSNET-60009
If you require priority support or can contact our Paid Support Management team directly, you can access Paid Support Services.
@lkf77081,
This is to inform you that your issue (Ticket ID: “CELLSNET-60009”) has been resolved. The fix/enhancement is scheduled to be included in the upcoming Aspose.Cells v26.4 release, anticipated in the first half of April 2026. We will notify you immediately once the new version becomes available.