This is a question that came into support and I wanted to make sure that our answer was the best answer. The problem is as follows;
When using the formula =NL("Eval","=NU()")the =NU() does not translate to various languages. For example,=NP("Eval","=JETZT()")
=NP("Eval","=AHORA()")
=NP("Eval","=NOW()")
are all the same function, but in different languages. This is normally not an issue for Excel formulas, as Excel will translate the formula correctly as you move from one language to another, but when using the NP("Eval"), Excel doesn't recognize the formula and doesn't translate it. How to resolve this, so you can write the workbook in one language and have the formula evaluated in any language.
What I've suggested is to have all the NP("Eval") formulas, one in each language, and use the Excel DMAX() function to select the formula that returns a value. Attached is an example report.
SelectNow(JET).xlsx
Please let me know if this report doesn't workbook doesn't work in your language (English, Dutch, German, Spanish) or if you have a better solution to resolving this issue.
Thank you,
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Sherman,
What I would like to have is a function that reads the language code from the Jet Reports options. Something like NP("LanguageCode").
Than I could use the result of that function to not only translate the NOW function, but also all kinds of captions in my report.
In the attachment is a small example of what I mean. Instead of reading the language code, you may enter it in Cell D3. Change it and you will get different results in Cell D11:D14, based on the translation table C5:G8. In Cell D12 the result in D11 will be executed by the NP("Eval").
Please let me know what you think of this.
Please sign in to leave a comment.