While it would be quite understandable if you said you got that value while reading 1060592230.000001 (a matter of precision), I do not know why you got that value for that number. We might be able to help if you can provide a bit more information.
1. What version of POI::HSSF are you using? (1.0.2, 1.2.0, etc) 2. Can you provide a sample XLS that exhibits this behavior (I realize you probably can't send me the real one but if you can create another sheet that has the same problem that would help us track this down if its a bug). Please provide an accompanying java file that reads the value (so I can determine if you're doing something wrong). 3. you do realize the cells are 0 based and yet in excel 1 based? Meaning 0,1 is B1 in excel. 4. One thing you can do to track this down yourself if you can't help us with this is try running net.sourceforge.poi.hssf.dev.BiffViewer myfile.xls and see if the [NUMBER] record with that row/col shows up that way. -Andy On Mon, 2002-01-28 at 17:03, [EMAIL PROTECTED] wrote: > Hi: > > I tried to read a cell with value "-13149594", but I got value > "1060592230". > > Can somebody help to explain this? > > Thanks > > HS > > > _______________________________________________ > Poi-general-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/poi-general-user -- www.superlinksoftware.com www.sourceforge.net/projects/poi - port of Excel 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
