We have multiple tables, they can be rendered in different order. Now we have encountered a problem (Handsontable is a JavaScript data grid that looks and feels like a spreadsheet - Available for React, Angular, and Vue) with such an arrangement of tables, the first table has an error #REF! Is there any way to fix this without usingEffect solution?
Hi @mbdoy213
You are setting a reference for the main sheet Sheet1 within Sheet2 before the Sheet1 is created. That is why you get the error. You will need to set up the reference once the Sheet1 is created.