https://issues.apache.org/bugzilla/show_bug.cgi?id=45699
Summary: POI loses row/cell records when merged cell records are
out of place
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P4
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Follow-on from bug 45698.
After fixing that bug, POI can read+write back the same sample file (attachment
(id=22488)) without throwing an exception, but some data is lost. The output
file is less than 1.4Mb but probably should be more than 4Mb. Excel opens the
output file without reporting an error. However, all but a few rows of content
is lost from most sheets. Sheets without merged cells seem unaffected.
The problem seems to stem from the presence of MERGEDCELLS records between the
row/cell records. The OOO documentation suggests that MERGEDCELLS should be
written after the 'Sheet View Settings Block' which is well after the Row
Blocks. Excel(2007) seems to follow this standard.
This example file was probably created by some other application besides Excel.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
