In the UI you can update only half of the range with no problem - it’s an automation issue.
For that matter it would be useful to have a Null constant in Formulas, so we can actually set something to null/empty. Anything that can be done in the UI should also be able to be done by Automation.