Examples with CellRangeAddress org.apache.poi.ss.util.CellRangeAddress used on opensource projects

Example 6 with CellRangeAddress

use of org.apache.poi.ss.util.CellRangeAddress in project poi by apache.

the class CFHeaderBase method read.

protected void read(RecordInputStream in) {
    field_1_numcf = in.readShort();
    field_2_need_recalculation_and_id = in.readShort();
    field_3_enclosing_cell_range = new CellRangeAddress(in);
    field_4_cell_ranges = new CellRangeAddressList(in);
}

Example 7 with CellRangeAddress

use of org.apache.poi.ss.util.CellRangeAddress in project poi by apache.

the class MergedCells method main.

public static void main(String[] args) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("new sheet");
    HSSFRow row = sheet.createRow(1);
    HSSFCell cell = row.createCell(1);
    cell.setCellValue("This is a test of merging");
    sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 2));
    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();
    wb.close();
}

Example 8 with CellRangeAddress

use of org.apache.poi.ss.util.CellRangeAddress in project poi by apache.

the class CFRecordsAggregate method shiftRange.

private static CellRangeAddress shiftRange(FormulaShifter shifter, CellRangeAddress cra, int currentExternSheetIx) {
    // FormulaShifter works well in terms of Ptgs - so convert CellRangeAddress to AreaPtg (and back) here
    AreaPtg aptg = new AreaPtg(cra.getFirstRow(), cra.getLastRow(), cra.getFirstColumn(), cra.getLastColumn(), false, false, false, false);
    Ptg[] ptgs = { aptg };
    if (!shifter.adjustFormula(ptgs, currentExternSheetIx)) {
        return cra;
    }
    Ptg ptg0 = ptgs[0];
    if (ptg0 instanceof AreaPtg) {
        AreaPtg bptg = (AreaPtg) ptg0;
        return new CellRangeAddress(bptg.getFirstRow(), bptg.getLastRow(), bptg.getFirstColumn(), bptg.getLastColumn());
    }
    if (ptg0 instanceof AreaErrPtg) {
        return null;
    }
    throw new IllegalStateException("Unexpected shifted ptg class (" + ptg0.getClass().getName() + ")");
}

Example 9 with CellRangeAddress

use of org.apache.poi.ss.util.CellRangeAddress in project poi by apache.

the class CFRecordsAggregate method updateFormulasAfterCellShift.

/**
     * @return <code>false</code> if this whole {@link CFHeaderRecord} / {@link CFRuleRecord}s should be deleted
     */
public boolean updateFormulasAfterCellShift(FormulaShifter shifter, int currentExternSheetIx) {
    CellRangeAddress[] cellRanges = header.getCellRanges();
    boolean changed = false;
    List<CellRangeAddress> temp = new ArrayList<CellRangeAddress>();
    for (CellRangeAddress craOld : cellRanges) {
        CellRangeAddress craNew = shiftRange(shifter, craOld, currentExternSheetIx);
        if (craNew == null) {
            changed = true;
            continue;
        }
        temp.add(craNew);
        if (craNew != craOld) {
            changed = true;
        }
    }
    if (changed) {
        int nRanges = temp.size();
        if (nRanges == 0) {
            return false;
        }
        CellRangeAddress[] newRanges = new CellRangeAddress[nRanges];
        temp.toArray(newRanges);
        header.setCellRanges(newRanges);
    }
    for (CFRuleBase rule : rules) {
        Ptg[] ptgs;
        ptgs = rule.getParsedExpression1();
        if (ptgs != null && shifter.adjustFormula(ptgs, currentExternSheetIx)) {
            rule.setParsedExpression1(ptgs);
        }
        ptgs = rule.getParsedExpression2();
        if (ptgs != null && shifter.adjustFormula(ptgs, currentExternSheetIx)) {
            rule.setParsedExpression2(ptgs);
        }
        if (rule instanceof CFRule12Record) {
            CFRule12Record rule12 = (CFRule12Record) rule;
            ptgs = rule12.getParsedExpressionScale();
            if (ptgs != null && shifter.adjustFormula(ptgs, currentExternSheetIx)) {
                rule12.setParsedExpressionScale(ptgs);
            }
        }
    }
    return true;
}

Example 10 with CellRangeAddress

use of org.apache.poi.ss.util.CellRangeAddress in project poi by apache.

the class MergedCellsTable method addMergeCellsRecord.

private void addMergeCellsRecord(MergeCellsRecord mcr) {
    int nRegions = mcr.getNumAreas();
    for (int i = 0; i < nRegions; i++) {
        CellRangeAddress cra = mcr.getAreaAt(i);
        _mergedRegions.add(cra);
    }
}