We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Wrong PowerQueryFormula.FormulaDefinition

This is a follow-up to PowerQueryFormula.FormulaDefinition shows spurious let as we still experience issues with Aspose.Cell 20.8.0. The attached Excel file has 3 queries, one of them is read correctly (Extract PojectM), 1 is adding an “;” at the end (DataMashup) and one returns empty (UnzipContents).

The code we use to read the power queries is:

private void SerializePowerQueryFormulas(IEnumerable<Aspose.Cells.QueryTables.PowerQueryFormula> powerQueryFormulas)
    foreach (var powerQueryFormula in powerQueryFormulas)
        var contents = powerQueryFormula.FormulaDefinition.Replace("\r\n", "\n");
        var loc = contents.Split('\n').Count();

ExtractCode.zip (17.4 KB)

Thanks for looking into this!

This issue is observed here and logged in our database for further investigation. We will notify you once any update is ready for sharing.

This issue is logged as:
CELLSNET-47552 - Wrong PowerQueryFormula.FormulaDefinition

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47552”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v20.8.1 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.8.1 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.8.1 For .Net4.0.Zip (5.4 MB)

This looks good now, thanks so much for the quick fix!

You are welcome.

The issues you have found earlier (filed as CELLSNET-47552) have been fixed in Aspose.Cells for .NET v20.9. This message was posted using Bugs notification tool by Amjad_Sahi
You may also get the new version @ nuget repos. (https://www.nuget.org/packages/Aspose.Cells/20.9.0)