diff options
author | Nick Burch <nick@apache.org> | 2014-07-25 16:42:31 +0000 |
---|---|---|
committer | Nick Burch <nick@apache.org> | 2014-07-25 16:42:31 +0000 |
commit | cd7de7d482ec06e4c9ab8050935cbf12d452878b (patch) | |
tree | 55cd7d55d00cb148034e65350c9d4115f166bf98 /src/ooxml/testcases/org/apache/poi | |
parent | af999df6aefbb57c98c6cc42881bb5264e7a1f46 (diff) | |
download | poi-cd7de7d482ec06e4c9ab8050935cbf12d452878b.tar.gz poi-cd7de7d482ec06e4c9ab8050935cbf12d452878b.zip |
Complete evaluation support for multi-sheet references for bug #55906
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613467 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src/ooxml/testcases/org/apache/poi')
-rw-r--r-- | src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java index 09c45f0404..aaba1643d6 100644 --- a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java +++ b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java @@ -247,10 +247,8 @@ public final class TestXSSFFormulaEvaluation extends BaseTestFormulaEvaluator { * from Sheets 1 through Sheet 3). * This test, based on common test files for HSSF and XSSF, checks * that we can correctly evaluate these - * - * DISABLED pending support, see bug #55906 */ - public void DISABLEDtestMultiSheetAreasHSSFandXSSF() throws Exception { + public void testMultiSheetAreasHSSFandXSSF() throws Exception { Workbook[] wbs = new Workbook[] { HSSFTestDataSamples.openSampleWorkbook("55906-MultiSheetRefs.xls"), XSSFTestDataSamples.openSampleWorkbook("55906-MultiSheetRefs.xlsx") @@ -264,11 +262,11 @@ public final class TestXSSFFormulaEvaluation extends BaseTestFormulaEvaluator { Cell sumFA = s1.getRow(2).getCell(7); assertNotNull(sumFA); assertEquals("SUM(Sheet1:Sheet3!A1:B2)", sumFA.getCellFormula()); - assertEquals("110.0", evaluator.evaluate(sumFA).formatAsString()); + assertEquals("Failed for " + wb.getClass(), "110.0", evaluator.evaluate(sumFA).formatAsString()); // Various Stats formulas on ranges of numbers - Cell avgFA = s1.getRow(2).getCell(7); + Cell avgFA = s1.getRow(2).getCell(8); assertNotNull(avgFA); assertEquals("AVERAGE(Sheet1:Sheet3!A1:B2)", avgFA.getCellFormula()); assertEquals("27.5", evaluator.evaluate(avgFA).formatAsString()); |