LO Calc freeze while viewing spreadsheet

[Michael T]

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)

[penalvch (penalvch)]

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?

[Michael T (michaeltandy)]

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!

[penalvch (penalvch)]

Attachment original reporter had the issue occur with.

[penalvch (penalvch)]

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

[Michael T (michaeltandy)]

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.

[Michael T (michaeltandy)]

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.

[penalvch (penalvch)]

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

[Michael T (michaeltandy)]

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.

[penalvch (penalvch)]

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