File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes hssf numerical types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "hssf numerical types" Watch "hssf numerical types" New topic

hssf numerical types

jeroen dijkmeijer
Ranch Hand

Joined: Sep 26, 2003
Posts: 131
I'm wondering.. Am i doing something stupid here or is my poi build (poi-2.5.1-final-20040804.jar) broken?
It looks very basic, the behavior is unexpected, the lib is over 2 years old now and I havent found any claims with the same issues @google normally making me very suspicious of my own qualities.

I've got a cell which does contain a numeric.
But doing cel.getCellType() does not give me a HSSFCell.CELL_TYPE_NUMERIC (0) but 2.

Any feedback would be appreciated.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42946
Although that is a number, the cell might be formatted as a formula (which is type 2), and the value might be the result of evaluating the formula. What is the result of calling cel.getCellFormula()?
I agree. Here's the link:
subject: hssf numerical types