This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

hssf numerical types  RSS feed

 
jeroen dijkmeijer
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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()?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!