After upgrade to 20.7 PowerQueries cannot be processed

Aspose.Cells Product Family
1

Hi Aspose team,

after upgrading to Aspose.Cells 20.7 we cannot process PowerQueries.
When we run line:

Aspose.Cells.QueryTables.DataMashup mashupData = workbook.DataMashup;

we are getting following error:

Unhandled Exception: Aspose.Cells.CellsException: Invalid pPower query formula definition.
at .(Byte[] )
at .()
at .()
at Aspose.Cells.Workbook.get_DataMashup()
at Aspose_Excel.ExcelTest.ReadMash() in C:_Projects\Bugs\Aspose\0\Aspose.Bugs\Excel.cs:line 273
at ReplaceTextInSinglePageOfPDF.Program.Main(String[] args) in C:_Projects\Bugs\Aspose\0\Aspose.Bugs\Program.cs:line 58

Project is attached:

Excel.PowerQuery.zip (754.6 KB)

Thanks for help,
Oliver

2

@dr.doc,
This issue is already reported and logged in our database for investigation and fix. You will be notified here once any update is ready to share.

This issue is logged as:
CELLSNET-47494 - Exception "Invalid pPower query formula definition" when retrieving mashup data from the workbook

3

@dr.doc,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@dr.doc,

Please try our latest version/fix: Aspose.Cells for .NET v20.7.2 (attached)
Aspose.Cells20.7.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.2 For .Net4.0.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

Problem fixed. Thx.

6

@dr.doc,

Good to know that your issue is sorted out by the new fix/version. Feel free to write us back if you have further comments or questions, we will be happy to assist you soon.

7

The issues you have found earlier (filed as CELLSNET-47494) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi