This works nicely when a user edits a row. When he comes out of edit mode the totals are recalculated properly.
Now comes the problem. We have a change values functionality which allows the user to setup a pattern for changing values, eg: decrease by 10 percent where amount > X. I cannot use .set(value) for setting the amount since the grid sometimes has 7 pages and calling that for many cells has a huge performance impact.
So how can I have all aggregates recalculated at the end of my function execution?
I'll mention that changes are batched and saved only when user presses the Save button.