Worksheets.GetNamedRanges causes NullReferenceException

Aspose.Cells Product Family
1

If i call GetNamedRanges(), the attached File causes a NullReferenceException inside Aspose Cells!
System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei ?..( , Cell )
bei ?..( , Cell )
bei ?..?( , Cell )
bei ?..?(Cell )
bei ?..??(Int32 , Int32 , Int32 , Int32 , Int32 , Boolean , Boolean , Boolean )
bei ?..?( , Worksheet , Cell , Int32 , Int32 , Int32 , Int32 )
bei ?..CalculateRange( , Worksheet , Cell , Int32 , Int32 , Int32 , Int32 , Boolean , Boolean )
bei ?..?( , Cell )
bei ?..?( , Cell )
bei ?..??( , Cell )
bei ?..( , Cell )
bei ?..?( , Cell )
bei ?..??( , Cell )
bei ?..?( , Cell )
bei ?..?( , Cell )
bei ?..( , Cell )
bei ?..?( , Cell )
bei Aspose.Cells.Name.GetCellArea(Int32 , Int32 , Boolean )
bei Aspose.Cells.Name.CreateRange()
bei Aspose.Cells.NameCollection.GetNamedRanges(WorksheetCollection )
bei Aspose.Cells.WorksheetCollection.GetNamedRanges()

This because the formula of the only Range DYAN.
The problem seems the used RANG-Formula in column M. =RANG(L4;L:L;1)
If i use a own Rang-Formula which calls the default RANG, then it works:

Function NowhowRang(wert As Double, bereich As Range, order As Integer)
NowhowRang = WorksheetFunction.Rank(wert, bereich, order)
End Function

Testing:
[Test]
public void TestIt() {
Aspose.Cells.Workbook wb = new Workbook(@“C:\tmp\asdf.xlsm”);
try {
wb.Worksheets.GetNamedRanges();
} catch (Exception ex) {
log.Error(ex);
}
}
Thank you for correcting this in next aspose-Release

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this exception using your code and sample file. We have logged this issue in our database. We will look into it and resolve it. Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41552.

3

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.2.4 and let us know your feedback.

4

The issues you have found earlier (filed as CELLSNET-41552) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.