I'm not sure if this worked with 1.0.1 but the problem is due to the handling of RK records. I will be submitting a fix to this soon.
Regards, Glen Stampoultzis (TriNexus Pty Ltd) +63 3 9753-6850 0402 835 458 ICQ: 62722370 EMail: [EMAIL PROTECTED] ----- Original Message ----- From: "Teutscher, Uwe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 11:15 PM Subject: RE: Wrong result from numberic cell value with v1.5.0-dev-20020416 > But with poi version 1.0.1 I get the correct result. > I think this is a step back. > > Uwe > > -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 2:05 PM > To: '[EMAIL PROTECTED]' > Subject: Re: Wrong result from numberic cell value with > v1.5.0-dev-20020416 > > > Yes this is a documentation bug. We're using double. double rounding > is not 100% accurate. Future versions may support BigDecimal as well, > but not the current dev version. If you round to the expected decimal > places you should get acceptable results. > > If someone wants to do a BigDecimal patch that provides it in addition > to double, then I'll gladly commit it. > > -Andy > > On Thu, 2002-04-18 at 05:20, Teutscher, Uwe wrote: > > 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 > -- > http://www.superlinksoftware.com > http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound > Document > format to java > http://developer.java.sun.com/developer/bugParade/bugs/4487555.html > - fix java generics! > The avalanche has already started. It is too late for the pebbles to > vote. > -Ambassador Kosh
