You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2015/02/08 16:17:48 UTC
svn commit: r1658186 - in /poi/trunk:
src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
test-data/spreadsheet/57535.xlsx
Author: nick
Date: Sun Feb 8 15:17:47 2015
New Revision: 1658186
URL: http://svn.apache.org/r1658186
Log:
Add a unit test (disabled) for bug #57535 - "Unknown error type: -60" fetching formula error value
Added:
poi/trunk/test-data/spreadsheet/57535.xlsx (with props)
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java?rev=1658186&r1=1658185&r2=1658186&view=diff
==============================================================================
--- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java (original)
+++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java Sun Feb 8 15:17:47 2015
@@ -2133,4 +2133,25 @@ public final class TestXSSFBugs extends
}
}
}
+
+ /**
+ * "Unknown error type: -60" fetching formula error value
+ */
+ @Test
+ public void bug57535() throws Exception {
+ Workbook wb = XSSFTestDataSamples.openSampleWorkbook("57535.xlsx");
+ FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
+ evaluator.clearAllCachedResultValues();
+
+ Sheet sheet = wb.getSheet("Sheet1");
+ Cell cell = sheet.getRow(5).getCell(4);
+ assertEquals(Cell.CELL_TYPE_FORMULA, cell.getCellType());
+ assertEquals("E4+E5", cell.getCellFormula());
+
+ CellValue value = evaluator.evaluate(cell);
+ assertEquals(Cell.CELL_TYPE_ERROR, value.getCellType());
+ assertEquals(-60, value.getErrorValue());
+ // TODO Fix this
+// assertEquals("", FormulaError.forInt(value.getErrorValue()).toString());
+ }
}
Added: poi/trunk/test-data/spreadsheet/57535.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/57535.xlsx?rev=1658186&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/57535.xlsx
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org