Examples of org.apache.poi.ss.util.Region

org.apache.poi.ss.util.Region
Represents a from/to row/col square. This is a object primitive that can be used to represent row,col - row,col just as one would use String to represent a string of characters. Its really only useful for HSSF though. @author Andrew C. Oliver acoliver at apache dot org @deprecated (Aug-2008) use {@link CellRangeAddress}

                                  + (( double ) cellnum / 10000)));
                c = r.createCell(cellnum + 1);
                c.setCellValue(new HSSFRichTextString("TEST"));
            }
        }
        s.addMergedRegion(new Region(0, (short)0, 10, (short)10));
        s.addMergedRegion(new Region(30, (short)5, 40, (short)15));
        sanityChecker.checkHSSFWorkbook(wb);
        wb = HSSFTestDataSamples.writeOutAndReadBack(wb);


        s  = wb.getSheetAt(0);
        CellRangeAddress r1 = s.getMergedRegion(0);

View Full Code Here


        HSSFRow row = sheet.createRow((short) 1);
        HSSFCell cell = row.createCell((short) 1);
        cell.setCellValue("This is a test of merging");


        sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));


        // Write the output to a file
        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();

View Full Code Here

     * @return the merged region (simple eh?)
     */


    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }

View Full Code Here

     */
    protected void shiftMerged(int startRow, int endRow, int n, boolean isRow) {
        List shiftedRegions = new ArrayList();
        //move merged regions completely if they fall within the new region boundaries when they are shifted
        for (int i = 0; i < this.getNumMergedRegions(); i++) {
             Region merged = this.getMergedRegionAt(i);


             boolean inStart = (merged.getRowFrom() >= startRow || merged.getRowTo() >= startRow);
             boolean inEnd =  (merged.getRowTo() <= endRow || merged.getRowFrom() <= endRow);


             //dont check if it's not within the shifted area
             if (! (inStart && inEnd)) continue;


             //only shift if the region outside the shifted rows is not merged too
             if (!merged.contains(startRow-1, (short)0) && !merged.contains(endRow+1, (short)0)){
                 merged.setRowFrom(merged.getRowFrom()+n);
                 merged.setRowTo(merged.getRowTo()+n);
                 //have to remove/add it back
                 shiftedRegions.add(merged);
                 this.removeMergedRegion(i);
                 i = i -1; // we have to back up now since we removed one


             }


        }


        //readd so it doesn't get shifted again
        Iterator iterator = shiftedRegions.iterator();
        while (iterator.hasNext()) {
            Region region = (Region)iterator.next();


            this.addMergedRegion(region);
        }


    }

View Full Code Here

    public void testNewMergedRegionAt() {
      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      Region region = new Region("B2:D4");
      sheet.addMergedRegion(region);
      assertEquals("B2:D4", sheet.getMergedRegionAt(0).getRegionRef());
    }

View Full Code Here

      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      assertEquals(0, sheet.getNumMergedRegions());
      Region region = new Region("B2:D4");
      sheet.addMergedRegion(region);
      assertEquals(1, sheet.getNumMergedRegions());
    }

View Full Code Here

    public void testRemoveMergedRegion() {
      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      Region region_1 = new Region("A1:B2");
      Region region_2 = new Region("C3:D4");
      Region region_3 = new Region("E5:F6");
      sheet.addMergedRegion(region_1);
      sheet.addMergedRegion(region_2);
      sheet.addMergedRegion(region_3);
      assertEquals("C3:D4", ctWorksheet.getMergeCells().getMergeCellArray(1).getRef());
      assertEquals(3, sheet.getNumMergedRegions());

View Full Code Here

    return worksheet.getPageMargins();
  }


    public Region getMergedRegionAt(int index) {
      CTMergeCell ctMergeCell = getMergedCells().getMergeCellArray(index);
      return new Region(ctMergeCell.getRef());
    }

View Full Code Here

                                  + (( double ) cellnum / 10000)));
                c = r.createCell(( short ) (cellnum + 1));
                c.setCellValue(new HSSFRichTextString("TEST"));
            }
        }
        s.addMergedRegion(new Region(( short ) 0, ( short ) 0, ( short ) 10,
                                     ( short ) 10));
        s.addMergedRegion(new Region(( short ) 30, ( short ) 5, ( short ) 40,
                                     ( short ) 15));
        wb.write(out);
        out.close();
        sanityChecker.checkHSSFWorkbook(wb);
        in = new FileInputStream(file);
        wb = new HSSFWorkbook(new POIFSFileSystem(in));
        s  = wb.getSheetAt(0);
        Region r1 = s.getMergedRegionAt(0);
        Region r2 = s.getMergedRegionAt(1);


        in.close();


        // System.out.println(file.length());
        // assertEquals("FILE LENGTH == 87552",file.length(), 87552);
        // System.out.println(s.getLastRowNum());
        assertEquals("REGION1 = 0,0,10,10", 0,
                     new Region(( short ) 0, ( short ) 0, ( short ) 10,
                                ( short ) 10).compareTo(r1));
        assertEquals("REGION2 == 30,5,40,15", 0,
                     new Region(( short ) 30, ( short ) 5, ( short ) 40,
                                ( short ) 15).compareTo(r2));
    }

View Full Code Here

   *
   */
  public void testRemoveMerged() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    Region region = new Region(0, (short)0, 1, (short)1);
    sheet.addMergedRegion(region);
    region = new Region(1, (short)0, 2, (short)1);
    sheet.addMergedRegion(region);


    sheet.removeMergedRegion(0);


    region = sheet.getMergedRegionAt(0);
    assertEquals("Left over region should be starting at row 1", 1, region.getRowFrom());


    sheet.removeMergedRegion(0);


    assertEquals("there should be no merged regions left!", 0, sheet.getNumMergedRegions());


    //an, add, remove, get(0) would null pointer
    sheet.addMergedRegion(region);
    assertEquals("there should now be one merged region!", 1, sheet.getNumMergedRegions());
    sheet.removeMergedRegion(0);
    assertEquals("there should now be zero merged regions!", 0, sheet.getNumMergedRegions());
    //add it again!
    region.setRowTo(4);


    sheet.addMergedRegion(region);
    assertEquals("there should now be one merged region!", 1, sheet.getNumMergedRegions());


    //should exist now!
    assertTrue("there isn't more than one merged region in there", 1 <= sheet.getNumMergedRegions());
    region = sheet.getMergedRegionAt(0);
    assertEquals("the merged row to doesnt match the one we put in ", 4, region.getRowTo());
  }

View Full Code Here

0 1 2

TOP

Related Classes of org.apache.poi.ss.util.Region

org.apache.poi.hssf.dev.HSSF

org.apache.poi.hssf.record.cf.CellRange

org.apache.poi.hssf.usermodel.examples.MergedCells

org.apache.poi.hssf.usermodel.HSSFSheet

org.apache.poi.hssf.usermodel.TestBugs

org.apache.poi.hssf.usermodel.TestCloneSheet

org.apache.poi.hssf.usermodel.TestDataValidation

org.apache.poi.hssf.usermodel.TestHSSFConditionalFormatting

org.apache.poi.hssf.usermodel.TestHSSFSheet

org.apache.poi.hssf.usermodel.TestWorkbook

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.