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.
The only way to get a value from other handsontable instance isinstance_name.getDataAtCell() here is an example of Bootstrap tabs using this logic http://jsfiddle.net/x910e6zm/
We had considered that approach, but that would basically render “useless” the cool formulas feature. We were hoping to be able to combine inside a HoT formula both instances.
I’m assuming then, that there is no “clean” way to link two hot instances inside a HandsOnTable formula, right?