[XMLBEANS-475] Adding image using XSSF with previous images corrupts the entire file

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: Version 2.3
• Fix Version/s: Version 5.0.1
• Environment: Windows 7, eclipse, java 1.6
• Assignee: Unassigned
• Reporter: Michael Benoit
• Created: 06/Jan/12 20:58
• Updated: 11/Jul/21 22:06
• Resolved: 23/Jun/21 20:48

Description

When I try to add images to an xlsx file that already contains images, the image is appended as a fragment at the end of the file which causes Microsoft Office to say the file is corrupted and gives the option of trying to recover.

Workbook workbook = new XSSFWorkbook(doc);
Sheet sheet;
if(workbook.getNumberOfSheets() > 0){
sheet = workbook.getSheetAt(0);
} else {
sheet = workbook.createSheet();
}
Drawing patriarch = sheet.createDrawingPatriarch();
ClientAnchor anchor = workbook.getCreationHelper().createClientAnchor();
anchor.setCol1(10);
anchor.setRow1(1);
anchor.setDx1(100);
anchor.setDy1(190);
((XSSFDrawing) patriarch).createLinkedPicture(anchor,"a location");
workbook.write(outDoc);
doc.close();
outDoc.close();