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

org.apache.poi.hssf.util.CellRangeAddress
See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'
Note - {@link SelectionRecord} uses the BIFF5 version of this structure @deprecated use {@link org.apache.poi.ss.util.CellRangeAddress}

      rule1, rule2
    };


    short col = 1;
    CellRangeAddress [] regions = {
      new CellRangeAddress(0, 65535, col, col)
    };


    sheetCF.addConditionalFormatting(regions, cfRules);
      
    try {

View Full Code Here

    HSSFPatternFormatting patternFmt = rule1.createPatternFormatting();
    patternFmt.setFillBackgroundColor(HSSFColor.YELLOW.index);
    HSSFConditionalFormattingRule [] cfRules = { rule1, };


    CellRangeAddress [] regions = {
      new CellRangeAddress(2, 4, 0, 0), // A3:A5
    };
    sheetCF.addConditionalFormatting(regions, cfRules);


    // This row-shift should destroy the CF region
    sheet.shiftRows(10, 20, -9);

View Full Code Here


        row = sheet.createRow(1);
        cell = row.createCell(1);
        cell.setCellValue(new HSSFRichTextString("second row, second cell"));


        CellRangeAddress region = new CellRangeAddress(1, 1, 0, 1);
        sheet.addMergedRegion(region);


        sheet.shiftRows(1, 1, 1);


        region = sheet.getMergedRegion(0);
        assertEquals("Merged region not moved over to row 2", 2, region.getFirstRow());
    }

View Full Code Here

        sheet.autoSizeColumn((short)0);
        assertTrue("Column autosized with only one row: wrong width", sheet.getColumnWidth(0) >= minWithRow1And2);
        assertTrue("Column autosized with only one row: wrong width", sheet.getColumnWidth(0) <= maxWithRow1And2);


        //create a region over the 2nd row and auto size the first column
        sheet.addMergedRegion(new CellRangeAddress(1,1,0,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

public final class TestCloneSheet extends TestCase {


  public void testCloneSheetBasic(){
    HSSFWorkbook b = new HSSFWorkbook();
    HSSFSheet s = b.createSheet("Test");
    s.addMergedRegion(new CellRangeAddress(0, 1, 0, 1));
    HSSFSheet clonedSheet = b.cloneSheet(0);
    
    assertEquals("One merged area", 1, clonedSheet.getNumMergedRegions());
  }

View Full Code Here

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


        confirmRegion(new CellRangeAddress(0, 10, 0, 10), r1);
        confirmRegion(new CellRangeAddress(30, 40,5, 15), r2);
    }

View Full Code Here

    }
    public void createDVTypeRow(String strTypeDescription) {
      HSSFSheet sheet = _currentSheet;
      HSSFRow row = sheet.createRow(sheet.getPhysicalNumberOfRows());
      row = sheet.createRow(sheet.getPhysicalNumberOfRows());
      sheet.addMergedRegion(new CellRangeAddress(sheet.getPhysicalNumberOfRows()-1, sheet.getPhysicalNumberOfRows()-1, 0, 5));
      HSSFCell cell = row.createCell(0);
      setCellValue(cell, strTypeDescription);
      cell.setCellStyle(_style_3);
      row = sheet.createRow(sheet.getPhysicalNumberOfRows());
    }

View Full Code Here

    }


    public void createDVDescriptionRow(String strTypeDescription) {
      HSSFSheet sheet = _currentSheet;
      HSSFRow row = sheet.getRow(sheet.getPhysicalNumberOfRows()-1);
      sheet.addMergedRegion(new CellRangeAddress(sheet.getPhysicalNumberOfRows()-1, sheet.getPhysicalNumberOfRows()-1, 0, 5));
      HSSFCell cell = row.createCell(0);
      setCellValue(cell, strTypeDescription);
      cell.setCellStyle(_style_3);
      row = sheet.createRow(sheet.getPhysicalNumberOfRows());
    }

View Full Code Here

            c = r.createCell(cellnum, HSSFCell.CELL_TYPE_BLANK);


            // c.setCellValue(0);
            c.setCellStyle(cs3);
        }
        s.addMergedRegion(new CellRangeAddress(0, 3, 0, 3));
        s.addMergedRegion(new CellRangeAddress(100, 110, 100, 110));


        // end draw thick black border
        // create a sheet, set its title then delete it
        s = wb.createSheet();
        wb.setSheetName(1, "DeletedSheet");

View Full Code Here

     */
    public void testMovingMergedRegion() {
        List records = new ArrayList();


        CellRangeAddress[] cras = {
            new CellRangeAddress(0, 1, 0, 2),
        };
        MergeCellsRecord merged = new MergeCellsRecord(cras, 0, cras.length);
        records.add(new DimensionsRecord());
        records.add(new RowRecord(0));
        records.add(new RowRecord(1));

View Full Code Here

0 1 2 3

TOP

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

com.aesthete.swingobjects.fw.common.util.ExcelHelper

com.eatle.utils.ExcelUtil

org.apache.poi.hssf.dev.HSSF

org.apache.poi.hssf.model.TestSheet

org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

org.apache.poi.hssf.record.aggregates.MergedCellsTable

org.apache.poi.hssf.record.aggregates.TestCFRecordsAggregate

org.apache.poi.hssf.record.cf.CellRangeUtil

org.apache.poi.hssf.record.cf.TestCellRange

org.apache.poi.hssf.record.CFHeaderRecord

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.