get_dependents_in_calculation method

get_dependents_in_calculation

Gets all cells whose calculated result depends on specific cell.

Returns

Enumerator to enumerate all dependents(Cell objects)

def get_dependents_in_calculation(self, row, column, recursive):
    ...
ParameterTypeDescription
rowintRow index of the specific cell
columnintColumn index of the specific cell.
recursiveboolWhether returns those dependents which do not reference to the specific cell directly
but reference to other leafs of that cell.

Remarks

To use this method, please make sure the workbook has been set with true value for FormulaSettings.enable_calculation_chain 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 Cell.get_dependents_in_calculation

See Also