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

[moma]

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

[Chris Cheney (ccheney)]

confirmed on official OOo 3.0.1

[nerkn (erkintek-gmail)]

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)]

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)]

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

[moma (osmoma)]

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.

[moma (osmoma)]

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)]

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?

[penalvch (penalvch)]

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

[moma (osmoma)]

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

[penalvch (penalvch)]

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!

[penalvch (penalvch)]

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.

[Fridrich (fridrich-strba)]

another one for you, Bjoern

[penalvch (penalvch)]

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.

[Björn Michaelsen (bjoern-michaelsen)]

[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.

[Björn Michaelsen (bjoern-michaelsen)]

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

However, note my remarks on the upstream bug.

[Björn Michaelsen (bjoern-michaelsen)]

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

[Björn Michaelsen (bjoern-michaelsen)]

To clarify: there is _no_ delay here with 3.4.3

[Björn Michaelsen (bjoern-michaelsen)]

closing