We plan to one day see what we can do with BigDecimal, but its not high on the stack right now.
On Sat, 2002-04-20 at 06:55, Nicola Ken Barozzi wrote: > From: "Andrew C. Oliver" <[EMAIL PROTECTED]> > > > True but a straight double isn't accurate to that many decimal places. > > I think that we don't know for sure is the result of a lack of unit > > tests in this area of the software. > > > > I think this is a great area for some of those who've written in saying > > "I want to get involved" to help contribute and a great place to get > > started. > > > > An example of software that calculates with high precision > http://www.jonelo.de/java/bigal.html > > > > > Glen Stampoultzis wrote: > > > > >Strange, it's stored internally in Excel as a double and we're just using > > >standard Java routines to convert to a double from bytes. The error is > > >reasonably large too. > > > > > >-- Glen > > > > > > > > >----- Original Message ----- > > >From: "Andrew C. Oliver" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Thursday, April 18, 2002 11:30 PM > > >Subject: Re: Wrong result from numberic cell value with > v1.5.0-dev-20020416 > > > > > > > > >>Anyone have any thoughts on this one? > > >> > > >>Teutscher, Uwe wrote: > > >> > > >>>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 > > >>>> > > >><snip content="attachment that I can't decode anyhow"/> > > >> > > > > > > > > > > > > > > > > > > -- 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
