RefersToRange is null from a NamedRange

[NLD]

I have a spreadsheet with a named ranges, but after getting the name of workbook, it's refersToRange is null.

IWorkbook workbook = application.Workbooks.Open(filePath);

var namedRange = workbook.Names["Nicolas"];

var range = namedRange.RefersToRange;

If I create a simple excel file, I can retrieve the RefersToRange value.

Moreover, many namedRange properties throw nullReferenceException.

--------

Version of XslIO.Base : 15.1400.0.41

Attachment: test_19f275ff.zip

[Abirami Varadharajan]

Hi Nicolas, 

  

We are able to reproduce the issue “Named Range’s RefersToRange returns null when it’s RefersToRange is Table Range”. A support incident to track the status of this issuehas been created under your account. Please log on to our support website to check for further updates.   

    

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents    

   

Please let us know if you have any concerns.  

  

Regards,  

Abirami.