@lukuser pptxImage works with the table but not in a natural way, which means that the image is not part of the table, it is a floating element (just like everything in pptx).
basically the data that gets passed to pptxImage helper comes from the root and not from the loop context generated from the table.
see this issue for more details about the problem, that issue combined with the fact that you are trying to make it work with pptxTable with dynamic columns (which is not supported yet) make the render to throw error.
hi @lukuser this is not possible in pptx, mostly because the pptx format seems to not support nested tables, each table is an independent floating element.
but the output you want does not necessarily need nested table, in theory if dynamic cells generation was supported in pptx (like in docx) you could create each cell, however the dynamic cells are not supported in pptx at the moment.
i have opened an issue to keep track of this, make sure to subscribe there for updates when this gets implemented
The problem in the original file was executing formulas
yes, this seems to be working after the fix i pushed the last time.
I tried to replicate the same issue but I am not able to perform B5=SUM(B2:B4). I have updated xlsx template. Please check.
i don't see more issues in the playground demo, i guess what you want now is to make the formulas in the Sheet1 to work, it is not throwing error now but i see the formula is defined but not producing the correct output in MS Excel (it just shows 0 as result). the reason for it to produce 0 is because you are not generating the cells with the correct number type, so when the formulas trying to do sum of cells it just find string, and when SUM is used with string it just returns 0.
you should fix the part of your xlsx transformation code to generate cells with the number type, if you have trouble with that, then just use the xlsx generation process which is designed to avoid getting into xml details about generating cells.
Is it possible to have multiple environment-specific jsreport.config.json?
jsreport only reads one configuration file, but you can have multiple of these files if you want and to use a specific one depending on your environment you can start jsreport with the --configFile=<path-to-your-file> cli argument or an env var configFile with the path
Hello @admin, Thank you for the suggestion. I tried your playground download example in both chrome and firefox. Both spin for a minute before stopping without downloading anything. In the end I used your suggestion and implemented my own download, by getting the report from blob to a File object. From there I uploaded to supabase storage.:
let blob = await report.toBlob();
let reportfile = await new File([blob], reportname + '.docx');
let reportURL = await FileManager.uploadFile(reportfile,"reports",reportname + '.docx');
@admin my mistake, i forgot to add the header i already have...I forgot to mention and add it, so I cannot use pdf utils in that way as im already using it. I updated my playground...is there another way? Or is it possible to add multiple headers (in a specific point and not at the absolute top position)?