/** * Create an instance of {@link CTDefinedName } * */ public CTDefinedName createCTDefinedName() { return new CTDefinedName(); }
/** * This method is invoked by the JAXB implementation on each instance when unmarshalling completes. * * @param parent * The parent object in the object tree. * @param unmarshaller * The unmarshaller that generated the instance. */ public void afterUnmarshal(Unmarshaller unmarshaller, Object parent) { setParent(parent); }
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 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()); }
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; }
private void addDefinedNames(String sheetInternalName, ObjectFactory factory, DefinedNames definedNames, long startedRowForRegion, long endedRowForRegion, ReportRegion reportRegion) { String regionCellFrom = String.format(CELL_MASK, "A", String.valueOf(startedRowForRegion)); String regionCellTo = String.format(CELL_MASK, (reportRegion.isTabulatedRegion() ? CellReference.convertNumToColString(reportRegion.getRegionProperties().size() - 1) : "B"), String.valueOf(endedRowForRegion)); if (reportRegion.isTabulatedRegion()) { //create defined name for a header of table CTDefinedName ctDefinedName = factory.createCTDefinedName(); ctDefinedName.setName(reportRegion.getNameForHeaderBand()); String regionHeaderCellFrom = String.format(CELL_MASK, "A", String.valueOf(startedRowForRegion - 1)); String regionHeaderCellTo = String.format(CELL_MASK, CellReference.convertNumToColString(reportRegion.getRegionProperties().size() - 1), String.valueOf(endedRowForRegion - 1)); ctDefinedName.setValue(sheetInternalName + "!" + regionHeaderCellFrom + ":" + regionHeaderCellTo); definedNames.getDefinedName().add(ctDefinedName); } CTDefinedName ctDefinedName = factory.createCTDefinedName(); ctDefinedName.setName(reportRegion.getNameForBand()); ctDefinedName.setValue(sheetInternalName + "!" + regionCellFrom + ":" + regionCellTo); definedNames.getDefinedName().add(ctDefinedName); }
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 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()); }
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 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); } } } } } }
/** * This method is invoked by the JAXB implementation on each instance when unmarshalling completes. * * @param parent * The parent object in the object tree. * @param unmarshaller * The unmarshaller that generated the instance. */ public void afterUnmarshal(Unmarshaller unmarshaller, Object parent) { setParent(parent); }
/** * Create an instance of {@link CTDefinedName } * */ public CTDefinedName createCTDefinedName() { return new CTDefinedName(); }
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); } } } } } }