I know this is a nit-pick request, but it's a pain that i have to resize my areas in the Studio every time i reload the page. Do you think it would be possible to store the div sizes in a cookie or something and then when we go back to the page we don't have to resize each panel to where we prefer it? When you have lots of folders on the left and the folder names are long, it's just a bit annoying.
Just a suggestion.
Thanks
You solved my issue!!!
The reason I thought it was odd was because I actually had the wrong syntax
In my example i was doing {{#xlsxAdd "xl/drawings/drawing1.xml" "xdr:wsDr.twoCellAnchor"}}
In your example you did {{#xlsxAdd "xl/drawings/drawing1.xml" "xdr:wsDr.xdr:twoCellAnchor"}}
I completely missed the 2nd namespace which is what caused things to not work at all. This is why things looked odd to me but I couldn't figure out why.
As always...thanks for everything! It's a great product!
You should consider bankers rounding.
https://stackoverflow.com/questions/3108986/gaussian-bankers-rounding-in-javascript
I have a scenario where i want to reuse an image within my Excel spreadsheet. In the sheet I have an image (red/yellow/green circle for status). Rather than use xlsxAddImage which will create a copy of the image X number of times, I have created an Excel Template that has the image in there once and then I am using the twoCellAnchor concept and referencing the same image by rID#. This works fine when working with OpenXML and verifying everything in the Office productivity tool. However, since this is in a different namespace than the original x: used in Row, it seems that the xlsxAdd has a big issue here. Not sure why, but it's not working. here's what I am seeing.
First, I would normally thing i would reference it by doing {{#xlsxAdd "xl/drawings/drawing1.xml" "wsDr.twoCellAnchor"}}, but instead I have to do {{#xlsxAdd "xl/drawings/drawing1.xml" "xdr:wsDr.twoCellAnchor"}} otherwise it creates another XML node without the namespace. This is not an issue, but is slightly odd.
Second (and the real issue) is that my content should be something like
<xdr:twoCellAnchor editAs="oneCell" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing">
...
</xdr:twoCellAnchor>
However, the result in the file generated strips out the xdr: from the node. This is causing Excel to not render anything (as well as the productivity tool not knowing what type of node it is). I have also tried
<xdr:twoCellAnchor editAs="oneCell">
and that didn't help anything.
Any help I can get on handling the namespace appropriately would be appreciated.
I have about 300 reports that I am converting from SSRS to JSReport. In the Excel rendering, many of the reports reuse the same functionality with xslxReplace or Merge to do the same thing per report (such as build a header or create a footer or add Properties in Excel). I was hoping there would be a way i could put these reusable xslxReplace or merge pieces in a component or childtemplate in case i need to change it in the future. Then i could update that functionality in 1 place and not have to change the copy/paste in each Excel portion.
Is there a way to do this? I have tried with Component and ChildTemplate and can't seem to do it anywhere. A super simple reused piece would be setting the SheetName to a value in the data.
{{!-- Adding the name to sheet1 of the workbook --}}
{{#xlsxMerge "xl/workbook.xml" "workbook.sheets[0].sheet[0]"}}
<sheet name="{{sheetName}}"/>
{{/xlsxMerge}}
https://github.com/jsreport/jsreport/search?q=dockerfile
this is how I got a lot of links too
Every link i can find to your dockerfile, including the DEPRECATED link in https://github.com/jsreport/docker all point to a 404. Where is the latest dockerfile for v3?
This issue is resolved. AWS must have changed their rules on the XSS validation because their WAF was the cause of the problem. I added an exclusion for odata within our XSS rules and now it's working fine. Thanks for the info on the intervals changes. We will update that as well.
well crap...that didn't actually fix it. It stopped the files from creating new versions every time, but it's still getting a 403 when we use the word "style" anywhere.
Still interested in finding out why it's saving the file every 15 seconds. I will continue looking in to the style issue