Skip to main content
Kofax

Excel WorkDays() function is not calculated with error

3020515

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

 

 

  • Was this article helpful?