Hi @bjrmatos that worked, thank you

Hi, we are going to update our test and production servers to the latest version, however when I initialise the latest version "start" is not there.

(Also, I used to be able to post pictures when I made a post but it says that I don't have the privileges to do that anymore - here is the text)

Ok, so update:

The file is now working if i use this syntax:

{{#xlsxReplace "xl/styles.xml"}}
{#asset style.xml}
{{/xlsxReplace}}

Just removing the extra curly bracket at the end, the file now works locally, and on the test server.

However, virtually identical files with the extra curly bracket will also work.

It also does not explain why the same file was working locally but not on the test server

Regarding the typo...

This does seem to be a problem. I have one report that uses it and runs perfectly:

This one will run every time:

But this one will not:

Unless you remove that replace code:

But then the files need to be "repaired" because they are not styled properly and are not suitable for client use.

The exact syntax for that replace code I got from here:

https://stackoverflow.com/questions/60283656/jsreport-handlebars-engine-and-xlsx-recipe-how-to-fill-cell-with-color

I thought it was a typo but it turns out that the stackoverflow poster got it right, and this looks like the only way to replace a style file.

Hi Jan,

Yes, I have to include that typo - the style file will not apply unless it is types exactly like that - can you tell me how what the exact syntax should be?

The issue is that the exact same file will work on one environment but not the other - even with that typo, also, I can't send you the export for commercial reasons. But even if I did, you could get the same issue, that it will work locally but not when you upload it to another server.

Hi,

I have jsreport running locally - 3.10.0
My test server is also 3.10.0

My deployment method is to export a .zip from my local and then do a "Full" import to the test server.

I have been working on an xlsx file - on my local it will generate like it is supposed to:

But the exact same file, after an import will not work on the test server:

Your help would be appreciated

So it does, thanks for the confirmation

Hi,

I am attempting to add a col element to an xlsx sheet to define custom column widths.

This works:

The first two columns are wider.

What need to do it add these cols dynamically, from an object in the script colWidths that has two properties, the index and width I want to set the column to.

This does not work, and I assume that it has to do with the double quotes, but I can't wrap the {{values}} in double quotes as that does not work in handlebars.

Any ideas?

Regards,

Ari

Hi Jan,

I got part of the way.

Adding to the pdfMeta will fix how the title appears in the pdf viewer, and will change the title - any idea how to change the file name itself?

Just for context, is a script like this supposed to work?