Calc almost freezes on full table operations

[dronus]

When Calc as of Ubuntu 14.04 LTS is forced to do some calculation on complete columns or tables, it can take a very long time or freeze altogether, even if there is very little data in the table.

For example, create a table with some number series about 1000 rows in some columns. Press Ctrl+A to select the whole table. Press 'Sort'. Calc does not respond to user interaction for a very long time now.

If the used part of the table is selected by Shift+Ctrl+End instead, the sorting completes almost instantly.

This problem may happen with many other operations too, and also triggers on full column selections (just click the column header) too.

I think this is a mayor issue, as users can run into this in several ways (column- or full table selection, several operations) and may force them to force-quit Calc, loosing data.

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: libreoffice-calc 1:4.2.8-0ubuntu3
ProcVersionSignature: Ubuntu 3.19.0-42.48~14.04.1-generic 3.19.8-ckt10
Uname: Linux 3.19.0-42-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.19
Architecture: amd64
CurrentDesktop: Unity
Date: Wed Jan 6 23:03:40 2016
EcryptfsInUse: Yes
InstallationDate: Installed on 2015-11-22 (45 days ago)
InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[penalvch (penalvch)]

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

Could you please attach an example file that demonstrates the problem?

Also, as a WORKAROUND, one may see if one of the following PPAs alleviates the issue via https://launchpad.net/~libreoffice.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]