https://issues.apache.org/bugzilla/show_bug.cgi?id=56317
Bug ID: 56317
Summary: While reading the numeric value "0.002877" and its
multipe of 2 & 4 and division of 3 it shows 19
decimals.
Product: POI
Version: unspecified
Hardware: PC
OS: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
The following apache packages used;
--------------
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.*;
import org.apache.log4j.*;
--------------
int lengthBeforeDecimal = decimalVal.substring(0,decimalPos).length();
//System.out.println("lengthh before
decimal:::"+lengthBeforeDecimal);
//System.out.println("Length after
decimal:::"+(actualLength-lengthBeforeDecimal-1));
lengthAfterDec=actualLength-lengthBeforeDecimal-1;
The above code is getting 19 decimals for the numeric value: "0.002877" and its
multiples of 2 & 4(0.005754, 0.011508) and division by 3(0.000959).
i.e.; for example: "0.002877" is taken as ".0028770000000000002".
Could you please suggest so that only the six decimals are to be read from the
xl-sheet.
Thanks & Regards,
Benny J. Kelambeth
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
