[upstream] Calc freezes for 15 seconds - 3 minutes when pasting in html data

Bug #350193 reported by moma on 2009-03-28
28
This bug affects 4 people
Affects Status Importance Assigned to Milestone
LibreOffice
Invalid
Low
OpenOffice
Confirmed
Unknown
gnumeric (Ubuntu)
Undecided
Unassigned
libreoffice (Ubuntu)
Medium
Unassigned
openoffice.org (Ubuntu)
Low
Unassigned

Bug Description

Binary package hint: openoffice.org2
Binary package hint: libreoffice

1)
OOo:
Ubuntu jaunty 64bits (development branch)

LibreOffice Natty:
lsb_release -rd
Description: Ubuntu Natty (development branch)
Release: 11.04

LibreOffice Maverick:
lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

2)
OOo:
Version: 1:3.0.1-7ubuntu1

LibreOffice Natty:
apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu2
  Candidate: 1:3.3.2-1ubuntu2
  Version table:
 *** 1:3.3.2-1ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 100
/var/lib/dpkg/status

apt-cache policy firefox
firefox:
  Installed: 4.0~rc2+build3+nobinonly-0ubuntu2
  Candidate: 4.0~rc2+build3+nobinonly-0ubuntu2
  Version table:
 *** 4.0~rc2+build3+nobinonly-0ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
        100 /var/lib/dpkg/status

LibreOffice Maverick:
apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu2~maverick1
  Candidate: 1:3.3.2-1ubuntu2~maverick1
  Version table:
 *** 1:3.3.2-1ubuntu2~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

apt-cache policy firefox
firefox:
  Installed: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Candidate: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Version table:
 *** 3.6.16+build1+nobinonly-0ubuntu0.10.10.1 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu/ maverick-security/main i386 Packages
        100 /var/lib/dpkg/status
     3.6.10+build1+nobinonly-0ubuntu3 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick/main i386 Packages

3) What is expected to happen is when one performs via the Terminal:

firefox https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/350193/+attachment/516406/+files/test-data.html && localc -nologo

secondary click the center of the table in Firefox -> click Select All -> secondary click the center of the table in Firefox -> click Copy -> in Calc secondary click cell C7 -> click Paste

 it does so quickly and successfully.

4) What happens instead is that it hangs Calc for a long time (15 seconds - 3 minutes) then pastes or hangs Calc indefinitely.

WORKAROUND: Copying from Firefox and pasting into Gnumeric has no delay.

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy gnumeric
gnumeric:
  Installed: 1.10.13-1ubuntu1
  Candidate: 1.10.13-1ubuntu1
  Version table:
 *** 1.10.13-1ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
        100 /var/lib/dpkg/status

moma (osmoma) wrote :
Chris Cheney (ccheney) wrote :

confirmed on official OOo 3.0.1

Changed in openoffice.org:
importance: Undecided → Medium
status: New → Triaged
Changed in openoffice:
status: Unknown → Confirmed
Chris Cheney (ccheney) on 2009-12-01
summary: - OOo calc freezes when pasting in html data.
+ [upstream] OOo calc freezes for a long time (15s+) when pasting in html
+ data.

I had 4 documents and all of them freezed. there was image element nearly 100 times used but it is the only one image!

moma (osmoma) wrote :

The bug is still in LibreOffice after so many years. Why?

LibreOffice calc freezes when I paste the test data to it.

$ uname -a
Linux natty64 2.6.38-7-generic #39-Ubuntu SMP Fri Mar 25 21:24:57 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu2

Jack Leigh (leighman) wrote :

Which browser are you pasting from?
I cannot confirm when pasting from Opera

moma (osmoma) wrote :

I have tested this with Firefox and Chromium browser. The result is the same. I've waited several minutes and LibreOffice calc blocks. Maybe the underlying data has web URL links?

Take a look at the attached video.

Notice: This machine runs Ubuntu 11.04 beta (Natty) with latest updates.

description: updated
moma (osmoma) wrote :
moma (osmoma) wrote :

You are right.
Import works right when I copy/paste it from the Opera browser.
LibreOffice calc opens the "Text Import" dialog and it imports data right. I've tested this several times copying/pasting from Firefox, Chromium(daily) and Opera. Only copy from Opera succeeds.

Thanks.

Jack Leigh (leighman) on 2011-04-05
Changed in libreoffice (Ubuntu):
status: New → Incomplete
Jack Leigh (leighman) wrote :

