Hi Team/@amjad.sahi ,
I am trying to read the power query details from the attached excel file using latest version of NuGet package (wb.DataMashup.PowerQueryFormulas), which resulted into an exception “Aspose.Cells.CellsException: Invalid Power query formula definition.”
Bare PQ Function Error.zip (10.0 KB)
Please do the needful to fix this issue.
Thank you for providing the test file “Bare PQ Function Error.xlsx” and the code snippet to demonstrate this issue.
I have successfully reproduced the exception “Invalid Power query formula definition” on my end. Our investigation confirms that the error occurs specifically when the DataMashup.PowerQueryFormulas property attempts to process workbooks containing bare function definitions within the Power Query metadata.
We have logged this behavior as a bug for our development team to investigate further and implement a fix to handle these types of formula definitions correctly.
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-60137
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.