Me thinks you're right.
On Sat, 2002-04-20 at 08:35, Glen Stampoultzis wrote:
>
> 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
>
>
--
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