I'm afriad I can't reproduce it in any browser here using the method in your video
I'm using the Classic desktop does it still occur with that?

moma, copying from Firefox into LibreOffice Calc hangs Calc for quite a few seconds before pasting. This delay does not occur pasting into Gnumeric. Marking Confirmed.

lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu2~maverick1
  Candidate: 1:3.3.2-1ubuntu2~maverick1
  Version table:
 *** 1:3.3.2-1ubuntu2~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

apt-cache policy firefox
firefox:
  Installed: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Candidate: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Version table:
 *** 3.6.16+build1+nobinonly-0ubuntu0.10.10.1 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu/ maverick-security/main i386 Packages
        100 /var/lib/dpkg/status
     3.6.10+build1+nobinonly-0ubuntu3 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick/main i386 Packages

apt-cache policy gnumeric
gnumeric:
  Installed: 1.10.8-1ubuntu1
  Candidate: 1.10.8-1ubuntu1
  Version table:
 *** 1.10.8-1ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick/universe i386 Packages
        100 /var/lib/dpkg/status

Changed in libreoffice (Ubuntu):
status: Incomplete → Confirmed
summary: - [upstream] OOo calc freezes for a long time (15s+) when pasting in html
+ [upstream] Calc freezes for a long time (15s+) when pasting in html
data.

Leighman,
I made a careful test on Ubuntu 10.10 (Maverick with GNOME 2.32.0) and the result is _exactly_ the same. Copy from Firefox and Chromium fails/blocks totally. Copy from Opera works fine. All my systems are 64bit Ubuntus.

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu2~maverick1

$ uname -a
Linux maverick64 2.6.35-24-generic #42-Ubuntu SMP Thu Dec 2 02:41:37 UTC 2010 x86_64 GNU/Linux

description: updated
tags: added: lo33

moma, since this bug has enough information provided for a developer to begin work, I'm going to mark it as Triaged and let them handle it from here. Thanks for taking the time to make Ubuntu better!

description: updated
Changed in libreoffice (Ubuntu):
status: Confirmed → Triaged
importance: Undecided → Medium
summary: - [upstream] Calc freezes for a long time (15s+) when pasting in html
- data.
+ [upstream] Calc freezes for 15 seconds - 3 minutes when pasting in html
+ data

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/350193

1) lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu2~maverick1
  Candidate: 1:3.3.2-1ubuntu2~maverick1
  Version table:
 *** 1:3.3.2-1ubuntu2~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

apt-cache policy firefox
firefox:
  Installed: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Candidate: 3.6.16+build1+nobinonly-0ubuntu0.10.10.1
  Version table:
 *** 3.6.16+build1+nobinonly-0ubuntu0.10.10.1 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu/ maverick-security/main i386 Packages
        100 /var/lib/dpkg/status
     3.6.10+build1+nobinonly-0ubuntu3 0
        500 http://us.archive.ubuntu.com/ubuntu/ maverick/main i386 Packages

3) What is expected to happen is when one performs via the Terminal:

firefox https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/350193/+attachment/516406/+files/test-data.html && localc -nologo

secondary click the center of the table in Firefox -> click Select All -> secondary click the center of the table in Firefox -> click Copy -> in Calc secondary click cell C7 -> click Paste

it does so quickly and successfully.

4) What happens instead is that it hangs Calc for a long time (15 seconds - 3 minutes) then pastes or hangs Calc indefinitely.

Changed in df-libreoffice:
importance: Unknown → Low
status: Unknown → Confirmed

another one for you, Bjoern

Changed in df-libreoffice:
status: Confirmed → In Progress
description: updated
Changed in gnumeric (Ubuntu):
status: New → Invalid

moma, please execute the following command, as it will automatically gather debugging information, in a terminal:
apport-collect 350193
When reporting bugs in the future please use apport by using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

Changed in openoffice.org (Ubuntu):
importance: Medium → Low
status: Triaged → Incomplete
Changed in openoffice.org (Ubuntu):
status: Incomplete → Won't Fix

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

This would need to be fix upstream, if confirmed. => Wontfix in ubuntu packaging.

However, note my remarks on the upstream bug.

Changed in libreoffice (Ubuntu):
status: Triaged → Won't Fix

Works as expected with 3.4.3-3ubuntu1. Also the test document contains unresolvable links to host "some-url.no" so a certain delay has to be expected. => WORKSFORME

To clarify: there is _no_ delay here with 3.4.3

Changed in df-libreoffice:
status: In Progress → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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