get_precedents_in_calculation method
get_precedents_in_calculation
Gets all precedents(reference to cells in current workbook) used by this cell’s formula while calculating it.
Returns
Enumerator to enumerate all references(ReferredArea)
def get_precedents_in_calculation(self):
...
Remarks
This method can only work with the situation that FormulaSettings.enable_calculation_chain
is true for the workbook and the workbook has been fully calculated.
If this cell is not a formula or it does not reference to any other cells, null will be returned.
Example
from aspose.cells import Workbook
workbook = Workbook()
cells = workbook.worksheets[0].cells
cells.get("A2").formula = "=IF(TRUE,B2,B1)"
workbook.settings.formula_settings.enable_calculation_chain = True
workbook.calculate_formula()
en = cells.get("A2").get_precedents_in_calculation()
print("A2's calculation precedents:")
for r in en:
print(r)
See Also
- module
aspose.cells
- class
Cell