See <https://builds.apache.org/job/POI/660/changes>
Changes: [dnorth] Add explicit test for NPE only caught by other tests. Test '97 fallback behaviour generally. https://bz.apache.org/bugzilla/show_bug.cgi?id=56328 [dnorth] My own patch to fix #56328 Add tests for initial patch applied by Nick in r1582892 Fix and test AreaReference#isWholeColumnReference to take account of the prevailing spreadsheet version. Fixing all users of this is a big undertaking, so for now I've left a fallback on the original behaviour for some cases. ------------------------------------------ [...truncated 6008 lines...] [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumif.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumifs.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumproduct.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTFunc.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestText.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTime.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTrim.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestValue.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestWeekNumFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestWeekNumFunctionsFromSpreadsheet2013.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestXYNumericFunction.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/AbstractPtgTestCase.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/AllFormulaTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestArea3DPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAreaErrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAreaPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestArrayPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAttrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestErrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestExternalFunctionFormulas.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestExternalNameReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestFuncPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestFuncVarPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestIntersectionPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestPercentPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestRangePtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestRef3DPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestReferencePtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestUnionPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestBugzillaIssues.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestCellComment.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestConditionalFormatting.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestDataFormat.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestDataValidation.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestFont.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestHyperlink.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestNamedRange.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestPicture.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetAutosizeColumn.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetHiding.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetUpdateArrayFormulas.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestDateUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestFractionFormat.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/charts/TestDataSources.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/AllSSUtilTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberComparingSpreadsheetGenerator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberComparisonExamples.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberRenderingSpreadsheetGenerator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberToTextConversionExamples.java> [echo] !????? <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestAreaReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestCellRangeAddress.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestCellReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestDateFormatConverter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestExpandedDouble.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestNumberComparer.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestNumberToTextConverter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestRegion.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestSheetBuilder.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestSheetUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestWorkbookUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/cellwalk/TestCellWalk.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/AllPOIUtilTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/DummyPOILogger.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/LocalTestNode.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestArrayUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestBinaryTree.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestBitField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestByteField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestHexDump.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestIntList.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestIntegerField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLittleEndian.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLittleEndianStreams.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLongField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestPOILogFactory.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestPOILogger.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestShortField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestShortList.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestStringUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestTempFile.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties1> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties2> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties3> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FFData_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgLw95_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgLw97_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgW97_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/LFOLVLBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/StdfBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/StdfPost2000_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/Stshif_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/bkf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/chp_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/dop_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/fld_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/frd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/fspa_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/grfhic_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/hresi_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lfo_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lstf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lvlf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/pap_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/picf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/sep_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/shd80_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/shd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tap_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tbd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tc_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tlp_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype.xsl> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype_document.xsl> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype_test.xsl> [echo] [echo] ***************************************************** [echo] Printing headers for files without AL header... [echo] [echo] [echo] ======================================================================= [echo] ==<https://builds.apache.org/job/POI/ws/src/ooxml/testcases/org/apache/poi/ss/formula/TestFormulaParser.java> [echo] ======================================================================= [echo] package org.apache.poi.ss.formula; [echo] [echo] import org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook; [echo] import org.apache.poi.hssf.usermodel.HSSFWorkbook; [echo] import org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook; [echo] import org.apache.poi.xssf.usermodel.XSSFWorkbook; [echo] [echo] import junit.framework.TestCase; [echo] [echo] /** [echo] * Test {@link FormulaParser}'s handling of row numbers at the edge of the [echo] * HSSF/XSSF ranges. [echo] * [echo] * @author David North [echo] */ [echo] public class TestFormulaParser extends TestCase { [echo] [echo] public void testHSSFFailsForOver65536() { [echo] FormulaParsingWorkbook workbook = HSSFEvaluationWorkbook.create(new HSSFWorkbook()); [echo] try { [echo] FormulaParser.parse("Sheet1!1:65537", workbook, FormulaType.CELL, 0); [echo] fail("Expected exception"); [echo] } [echo] catch (FormulaParseException expected) { [echo] } [echo] } [echo] [echo] public void testHSSFPassCase() { [echo] FormulaParsingWorkbook workbook = HSSFEvaluationWorkbook.create(new HSSFWorkbook()); [echo] FormulaParser.parse("Sheet1!1:65536", workbook, FormulaType.CELL, 0); [echo] } [echo] [echo] public void testXSSFWorksForOver65536() { [echo] FormulaParsingWorkbook workbook = XSSFEvaluationWorkbook.create(new XSSFWorkbook()); [echo] FormulaParser.parse("Sheet1!1:65537", workbook, FormulaType.CELL, 0); [echo] } [echo] [echo] public void testXSSFFailCase() { [echo] FormulaParsingWorkbook workbook = XSSFEvaluationWorkbook.create(new XSSFWorkbook()); [echo] try { [echo] FormulaParser.parse("Sheet1!1:1048577", workbook, FormulaType.CELL, 0); // one more than max rows. [echo] fail("Expected exception"); [echo] } [echo] catch (FormulaParseException expected) { [echo] } [echo] } [echo] [echo] } [echo] [echo] ======================================================================= [echo] ==<https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestAreaReference.java> [echo] ======================================================================= [echo] package org.apache.poi.ss.util; [echo] [echo] import org.apache.poi.ss.SpreadsheetVersion; [echo] [echo] import junit.framework.TestCase; [echo] [echo] /** [echo] * Test for {@link AreaReference} handling of max rows. [echo] * [echo] * @author David North [echo] */ [echo] public class TestAreaReference extends TestCase { [echo] [echo] public void testWholeColumn() { [echo] AreaReference oldStyle = AreaReference.getWholeColumn(SpreadsheetVersion.EXCEL97, "A", "B"); [echo] assertEquals(0, oldStyle.getFirstCell().getCol()); [echo] assertEquals(0, oldStyle.getFirstCell().getRow()); [echo] assertEquals(1, oldStyle.getLastCell().getCol()); [echo] assertEquals(SpreadsheetVersion.EXCEL97.getLastRowIndex(), oldStyle.getLastCell().getRow()); [echo] assertTrue(oldStyle.isWholeColumnReference()); [echo] [echo] AreaReference oldStyleNonWholeColumn = new AreaReference("A1:B23", SpreadsheetVersion.EXCEL97); [echo] assertFalse(oldStyleNonWholeColumn.isWholeColumnReference()); [echo] [echo] AreaReference newStyle = AreaReference.getWholeColumn(SpreadsheetVersion.EXCEL2007, "A", "B"); [echo] assertEquals(0, newStyle.getFirstCell().getCol()); [echo] assertEquals(0, newStyle.getFirstCell().getRow()); [echo] assertEquals(1, newStyle.getLastCell().getCol()); [echo] assertEquals(SpreadsheetVersion.EXCEL2007.getLastRowIndex(), newStyle.getLastCell().getRow()); [echo] assertTrue(newStyle.isWholeColumnReference()); [echo] [echo] AreaReference newStyleNonWholeColumn = new AreaReference("A1:B23", SpreadsheetVersion.EXCEL2007); [echo] assertFalse(newStyleNonWholeColumn.isWholeColumnReference()); [echo] } [echo] [echo] public void testWholeRow() { [echo] AreaReference oldStyle = AreaReference.getWholeRow(SpreadsheetVersion.EXCEL97, "1", "2"); [echo] assertEquals(0, oldStyle.getFirstCell().getCol()); [echo] assertEquals(0, oldStyle.getFirstCell().getRow()); [echo] assertEquals(SpreadsheetVersion.EXCEL97.getLastColumnIndex(), oldStyle.getLastCell().getCol()); [echo] assertEquals(1, oldStyle.getLastCell().getRow()); [echo] [echo] AreaReference newStyle = AreaReference.getWholeRow(SpreadsheetVersion.EXCEL2007, "1", "2"); [echo] assertEquals(0, newStyle.getFirstCell().getCol()); [echo] assertEquals(0, newStyle.getFirstCell().getRow()); [echo] assertEquals(SpreadsheetVersion.EXCEL2007.getLastColumnIndex(), newStyle.getLastCell().getCol()); [echo] assertEquals(1, newStyle.getLastCell().getRow()); [echo] } [echo] [echo] @SuppressWarnings("deprecation") // deliberate test for behaviour if deprecated constructor used. BUILD FAILED <https://builds.apache.org/job/POI/ws/build.xml>:1678: condition satisfied Total time: 14 minutes 45 seconds Build step 'Invoke Ant' marked build as failure [FINDBUGS] Skipping publisher since build result is FAILURE [WARNINGS] Skipping publisher since build result is FAILURE Archiving artifacts Sending artifact delta relative to POI #659 Archived 4364 artifacts Archive block size is 32768 Received 472 blocks and 112829208 bytes Compression is 12.1% Took 1 min 29 sec Recording test results --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
