@a-pulvirenti_TSGC24 thanks, i have received the email with the zip, i am going to review this soon

@a-pulvirenti_TSGC24 it seems the zip was not uploaded correctly. can you try again?

you can also email me the zip at bjrmatos@gmail.com in case the upload does not work again.

hi @a-pulvirenti_TSGC24

I have an Excel report where I use a data table and in the header I put a placeholder which contains the call to a function which is defined in the helper of the report itself.
Up to version 4.10, that worked perfectly, sinche the function call returned a string, and that string appeared in the table header as expected.
Now I am using versione 4.13 and whenever I try to launch this report, it produces a corrupted file, which Excel has to repair before opening it, while if I try to run the report from the jsReport studio, it does not manage to produce a valid Excel file.

if you have a template that worked fine in 4.10 but broke in 4.13 please share the full template so we can fix it.

I have tried to act in the template by using xlsxReplace to replace the value on the fly before rendering, but this does not work. It does not work either if I try to put the value in the shared strings replacing the fixed string value I put in the Excel template.

was this part of the original template in 4.10? or is it a workaround for your template in 4.13?

if this is just a workaround for 4.13, lets focus on fixing the original template so you dont need this.

hi @andribo

sorry for not adding a reply, yes i am currently working on fixing this.

hi @andribo the changes are these, if you have a case where a previous template was working, please share all the details so we can fix the implementation or investigate the reason for the result.

@Genhan @fmmich

hmm we only call promisify on script functions with 3 parameters, does your beforeRender or afterRender functions in the script are defined with 3 parameters?

it seems you have async functions but for some reason the definition of them have 3 parameters, which is incorrect for modern jsreport scripts. you are hitting a legacy part of code that we maintain to support older version in which the beforeRender, afterRender functions were callback based.

the solution is to check the beforeRender, afterRender functions in your scripts and if you are using async function just make sure the function does not receive 3 parameters.

@Ish-Modi the usage is exactly as the code snippet in this thread.

<table>
<tr>
      <td>
        <img src="{{base64imageDataUri}}" />
      </td>
    </tr>
</table>

to generate the base64 data uri you can use assets

hi @sallystalone we are currently taking a look into xlsx related tasks, when it comes the time to review this case i will reply.

got it, FYI this is now fixed on master branch, it will be part of next release

I've even tested putting the formula =B2 in the cell A3 and that causes this issue, so perhaps that's the simplest form

do you mean this? for me, it works