https://bz.apache.org/bugzilla/show_bug.cgi?id=57828
Bug ID: 57828
Summary: Shifting rows with cell comments only shifts comments
from first such cell. Other cell comments not shifted
Product: POI
Version: 3.12-dev
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
I am using POI for simple CRUD operations on excel files. Once such operation
is deleting and shifting of rows in a sheet. Unfortunately, both these
operations don't work as expected when a row that I need to delete/shift has
one or more cell comments.
I noticed the following line in this page https://poi.apache.org/changes.html :
56017 - Fix shifting comments with shifted rows
Since POI 3.12 beta 2 is not out yet, I used the latest stable SVN revision
1674025 to download the source code and followed the build instructions to
build the 3.12 beta2 binaries.
I used a simple stand alone program to shift rows with comments in an excel
sheet using POI apis.
When a row has only one cell comment, that row is being properly shifted.
However, when a row has more than one cell with comments, only the first
comment gets properly shifted along with its cell. The other remaining comments
stay in that exact same cell number/row number position with only the
corresponding cell's data being shifted.
Attaching a simple java project with a Junit test class
ShowShiftRowsWithCommentsBugTest.java . Please note all the jars needed are
under libs folder of this project. The excel sheet is also in the classpath
/src/resources/deletewithcomments.xlsx
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
