We updated to 4.0 and we are getting weird behavior with checkboxes when trying to export. We have lots of folders and on average about 6 files per folder. When I right click on a folder in Studio and click Export Folder, it brings up a dialog with the folder and all files selected. If i try to change checkboxes, it selects different files. This is making the export difficult to select what we want and move those files over to our production setup

You can see this behavior here:

https://www.flexclip.com/share/38848218a5d023d4e961062aa32c703c6c4b3e3.html

I was wondering if you guys have done anything with the Office Online Server to be able to have a private server for office preview. I know you have configuration on where to store the files (on our server vs. yours), but what about being able to change the actual previewing server from MS's public server to using Office Online Server which is free if you want to be able to have it in read-only mode. I am looking at trying to set up a proof of concept server to be able to preview documents internally on our servers for a secured site and I would love the ability to be able to offer the same through JSReport templates that we have already setup.

Thanks,
Justin

For our stuff, it was because the SUM() formula that was in our template file referenced a cell that was below it. We actually didn't modify anything via code in the xlsx recipe and just put in the xslxPrint command and it threw that error, so it's validating things that aren't even touching. Excel had no problem with the forumla using a cell below what was being summed, but JSReport did. So we had to rip out the formula and manually calculate it ourself and then put the Replace command in there to write the value instead of the formula

as an FYI, we ran in to the same issue and had to code around it. It seems more checking was added to make sure things didn't go out of bounds and changing the order to make sure the cells were created before this was done was our only solution. Sort of a pain, but it did work for us

That's fantastic news. Thanks for digging in to this as i know it wasn't easy to find and fix. Hopefully the performance improvements will be a benefit to everyone. I know they will be huge for us and save us from having to rewrite a bunch of reports using a non-standard way.

Checking on status. Have you found the underlying cause of the slowness?

I may not be describing things correctly, but i am trying to access variables from within helpers, not scripts. Does that matter?

I will work on getting you a playground entry to look at so you can see, but if the helpers can't run the beforeRender and don't have access to variables within the global, it won't really matter much

This may be a weird scenario but i thought i would ask if it's possible. We have a template for Excel recipe generation (doesn't matter which we use). We also have a global JS file that has reusable methods in it for our other templates. Is it possible that the template can access variables in the global or more specifically, override the values?

The idea we have is like the way CSS works, but we need it for style building in Excel. We have already created our own style builder and want to be able to extend it a bit more. We would like to have a variable in the global JS file like this

let Styles = "{ blah blah blah }";

and then in the template be able to Merge any additional styles on top of that So in the template we would do:

Styles = object.assign(Styles, "{ my overrides or additional styles }");

The issue we are having is being able to access the global properties from within the template itself.

any ideas on what is causing this slowness? i don't want to have to move to this new reporting style as it's very hard to read/maintain

You can use the ../ operator to traverse back up the tree if you need to. So to go up 3 levels it would be ../../../variable