protected Range getBandRange(BandData band) { CTDefinedName targetRange = template.getDefinedName(band.getName()); if (targetRange == null) { log.info("Could not find named range for band {}", band.getName()); return null; } return Range.fromFormula(targetRange.getValue()); }
protected Range getBandRange(BandData band) { CTDefinedName targetRange = template.getDefinedName(band.getName()); if (targetRange == null) { log.info("Could not find named range for band {}", band.getName()); return null; } return Range.fromFormula(targetRange.getValue()); }
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; } } } } } } }
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); } } } } } }