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 2011/10/19 13:36:28 UTC
DO NOT REPLY [Bug 52057] New: Update FormulaEvalTestData.xls with
recently added Functions
https://issues.apache.org/bugzilla/show_bug.cgi?id=52057
Bug #: 52057
Summary: Update FormulaEvalTestData.xls with recently added
Functions
Product: POI
Version: 3.8-dev
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: nick.burch@alfresco.com
Classification: Unclassified
As described in the Formula eval guide
<http://poi.apache.org/spreadsheet/eval-devguide.html>, we have a special test
file FormulaEvalTestData.xls
For every excel function we implement, we should populate the appropriate
entries in there for those functions. This will then allow the function to be
automatically tested for basic operation
Looking through the file, it seems the quite a few of the recently added
formula functions are missing from this. So, it needs someone to review the
list of functions there are implemented (by looking at
src/java/org/apache/poi/ss/formula/eval/FunctionEval.java and possibly checking
IDs in
src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt).
Then, for any that are not present in the file so far, add in a formula using
the function and the value that should be produced
--
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
DO NOT REPLY [Bug 52057] Update FormulaEvalTestData.xls with
recently added Functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52057
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2012-02-28 11:56:17 UTC ---
Done in r1294595
I added a warning to catch similar issues in the future. it turned out we had
quite a lot of not covered functions:
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] ADDRESS: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] CHAR: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] CLEAN: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] COLUMNS: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] COUNTBLANK:
function is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] DATE: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] DAYS360: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] FIND: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] HLOOKUP: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] HOUR: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] HYPERLINK:
function is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] INDIRECT: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] IRR: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] LOOKUP: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] MINUTE: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] NOT: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] NOW: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] NPV: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] PI: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] POISSON: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] RAND: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] RATE: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] ROWS: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] SEARCH: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] SECOND: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] SUBTOTAL: function
is supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] TEXT: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] TIME: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] TODAY: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] TRUNC: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] VALUE: function is
supported but missing test data
[org.apache.poi.ss.formula.eval.TestFormulasFromSpreadsheet] VLOOKUP: function
is supported but missing test data
I fixed all except NOW,TODAY and RAND : these are not deterministic.
Yegor
--
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