You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Kasper Sørensen (JIRA)" <ji...@apache.org> on 2016/08/01 16:23:20 UTC
[jira] [Created] (METAMODEL-1108) Rare unittest failure in Excel
module: Cannot get a numeric value from a text cell
Kasper Sørensen created METAMODEL-1108:
------------------------------------------
Summary: Rare unittest failure in Excel module: Cannot get a numeric value from a text cell
Key: METAMODEL-1108
URL: https://issues.apache.org/jira/browse/METAMODEL-1108
Project: Apache MetaModel
Issue Type: Bug
Reporter: Kasper Sørensen
In an unrelated test run [1] we saw this error happening on Travis:
[1] https://s3.amazonaws.com/archive.travis-ci.org/jobs/148895750/log.txt
{code}
Running org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: A10/0
java.lang.IllegalStateException: Cannot get a numeric value from a text cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:895)
at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:216)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.data.FilteredDataSet.next(FilteredDataSet.java:52)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testStylingOfNullCell(DefaultSpreadsheetReaderDelegateTest.java:209)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(12,1) is a formula. Attempting to evaluate: A10/0
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: A10/0
java.lang.IllegalStateException: Cannot get a numeric value from a text cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:895)
at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:216)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testStylingOfNullCell(DefaultSpreadsheetReaderDelegateTest.java:241)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(12,1) is a formula. Attempting to evaluate: A10/0
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@47f9738
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet2,type=null,remarks=null]
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet2,type=TABLE,remarks=null]
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@4748a0f9
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet3,type=null,remarks=null]
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet3,type=TABLE,remarks=null]
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@41d426b5
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=sheet,type=null,remarks=null]
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@66565121
[MetaModel.SharedExecutorService.Thread.1] WARN org.apache.metamodel.excel.XlsxSheetToRowsHandler - Error-cell occurred: #DIV/0!
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: A10/0
java.lang.IllegalStateException: Cannot get a numeric value from a text cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:895)
at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:216)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(12,1) is a formula. Attempting to evaluate: A10/0
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: -"t" "houetismfsthueiss"
java.lang.IllegalStateException: Cannot get a numeric value from a error formula cell
at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:644)
at org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType(HSSFCell.java:649)
at org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue(HSSFCell.java:674)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(2,0) is a formula. Attempting to evaluate: -"t" "houetismfsthueiss"
[main] WARN org.apache.metamodel.excel.ExcelUtils - Exception occurred while evaluating formula at position (2,0): Unexpected ref arg class (org.apache.poi.ss.formula.eval.StringEval)
[main] ERROR org.apache.metamodel.excel.ExcelUtils - Illegal formula argument occurred while evaluating cell formula: -"t" "houetismfsthueiss"
java.lang.IllegalArgumentException: Unexpected ref arg class (org.apache.poi.ss.formula.eval.StringEval)
at org.apache.poi.ss.formula.eval.IntersectionEval.evaluateRef(IntersectionEval.java:94)
at org.apache.poi.ss.formula.eval.IntersectionEval.evaluate(IntersectionEval.java:37)
at org.apache.poi.ss.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:503)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:263)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:374)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:262)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:46)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:274)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: -t HouetisMFSTHueiss
java.lang.IllegalStateException: Cannot get a numeric value from a error formula cell
at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:644)
at org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType(HSSFCell.java:649)
at org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue(HSSFCell.java:674)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(99,3) is a formula. Attempting to evaluate: -t HouetisMFSTHueiss
[main] WARN org.apache.metamodel.excel.ExcelUtils - Exception occurred while evaluating formula at position (99,3): Don't now how to evalate name 't'
[main] ERROR org.apache.metamodel.excel.ExcelUtils - Unexpected exception occurred while evaluating cell formula: -t HouetisMFSTHueiss
java.lang.RuntimeException: Don't now how to evalate name 't'
at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForNameRecord(WorkbookEvaluator.java:682)
at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:597)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:505)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:263)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:374)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:262)
at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:46)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:274)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@3b00856b
[main] INFO org.apache.metamodel.data.RowPublisherDataSet - Starting separate thread for publishing action: org.apache.metamodel.excel.XlsxRowPublisherAction@a43ce46
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet2,type=null,remarks=null]
[main] WARN org.apache.metamodel.QueryPostprocessDataContext - Queried table has no columns: Table[name=Sheet3,type=null,remarks=null]
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: IF(A6=5,"yes","no")
java.lang.IllegalStateException: Cannot get a numeric value from a text formula cell
at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:644)
at org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType(HSSFCell.java:649)
at org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue(HSSFCell.java:674)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(5,1) is a formula. Attempting to evaluate: IF(A6=5,"yes","no")
[main] INFO org.apache.metamodel.excel.ExcelUtils - Failed to fetch cached/precalculated formula value of cell: IF(A7=5,"yes","no")
java.lang.IllegalStateException: Cannot get a numeric value from a text formula cell
at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:644)
at org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType(HSSFCell.java:649)
at org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue(HSSFCell.java:674)
at org.apache.metamodel.excel.ExcelUtils.getFormulaCellValue(ExcelUtils.java:254)
at org.apache.metamodel.excel.ExcelUtils.getCellValue(ExcelUtils.java:223)
at org.apache.metamodel.excel.ExcelUtils.createRow(ExcelUtils.java:432)
at org.apache.metamodel.excel.XlsDataSet.getRow(XlsDataSet.java:75)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.runTest(DefaultSpreadsheetReaderDelegateTest.java:120)
at org.apache.metamodel.excel.DefaultSpreadsheetReaderDelegateTest.testReadAllTestResourceFiles(DefaultSpreadsheetReaderDelegateTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
[main] INFO org.apache.metamodel.excel.ExcelUtils - cell(6,1) is a formula. Attempting to evaluate: IF(A7=5,"
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)