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

GrapeCity.Documents.Excel.IRange.GetPrecedents

GetPrecedents Method

GetPrecedents()

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

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

The precedent ranges.
Examples
worksheet.Range["A1"].Value = 10;
worksheet.Range["B1"].Formula = "=A1*2";
List<IRange> precedents = worksheet.Range["B1"].GetPrecedents();

GetPrecedents(bool)

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

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

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

The precedent ranges.
Examples
worksheet.Range["A1"].Value = 10;
worksheet.Range["B1"].Formula = "=A1*2";
List<IRange> precedents = worksheet.Range["B1"].GetPrecedents();