previewInExcelOnline at Azure app service

koccintosful

Hi,

I'd like to ask your help regarding the xlsx_previewInExcelOnline Azure app service what is deployed using the jsreport/jsreport:latest-full docker package.
I tried to set the jsreport just download the Excel file after rendering, not to send it to an office server. But even if I set the xlsx_previewInExcelOnline=false the jsreport still sends the excel to the server what is defined in the xlsx_publicUriForPreview parameter.

I set these parameters:
xlsx_previewInExcelOnline = false
xlsx_publicUriForPreview = http://mypublicSever
xlsx_numberOfParsedAddIterations = 50
xlsx_addBufferSize = 50000000

If I left the xlsx_publicUriForPreview empty, it used the original server uri.
Please give me advice how can I set the download option for preview.

Thanks in advance,

jan_blaha

I see, thank you. This is a bug we need to solve.
The problem is that the environment variable sends this field as string and we expect bool.

You can use this workaround at this moment.
Create jsreport script, mark it as global and add the following content:

function beforeRender(req, res, done) {
  req.options.preview = false
  done()
}

koccintosful

Thank you for the quick answer!