Bug 59360 - XHTML export of selected cells is much slower than full export
Summary: XHTML export of selected cells is much slower than full export
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Keywords: perf
Depends on:
Blocks: HTML-Export
  Show dependency treegraph
Reported: 2013-01-14 14:08 UTC by Nemo_bis
Modified: 2020-04-15 16:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

ods in question (915.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-14 14:08 UTC, Nemo_bis
PDF export of column C (2.61 MB, application/x-bzip)
2015-05-03 08:18 UTC, Nemo_bis

Note You need to log in before you can comment on or make changes to this bug.
Description Nemo_bis 2013-01-14 14:08:52 UTC
Created attachment 73010 [details]
ods in question

When I select a column in the attached file and try to export it from File->Export, variant HTML, LibreOffice takes all CPU and never ends the job (the progress bar for "saving" is stuck near the end).
The first time I've tried exporting about 6000 columns and after half a day it wasn't done yet; then I tried about 1500 and it happened the same.

This shouldn't be the same as bug 37878.

The table was created by copy and pasting from http://wikistats.wmflabs.org/display.php?t=mw , in case this matters.
Comment 1 retired 2013-11-08 22:26:30 UTC
Tried verifying this bug report, but when opening the attached test ods with LO

CPU spikes to 100% and opening the file took ages. After 5 minutes and still not loaded I force quit LO.

Same with LO 4.2a1. Tested on OS X 10.9.
Comment 2 sophie 2014-01-08 10:41:06 UTC
Hi, it took a lot of time to load the document, but was able to do so. I selected column D and goes to File > Export > XHTML, and then was forced to quit because Calc became unresponsive (Save in progress bar almost reached the end too)
Using Version:
Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a - Set to New - Sophie
Comment 3 Joel Madero 2015-05-02 15:42:52 UTC Comment hidden (obsolete)
Comment 4 Nemo_bis 2015-05-03 08:18:46 UTC
Created attachment 115284 [details]
PDF export of column C

I can't reproduce this bug any longer because I no longer find the XHTML export option in the menu. Where is it?

I can confirm that loading the document and exporting it to PDF (the only option I find) takes a very long time. I left the export running during the night and I got the attached PDF.

$ libreoffice --version
LibreOffice 420(Build:2)
$ uname -a
Linux 3.18.9-100.fc20.x86_64 #1 SMP Mon Mar 9 16:27:23 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
Comment 5 QA Administrators 2016-09-20 09:36:50 UTC Comment hidden (obsolete)
Comment 6 Nemo_bis 2016-09-20 12:11:25 UTC
For me the sheet loaded in 10 CPU minutes with LibreOffice on an AMD A8-7600.

I no longer find the export to HTML in the export menu. Export to PDF completed in about 11 minutes.
Comment 7 QA Administrators 2018-06-27 02:48:05 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2020-04-15 16:03:41 UTC
I confirm it is slower to export "Selection" with a column selected (maybe 1-2 minutes) than it is when nothing is selected (maybe 20 sec).

Arch Linux 64-bit
Build ID: b267650fd097f16d1b31c87a11a497294ad4ee42
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 15 April 2020