NotImplementedException for the functions 'TEXT' and 'REPT'

[Torsten Link <to...@gmx.de>]

Hi,

I got a problem when I recalculate all formulars in my sheet. 
There are two functions which gives me problems:

I got the message NotImplementedException for the functions 'TEXT' and 'REPT'.
But I found these functions implemented in the source code. So I am a bit lost
with this problem.


Here ist the original formular:
=CONCATENATE("MyMessage ";TEXT($'Raw Data'.B21;"MMM-TT JJJJ"))


Here is the debug output of one of the formular:

[FORMULA]
    .row    = 0x0000
    .col    = 0x0005
    .xfindex= 0x0073
  .value	 = <string> [00, 00, C0, BD, 44, 02]
  .options   = 0x0020
    .alwaysCalc= false
    .calcOnLoad= false
    .shared    = false
  .zero      = 0xFF080001    Ptg[0]=org.apache.poi.hssf.record.formula.StringPtg ["MyMessage "].
    Ptg[1]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! B21]V
    Ptg[2]=org.apache.poi.hssf.record.formula.StringPtg ["MMM-TT JJJJ"].
    Ptg[3]=org.apache.poi.hssf.record.formula.FuncPtg [TEXT nArgs=2]V
    Ptg[4]=org.apache.poi.hssf.record.formula.FuncVarPtg [CONCATENATE nArgs=2]V
[/FORMULA]


which leads to the exception:

org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'MySheet'!F1
	at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:302)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:269)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:206)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:317)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:210)
	at com.db.gatekeeper.controller.scorecard.AbstractExcelScoreCardController.recalculateFormulars(AbstractExcelScoreCardController.java:246)
	at com.db.gatekeeper.controller.scorecard.AbstractExcelScoreCardController.recalculateFormulars(AbstractExcelScoreCardController.java:231)
	at com.db.gatekeeper.controller.scorecard.RecertificationMoversScoreCardController.run(RecertificationMoversScoreCardController.java:86)
	at com.db.gatekeeper.Main.handleScorecardRecertificationMovers(Main.java:446)
	at com.db.gatekeeper.Main.callModules(Main.java:116)
	at com.db.gatekeeper.Main.run(Main.java:91)
	at com.db.gatekeeper.Main.main(Main.java:63)
Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: TEXT
	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:437)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:260)
	... 10 more




with kind regards

Torsten Link




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