You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/11/04 13:35:20 UTC

[Bug 123624] New: Big table with more than 65536 cells gets damaged when saving

https://issues.apache.org/ooo/show_bug.cgi?id=123624

            Bug ID: 123624
        Issue Type: DEFECT
           Summary: Big table with more than 65536 cells gets damaged when
                    saving
           Product: Writer
           Version: 4.0.1
          Hardware: All
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: save-export
          Assignee: issues@openoffice.apache.org
          Reporter: andy.versal@gmail.com
                CC: issues@openoffice.apache.org

When saving odt document with table that has more than 64K cells, it damaged
after opening saved document.
Test case in attachment. 
1. Open attached document "2521.odt". Table has 26 columns and 2521 rows
2. Save it as "odt" with different name
3. Open saved document - table damaged

4. Open attached document "2520.odt". Table has 26 columns and 2520 rows.
5. Delete last 10 rows from table
6. Save it as "odt" with different name
7. Open saved document - table ok

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #4 from andy.versal@gmail.com ---
I tested this issue on LibreOffice 4.1.2.3 - everything ok

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #11 from andy.versal@gmail.com ---
(In reply to jimmore295 from comment #9)
> On Win 7 with Open Office 4.0.1 I could not replicate this.  I attempted to
> open the sample documents and both refused to open on my system.  I created
> a sheet Excel with 2^16 - 26 cells (26 x 2520).  This file opened in Calc
> without a problem.  In Excel I increased the rows to 2521, this file also
> opened in Calc.  I repeated this process with 2522, 2523...on up to 2550
> rows.  Calc opened all the produced files.

Try to save this files in odt format.
There is no problem with opening, but with saving - yes

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|IRREPRODUCIBLE              |---
     Ever confirmed|0                           |1

--- Comment #16 from Edwin Sharp <el...@apache.org> ---
sorry for missing it.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #8 from kelleybp@iupui.edu ---
I successfully replicated the bug in 4.0.1 using Windows 7 64 bit.  Following
the steps laid out by andy.versal@gmail.com, the renamed 2521.odt file's table
was absolutely destroyed.  

Also, I can also confirm that the renamed file has been converted from odf 1.0
to 1.2, though with errors.  In fact, both test files are 1.0, and both renamed
test files are incorrectly 1.2.  I'm not sure how much this has to do with the
formatting problem, as the renamed 2520.odt file still displays correctly,
despite the poor conversion.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #7 from chopf@iupui.edu ---
Following the steps (skipping 5 as specified), I can verify that 2520 does
indeed work properly, and 2521 does break when re-opened. 
Both of these files have a quite long loading time, and they do make open
office "not respond" for a short while, but will eventually open. 
When the new version of 2521.odt does finally open, each row has only one cell,
and then there is one row at the very bottom with about 10 cells in the row.
Replicated on Ver 4.0.1 on a Win7 machine.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

jimmore295@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jimmore295@gmail.com

--- Comment #9 from jimmore295@gmail.com ---
On Win 7 with Open Office 4.0.1 I could not replicate this.  I attempted to
open the sample documents and both refused to open on my system.  I created a
sheet Excel with 2^16 - 26 cells (26 x 2520).  This file opened in Calc without
a problem.  In Excel I increased the rows to 2521, this file also opened in
Calc.  I repeated this process with 2522, 2523...on up to 2550 rows.  Calc
opened all the produced files.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #13 from Edwin Sharp <el...@apache.org> ---
No info from author.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #2 from andy.versal@gmail.com ---
> 1. Open attached document "2521.odt". Table has 26 columns and 2521 rows
> 2. Save it as "odt" with different name
> 3. Open saved document - table damaged
> 
> 4. Open attached document "2520.odt". Table has 26 columns and 2520 rows.
> 6. Save it as "odt" with different name
> 7. Open saved document - table ok

sorry, step 5 not needed. I was wrong

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

smc967@yahoo.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |smc967@yahoo.com

--- Comment #6 from smc967@yahoo.com ---
Replicated the defect utilizing your test case on AOO401m5(Build:9714)  -  Rev.
1524958, Windows 7 Home Premium 64 bit.  However any attempts to modify the
test documents crashed Writer.  I attempted to replicate the bug by creating my
own table of the same dimensions and could not replicate the defect.  Perhaps
in your document you could work around the defect by creating two tables rather
than one large one to get the same appearance.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #1 from andy.versal@gmail.com ---
Created attachment 81878
  --> https://issues.apache.org/ooo/attachment.cgi?id=81878&action=edit
Test case

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo
                 CC|                            |elish@apache.org

--- Comment #12 from Edwin Sharp <el...@apache.org> ---
step 1 - no 2521.odt in attachment 81878 ?

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|needmoreinfo                |
             Status|REOPENED                    |CONFIRMED
             Latest|---                         |4.1.0
    Confirmation on|                            |
                 OS|Windows XP                  |All

--- Comment #17 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m18(Build:9764)  -  Rev. 1589052
2014-04-22 12:11 - Linux x86_64
Debian

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #14 from andy.versal@gmail.com ---
Created attachment 83336
  --> https://issues.apache.org/ooo/attachment.cgi?id=83336&action=edit
screen shot

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

sepana7@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |sepana7@gmail.com

--- Comment #10 from sepana7@gmail.com ---
I replicated this bug with version 4.0.1 on Windows 7 64-bit. When loading and
saving the files it was very slow and was "(Not Responding)" at several
moments, although this is likely just due to the large size of the table within
the document.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

araker@iupui.edu changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |araker@iupui.edu

--- Comment #5 from araker@iupui.edu ---
araker 11/13/2013

I tried replicated the bug using your test_case and the steps provided but it
crashed my OpenOffice Writer perhaps a new test_case file is needed before this
bug can be fixed.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123624] Big table with more than 65536 cells gets damaged when saving

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

Prosper Uniger <fi...@web.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |firstofnone@web.de

--- Comment #3 from Prosper Uniger <fi...@web.de> ---
the file is odf version 1.0 when saved as new it is converted to odf 1.2

When I validate the new corrupt file
http://odf-validator.rhcloud.com/

there are lots of errors

> The document is NOT conformant ODF1.2!
> Details:
> 2521b.odt/styles.xml[2,1413]: Error: element "office:document-styles" is missing "version" attribute
> 2521b.odt/content.xml[2,1637]: Error: element "office:document-content" is missing "version" attribute
> 2521b.odt/content.xml[2,2980]: Error: unexpected attribute "style:keep-together"
> 2521b.odt/content.xml[2,5060]: Error: uncompleted content model. expecting: <covered-table-cell>,<table-cell>
> ...
> 2521b.odt/content.xml[2,127442]: Error: uncompleted content model. expecting: <covered-table-cell>,<table-cell>
> 2521b.odt: Info: Generator: OpenOffice/4.0.1$Win32 
> OpenOffice.org_project/401m5$Build-9714

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 123624] Big table with more than 65536 cells gets damaged when saving

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

--- Comment #15 from andy.versal@gmail.com ---
(In reply to Edwin Sharp from comment #12)
> step 1 - no 2521.odt in attachment 81878 [details] ?

attachment 81878 is an winrar archive. try unpack it.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.