https://issues.apache.org/bugzilla/show_bug.cgi?id=56017
--- Comment #9 from Mikalai Zhudro <[email protected]> --- I was able to reproduce this bug with Excel 2010. (poi 3.11 Final) My further investigation shows that problem lies in following code: XSSFSheet.java:2567 if(sheetComments != null){ //TODO shift Note's anchor in the associated /xl/drawing/vmlDrawings#.vml CTCommentList lst = sheetComments.getCTComments().getCommentList(); for (CTComment comment : lst.getCommentArray()) { String oldRef = comment.getRef(); CellReference ref = new CellReference(oldRef); if(ref.getRow() == rownum){ ref = new CellReference(rownum + n, ref.getCol()); comment.setRef(ref.formatAsString()); sheetComments.referenceUpdated(oldRef, comment); } } } I looked at /xl/drawing/vmlDrawings#.vml and note's anchor was not shifted. So I updated this file manually and was able to open excel file without problem. Can somebody implement this TODO?? -- 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]
