DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44070>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=44070 Summary: Comments will not shift Product: POI Version: 3.0-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] If you have a Cells with comments and you want to shift them up or down, the Cell Values will be shift, but not the Comments: POIFSFileSystem fileSystem = new POIFSFileSystem(new FileInputStream("comments.xls")); HSSFWorkbook workbook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workbook.getSheet("Sheet1"); sheet.shiftRows(1, sheet.getLastRowNum(), 1, true, true); workbook.write(new FileOutputStream("comments-error.xls")); In this Example the Comment in comments.xls is in the same row as in comments-error.xls but it must be at row+1 -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
