[Bug 62581] New: If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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

[Bug 62581] New: If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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

            Bug ID: 62581
           Summary: If source sheet of cloneSheet has comments, adding
                    more comments creates inconsistant xlsx
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Related info:
https://stackoverflow.com/questions/51559133/poi-3-17-creating-cell-comments-in-a-cloned-sheet-creates-inconsistent-xlsx

How to reproduce:
- Source sheet contains comments
- Use cloneSheet to copy
- Create new comment in new sheet
- Save
- Open file with Excel

Result:
Excel wants to recover the excel. Afterwards the comments from the original
sheet are gone.

Workaround stated in url reference is working.

--
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 62581] If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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

Ed Holland <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                URL|                            |https://stackoverflow.com/q
                   |                            |uestions/51559133/poi-3-17-
                   |                            |creating-cell-comments-in-a
                   |                            |-cloned-sheet-creates-incon
                   |                            |sistent-xlsx
                 OS|                            |All

--
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 62581] If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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=62581

--- Comment #1 from PJ Fanning <[hidden email]> ---
I suspect it would be better to rewrite cloneSheet to use the XSSF APIs to
create a new sheet and to copy the data and comments from the source sheet
instead of trying to work at the low-level CT generated class level and cloning
all the relationships.

--
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 62581] If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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=62581

--- Comment #2 from [hidden email] ---
A related problem regarding cloneSheet with comments is that removing the
comment from the cloned sheet produces a NullPointerException in
XSSFCell.java:1087 (POI 4.1.1)

Attached a sample to reproduce.

--
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 62581] If source sheet of cloneSheet has comments, adding more comments creates inconsistant xlsx

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=62581

--- Comment #3 from [hidden email] ---
Created attachment 36997
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36997&action=edit
Test case

--
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]