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

org.apache.poi.hssf.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

  
  public void testCloneSheetBasic(){
    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());


    }

View Full Code Here

                                  + (( double ) cellnum / 10000)));
                c = r.createCell(( short ) (cellnum + 1));
                c.setCellValue("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

    
    row = sheet.createRow(1);
    cell = row.createCell((short)1);
    cell.setCellValue("second row, second cell");
    
    Region region = new Region(1, (short)0, 1, (short)1);     
    sheet.addMergedRegion(region);
    
    sheet.shiftRows(1, 1, 1);
    
    region = sheet.getMergedRegionAt(0);
    assertEquals("Merged region not moved over to row 2", 2, region.getRowFrom());
    
  }

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

        short   toCol = (short)(rangeAddress.getXPosition(rangeAddress.getToCell())-1);
        int     toRow = rangeAddress.getYPosition(rangeAddress.getToCell())-1;
        
        getLogger().debug("Merging Range: Row ("+fromRow+") Col ("+fromCol+") to Row("+toRow+") Col("+toCol+")");
        
        Region region = new Region(fromRow, fromCol, toRow, toCol);
        sheet.addMergedRegion(region);


    }

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


        HSSFRow row = sheet.createRow((short) 0);
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("XC");


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


        cell = row.createCell((short) 2);
        cell.setCellValue(categorie.getNom());


        sheet.addMergedRegion(new Region(0, (short) 2, 0, (short) 5));


        cell = row.createCell((short) 6);
        cell.setCellValue(categorie.getSexe());


        HSSFUtils.applyStyle(row, style);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.jfinal.ext.render.excel.PoiKit

net.fqsc.inscriptions.view.component.principalcontent.admin.evenements.reports.plaques.ListePlaquePanel

net.loyin.jFinal.render.excel.ExcelKit

no.ugland.utransprod.util.excel.ExcelUtil

org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPCell

org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPMerge

org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPStyleRegion

org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.Sheet

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

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

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.