Bug 60642 - clone sheet with graphic images, rects and textboxs
Summary: clone sheet with graphic images, rects and textboxs
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.15-FINAL
Hardware: PC Linux
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-25 14:12 UTC by Metehan MERAL
Modified: 2017-01-25 14:14 UTC (History)
1 user (show)



Attachments
Sample document (28.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-01-25 14:12 UTC, Metehan MERAL
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Metehan MERAL 2017-01-25 14:12:06 UTC
Created attachment 34673 [details]
Sample document

Dear Sir or Madam,
I cloned a sheet , than I copied its relations and pagesetup options from source sheet to target sheet. But I can't see the relations (etc: graphics images,rects, texboxes.. ) on the new sheet of saved workbook.

wb.cloneSheet(0);
sheet=wb.getSheetAt(1);
for(POIXMLDocumentPart dp:wb.getSheetAt(0).getRelations())
{
	sheet.getRelations().add(dp);
}
sheet.getCTWorksheet().setPageSetup(wb.getSheetAt(0).getCTWorksheet().getPageSetup());

1- Can not copy clone command the relations automatically?
2- If not, how can we clone a sheet completely?

You can look for attached excel document.