Excel formula not calculating when using IFERROR and propertyExpression

0

I'm using jasper reports 4.7, and I'm working on creating an excel report using the IFERROR excel function.  Here is an example of one of the text fields I am using

 

However, when I open this up, Excel has #NAME? in the cell.  If I edit the cell, but don't make any changes to its contents, the formula is calculated correctly.  If I remove the IFERROR function from the above propertyExpression, the division calculates fine in my excel file.  Do I need to do something else to get the IFERROR function to calculate properly?
btenney's picture
Joined: Feb 21 2013 - 10:51am
Last seen: 11 months 1 week ago

1 Answer:

1

Hi,

The IFERROR() function is not recognized by Excel 2003. In this case it should be replaced by IF(ISERROR(...), ... , ...).

But for Excel 2007 or newer, IFERROR() is the right function, indeed. In this case, please upload a file containing your sample formula.

Regards,

sanda

shertage's picture
1940
Joined: Sep 26 2006 - 8:06pm
Last seen: 3 months 15 hours ago
Feedback
randomness