UpdateCalculations is used for doing calculations for cells that were changed through editing, not via programmatic changes.
For programmatic changes to cells, only recalc can be used, UpdateCalculations cannot be used as internally there are no cells marked as changed.