Hi, We are using POI 3.1 and are trying to upgrade to POI 3.7 to provide XSLX files. I am facing a similar problem as being described above.
The problem seems to be that if you have a duplicate mergecell definition (you add the same merge region twice) or if you have a conflicting mergecell definition then you get this error when opening the file in Excel. Excel tells us that some data might be lost. However this does work fine for the older .xls files and Excel does not complain. Is this a POI bug or Excel bug? Seems like POI could provide some error if conflicting merge regions are added or provide a validation routine to see if a sheet contains conflicting merge regions and drop duplicates if they are specified that would be great. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSFSheet-addMergedRegion-giving-excel-error-tp3389764p4452951.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
