[patch] Unit test to replicate the issue

TestIndirect.java.patch (text/plain), 1.94 KB, created by samson on 2018-03-07 11:16:38 UTC

(hide)

Description: Unit test to replicate the issue

Filename:

MIME Type:

Creator: samson

Created: 2018-03-07 11:16:38 UTC

Size: 1.94 KB

patch

obsolete

>Index: TestIndirect.java >=================================================================== >--- TestIndirect.java (revision 288774) >+++ TestIndirect.java (working copy) >@@ -20,6 +20,8 @@ > import static org.junit.Assert.assertEquals; > import static org.junit.Assert.fail; > >+import java.io.IOException; >+ > import org.apache.poi.hssf.usermodel.HSSFCell; > import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; > import org.apache.poi.hssf.usermodel.HSSFName; >@@ -32,6 +34,11 @@ > import org.apache.poi.ss.usermodel.CellType; > import org.apache.poi.ss.usermodel.CellValue; > import org.apache.poi.ss.usermodel.FormulaEvaluator; >+import org.apache.poi.xssf.usermodel.XSSFCell; >+import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator; >+import org.apache.poi.xssf.usermodel.XSSFName; >+import org.apache.poi.xssf.usermodel.XSSFSheet; >+import org.apache.poi.xssf.usermodel.XSSFWorkbook; > import org.junit.Test; > > /** >@@ -205,7 +212,32 @@ > + "' but got '" + cv.formatAsString() + "'."); > } > } >+ >+ @Test >+ public void testIndirectWichNamedRange() throws IOException{ >+ XSSFWorkbook workbook = new XSSFWorkbook(); >+ try { >+ >+ XSSFSheet sheet1 = workbook.createSheet("sheet1"); >+ XSSFSheet sheet2 = workbook.createSheet("sheet2"); >+ XSSFName namedRange = workbook.createName(); > >+ sheet2.createRow(0).createCell(0).setCellValue(10); >+ namedRange.setNameName("name1"); >+ namedRange.setSheetIndex(1); >+ namedRange.setRefersToFormula("sheet2!A1:A1"); >+ >+ XSSFCell formulaCell = sheet1.createRow(0).createCell(0); >+ formulaCell.setCellFormula("SUM(INDIRECT(\"sheet2!name1\"))"); >+ >+ XSSFFormulaEvaluator formulaEvaluator = workbook.getCreationHelper().createFormulaEvaluator(); >+ formulaEvaluator.evaluate(formulaCell); >+ } finally { >+ workbook.close(); >+ } >+ >+ } >+ > @Test > public void testInvalidInput() { > assertEquals(ErrorEval.VALUE_INVALID, Indirect.instance.evaluate(new ValueEval[] {}, null)); View Attachment As Diff View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]