Bug 57838 - Deleting rows in a sheet with comments does not delete comments.
Summary: Deleting rows in a sheet with comments does not delete comments.
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.12-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-21 01:19 UTC by Balaji Venkatamohan
Modified: 2016-05-29 21:34 UTC (History)
0 users



Attachments
Source folder of java test project with a Junit test class (9.95 KB, application/zip)
2015-04-21 01:19 UTC, Balaji Venkatamohan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Balaji Venkatamohan 2015-04-21 01:19:55 UTC
Created attachment 32668 [details]
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.
Comment 1 Dominik Stadler 2016-05-29 21:34:42 UTC
This should be fixed via r1746062, thanks for the bug-report!