Hi 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. output
Any feedback would be appreciated. Regards, Jeroen
posted 9 years ago
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()?