I want to use YEARFRAC For my calculation
Eg:
in cell A3 i have given date 10/10/2010
in cell A4 i have given date 10/10/2020
in A5 i have given formula =YEARFRAC($A$3,$A$4,1)
When i evauate this particular cell in java its throwing exception as
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)
Can any one resolve this problem?
thanks
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Not-implemented-yet-issue-with-YEARFRAC-in-Excel-2007-tp3304593p3304593.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
