protected void updateMergeRegions() { for (Range templateRange : rangeDependencies.templates()) { Worksheet templateSheet = template.getSheetByName(templateRange.getSheet()); Worksheet resultSheet = result.getSheetByName(templateRange.getSheet()); if (templateSheet.getMergeCells() != null) { if (resultSheet.getMergeCells() == null) { CTMergeCells resultMergeCells = new CTMergeCells(); resultMergeCells.setParent(resultSheet); resultSheet.setMergeCells(resultMergeCells); } } for (Range resultRange : rangeDependencies.resultsForTemplate(templateRange)) { if (templateSheet.getMergeCells() != null && templateSheet.getMergeCells().getMergeCell() != null) { for (CTMergeCell templateMergeRegion : templateSheet.getMergeCells().getMergeCell()) { Range mergeRange = Range.fromRange(templateRange.getSheet(), templateMergeRegion.getRef()); if (templateRange.contains(mergeRange) || templateRange.isOneCellRange() && mergeRange.contains(templateRange)) { Offset offset = calculateOffset(templateRange, resultRange); Range resultMergeRange = mergeRange.copy().shift(offset.downOffset, offset.rightOffset); CTMergeCell resultMergeRegion = new CTMergeCell(); resultMergeRegion.setRef(resultMergeRange.toRange()); resultMergeRegion.setParent(resultSheet.getMergeCells()); resultSheet.getMergeCells().getMergeCell().add(resultMergeRegion); } } } } } }
protected void updateMergeRegions() { for (Range templateRange : rangeDependencies.templates()) { Worksheet templateSheet = template.getSheetByName(templateRange.getSheet()); Worksheet resultSheet = result.getSheetByName(templateRange.getSheet()); if (templateSheet.getMergeCells() != null) { if (resultSheet.getMergeCells() == null) { CTMergeCells resultMergeCells = new CTMergeCells(); resultMergeCells.setParent(resultSheet); resultSheet.setMergeCells(resultMergeCells); } } for (Range resultRange : rangeDependencies.resultsForTemplate(templateRange)) { if (templateSheet.getMergeCells() != null && templateSheet.getMergeCells().getMergeCell() != null) { for (CTMergeCell templateMergeRegion : templateSheet.getMergeCells().getMergeCell()) { Range mergeRange = Range.fromRange(templateRange.getSheet(), templateMergeRegion.getRef()); if (templateRange.contains(mergeRange) || templateRange.isOneCellRange() && mergeRange.contains(templateRange)) { Offset offset = calculateOffset(templateRange, resultRange); Range resultMergeRange = mergeRange.copy().shift(offset.downOffset, offset.rightOffset); CTMergeCell resultMergeRegion = new CTMergeCell(); resultMergeRegion.setRef(resultMergeRange.toRange()); resultMergeRegion.setParent(resultSheet.getMergeCells()); resultSheet.getMergeCells().getMergeCell().add(resultMergeRegion); } } } } } }
public void clearWorkbook() { for (SheetWrapper sheet : worksheets) { sheet.worksheet.getJaxbElement().getSheetData().getRow().clear(); CTMergeCells mergeCells = sheet.worksheet.getJaxbElement().getMergeCells(); if (mergeCells != null && mergeCells.getMergeCell() != null) { mergeCells.getMergeCell().clear(); } try { CTPageBreak rowBreaks = sheet.worksheet.getContents().getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { rowBreaks.getBrk().clear(); } } catch (Docx4JException e) { throw new ReportFormattingException("An error occurred while clearing docx4j workbook", e); } } workbook.getDefinedNames().getDefinedName().clear(); }
public void clearWorkbook() { for (SheetWrapper sheet : worksheets) { getWorksheetContents(sheet).getSheetData().getRow().clear(); CTMergeCells mergeCells = getWorksheetContents(sheet).getMergeCells(); if (mergeCells != null && mergeCells.getMergeCell() != null) { mergeCells.getMergeCell().clear(); } try { CTPageBreak rowBreaks = sheet.worksheet.getContents().getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { rowBreaks.getBrk().clear(); } } catch (Docx4JException e) { throw new ReportFormattingException("An error occurred while clearing docx4j workbook", e); } } workbook.getDefinedNames().getDefinedName().clear(); }