https://bz.apache.org/bugzilla/show_bug.cgi?id=65467
Bug ID: 65467
Summary: Excel function IFNA() is not defined
Product: POI
Version: 5.0.0-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
The Excel IFNA() function isn't defined in POI. I needed it, so I whipped up
an implementation, but I'm having problems with testing it. I've got a unit
test (TestIfna.java), built similarly to lots of other function tests, and it
passes. But my attempt to test using IFNA() in a spreadsheet
(TestIfnaFromSpreadsheet.java) acts as if the function isn't defined:
Testcase: org.apache.poi.ss.formula.functions.TestIfnaFromSpreadsheet
Test: processFunctionRow(String, String, HSSFSheet, int,
HSSFFormulaEvaluator, int)[1] took 140 milli sec(s) FAILED: In
IfnaTestCaseData.xls Ifna!B5 {=_xlfn.IFNA(E5,F5)} 'An N/A value' - exception in
evaluator.evaluate(evalCell):
org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating
cell Ifna!B5 with inner exception:
org.apache.poi.ss.formula.eval.NotImplementedFunctionException: _xlfn.IFNA
org.apache.poi.ss.formula.eval.NotImplementedFunctionException: _xlfn.IFNA
...
This is a surprise, because I've updated FunctionEval.java and
functionMetadata.txt to define it. I followed the "Developing Formula
Evaluation" instructions at
https://poi.apache.org/components/spreadsheet/eval-devguide.html, but I've
clearly missed a step. Where should I be looking? Is there a decent example
of a patch that adds a new function?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
