Hi,
Here is a stripped down template as you suggested.
https://playground.jsreport.net/w/steraji/zpfH_uwE
I ran the template, downloaded the xlsx, examined sheet1.xml and confirmed that the ActiveX control is now gone.
Hi,
Here is a stripped down template as you suggested.
https://playground.jsreport.net/w/steraji/zpfH_uwE
I ran the template, downloaded the xlsx, examined sheet1.xml and confirmed that the ActiveX control is now gone.
D'oh! I'm such a newbie :P
Thank you :)
Hi,
I'm using an xlsx template that has an ActiveX control, and I'm finding that it disappears when I run a report with the file.
Are ActiveX controls not supported or is there a workaround for this issue?
I'm having a curious problem using the s attribute. If I use a style on a cell that doesn't already use that style in my template, no problems - it works as expected. But if I use the style on a cell that already had that style in the template, that cell appears to lose the style.
I've uploaded an example here https://playground.jsreport.net/w/steraji/zpfH_uwE
where I set cells A1-F1 to a value with style 26 (yellow background). In the template, F1 is the only cell in that range that already had style 26 applied to it, and it's the only one that isn't yellow. I downloaded & unzipped the file and found that A1-F1 all had the style.
I'm using an xlsx template with cells formatted with background colors and border styles. When I run this code, it clears out the formatting. How can I preserve the formatting from the xlsx template?
{{#xlsxReplace "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[0].c[6]"}}
<c t="inlineStr"><is><t>{{PRJ_NAME}}</t></is></c>
{{/xlsxReplace}}