poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44708] FormulaEvaluator can' t handle all functions for XSSF
Date Sun, 06 Apr 2008 20:57:40 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=44708


Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Josh Micich <josh@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


Mime
View raw message