This is yet another good example of why you're the Hawaiian chef. Anyhow, any thoughts on why it doesn't seem to happen w/smaller values? I'd still like a sample, among other reasons because I'd like to know whether thats an RK record or a NUMBER. As soon as we move over I'll attempt to reproduce this. Maybe Glen has some thoughts?
-Andy On Mon, 2002-01-28 at 21:21, Marc Johnson wrote: > I suspect this is a type conversion problem. Consider this: the original > value (-13149594) is, in hexadecimal, FF375A66. The value displayed, > 1060592230, is, in hexadecimal, 3F375A66. Let's look at those two values, > side by side: > > FF375A66 > 3F375A66 > > Looks like a classic type conversion problem to me, and that's where I > recommend we look. > > Marc > > Hawaiian chef > "will make POI in trade for traditional Hawaiian pizza" > > > >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 > > > > > A stroke of the brush does not guarantee art from the bristles. > - Kosh Naranek > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > _______________________________________________ > 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
