poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From atulk <atul...@hotmail.com>
Subject Re: XSSFSheet.addMergedRegion giving excel error
Date Sat, 04 Jun 2011 00:11:56 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message