How to reduce the initial loading time of a large number of HOT instances? All instances are linked with HyperFormula.

[hacker0000]

Hi friends, I have encountered a problem. I am using Handsontable 13.1.0 and need to load around 500-1000 sheets, but only one sheet is displayed at a time, similar to the Excel scenario. However, all sheets are linked with HyperFormula. On my Windows device, it takes about 10 seconds to load all the sheets. How can I optimize this?

<div class="table-wrap">
    <a-skeleton active :paragraph="{ rows: 4 }" :loading="workbookLoading">
        <template v-for="worksheet in workbookStore.worksheets" :key="worksheet.id">
            <HotTable
                  :worksheet="worksheet"
                  v-show="workbookStore.activeWorksheet?.code === worksheet.code"
                />
            </template>
    </a-skeleton>
</div>

const instance = new Handsontable(hotElement.value, {
    ...options,
    ...worksheet.value.conf,
  });
  hotStore.setInstance(worksheet.value.code, instance);

[hacker0000]

i tried to find some way banned first render action of handsontable, but seems no options can do
and i tried to new Handsontable(document.createElement('div'), {...}; and then switch to real container but still slow...
other ways like window.setTimeout(...) does not work well, either

[adrianszymanski89]

Hi @hacker0000

Thank you for contacting us. I can see that you reported the same issue on our forum, where my colleague already gave you the answer: https://forum.handsontable.com/t/how-to-reduce-the-initial-loading-time-of-a-large-number-of-hot-instances-all-instances-are-linked-with-hyperformula/7643 I will close this topic then to keep communication in one channel.

[hacker0000]

thanks for reply! @adrianszymanski89