Re: POI currency format numeric issue

2013-06-10 Thread Leigh
Hey thanks, changing my javacast from float to double fixed it. Rick Good. According to that thread, using double will not eliminate the issue entirely .. but will reduce it at least. -Leigh ~| Order the Adobe Coldfusion

Re: POI currency format numeric issue

2013-06-09 Thread Rick Root
Hey thanks, changing my javacast from float to double fixed it. Rick On Fri, May 31, 2013 at 4:43 PM, Leigh cfsearch...@yahoo.com wrote: 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

POI currency format numeric issue

2013-05-31 Thread Rick Root
Hi, I'm using the poi library (the one that comes with CF10) directly to create an excel spreadsheet, and one of our users has complained about the currency data. It shows up properly like $5.71, but sometimes the actual data in the cell is 5.71059 or something like that. Here's the code

Re: POI currency format numeric issue

2013-05-31 Thread Dave Watts
I'm using the poi library (the one that comes with CF10) directly to create an excel spreadsheet, and one of our users has complained about the currency data. It shows up properly like $5.71, but sometimes the actual data in the cell is 5.71059 or something like that. Here's the code

Re: POI currency format numeric issue

2013-05-31 Thread Leigh
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