[GitHub] [poi] aschott-looker opened a new pull request #265: Use BigDecimal to maintain precision of doubles

[GitBox]

aschott-looker opened a new pull request #265:
URL: https://github.com/apache/poi/pull/265


   * Multiplying certain numbers by `100.0` causes a loss in precision for 
certain doubles/floats. This can be demonstrated as follows:
   ![rounding 
bug](https://user-images.githubusercontent.com/57158607/137808739-29bd79a6-88ae-4e32-8acf-211b5324e3a0.png)
   * This causes a value of `0.00035` formatted by `#,##0.00%` to output as 
`0.03%` when Excel actually outputs `0.04%`. Using `BigDecimal` should remedy 
this issue.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org