Posts made by jcschmidig

The strange thing is that the formula as shown is correct, but there must be some thing not shown here.
Anyway let us close it.I'll find another way to achieve my goal.
Thanks a lot for your help!

It's all in the playground ?! I can't imagine what the difference comes from.
What does the error message (at the exclamation triangle) say?

I just sent you the file. Thx.

Thanks for looking!
I updated the playground to not use the {{formula ...}} helper and the result is the same.
Could it be a 'german' thing?

Thanks for your reply!
Here's the playground for it: https://playground.jsreport.net/w/anon/YEABx0bl

I use the formula

=LOOKUP(2,1/(INDIRECT(CONCATENATE("'",INDIRECT(CONCATENATE("Z",ROW(),"S1"),FALSE),"'!D:D"))<>""),INDIRECT(CONCATENATE("'",INDIRECT(CONCATENATE("Z",ROW(),"S1"),FALSE),"'!D:D")))

to get some data from another location.
After the conversion by html-to-xlsx recipe it looks like (I use a german version of excel)

=VERWEIS(2;1/(INDIREKT(VERKETTEN("'";INDIREKT(VERKETTEN("Z";ZEILE();"S1");FALSCH);"'!D:D"))<>"");INDIREKT(VERKETTEN("'";@INDIREKT(VERKETTEN("Z";ZEILE();"S1");FALSCH);"'!D:D")))

As you can see, a @ has been added to the last INDIREKT. This prevents the formula from being evaluated.
What is the problem? How can I prevent it?

Thanks for listening!

After having investigated my jsreport.config.json it revelead that the option

    "extensions":  {
        "chrome-pdf": {
            "launchOptions": {
                "args": [
                    "--no-sandbox", "--ignore-certificate-errors"
                ]
            }
        }
    }

in fact any "launchOptions" (even empty) lead to the described error.
With version 3.12 this was not the case.

Thanks for your reply.
I just noticed that it only happens on my Apple M1.
I use it as part of a docker-compose:

  jsreport:
    image: jsreport/jsreport:4.2.0
    restart: always
    volumes:
      - type: bind
        source: ./jsreport.config.json
        target: /app/jsreport.config.json
        read_only: true
    expose:
      - $JSREPORT_PORT
    entrypoint: "jsreport"
    command: ["start", "--httpPort", $JSREPORT_PORT]

The image "jsreport/jsreport:4.2.0" does not work on a debian docker container. Any request results in an "Error when processing render request 1 (because) could not find Chrome (ver. 117.0.5938.149)."
What should I do to make it work?