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: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.7.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: (X)HTML-Export
  Show dependency treegraph
 
Reported: 2013-01-14 14:08 UTC by Nemo_bis
Modified: 2022-04-16 06:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
ods in question (915.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-14 14:08 UTC, Nemo_bis
Details
PDF export of column C (2.61 MB, application/x-bzip)
2015-05-03 08:18 UTC, Nemo_bis
Details
Export of column C from LibreOffice 7 (2.78 MB, application/pdf)
2022-04-16 06:06 UTC, Nemo_bis
Details

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

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: 4.2.0.1
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 4.2.8.2 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 5.0.6.2-10.fc23 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
Version: 7.0.0.0.alpha0+
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
Comment 9 QA Administrators 2022-04-16 03:51:57 UTC Comment hidden (obsolete)
Comment 10 Nemo_bis 2022-04-16 06:05:41 UTC
New test with LibreOffice 7.2.6.2 20 on AMD A8-7600. I still can't find the XHTML export.

Opening the ods and exporting it to PDF took about 7 minutes in total, significantly less than before:

$ time libreoffice /tmp/mediawikis.ods 
real    7m13,510s
user    5m54,299s
sys     0m14,462s

Exporting just column C took few seconds and the export seems correct. The bug as described by the current summary is therefore fixed.
Comment 11 Nemo_bis 2022-04-16 06:06:13 UTC
Created attachment 179604 [details]
Export of column C from LibreOffice 7
Comment 12 Nemo_bis 2022-04-16 06:09:22 UTC
Version: 7.2.6.2
Build ID: 20(Build:2)
CPU threads: 4; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb)
Locale: it-IT (it_IT.UTF-8); UI: it-IT
Calc: threaded