TTEST is not implemented. At the moment POI supports only basic statistical functions (COUNT and its variations, AVERAGE, STDEV, VAR and POISSON) . Other functions involving complex math are not yet supported.
You can't iterate over implemented / not-implemented functions programmatically. The best way to see what is supported is to study the source code. All built-in function implementations live in the org.apache.poi.ss.formula.functions namespace: http://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/formula/functions/ The function API in POI is extendable. To evaluate TTEST you need to write a class implementing the Function interface and register this class in http://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/formula/eval/FunctionEval.java Patches are welcome. Regards, Yegor On Tue, Feb 14, 2012 at 4:09 AM, David <[email protected]> wrote: > Hi there, > > I encountered an error when trying to evaluate a cell using ttest function: > org.apache.poi.ss.formula.eval.NotImplementedException: > Error evaluating cell Summary_6103!R3 > at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo > (WorkbookEvaluator.java:321) > at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny > (WorkbookEvaluator.java:288) > at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate > (WorkbookEvaluator.java:221) > at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue > (HSSFFormulaEvaluator.java:320) > at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate > (HSSFFormulaEvaluator.java:182) > ... > Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: TTEST > 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) > ... 20 more > > Is the TTEST function supported? where can I find a list of > supported functions in POI? > Is it's not supported, is there a workaround? > Thanks, > > David > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
