User Story

As a developer, I want to batch calls to cell range.clearContents() and range.setValue().
For example, I may have a set of cells which needs to be cleared to reset my spreadsheet between operation.
If each of the target cells has a large number of the same dependants which lookup takes significant processing time, calling clearContents() on each cell causes the same dependants to be looked up repeatedly, leading to long transaction times.

Acceptance Criteria

be able to set autoRefresh false on all of the cells being cleared or value updated, perform all clear operations as a batch, set autoRefresh to true and use range.notifyChange() to trigger the recalculation of descendants once at the end of the batch.

Details

allowed for other type of cell updates, so would be useful for cell clearing or setting value.