Hi!
We are evaluating the possibilities of using HandsOnTable for an Excel-migration project (Angular 7+). The only issue we seem to be facing right now, is that some of the formulas in the files, would span across multiple HoT instances, and we don’t really know what’s the best approach to acheiving this.
So:
If the user modifies any of the required cells in Instance 1
or Instance 2
, the values should update (ideally, automatically).
- Is there any way we can achieve this?
- Interpolating a
GetDataAtCell()
inside the formula? - Using
variables
? - Re-loading every instance’s data every time a change is applied (sounds terribly inefficient…)?
- …?
PS: We would be using the Angular HoT wrapper, if that’s any help…
Apologies for the somewhat-abstract question, and thank you very much for the awesome work!