This project has moved. For the latest updates, please go here.

#VALUE! displays after calculated simple formula

Dec 9, 2014 at 3:39 AM
Edited Dec 9, 2014 at 3:54 AM
Hi , I am using EPPlus 4.0.1.1 .

I have a problem in simple vertical cell referencing formula with calculation.
 W72 =(( W60 -(- W63 )-( W29 + W30 + W31 ))/( W23 + W28 + W42 - W51 )* W4 )
#VALUE! : After Calculated, actual result is number(after refreshing manually it becomes correct result)

Each referencing cells have and displaying proper value.

It was good when I used EPPlus 4.0 beta2.

Thanks!
Developer
Dec 11, 2014 at 11:42 AM
Hi,

thanks for reporting this. Just want to let you know that I am working on this and are able to reproduce the error. Seems to be a tricky one though. We fixed some bugs on the formula calculation between RC and 4.0.1 so this is probably a new "feature".