Cell.GetDependents doesn't work with namerange

Aspose.Cells Product Family
1

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.

Example:

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));
}

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

Actual:
Sheet1 ---- C1 : 20
Sheet1 ---- D1 : 30
2
Hi,

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.
3

Hi,

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

4

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.