https://bz.apache.org/bugzilla/show_bug.cgi?id=64759

            Bug ID: 64759
           Summary: cloneSheet
           Product: POI
           Version: 4.1.1-FINAL
          Hardware: Macintosh
            Status: NEW
          Severity: regression
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: pankaj.chaudh...@workday.com
  Target Milestone: ---

Created attachment 37461
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37461&action=edit
Payload file

Hi,

I am using POI 4.1.1 and latest Excel format (Office 365 Excel version :
16.39). My Excel sheet has cells with some comments in it, when I try to clone
this sheet it fails with following error. Can you please suggest a solution for
this.

Exception in thread "main" org.apache.poi.ooxml.POIXMLException: Can't clone
sheet - unknown relation type found:
http://schemas.microsoft.com/office/2017/10/relationships/threadedComment
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.addRelation(XSSFWorkbook.java:696)
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:627)
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:581)
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.cloneSheet(XSSFWorkbook.java:118)
        at poi.main(poi.java:14)


-----------------------------------------------------------------------------

public static void main(String[] args) throws Exception {
        Workbook workbook = WorkbookFactory.create(new
FileInputStream("Sample.xlsx"));

        Sheet cloned = workbook.cloneSheet(0);

        System.out.println("Clone Successful : "+ cloned);
    }

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to