Bug 45768 - HSSFFormulaEvaluator evaluateFormulaCell() returns -1 for non-formula cells
Summary: HSSFFormulaEvaluator evaluateFormulaCell() returns -1 for non-formula cells
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows 2000
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-08 16:17 UTC by Niall Pemberton
Modified: 2008-09-29 16:15 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Niall Pemberton 2008-09-08 16:17:31 UTC
I read the following docs on HSSFFormulaEvaluator's evaluateFormulaCell() method:

http://poi.apache.org/hssf/eval.html#EvaluateFormulaCell

...and assumed that this would return a valid cell type for all cells whether they were formula or not - but found that for Non-formula cells it returns -1.

Is this working as it should? If it is I think the docs need to be made clearer in that example and evaluateFormulaCell() method javadocs that it only works with formula cell types.

(using POI 3.1-FINAL - but bugzilla doesn't have that version)
Comment 1 Josh Micich 2008-09-29 16:15:45 UTC
You are right about the ambiguity.  Documentation updated in svn r700304.