Invalid PowerQuery formula definition

We have the following sample file: PowerQuery3.xlsx.zip (44.8 KB)

This file contains one query. Now we have the following test code:

var workbook = new Workbook("PowerQuery3.xlsx");
var queries = workbook.DataMashup.PowerQueryFormulas;

This results in an Aspose.Cells.CellsException: ‘Invalid Power query formula definition.’

We are using Aspose.Cells 25.1.2 for .NET. Can you investigate and resolve this error?

@perfectxl,

Thanks for the template Excel file.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file. I found an exception “Invalid Power query formula definition” while retrieving PowerQuery from the workbook.

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

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.

@perfectxl,

This is to inform you that your issue(Ticket ID: “CELLSNET-57740”) has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v25.2) that we plan to release in the first half of February 2025. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSNET-57740) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi