I have encountered this problem also. I've written an app that iterates over
a hierarchy of data and uses POI XSSF to format that in a vertical table.
e.g. converting
Hazard
Risk
Risk Control
Risk
Risk Control
to an Excel output of:
Hazard Risk Risk Control
Risk Risk Control
I use the merge region capability to try and merge cells in the case where 1
Hazard has multiple Risks, or where 1 Risk has multiple Risk Controls.
I'm getting the same error as the posted above. I've attached the sheet1.xml
file from the ZIP that is outputted from POI and the version that MS Excel
repairs, to see if the difference is obvious.
http://apache-poi.1045710.n5.nabble.com/file/n4407440/XML_Sheets.zip
XML_Sheets.zip
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/XSSFSheet-addMergedRegion-giving-excel-error-tp3389764p4407440.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]
