poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: XSSFSheet.addMergedRegion giving excel error
Date Tue, 07 Jun 2011 21:34:08 GMT
On Fri, 3 Jun 2011, atulk wrote:
> However this does work fine for the older .xls files and Excel does not
> complain.

I guess this means that the .xlsx format is stricter. OOI, if you open a 
.xls file with overlapping regions in excel and save it as a .xlsx, how 
does excel itself resolve it?

> 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.

Sounds like a handy XSSF specific feature, please send in a patch if you 
manage to code something up to do it!

Cheers
Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message