Dear Canvas specialists,
is there any approach or workaround to prevent updating of ActiveForm once a users changed a DBR cell and leaves the input field? We have a bigger active form that takes a while to recalculate, so for users it’s quite annoying to wait each time 2-5 sec for the form to rebuild after changing just one entry, before the user can go to the next cell.
Users would prefer to have a button for turning off rebuild/recalculation of ActiveForm after changing the value, until they are done with their changes. After being done, they would recalculate the form again. In fact, the most annoying behaviour here is that the ActiveForm rebuilds completely after leaving a cell, it is not just recalculating the DBRs, but disappears for a moment and then comes back with new data, which destroys a smooth navigation from cell to cell in case of any data change.
I have seen nothing obvious on how to achieve this, but any workaround very welcome. A typical “it doesn’t work like Excel” situation
It should work like this: updated values could be sent to the cube after leaving the cell, but the form should not refresh. Or somehow all updates are sent together when enabling recalculation again. Do you think I could apply a unique refresh-group attribute to each cell to achieve this? Of course, via button a user would then need to trigger $tm1Ui.dataRefresh().
Thanks in advance,