RefreshDynamicArrayFormulas

Workbook.RefreshDynamicArrayFormulas method

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

public void RefreshDynamicArrayFormulas(bool calculate)
Parameter Type Description
calculate Boolean Whether calculates and update cell values for those dynamic array formulas when the spilled range changes.

See Also