Examples of CellRangeAddress

com.sun.star.table.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}
org.apache.poi.ss.util.CellRangeAddress
See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

In the Microsoft documentation, this is also known as a Ref8U - see page 831 of version 1.0 of the documentation. Note - {@link SelectionRecord} uses the BIFF5 version of this structure @author Dragos Buleandra (dragos.buleandra@trade2b.ro)
org.zkoss.poi.ss.util.CellRangeAddress

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

            String[] regions = stRef.split(" ");
            for (int i = 0; i < regions.length; i++) {
            String[] parts = regions[i].split(":");
            CellReference begin = new CellReference(parts[0]);
            CellReference end = parts.length > 1 ? new CellReference(parts[1]) : begin;
            CellRangeAddress cellRangeAddress = new CellRangeAddress(begin.getRow(), end.getRow(), begin.getCol(), end.getCol());
            addressList.addCellRangeAddress(cellRangeAddress);
          }
        }
        XSSFDataValidation xssfDataValidation = new XSSFDataValidation(addressList, ctDataValidation);
        xssfValidations.add(xssfDataValidation);

View Full Code Here

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


    public XSSFAutoFilter setAutoFilter(CellRangeAddress range) {
        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();


        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);


        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);

View Full Code Here

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

    }


    public void testNewMergedRegionAt() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CellRangeAddress region = CellRangeAddress.valueOf("B2:D4");
        sheet.addMergedRegion(region);
        assertEquals("B2:D4", sheet.getMergedRegion(0).formatAsString());
        assertEquals(1, sheet.getNumMergedRegions());
    }

View Full Code Here

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


    public void testRemoveMergedRegion_lowlevel() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet ctWorksheet = sheet.getCTWorksheet();
        CellRangeAddress region_1 = CellRangeAddress.valueOf("A1:B2");
        CellRangeAddress region_2 = CellRangeAddress.valueOf("C3:D4");
        CellRangeAddress region_3 = CellRangeAddress.valueOf("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

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

        CellRangeAddress[] ranges = new CellRangeAddress[1];


        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(2).createCell(2);
        ranges[0] = new CellRangeAddress(2, 7, 2, 5);
        cell.setCellValue(FIRST_CELL_CONTENT);


        cell = sheet.createRow(7).createCell(5);
        cell.setCellValue(LAST_CELL_VALUE);


        cell = sheet.createRow(1).createCell(1);
        assertNull(parser.getRangeIfMerged(cell, ranges));


        cell = sheet.getRow(2).createCell(5);
        cell.setCellValue("wrong");


        CellRangeAddress rangeIfMerged = parser.getRangeIfMerged(cell, ranges);
        assertEquals(FIRST_CELL_CONTENT, sheet.getRow(rangeIfMerged.getFirstRow()).getCell(rangeIfMerged.getFirstColumn()).getStringCellValue());
    }

View Full Code Here

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


    private List<MergedCellRange> getMergedCellRangeList(HSSFSheet worksheet) {
        List<MergedCellRange> mergedCellRanges = new ArrayList<MergedCellRange>();
        int mergedRegionsCount = worksheet.getNumMergedRegions();
        for (int ctr = 0; ctr < mergedRegionsCount; ctr++) {
            CellRangeAddress rangeAddress = worksheet.getMergedRegion(ctr);
            mergedCellRanges.add(new MergedCellRange(rangeAddress.getFirstRow(), rangeAddress.getFirstColumn(), rangeAddress.getLastRow(), rangeAddress.getLastColumn()));
        }
        return mergedCellRanges;
    }

View Full Code Here

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


    private List<MergedCellRange> getMergedCellRangeList(HSSFSheet worksheet) {
        List<MergedCellRange> mergedCellRanges = new ArrayList<MergedCellRange>();
        int mergedRegionsCount = worksheet.getNumMergedRegions();
        for (int ctr = 0; ctr < mergedRegionsCount; ctr++) {
            CellRangeAddress rangeAddress = worksheet.getMergedRegion(ctr);
            mergedCellRanges.add(new MergedCellRange(rangeAddress.getFirstRow(), rangeAddress.getFirstColumn(), rangeAddress.getLastRow(), rangeAddress.getLastColumn()));
        }
        return mergedCellRanges;
    }

View Full Code Here

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

    for(int col=0; col<=maxCol; col++){
      if(sheet.getColumnWidth(col) >=0) 
        newSheet.setColumnWidth(col, sheet.getColumnWidth(col));
    }
    for(int i=0; i< sheet.getNumMergedRegions(); i++){
      CellRangeAddress cra = sheet.getMergedRegion(i);
      newSheet.addMergedRegion(cra);
    }
  }

View Full Code Here

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

      if(sheet.getColumnWidth(col) >=0) 
        sheet.setColumnWidth(col + colOffset, sheet.getColumnWidth(col));
    }
    if(mergedRegions != null){
      for(CellRangeAddress cra: mergedRegions){
        CellRangeAddress craNew = new CellRangeAddress(cra.getFirstRow() + rowOffset,cra.getLastRow() + rowOffset,
            cra.getFirstColumn() + colOffset, cra.getLastColumn() + colOffset);
        sheet.addMergedRegion(craNew);
      }
    }
  }

View Full Code Here

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

      sheetName = (String)stack.getValue("sheetName");
    if(sheetName != null) wb.setSheetName(wb.getSheetIndex(sheet), sheetName);
    
    Map<ExcelBlock, List<CellRangeAddress>> mergedRegions = new HashMap<ExcelBlock, List<CellRangeAddress>>();
    for(int i=0; i< sheet.getNumMergedRegions(); i++){
      CellRangeAddress cra = sheet.getMergedRegion(i);
      logger.debug("Merged Region:[{}-{}]", 
          ExcelUtil.getCellIndex(cra.getFirstRow(), cra.getFirstColumn()),
          ExcelUtil.getCellIndex(cra.getLastRow(), cra.getLastColumn()));
      for(ExcelBlock blockDefinition: sheetDefinition.getSortedExcelBlocks()){
        if(cra.getFirstRow() >= blockDefinition.getStartRow() &&
            cra.getFirstColumn() >= blockDefinition.getStartCol() &&
            cra.getLastRow() <= blockDefinition.getEndRow() &&
            cra.getLastColumn() <= blockDefinition.getEndCol()){
          List<CellRangeAddress> cras = mergedRegions.get(blockDefinition);
          if(cras == null){
            cras = new ArrayList<CellRangeAddress>();
            mergedRegions.put(blockDefinition, cras);            
          }

View Full Code Here

0 1 2 3 4 5

TOP

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.