https://issues.apache.org/bugzilla/show_bug.cgi?id=56886
Bug ID: 56886
Summary: Unreadable content when inserting a column into an
Excel Table
Product: POI
Version: 3.10-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 31941
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31941&action=edit
zip file containing excel files used to reproduce the bugs, table1.xml and
diffs
Steps to reproduce:
In Excel:
1. add data to a sheet in a blank workbook
2. Select the range and make it a table (Excel > Insert > Tables > Table)
3. Insert a new column in the middle of the table.
4. Save the workbook as OOXML format
In POI:
5. Open, save, and close the workbook:
String input_filename = "Excel_does_not_find_unreadable_content.xlsx";
String output_filename = "Excel_finds_unreadable_content.xlsx";
Workbook wb = WorkbookFactory.create(FileInputStream(input_filename));
wb.write(FileOutputStream(File(output_filename)));
In Excel:
6. Open workbook. Excel dialog: "Excel found unreadable content in
<filename.xlsx>. Do you want to recover the contents of this workbook. If you
trust the source of this workbook, click Yes."
--
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]
