/** * Get the WorksheetPart * @return * @since 3.3.3 */ public WorksheetPart getWorksheetPart() { return ((Row)getParent()).getWorksheetPart(); }
/** * Get the WorksheetPart * @return * @since 3.3.3 */ public WorksheetPart getWorksheetPart() { return ((Row)getParent()).getWorksheetPart(); }
@Override protected Cell copyCell(Cell cell) { Object parent = cell.getParent(); try { cell.setParent(null); return (Cell) SerializationSupport.getKryoSerialization().copy(cell); } finally { cell.setParent(parent); } } }
protected List<Cell> copyCells(BandData band, Range templateRange, List<Row> resultSheetRows, Row firstRow, Worksheet resultSheet) { List<Cell> resultCells = new ArrayList<Cell>(); for (int i = 0; i <= templateRange.getLastRow() - templateRange.getFirstRow(); i++) { Range oneRowRange = new Range(templateRange.getSheet(), templateRange.getFirstColumn(), templateRange.getFirstRow() + i, templateRange.getLastColumn(), templateRange.getFirstRow() + i); Map<CellReference, Cell> cellsForOneRowRange = template.getCellsByRange(oneRowRange); List<Cell> templateCells = new ArrayList<Cell>(cellsForOneRowRange.values()); Row templateRow = !templateCells.isEmpty() ? (Row) templateCells.get(0).getParent() : resultSheet.getSheetData().getRow().get(oneRowRange.getFirstRow() - 1); createFakeTemplateCellsForEmptyOnes(oneRowRange, cellsForOneRowRange, templateCells); Row resultRow = resultSheetRows.get((int) (firstRow.getR() + i - 1)); List<Cell> currentRowResultCells = copyCells(templateRange, band, resultRow, templateCells); resultCells.addAll(currentRowResultCells); copyRowSettings(templateRow, resultRow, getWorksheet(templateRow), getWorksheet(resultRow)); } return resultCells; }
protected List<Cell> copyCells(BandData band, Range templateRange, List<Row> resultSheetRows, Row firstRow, Worksheet resultSheet) { List<Cell> resultCells = new ArrayList<>(); for (int i = 0; i <= templateRange.getLastRow() - templateRange.getFirstRow(); i++) { Range oneRowRange = new Range(templateRange.getSheet(), templateRange.getFirstColumn(), templateRange.getFirstRow() + i, templateRange.getLastColumn(), templateRange.getFirstRow() + i); Map<CellReference, Cell> cellsForOneRowRange = template.getCellsByRange(oneRowRange); List<Cell> templateCells = new ArrayList<>(cellsForOneRowRange.values()); Row templateRow = !templateCells.isEmpty() ? (Row) templateCells.get(0).getParent() : resultSheet.getSheetData().getRow().get(oneRowRange.getFirstRow() - 1); createFakeTemplateCellsForEmptyOnes(oneRowRange, cellsForOneRowRange, templateCells); Row resultRow = resultSheetRows.get((int) (firstRow.getR() + i - 1)); List<Cell> currentRowResultCells = copyCells(templateRange, band, resultRow, templateCells); resultCells.addAll(currentRowResultCells); copyRowSettings(templateRow, resultRow, getWorksheet(templateRow), getWorksheet(resultRow)); } return resultCells; }
cellWithFormula.getF().setValue(newFormula); Row row = (Row) cellWithFormula.getParent(); Worksheet worksheet = getWorksheet(row); Set<Range> formulaRanges = Range.fromCellFormula(result.getSheetName(worksheet), cellWithFormula);
cellWithFormula.getF().setValue(newFormula); Row row = (Row) cellWithFormula.getParent(); Worksheet worksheet = getWorksheet(row); Set<Range> formulaRanges = Range.fromCellFormula(result.getSheetName(worksheet), cellWithFormula);
cellWithFormula.getF().setValue(newFormula); Row row = (Row) cellWithFormula.getParent(); Worksheet worksheet = getWorksheet(row); Set<Range> formulaRanges = Range.fromCellFormula(result.getSheetName(worksheet), cellWithFormula);
cellWithFormula.getF().setValue(newFormula); Row row = (Row) cellWithFormula.getParent(); Worksheet worksheet = getWorksheet(row); Set<Range> formulaRanges = Range.fromCellFormula(result.getSheetName(worksheet), cellWithFormula);