• 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: 42972
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()?
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!