XLSX template rendering problem.

[sallystalone]

Hello.
I have a jsreport template. I shared the link below. Here, jsreport takes a very long time in the xlsx section while rendering. I get either a timeout or socket hang up error when rendering both in the playground and in the v3.10.0 version, but when I switch to the v2.11.0 version, my xlsx template that I have already uploaded is rendered quickly. Also the config I use on the v3.10.0 side

jsreport playground link : https://playground.jsreport.net/w/anon/rlPbYIM~

jsreport.config.json
{
"allowLocalFilesAccess": true,
"reportTimeout": 4500000,
"chrome": {
"timeout": 4500000,
"launchOptions": {
"args": [
"--disable-dev-shm-usage"
]
}
},
"store": {
"provider": "fs"
},
"extensions": {
"fs-store": {
"dataDirectory": "data",
"syncModifications": true,
"sync": {
"usePolling": true
}
},
"express": {
"renderTimeout": 300000,
"inputRequestLimit": "550mb"
},
"xlsx": {
"numberOfParsedAddIterations": 500
}
},
"templatingEngines": {
"numberOfWorkers": 2,
"strategy": "in-process"
}
}

How can I render this template on v3.10.0 and playgorund side?
Do you have any suggestions for this?

[admin]

This runs for 2s on the latest jsreport 4.7.0. Are you able to update?

On 3.10.0 it runs for 57s for me. However, you have there many rows in the template that don't need to be there I guess. If you remove the rows from 5 to end, it runs for 2s.

[sallystalone]

I can't delete it because there are formulas in the rows. When I tried it in v3.10.0, the approximate rendering time is more than 5 minutes. Is there a special config you use to render in 50 seconds? I mentioned that I encountered the same situation when I tried it in the playground version. Is there an approach without upgrading the version or mostly the all versions have the same issue?

[admin]

I was just using config defaults..

I can't delete it because there are formulas in the rows.

How do you fill in the values? Using xlsxInsert, xlsxAdd, and other transformation helpers?
Maybe you can use them to create the formulas dynamically as well instead of prefilling empty worksheet?