Wrong PowerQueryFormula.FormulaDefinition

Aspose.Cells Product Family
1

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!

2

@fzumstein,
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

3

@fzumstein,
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.

4

@fzumstein,

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)

5

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

6

@fzumstein,
You are welcome.

7

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. (NuGet Gallery | Aspose.Cells 20.9.0)