CalculationOptions.RefreshDynamicArrayFormula

CalculationOptions.RefreshDynamicArrayFormula property

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

public bool RefreshDynamicArrayFormula { get; set; }

Remarks

If this property has been specified explicitly, then the specified value will be used to determine whether refresh dynamic array formulas. Otherwise(UserSpecifiedRefreshDynamicArrayFormula 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 CalculateFormula, this property will be taken as true. For other cases, such as Calculate or CalculateFormula, this property will be taken as false.

See Also