From db8eb4c56cb68776a52039c060ad69b431498739 Mon Sep 17 00:00:00 2001 From: Avik Sengupta Date: Tue, 31 May 2005 18:41:19 +0000 Subject: [PATCH] new testcase git-svn-id: https://svn.apache.org/repos/asf/jakarta/poi/trunk@353703 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/hssf/usermodel/TestUnfixedBugs.java | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java index 525503cfa1..810109add1 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java @@ -58,5 +58,22 @@ public class TestUnfixedBugs extends TestCase { HSSFWorkbook wb = new HSSFWorkbook(in); assertTrue("Read book fine!" , true); } - + + /* cell with formula becomes null on cloning a sheet*/ + public void test35084() { + + HSSFWorkbook wb = new HSSFWorkbook(); + HSSFSheet s =wb.createSheet("Sheet1"); + HSSFRow r = s.createRow(0); + r.createCell((short)0).setCellValue(1); + r.createCell((short)1).setCellFormula("A1*2"); + HSSFSheet s1 = wb.cloneSheet(0); + r=s1.getRow(0); + assertEquals("double" ,r.getCell((short)0).getNumericCellValue(),(double)1,0); //sanity check, pass + assertNotNull(r.getCell((short)1)); //Fails + assertEquals("formula", r.getCell((short)1).getCellFormula(), "A1*2"); //Fails + + + + } } -- 2.39.5