You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/04/06 22:57:40 UTC
DO NOT REPLY [Bug 44708] FormulaEvaluator can'
t handle all functions for XSSF
https://issues.apache.org/bugzilla/show_bug.cgi?id=44708
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-04-06 13:57:39 PST ---
fixed in svn r645298. Most of the failures were due to xssf classifying empty
cells as type 'numeric'. XSSF internally uses *numeric* cells with no value to
represent 'blank' cells. However, it is useful to distinguish 'blank' cell
type for evaluating formulas. The rest of POI seems to rely on this.
After the fix, the far majority of function test evaluations work:
"There were 862 successful evaluation(s) and 93 function(s) without error"
So I decided to enable the whole test, but specifically skip the 3 remaining
failing evaluation cases.
The first bug is related to parsing of full column references. This is a bug
in trunk too, and should probably be fixed there (I think there is already a
bugzilla for this).
The second remaining bug (just one(?!)) is related to the missing Workbook
object.
I have opened the a new bugzilla bug 44762 to track the work for this second
bug.
Note - there is a minor TODOs left in XSSFCell.getNumericCellValue() requesting
the spec to be settled.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org