On Tue, 17 Mar 2015, Bryan Varner wrote:
I’m working with a client making use of POI to do some heavy
calculations of workbook formulas in java.
We’re having issues with the precision of some of the math functions
(TwoOperandNumericOperation) being based on double math rather than
BigDecimal math.
I believe that Excel uses doubles internally as well, no big decimals. The
problem is that it doesn't quite use the same rounding as Java does.
There's a bit of an explanation of the problems this can cause in this
stackoverflow discussion:
http://stackoverflow.com/questions/28537614/matching-excels-floating-point-in-java
If your problem is that, then I'm not sure that dropping in a big decimal
will work, as the Java big decimal's rounding rules don't match the Excel
ones
David North has been doing lots of work on / around this area, so we might
want to wait for him to chime in
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
