Workbook.RefreshDynamicArrayFormulas

RefreshDynamicArrayFormulas(bool)

Refreshes dynamic array formulas(spill into new range of neighboring cells according to current data) Other formulas in the workbook will not be calculated recursively even if they were used by dynamic array formulas.

public void RefreshDynamicArrayFormulas(bool calculate)
ParameterTypeDescription
calculateBooleanWhether calculates and updates cell values for those dynamic array formulas

See Also

RefreshDynamicArrayFormulas(bool, CalculationOptions)

Refreshes dynamic array formulas(spill into new range of neighboring cells according to current data)

public void RefreshDynamicArrayFormulas(bool calculate, CalculationOptions copts)
ParameterTypeDescription
calculateBooleanWhether calculates and updates cell values for those dynamic array formulas
coptsCalculationOptionsThe options for calculating formulas

Remarks

For performance consideration, we do not refresh all dynamic array formulas automatically when the formula itself or the data it references to changed. So user need to call this method manually after those operations which may influence dynamic array formulas, such as importing/setting cell values, inserting/deleting rows/columns/ranges, …etc. For most formulas with functions, calculating the spill range also needs to calculating the formula, so in general true value for “calculate” flag is preferred. If the formula is simple, such as a range reference or array(for example “=C1:E5”, “={1,2;3,4}”, …), simple function on a range or array(for example “=ABS(C1:E5)”, “=1+{1,2;3,4}”, …), and all formulas will be calculated later(such as by CalculateFormula), then using false vlaue for “calculate” flag may avoid the duplicated calculation for the benefit of performance.

See Also