FileDocCategorySizeDatePackage
TestCloneSheet.javaAPI DocApache Poi 3.0.12320Mon Jan 01 12:39:46 GMT 2007org.apache.poi.hssf.usermodel

TestCloneSheet

public class TestCloneSheet extends TestCase
Test the ability to clone a sheet. If adding new records that belong to a sheet (as opposed to a book) add that record to the sheet in the testCloneSheetBasic method.
author
avik

Fields Summary
Constructors Summary
public TestCloneSheet(String arg0)

		super(arg0);
Methods Summary
public voidtestCloneSheetBasic()

		try{
			HSSFWorkbook b = new HSSFWorkbook();
			HSSFSheet s = b.createSheet("Test");
			s.addMergedRegion(new Region((short)0,(short)0,(short)1,(short)1));
			HSSFSheet clonedSheet = b.cloneSheet(0);
			
			assertEquals("One merged area", 1, clonedSheet.getNumMergedRegions());

		}
		catch(Exception e){e.printStackTrace();fail(e.getMessage());}
public voidtestPageBreakClones()
Ensures that pagebreak cloning works properly

      HSSFWorkbook b = new HSSFWorkbook();
      HSSFSheet s = b.createSheet("Test");
      s.setRowBreak(3);
      s.setColumnBreak((short)6);
      
      HSSFSheet clone = b.cloneSheet(0);
      assertTrue("Row 3 not broken", clone.isRowBroken(3));
      assertTrue("Column 6 not broken", clone.isColumnBroken((short)6));
      
      s.removeRowBreak(3);
      
      assertTrue("Row 3 still should be broken", clone.isRowBroken(3));