[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.IRange.GetDependents

GetDependents Method

GetDependents()

Gets the dependent ranges of the left top cell of the range.

Declaration
IReadOnlyList<IRange> GetDependents()
Function GetDependents() As IReadOnlyList(Of IRange)
Returns
Type Description
IReadOnlyList<IRange>

The dependent ranges.
Examples
worksheet.Range["A1"].Value = 10;
worksheet.Range["B1"].Formula = "=A1*2";
IReadOnlyList<IRange> dependents = worksheet.Range["A1"].GetDependents();

GetDependents(bool)

Gets the dependent ranges of all the cells of the range.

Declaration
IReadOnlyList<IRange> GetDependents(bool includeIndirect)
Function GetDependents(includeIndirect As Boolean) As IReadOnlyList(Of IRange)
Parameters
Type Name Description
bool includeIndirect

Include the indirect dependent cells.
Returns
Type Description
IReadOnlyList<IRange>

The dependent ranges.
Examples
worksheet.Range["A1"].Value = 10;
worksheet.Range["B1"].Formula = "=A1*2";
IReadOnlyList<IRange> dependents = worksheet.Range["A1"].GetDependents();