Package org.apache.poi.hssf.util

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

306
307
308
309
310
311
312
313
314
315
316
317
318
319
   
    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
303
304
305
306
307
308
309
310
311
312
313
314
    public void test22720() {
       HSSFWorkbook workBook = new HSSFWorkbook();
       workBook.createSheet("TEST");
       HSSFSheet template = workBook.getSheetAt(0);

       template.addMergedRegion(new Region(0, (short)0, 1, (short)2));
       template.addMergedRegion(new Region(1, (short)0, 2, (short)2));

       HSSFSheet clone = workBook.cloneSheet(0);
       int originalMerged = template.getNumMergedRegions();
       assertEquals("2 merged regions", 2, originalMerged);
View Full Code Here
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
   *
   */
  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
502
503
504
505
506
507
508
509
510
511
512
513
514
    row = sheet.createRow(1);
    cell = row.createCell((short)1);
    cell.setCellValue(new HSSFRichTextString("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
667
668
669
670
671
672
673
674
675
676
677
    sheet.autoSizeColumn((short)0);
    assertTrue("Column autosized with only one row: wrong width", sheet.getColumnWidth((short)0) >= minWithRow1And2);
    assertTrue("Column autosized with only one row: wrong width", sheet.getColumnWidth((short)0) <= maxWithRow1And2);

    //create a region over the 2nd row and auto size the first column
    sheet.addMergedRegion(new Region(1,(short)0,1,(short)1));
    sheet.autoSizeColumn((short)0);
    HSSFWorkbook wb2 = HSSFTestDataSamples.writeOutAndReadBack(wb);

    // check that the autoSized column width has ignored the 2nd row
    // because it is included in a merged region (Excel like behavior)
View Full Code Here
704
705
706
707
708
709
710
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
     */
    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
314
315
316
317
318
319
320
321
322
323
324
325
326
327
     *  @return HSSFCellStyle
     */
     HSSFCellStyle getCellStyleForRegion(int row, short col) {
        Iterator iregions = regions.keySet().iterator();
        while (iregions.hasNext()) {
            Region region = ((Region) iregions.next());
//            if (col == 1)
//                getLogger().debug("breakpoint support");
            if ( region.contains(row, col) ) {
                //getLogger().debug("Returning style for " + row +"," + col);
                return (HSSFCellStyle) regions.get( region );
            }
        }
        //getLogger().debug("returning null for "+row+","+col);
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
        Iterator iregions = regions.keySet().iterator();



        while (iregions.hasNext()) {
            Region region = ((Region) iregions.next());
            //getLogger().debug("fixing region "+region.getRowFrom()+","+region.getColumnFrom()+"-"+
            //          region.getRowTo()+","+region.getColumnTo());

            for (int rownum = region.getRowFrom(); rownum < region.getRowTo() +1; rownum++) {

                HSSFRow row  = _sheet.getRow(rownum);

                for (short colnum = region.getColumnFrom(); colnum < region.getColumnTo()+1; colnum ++) {

                    HSSFCellStyle style = (HSSFCellStyle)regions.get(region);


                    if (!isBlank(style)) { //don't waste time with huge blocks of blankly
View Full Code Here
580
581
582
583
584
585
586
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.