Re: Wrong result from numberic cell value with v1.5.0-dev-20020416

2002-04-20 Thread Andrew C. Oliver
835 458 ICQ: 62722370EMail: [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

Wrong result from numberic cell value with v1.5.0-dev-20020416

2002-04-18 Thread Teutscher, Uwe
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

RE: Wrong result from numberic cell value with v1.5.0-dev-20020416

2002-04-18 Thread Graaf, Edgar de (fin)
]' Onderwerp: Wrong result from numberic cell value with v1.5.0-dev-20020416 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

Re: Wrong result from numberic cell value with v1.5.0-dev-20020416

2002-04-18 Thread Andrew C. Oliver
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

RE: Wrong result from numberic cell value with v1.5.0-dev-20020416

2002-04-18 Thread Teutscher, Uwe
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