Hello, Since it might be Apache POI issue you should ask on user@poi.apache.org mailing list. Also you can file a ticket to their bugzilla [1] attaching test file and expected result.
to -= tradema...@apache.org to += user@poi.apache.org [1]: https://bz.apache.org/bugzilla/buglist.cgi?product=POI ср, 28 сент. 2016 г. в 13:11, Sun, Ricky <he....@fmr.com>: > Dear Sirs, > > > > Thank you for your poi jars working on Excel. I’m using it to develop > project using java. > > I got an bug about accurate calculation. The result from java is 0.07 base > on the formula in Excel, but actually, the result is 0.06 in Excel. > > I think the bug can be fixed by using BigDecimal type to calculate formula > in java. > > > > Thanks, > > Ricky > -- Best regards, Konstantin Gribov