Issue 126954 - Excel spreadsheet starts to open then hangs
Summary: Excel spreadsheet starts to open then hangs
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.2
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2016-05-05 12:36 UTC by goodse67
Modified: 2016-05-06 01:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.2
Developer Difficulty: ---

Attachments
Vendor spreadsheet. Prior months have converted without issue (67 bytes, text/plain)
2016-05-05 12:47 UTC, goodse67 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description goodse67 2016-05-05 12:36:02 UTC 
Spreadsheet starts to open then hangs.  Locks system so another spreadsheet cannot be opened.  Only way found to correct the problem is hardware reboot.
Comment 1 goodse67 2016-05-05 12:47:20 UTC 
Created attachment 85522 [details]
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.
Comment 2 orcmid 2016-05-05 15:19:28 UTC 
(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.).
Comment 3 Keith N. McKenna 2016-05-06 00:02:58 UTC 
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?
Comment 4 orcmid 2016-05-06 01:13:02 UTC 
(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.