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: [email protected] For additional commands, e-mail: [email protected]
