Cells.GetDependentsInCalculation

Cells.GetDependentsInCalculation method

Gets all cells whose calculated result depends on specific cell.

public IEnumerator GetDependentsInCalculation(int row, int column, bool recursive)
ParameterTypeDescription
rowInt32Row index of the specific cell
columnInt32Column index of the specific cell.
recursiveBooleanWhether returns those dependents which do not reference to the specific cell directly but reference to other leafs of that cell.

Return Value

Enumerator to enumerate all dependents(Cell objects)

Remarks

To use this method, please make sure the workbook has been set with true value for EnableCalculationChain and has been fully calculated with this setting. If there is no formula reference to this cell, null will be returned. For more details and example, please see GetDependentsInCalculation

See Also