poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "chaitanya.gorugontula@kkr.com" <chaitanya.gorugont...@kkr.com>
Subject POI 3.7 - Formula Evaluation - Not implemented yet
Date Tue, 01 Jul 2014 13:15:24 GMT
In an xlsx file, the value from certain cells is to be forced to be positive.
To make that happen, we take the value or formula from the cell and apply
the ABS() formula to ensure the end value is positive.

When we are trying to do that on a cell, with an existing formula as
follows...

+'RR HA'!W144/1000

by applying ABS() ...

ABS(+'RR HA'!W144/1000)

and when we try to re-evaluate this cell, we are getting a "Not implemented
yet" exception.

can someone please explain which part of the above formula is not
implemented yet in POI 3.7 ?
Please find stacktrace below...

ERROR MAKING FORMULA ABS():LTM Gross Interest Exp:ABS(+'RR HA'!W144/1000)
java.lang.RuntimeException: Not implemented yet
	at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105)
	at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916)
	at
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556)
	at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:427)
	at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
	at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117)
	at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077)
	at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064)
	at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424)
	at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524)
	at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508)
	at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465)
	at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1445)
	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1566)
	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174)
	at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:146)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:277)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:618)
	at
org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:47)
	at
org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:44)
	at
org.apache.poi.hssf.record.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62)
	at
org.apache.poi.hssf.record.formula.eval.TwoOperandNumericOperation.singleOperandEvaluate(TwoOperandNumericOperation.java:29)
	at
org.apache.poi.hssf.record.formula.eval.TwoOperandNumericOperation.evaluate(TwoOperandNumericOperation.java:35)
	at
org.apache.poi.hssf.record.formula.functions.Fixed2ArgFunction.evaluate(Fixed2ArgFunction.java:33)
	at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:456)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:279)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:618)
	at
org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:47)
	at
org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:44)
	at
org.apache.poi.hssf.record.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62)
	at
org.apache.poi.hssf.record.formula.eval.UnaryPlusEval.evaluate(UnaryPlusEval.java:38)
	at
org.apache.poi.hssf.record.formula.functions.Fixed1ArgFunction.evaluate(Fixed1ArgFunction.java:33)
	at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:456)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:279)
	at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221)
	at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:257)
	at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:150)



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-7-Formula-Evaluation-Not-implemented-yet-tp5715911.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message