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

# Worksheets.GetNamedRanges causes NullReferenceException

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

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.

Hi,

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

We have fixed the issue.