Hi
I have the following problem with POI versions
jakarta-poi-1.5.0-dev-20020416-bin and version 1.4583.
I get the wrong result back when I read a cell with the vale 987.01.
public class Test {
public static void main(String[] args) throws IOException {
POIFSFileSystem fs = new POIFSFileSystem(new
FileInputStream("test.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short)0);
System.out.println("> " + cell.getNumericCellValue());
cell = row.getCell((short)1);
System.out.println("> " + cell.getNumericCellValue());
cell = row.getCell((short)2);
System.out.println("> " + cell.getNumericCellValue());
cell = row.getCell((short)3);
System.out.println("> " + cell.getNumericCellValue());
}
}
The excel file test.xls has one row with 4 cells:
987.0 987.01 987.02 987.011
The result is:
987.0
987.010625
987.020625
987.011
Thanks for your help
begin 600 test.xls
MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
M````&0``````````$```_O___P````#^____`````!@```#_____________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M______________________\)"!````8%`/X<S0?)0```!@$``.$``@"P!,$`
M`@```.(```!<`'``"0``5&5U='-C:&5R("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@($(``@"P!&$!`@``
M`,`!```]`0(``0"<``(`#@`9``(````2``(````3``(```"O`0(```"\`0(`
M```]`!(````\`%L[^B,X```````!`'<`0``"````C0`"````(@`"````#@`"
M``$`MP$"````V@`"````,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`
M,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y`!````
M````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`
M,0`:`,@`!``,`)`!```!````!0%!`'(`:0!A`&P`,0`:`,@`!``D`)`!```!
M````!0%!`'(`:0!A`&P`,0`:`,@``0#_?[P"`````@``!0%!`'(`:0!A`&P`
M'@0>``4`&0``(RPC(S!<(")$32([7"TC+",C,%P@(D1-(AX$(P`&`!X``",L
M(R,P7"`B1$TB.UM2961=7"TC+",C,%P@(D1-(AX$)``'`!\``",L(R,P+C`P
M7"`B1$TB.UPM(RPC(S`N,#!<(")$32(>!"D`"``D```C+",C,"XP,%P@(D1-
M(CM;4F5D75PM(RPC(S`N,#!<(")$32(>!#X`*@`Y``!?+2H@(RPC(S!<(")$
M32)?+3M<+2H@(RPC(S!<(")$32)?+3M?+2H@(BTB7"`B1$TB7RT[7RU`7RT>
M!#X`*0`Y``!?+2H@(RPC(S!<(%]$7TU?+3M<+2H@(RPC(S!<(%]$7TU?+3M?
M+2H@(BTB7"!?1%]-7RT[7RU`7RT>!$8`+`!!``!?+2H@(RPC(S`N,#!<(")$
M32)?+3M<+2H@(RPC(S`N,#!<(")$32)?+3M?+2H@(BTB/S]<(")$32)?+3M?
M+4!?+1X$1@`K`$$``%\M*B`C+",C,"XP,%P@7T1?35\M.UPM*B`C+",C,"XP
M,%P@7T1?35\M.U\M*B`B+2(_/UP@7T1?35\M.U\M0%\MX``4``````#U_R``
M`````````````,`@X``4``$```#U_R```/0``````````,`@X``4``$```#U
M_R```/0``````````,`@X``4``(```#U_R```/0``````````,`@X``4``(`
M``#U_R```/0``````````,`@X``4``````#U_R```/0``````````,`@X``4
M``````#U_R```/0``````````,`@X``4``````#U_R```/0``````````,`@
MX``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`````````
M`,`@X``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`````
M`````,`@X``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`
M`````````,`@X``4``````#U_R```/0``````````,`@X``4```````!`"``
M`````````````,`@X``4``8```#T_P```/0``````````,`@X``4``$`*P#U
M_R```/@``````````,`@X``4``$`*0#U_R```/@``````````,`@X``4``4`
M``#T_P```/0``````````,`@X``4``$`"0#U_R```/@``````````,`@X``4
M``$`+`#U_R```/@``````````,`@X``4``$`*@#U_R```/@``````````,`@
MX``4``<````!`"````@``````````,`@DP($`!"`"?^3`@0`$8`#_Y,"!``2
M@`;_DP($`!.`"/^3`@0`%(`%_Y,"!```@`#_DP($`!6`!/^3`@0`%H`'_V`!
M`@```(4`$`!8!@`````(`%1A8F5L;&4QC``$`#$`,0#!`0@`P0$``&!I`0#\
M``@```````````#_``(`"``*````"0@0```&$`#^',T'R4````8!```+`A0`
M```````````"````*@H``*@*```-``(``0`,``(`9``/``(``0`1``(````0
M``@`_*GQTDUB4#]?``(``0`J``(````K``(```""``(``0"```@`````````
M```E`@0```#_`($``@#!!!0````5````@P`"````A``"````30`2`P``2`!0
M`"``1`!E`',`:P!*`&4`=``@`#4`,``P````````````````````````````
M``````````````````````$$``7<`#0"0^^`!0$`"0":"S0(9``!``\`+`$!
M``$`+`$"``$`00`T````````````````````````````````````````````
M`````````````````````````````````````````````````````````0``
M```````!`````@````$```#_____`````````````````````$1)3E4B````
M-`(``%KWK[L`````````````````````````````````````!P````$`````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````*$`(@`)`&0``0`!``$``@`L`2P!BAT\_/U^WS^*
M'3S\_7[?/P$`50`"``H`?0`,``````!)#0\`!@`"```"#@```````@``````
M!`````@"$```````!`#_`````````0\`"`(0``$````$`/\``````(`!%P"]
M`!@```````\``-B.0`\`T1CX0`\`X1CX0`(``P(.`````P`/``P"*X<6V(Y`
MUP`(`%8````4`"X`/@(2`+8&`````$```````````````!T`#P`#`0`#````
M`0`!``$``P/O``8````W````"@``````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````_O\```4``@```````````````````````0``
M`."%G_+Y3V@0JY$(`"LGL]DP````H`````<````!````0`````0```!(````
M"````%0````2````:`````P```"`````#0```(P````3````F`````(```#D
M!```'@````0```!U=&4`'@````H```!4975T<V-H97(`(``>````$````$UI
M8W)O<V]F="!%>&-E;`!``````'0E"7)SP0%``````$O9^KCFP0$#````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````````/[_```%``(```````````````````````$`
M```"U<W5G"X;$).7"``K+/FN,````,@````)`````0```%`````/````6```
M`!<```!D````"P```&P````0````=````!,```!\````%@```(0````-````
MC`````P```"A`````@```.0$```>````!````'5T90`#````%Q`)``L`````
M````"P`````````+``````````L`````````'A````$````)````5&%B96QL
M93$`#!````(````>````#P```$%R8F5I='-B;.1T=&5R``,````!````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M```````````````````````````!`````@````,````$````!0````8````'
M````_O___PD````*````"P````P````-````#@````\```#^____$0```!(`
M```3````%````!4````6````%P```/[____]_____O__________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_________________________________________________U(`;P!O`'0`
M(`!%`&X`=`!R`'D`````````````````````````````````````````````
M```````````````6``4!__________\"````(`@"``````#`````````1@``
M````````````````````````_O___P``````````5P!O`'(`:P!B`&\`;P!K
M````````````````````````````````````````````````````````````
M`````!(``@'_______________\`````````````````````````````````
M`````````````````````!`````````%`%,`=0!M`&T`80!R`'D`20!N`&8`
M;P!R`&T`80!T`&D`;P!N````````````````````````````````````*``"
M`0$````#````_____P``````````````````````````````````````````
M``````@`````$`````````4`1`!O`&,`=0!M`&4`;@!T`%,`=0!M`&T`80!R
M`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N```````````````X``(!________
M________````````````````````````````````````````````````$```
)```0````````
`
end
