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 2016/05/05 12:36:02 UTC

[Issue 126954] New: Excel spreadsheet starts to open then hangs

https://bz.apache.org/ooo/show_bug.cgi?id=126954

          Issue ID: 126954
        Issue Type: DEFECT
           Summary: Excel spreadsheet starts to open then hangs
           Product: Calc
           Version: 4.1.2
          Hardware: PC
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: goodse67@hotmail.com

Spreadsheet starts to open then hangs.  Locks system so another spreadsheet
cannot be opened.  Only way found to correct the problem is hardware reboot.

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

[Issue 126954] Excel spreadsheet starts to open then hangs

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

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|---                         |4.1.2
    Confirmation in|                            |
             Status|UNCONFIRMED                 |CONFIRMED
     Ever confirmed|0                           |1

--- Comment #4 from orcmid <or...@apache.org> ---
(In reply to Keith N. McKenna from comment #3)
> The attachment contains a link to download the xlsx file from degoo. I have
> downloaded the file and it does indeed hang AOO 4.1.2 on my Windows 7 system.

The file is over 2MB so it might not be accepted as an attachment for Bugzilla.

Opening the file in Excel 2016, I notice that there are three sheets.  Sheet3
is empty.  Sheet1 has 385 rows with data but there are at least 16980 rows
which appear to be mostly empty, except there are borders on the left on column
AC cells and on the right of column AE cells starting downward forever at row
16981.  Sheet2 has 42 used rows with no data but then has the peculiarities in
its blank material for many rows down to row 16980 and beyond.

Now for the interesting news.  

 1. I can also open the original file quickly and without difficulty in
LibreOffice 5.0.0.

 2. With Apache OpenOffice 4.1.2 on Windows 10 Pro x64, opening the file stalls
in Loading according to the status bar at the bottom of the page.  OpenOffice
is running, and its memory requirements are slowing increasing (though not to
any  shocking value).  It is difficult to know if it will complete in some
finite time.  It is clear that it is hung up attempting to convert the .xlsx
file.  I stopped the program after about 20 minutes.

 3. While I was waiting to see if AOO 4.1.2 would finish loading the document
before I needed to wrap this up, I did upload the .xlsx file to Microsoft
OneDrive.  I went to my OneDrive on the web using Internet Explorer and I was
then able to open the file there.  It opened with Excel Online just fine.  I
think just reading a file will work without a Microsoft Office account, just
with a OneDrive account.  THIS SHOULD BE TRIED AS A NEAR-TERM WORKAROUND.

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

[Issue 126954] Excel spreadsheet starts to open then hangs

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

--- Comment #1 from goodse67@hotmail.com ---
Created attachment 85522
  --> https://bz.apache.org/ooo/attachment.cgi?id=85522&action=edit
Vendor spreadsheet.  Prior months have converted without issue

Spreadsheet starts to convert then hangs.  Once it hangs I cannot open other
spreadsheets.  Must restart PC to fix problem.

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

[Issue 126954] Excel spreadsheet starts to open then hangs

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

Keith N. McKenna <kn...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |knmc@apache.org

--- Comment #3 from Keith N. McKenna <kn...@apache.org> ---
The attachment contains a link to download the xlsx file from degoo. I have
downloaded the file and it does indeed hang AOO 4.1.2 on my Windows 7 system.

goodse67 is it acceptable to upload the xlsx file here so that others can try
to troubleshoot the problem?

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

[Issue 126954] Excel spreadsheet starts to open then hangs

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

Theodore Matula <bu...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |buddymatula@gmail.com
           Keywords|                            |needmoreinfo

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

[Issue 126954] Excel spreadsheet starts to open then hangs

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

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |orcmid@apache.org

--- Comment #2 from orcmid <or...@apache.org> ---
(In reply to goodse67 from comment #1)
> Created attachment 85522 [details]
> Vendor spreadsheet.  

This is not the spreadsheet but a text file containing a link to degoo.com.

If possible, please provide the spreadsheet file itself.

Also, whether you can do that or not, please specify the format of the
spreadsheet (.ods, .xls, .xlsx, etc.).

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