Error when generating report with Excel formula

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hello. I'm getting this error when using an Excel formula on my report. My guess is that it's not reading WORKDAY.INTL() as one function, resulting in the following message:

Warning:  Could not find named cell WORKDAY when parsing formula ROUNDDOWN(WORKDAY.INTL($E3,K3)-$E3-(K5-1),0) in cell XlsFormulaReport!P3

And then it generates the .xls file and in the cell I get:  =#NAME?

How can I solve this?
Thank you.

lucas_30's picture
Joined: Jun 14 2019 - 10:59am
Last seen: 3 years 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness