You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/08/28 05:04:53 UTC

DO NOT REPLY [Bug 45699] New: POI loses row/cell records when merged cell records are out of place

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: dev@poi.apache.org
        ReportedBy: josh@gildedtree.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 45699] POI loses row/cell records when merged cell records are out of place

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45699

Smitha <ma...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mandicha.smitha@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

DO NOT REPLY [Bug 45699] POI loses row/cell records when merged cell records are out of place

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45699


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2008-08-27 21:32:07 PST ---
Fixed in svn r689716

Junit added

Paul, do you know which application produced the file in question?


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org