Hello Andreas this issue pops up every now and then. Please have a look at http://apache-poi.1045710.n5.nabble.com/Floating-point-behaviour-difference-between-POI-and-Excel-td5715765.html
So Excel rounds to 15 digits. I'm undecided about the BigDecimal API, so I leave it to the others to decide. Regarding the DB inserts, why do you store numbers in varchars(12)? ... I would expect the jdbc API to truncate/round the doubles and use the maximum number type. If the schema is not in your hands, you have to do the rounding ... for being consistent with Excel, you probably need to do the rounding anyways or use the DataFormatter. Andi -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
