XLSX recipe very slow with multiple sheets and formulas
-
Hi, we have a xslx template with multiple sheets and lots of formulas on each. We are trying to use the xlsx recipe to add data,, but even turning off the calcs and just running the spreadsheet is taking over 10 mins.
{{#xlsxMerge "xl/workbook.xml" "workbook.calcPr[0]"}}
<calcPr calcMode="manual"/>
{{/xlsxMerge}}{{{xlsxPrint}}}
Is there a way to speed this up?
-
Hi,
we will need some workspace from you that we can test and try to optimize.
Can you provide it? In the playground or you can email it confidentially to us.
We don't need real data, just multiplied random values will be fine.Thank you
-
Hi, we have signed up for support and am creating the support request now