protected void validateTemplateContainsNamedRange() { if (Objects.isNull(template.getWorkbook().getDefinedNames())) { throw wrapWithReportingException("An error occurred while rendering document from template. Template does not contain named ranges"); } }
protected void validateTemplateContainsNamedRange() { if (Objects.isNull(template.getWorkbook().getDefinedNames())) { throw wrapWithReportingException("An error occurred while rendering document from template. Template does not contain named ranges"); } }
public CTDefinedName getDefinedName(String name) { List<CTDefinedName> definedName = workbook.getDefinedNames().getDefinedName(); CTDefinedName targetRange = null; for (CTDefinedName namedRange : definedName) { if (name.equals(namedRange.getName())) { targetRange = namedRange; } } return targetRange; }
public CTDefinedName getDefinedName(String name) { List<CTDefinedName> definedName = workbook.getDefinedNames().getDefinedName(); CTDefinedName targetRange = null; for (CTDefinedName namedRange : definedName) { if (name.equals(namedRange.getName())) { targetRange = namedRange; } } return targetRange; }
protected void initDescriptors(Document template, Document result) { DefinedNames definedNames = template.getWorkbook().getDefinedNames(); if (definedNames != null) { for (CTDefinedName name : definedNames.getDefinedName()) { if (isHintDefinedName(name.getName())) { List<String> names = Splitter.on(DELIMITER).splitToList(name.getName()); if (names.size() > 1) { String hintName = names.get(1); for (XlsxHint hint : hints) { if (hint.getName().equals(hintName)) { HintDescriptor descriptor = new HintDescriptor(); descriptor.hint = hint; descriptor.range = Range.fromFormula(name.getValue()); descriptor.params = names.size() > 2 ? names.subList(2, names.size()) : Collections.<String>emptyList(); descriptors.add(descriptor); break; } } } } } } }
protected void initDescriptors(Document template, Document result) { DefinedNames definedNames = template.getWorkbook().getDefinedNames(); if (definedNames != null) { for (CTDefinedName name : definedNames.getDefinedName()) { if (isHintDefinedName(name.getName())) { List<String> names = Splitter.on(DELIMITER).splitToList(name.getName()); if (names.size() > 1) { String hintName = names.get(1); for (XlsxHint hint : hints) { if (hint.getName().equals(hintName)) { HintDescriptor descriptor = new HintDescriptor(); descriptor.hint = hint; descriptor.range = Range.fromFormula(name.getValue()); descriptor.params = names.size() > 2 ? names.subList(2, names.size()) : Collections.<String>emptyList(); descriptors.add(descriptor); break; } } } } } } }
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(); }
protected void findVerticalDependencies() { DefinedNames definedNames = template.getWorkbook().getDefinedNames(); if (definedNames != null) { List<CTDefinedName> definedName = definedNames.getDefinedName(); for (CTDefinedName name1 : definedName) { if (hintProcessor.isHintDefinedName(name1.getName())) continue; for (CTDefinedName name2 : definedName) { if (hintProcessor.isHintDefinedName(name2.getName())) continue; if (!name1.equals(name2)) { Range range1 = Range.fromFormula(name1.getValue()); Range range2 = Range.fromFormula(name2.getValue()); if (range1.intersectsByVertical(range2)) { rangeVerticalIntersections.put(range1, range2); rangeVerticalIntersections.put(range2, range1); } } } } } }
protected void findVerticalDependencies() { DefinedNames definedNames = template.getWorkbook().getDefinedNames(); if (definedNames != null) { List<CTDefinedName> definedName = definedNames.getDefinedName(); for (CTDefinedName name1 : definedName) { if (hintProcessor.isHintDefinedName(name1.getName())) continue; for (CTDefinedName name2 : definedName) { if (hintProcessor.isHintDefinedName(name2.getName())) continue; if (!name1.equals(name2)) { Range range1 = Range.fromFormula(name1.getValue()); Range range2 = Range.fromFormula(name2.getValue()); if (range1.intersectsByVertical(range2)) { rangeVerticalIntersections.put(range1, range2); rangeVerticalIntersections.put(range2, range1); } } } } } }