> I'm guessing this is coming from casting it to float, but I'm not > sure what else to do here.
Maybe not just that, but POI's handling of it? Since Excel does not support precise types, POI uses doubles (and auto casts floats to doubles). Since both are approximate types that may be what is causing it. Do you notice any change if you use "double" as mentioned here? (It will not fix the problem, but may lessen it) http://apache-poi.1045710.n5.nabble.com/a-float-number-set-to-a-numeric-cell-is-changed-to-a-double-tt2305277.html#a2305290 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
