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

Free Support Forum - aspose.com

Cell.GetDependents doesn't work with namerange

Hi. Please use the attachment with the code below to reproduce the issue.

Issue 1: when a cell’s forumla contains a name range, Cell.GetDependents doesn’t return the one with the name range.


var c = worksheet.Cells[“A1”];
var dependents = c.GetDependents(true);
foreach (var dependent in dependents)
Console.WriteLine( string.Format("{0} ---- {1} : {2}", dependent.Worksheet.Name, dependent.Name, dependent.Value));

Sheet1 ---- B1 : 10
Sheet1 ---- C1 : 20
Sheet1 ---- D1 : 30

Sheet1 ---- C1 : 20
Sheet1 ---- D1 : 30

I can find the issue as you have pointed out by your sample code with file. I think the GetDependents() method just skips dependents for the named ranges. We will check if we can support named ranges for it. I have logged a ticket with an id: CELLSNET-40350. We will look into it soon.

Thank you.


Please download and try this fix: Aspose.Cells for .NET v7.1.0.5

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.