[Bug 64759] New: cloneSheet

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64759] New: cloneSheet

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64759] Can't clone sheet - unknown relation type found: http://schemas.microsoft.com/office/2017/10/relationships/threadedComment

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

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
            Summary|cloneSheet                  |Can't clone sheet - unknown
                   |                            |relation type found:
                   |                            |http://schemas.microsoft.co
                   |                            |m/office/2017/10/relationsh
                   |                            |ips/threadedComment

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64759] Can't clone sheet - unknown relation type found: http://schemas.microsoft.com/office/2017/10/relationships/threadedComment

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64759

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|regression                  |normal

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64759] Can't clone sheet - unknown relation type found: http://schemas.microsoft.com/office/2017/10/relationships/threadedComment

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64759

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |56205

--- Comment #1 from Dominik Stadler <[hidden email]> ---
Bug #56205 updates to a newer edition of the OOXML schema, however even the 5th
edition of the standard is from 2015, so without taking a closer look this one
likely is still not included as it has "2017" in the type-URI.


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=56205
[Bug 56205] [PATCH] Upgrade OOXML schema to 3rd edition (transitional)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64759] Can't clone sheet - unknown relation type found: http://schemas.microsoft.com/office/2017/10/relationships/threadedComment

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64759

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]