Excel WorkDays() function is not calculated with error
Question / Problem:
Excel WorkDays() function is not calculated with error in Design Studio
Error from the Set Content of Cell action. Could not perform the given operation. This might be because the spreadsheet contains unsupported features, eg unsupported function or expression syntax. Please consult the documentation for further details on which features are supported. The spreadsheet reported the following error:
Unexpected arg eval type (org.apache poi.ss.formula LazyRefEval)
Answer / Solution:
This is a known issue (BUG: 1236771).
If variable is utilized in Excel such as below, it will not calculate in Design Studio.
=WORKDAY(A2,A3,B2:C11)
It will work ok in Design Studio, if you change one of the expression to a fixed value like below. This can be a workaround for this issue.
=WORKDAY(A2,-3,B2:C11)
Applies to:
Product | Version |
---|---|
RPA | 10.x |