I created the HSSFWorkbook with Microsoft Excel. The numeric cell value gets converted into the wrong value in the resultant HSSFCell in the numeric type. The value 0.769 in the file is converted to 0.7689999999999999 by LittleEndian in the fillFields(RecordInputStream in) method in NumberRecord class. If I save the file as a csv file and then save back as a xls file, this problem doesn't happen. Does any body know what is causing this problem? If this is a known bug, is there any work around?
Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
