Bug 62490 - Using column 16383 creates XLSX file which can't be opened by Excel 2016
Summary: Using column 16383 creates XLSX file which can't be opened by Excel 2016
Status: RESOLVED DUPLICATE of bug 61798
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-06-26 09:39 UTC by Jan Peter Stotz
Modified: 2018-06-27 08:07 UTC (History)
0 users


Attachments
PoiBug.java minimal example (1.38 KB, text/plain)
2018-06-26 09:39 UTC, Jan Peter Stotz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Peter Stotz 2018-06-26 09:39:05 UTC 
Created attachment 35989 [details]
PoiBug.java minimal example

The attached code creates an XLSX file which can't be opened by Excel 2016 (Excel reports error 101648 when pressing Ctrl+Shift+I in the error dialog)

The problem occurs if I use the column 16383:

Cell c = row.createCell(16383);

Tested with Excel 2016 (16.0.4705.1000).
Comment 1 Jan Peter Stotz 2018-06-26 14:45:48 UTC 
This bug was introduced with POI 3.16. With 3.15 everything works fine.
Comment 2 Andreas Beeker 2018-06-26 16:06:33 UTC 
Maybe this is related to [1] - does it work with a nightly?

[1] https://bz.apache.org/bugzilla/show_bug.cgi?id=61798
Comment 3 Jan Peter Stotz 2018-06-27 08:07:58 UTC 
I just made a test with the nightly version. Using nightly the created xlsx file does not show any error when opened in Excel.

*** This bug has been marked as a duplicate of bug 61798 ***