Unable to render the xlsx file which is having multiple worksheets



  • Thanks and now it is not showing error and also the preview or download is not working



  • Playground is fixed now, here is the updated workspace for ref
    https://playground.jsreport.net/w/anon/dziNODoq



  • Hi,

    Thank you for your prompt assistance in fixing the issue in the playground environment.

    We are experiencing the same issue on our on-premise server and would like to implement the same changes you made in the playground to resolve it.

    Could you please provide details of the changes or configurations that were applied to make it work in the playground? This information will help us apply the same modifications to our on-premise server.

    Thank you for your support and assistance



  • That was purely just about playground...

    Please describe what are you experiencing in detail...
    Do you also have problems with "hello world" templates? Do you see errors in the F12 browser tools...



  • Hi
    i am getting the below error when i try to run the report using spread sheet which having cross worksheet formula

    Error while executing xlsx recipe
    (because) error when evaluating engine handlebars for template anonymous
    (because) parse error on line 16:
    ...='COUNTIF('Detailed Inventory'!$X$13:$X$
    -----------------------^
    Expecting 'EQUALS', got 'INVALID'

    (sandbox.js line 13:18)



  • What jsreport version do you use?
    Please provide a minimal example in playground. With just a "blank sheet" and a formula that breaks.



  • Hi We are having the same issue. Any formula with a cross-sheet reference is throwing the same error.

    Error while executing xlsx recipe
    (because) error when evaluating engine handlebars for template anonymous
    (because) parse error on line 15:
    ...rmula='-E158
    'Fixed Data'!$B$25/10^2'}}<
    -----------------------^
    Expecting 'EQUALS', got 'INVALID'
    *

    We are using version: 3.11.3



  • Please try the latest.
    If it won't help, please share a minimal playground demo.



  • Hi,
    we are using version 4.2.0

    this is working fine in playground, but it is not working in our on-premise server

    https://playground.jsreport.net/w/papegowda/I1pQW9CK



  • Try to update...


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.