LO Calc freeze while viewing spreadsheet

Bug #1622386 reported by Michael T
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
New
Low
Unassigned

Bug Description

I was viewing the xls file from https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1622386/+attachment/4739554/+files/Multimeters%20April%202016%20Comments%20Autosized.xls in LibreOffice Calc when it froze and the window greyed out.

See https://youtu.be/r2YtF2utXgA for a demonstration of opening the file, applying autofilter, then waiting to get a crash.

ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: libreoffice-core 1:5.1.4-0ubuntu1
ProcVersionSignature: Ubuntu 4.4.0-36.55-generic 4.4.16
Uname: Linux 4.4.0-36-generic x86_64
NonfreeKernelModules: nvidia_uvm nvidia_drm nvidia_modeset nvidia
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
CurrentDesktop: Unity
Date: Sun Sep 11 21:55:50 2016
EcryptfsInUse: Yes
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2016-08-24 (18 days ago)
InstallationMedia: Ubuntu 16.04.1 LTS "Xenial Xerus" - Release amd64 (20160719)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Michael T (michaeltandy) wrote :
Revision history for this message
penalvch (penalvch) wrote :

Michael T, thank you for reporting this and helping make Ubuntu better.

1) Please attach the example file to this report (not post URLs, etc.).
2) After the freeze is there a crash file in /var/crash?

Changed in libreoffice (Ubuntu):
importance: Undecided → Low
status: New → Incomplete
Revision history for this message
Michael T (michaeltandy) wrote :

No file in /var/crash

Unfortunately I'm not the copyright holder for the problem file, so I probably shouldn't repost it. You know how open source projects can be about copyright!

Revision history for this message
penalvch (penalvch) wrote :

Attachment original reporter had the issue occur with.

description: updated
Revision history for this message
penalvch (penalvch) wrote :

Michael T, to clarify:
1) Is this issue consistently reproducible?
2) What keyboard click-for-click steps are required to reproduce this?

Revision history for this message
Michael T (michaeltandy) wrote :

To be honest I assumed the command line bug reporter would capture enough detail to identify the cause.

I've had it happen three or four times, but I can't get it to reproduce while my screen recorder is running. I've read everything I need to from that file, so I'm happy for you to close this bug report. Unfortunately I can't see an appropriate status for that - so feel free to close this report however you think best.

Revision history for this message
Michael T (michaeltandy) wrote :

Aha, got it to reproduce with the screen capture running. Here's a video: https://youtu.be/r2YtF2utXgA

Steps to reproduce, at least on my computer:
1. Open file
2. Select rows 2 to 356 and use Data -> Autofilter (not clearly shown in video, as the menu opened out of view)
3. Apply some filters
4. Wait about 10 minutes.

Michael T (michaeltandy)
description: updated
Revision history for this message
penalvch (penalvch) wrote :

Michael T, what filters precisely in a keyboard click-for-click fashion?

Revision history for this message
Michael T (michaeltandy) wrote :

I assume, from your questions, that you're having trouble getting this bug to reproduce!

Here's another video: https://youtu.be/o-Tu1bH_pdk

Procedure is:
1. Open the file with no other files open (bug happens whether you launch calc and use file->open or double-click the file on the desktop)
2. Click cell A2
3. Scroll to the bottom right of the data
4. Hold 'shift' to select a range, and click cell AU356
5. Choose the 'Data' menu and click 'Autofilter'
6. Deselect the large range and scroll up to row 2, where the filters have been created.
7. In column A expand the filter, uncheck the 'all' box, and check the 'UT61D' box (I have seen the crash with a variety of different filters applied - but I figure you want a single example.
8. Alt+Tab to a web browser and wait about 9-10 minutes.

Revision history for this message
penalvch (penalvch) wrote :

Not reproducible with me following steps verbatim:
lsb_release -rd && apt policy libreoffice-calc
Description: Ubuntu 16.04.1 LTS
Release: 16.04
libreoffice-calc:
  Installed: 1:5.1.4-0ubuntu1
  Candidate: 1:5.1.4-0ubuntu1
  Version table:
 *** 1:5.1.4-0ubuntu1 500
        500 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages
        500 http://us.archive.ubuntu.com/ubuntu xenial-security/main amd64 Packages
        100 /var/lib/dpkg/status
     1:5.1.2-0ubuntu1 500
        500 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 Packages

Changed in libreoffice (Ubuntu):
status: Incomplete → New
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.