refresh_dynamic_array_formula property

refresh_dynamic_array_formula property

Indicates whether dynamic array formulas should be refreshed before calculating formulas.

Remarks

If this property has been specified explicitly, then the specified value will be used to determine whether refresh dynamic array formulas. Otherwise(CalculationOptions.user_specified_refresh_dynamic_array_formula is flase), the default value of it depends on what kind of formulas need to be calculated: For calculating formulas for the workbook, such as Workbook.calculate_formula, this property will be taken as true. For other cases, such as Cell.calculate or Worksheet.calculate_formula, this property will be taken as false.

Definition:

@property
def refresh_dynamic_array_formula(self):
    ...
@refresh_dynamic_array_formula.setter
def refresh_dynamic_array_formula(self, value):
    ...

See Also

recursive property user_specified_refresh_dynamic_array_formula property