poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56017] New: Shifting rows with comment result - Unreadable content error and comment deletion
Date Thu, 16 Jan 2014 10:04:58 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56017

            Bug ID: 56017
           Summary: Shifting rows with comment result - Unreadable content
                    error and comment deletion
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: yevsjunk@gmail.com

If I try to shiftrows that contains comments nad open excel document in Excel I
get a popup warning Message "Unreadable content..." that says that comments
were deleted.

How to reproduce:
Create new Excel 2007 Document, in first cell (A1) add comment (any text).

Run code:

FileInputStream inputStream = null;
FileOutputStream outputStream = null;
XSSFWorkbook book = null;

try {
    inputStream = new FileInputStream("c://1//Test.xlsx");
    book = new XSSFWorkbook(inputStream);

    XSSFSheet sheet = book.getSheetAt(0);

    sheet.shiftRows(0, 1, 1);

    outputStream = new FileOutputStream("c://1//Test.xlsx");
    book.write(outputStream);
    outputStream.close();

}

-- 
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


Mime
View raw message