https://bz.apache.org/bugzilla/show_bug.cgi?id=58468
Bug ID: 58468
Summary: Not implemented function 'DAYS'
Product: POI
Version: 3.13-dev
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 33153
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33153&action=edit
Test case + excel file
Evaluation of DAYS function fails with message:
org.apache.poi.ss.formula.FormulaParseException: Name '_xlfn.DAYS' is
completely unknown in the current workbook
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:947)
at
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:436)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:257)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1143)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1103)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1090)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1450)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1570)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1554)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1511)
at
org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1492)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1472)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1612)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:153)
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:53)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:261)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:189)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.doEvaluateInCell(BaseXSSFFormulaEvaluator.java:133)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:75)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:34)
at it.matula.expimp.DatesTest.evaluateFormula(DatesTest.java:104)
at it.matula.expimp.DatesTest.getStringCellValue(DatesTest.java:88)
at it.matula.expimp.DatesTest.getCellContent(DatesTest.java:67)
at it.matula.expimp.DatesTest.testDays(DatesTest.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
