Wrong value using JavaCast Float calling HSSFWorkbook

[CFJSGeekOmaha]

I am running the HSSFWorkbook java object to create Excel Spreadsheets. The "est_outgoing_cost" variable is getting populated at 1.51. When I open the created spreadsheet the cell displays 1.51. However the actual value for the cell is 1.50999999046325. Any ideas why it's subtracting from 1.51?

[cf_dev2 · Accepted solution]

> cellValue = javaCast(arguments[3], val);
> cell.setCellValue(cellValue);

You're casting the value as a "float". You might try casting it to "double"

<cfscript>
cell.setCellValue(javaCast("double", val));
</cfscript>