You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/04/21 03:19:55 UTC

[Bug 57838] New: Deleting rows in a sheet with comments does not delete comments.

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

            Bug ID: 57838
           Summary: Deleting rows in a sheet with comments does not delete
                    comments.
           Product: POI
           Version: 3.12-dev
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: bvenkata@tibco.com

Created attachment 32668
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32668&action=edit
Source folder of java test project with a Junit test class

Using XssfSheet.removeRow(row0), only deletes cell values. If any cell in row0
contained comments, they are not deleted and are retained in the same cell
address. This causes unpredictable behavior in the saved / modified excel file
and opening this saved workbook may or may not open properly.

Expected: When I remove a row from sheet, I expect all the cells along with its
values and comments to be removed. Comments should not be left dangling.

Attaching a simple java project's source folder with a Junit test class
DeleteRowsWithComments.java . The excel sheet is also in the classpath
/src/resources/deletewithcomments.xlsx.

The POI and OOXML libs used for this project were built from revision r1674975
of POI source.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57838] Deleting rows in a sheet with comments does not delete comments.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57838

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
This should be fixed via r1746062, thanks for the bug-report!

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57838] Deleting rows in a sheet with comments does not delete comments.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57838

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org