Incorrect type of PowerQueryFormula

Aspose.Cells Product Family
1

We have the following test file: PowerQueryTestConnections.xlsx.zip (20.1 KB)

This file contains 8 queries. Four of them are of type Formula, three of them are of type Parameter, and one of them of type Function. It appears that the type Function is not correctly detected by Aspose.Cells.

Here is the test code:

var workbook = new Workbook("PowerQueryTestConnections.xlsx");

var powerQueryFormula = workbook.DataMashup.PowerQueryFormulas["from_timestamp"];
Console.WriteLine(powerQueryFormula.Name);
Console.WriteLine(powerQueryFormula.Type); // expected: Function, current value: Formula

This screenshot demonstrates that in Excel the query is classified as Function: PowerQueryFormula function.png (12.3 KB)

Can you fix this invalid property? We’re using Aspose.Cells 24.11.0 for .NET.

2

@perfectxl,

Thanks for the template Excel file and screenshot.

After initial testing, I was able to reproduce the issue as you mentioned by using your template file and sample code segment. I found incorrect type of PowerQueryFormula when retrieving it.

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

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.

3

@perfectxl
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells for .NET 24.12) that we plan to release in the first half of December 2024. You will be notified when the next version is released.

4

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