RE: XSSFTable with Merged Ranges

2018-05-07 Thread Hayward, Ryan
> -Original Message- > From: Greg Woolsey [mailto:greg.wool...@gmail.com] > Sent: Tuesday, May 01, 2018 5:56 PM > To: POI Users List > Subject: Re: XSSFTable with Merged Ranges > > The best way I've found to work through issues like this (I also modify >

Re: XSSFTable with Merged Ranges

2018-05-01 Thread Greg Woolsey
The best way I've found to work through issues like this (I also modify tables, but don't need merged cells) is to mock up what I want it to end up like in Excel, save it to XLSX, mock up the same (or what I want to be the same) content via POI and save it to XLSX. I then unzip the files and compa

XSSFTable with Merged Ranges

2018-05-01 Thread Hayward, Ryan
I've been trying to use POI 3.17 to generate files with Excel Tables (e.g. XSSFTable table = sheet.createTable()) over cells with merged ranges. The file generates fine, but when opening it in Excel 2013, it shows a "we found a problem with some content..." error. Upon trying to recover, it re