Hello, I have a lot of Office Excel test files to query with Aspose.Cells, among other things, whether they contain a VbaProject. Interestingly, I have an xlsm file that only contains a Hello World message box, which already causes an error when loading. The xlsm test file can be opened normally in Excel and the VBA code with the small routine can also be opened. I cannot see what is causing the crash when trying to load it with Aspose.Cells. Attached is the test file. It would be desirable if such problems did not cause a crash, but instead feedback was given as to what prevented loading.
The error occurs with the programme line:
Workbook workbook = new Workbook(file)
So before I can use other Aspose.Cells functions to query things like has VbaProject.
After initial testing, I was able to reproduce the issue as you mentioned by using your template XLSM file. I found “System.NullReferenceException - Object reference not set to an instance of an object” when loading the XLSM file.
We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-57197
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issue (Ticket ID: “CELLSNET-57197”) has been resolved. The fix/enhancement will be incorporated in the forthcoming release (Aspose.Cells v24.12), scheduled for the first half of December 2024. You will be notified once the new version is published.