Hi,
I am using POI-3.7-20101029.
I have a complex Excel xls file with nested formulas (inserted as matric
formulas!) using the basic FREQUENCY function.
Example:
=SUM (
IF (
FREQUENCY (
IF
(LEN(DECLARED_VIALS)>0,MATCH(DECLARED_VIALS,DECLARED_VIALS,0),""),IF(LEN(DECLARED_VIALS)>0,MATCH(DECLARED_VIALS,DECLARED_VIALS,0),""))>0,1))
I see (http://poi.apache.org/spreadsheet/formula.html) that there are:
References: single cell & area, 2D & 3D, relative & absolute
Literals: Number, text, boolean, error and array
Operators: arithmetic and logical, some region operators
>>> Built-in functions: over 350 recognised, 280 evaluatable <<<
Add-in functions: 3 from Analysis Toolpack
but could not find the list of built in functions.
As I get:
Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: FREQUENCY
at
org.apache.poi.hssf.record.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:42)
at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:456)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:279)
... 41 more
and I can not find any
org.apache.poi.hssf.record.formula.functions.Frequency
class in the src distribution, I suppose this is not supported yet.
Can anybody confirm?
Will it be added? If yes, any plan?
Is there anybody having an implementation to share?
Thanks in advance,
cheers
Stefano
