Bug 117309 - Problem with .pdf export of large spreadsheet (~42.000 rows)
Summary: Problem with .pdf export of large spreadsheet (~42.000 rows)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-28 08:44 UTC by John Kjersgaard
Modified: 2018-06-03 21:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
.ods calc spreadsheet (1.75 MB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-28 17:52 UTC, John Kjersgaard
Details

Note You need to log in before you can comment on or make changes to this bug.
Description John Kjersgaard 2018-04-28 08:44:20 UTC
Description:
I have two large spreadsheets which I frequently export as .pdf. The one with ~42.000 rows takes hours to finish in both M$ Windows 7 and debian linux. The spreadsheet with ~20.000 rows finish in few seconds.
I was advised to report this as a bug. If a parameter exist that may solve the issue I would be happy.
Until now I have used M$ excel and I hope to skip M$ Office in the future, but because I still can use excel the problem is not critical.

Steps to Reproduce:
1.Insert ;-sep .txt file with 5 columns and 42.000 rows into calc.
2.Adjust page headers, page size and margins.
3.

Actual Results:  
Export as .pdf

Expected Results:
The export takes more than 1 hour to finish.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Would expect the export to finish in less than 1 minute.

Note 1: The behavior of the export on debian linux is similiar. The LibreOffice version on debian is 4.3.3.2 and the computer is a x86-64.

Note 2: I have experienced the problem also in earlier versions of LibreOfice on M$ Windows.


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 raal 2018-04-28 15:08:33 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 John Kjersgaard 2018-04-28 17:52:31 UTC
Created attachment 141745 [details]
.ods calc spreadsheet

To verify the error just open the spreadsheet in calc and select export as .pdf
Comment 3 John Kjersgaard 2018-04-28 17:55:43 UTC
Open the spreadsheet in calc and perform an export to .pdf to verify the problem.
Comment 4 Xavier Van Wijmeersch 2018-04-28 18:22:50 UTC
about 34 seconds needed to export to pdf (578pages)

Version: 6.1.0.0.alpha1+
Build ID: 212807f77b78c69263f8aae51dcdc73e8017c53a
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

but with v6.0 it take a lot of time to get exported to pdf

Version: 6.0.5.0.0+
Build ID: 1e05b2d030a97b0e7c86433bec26032b8b5d16ee
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 5 MM 2018-04-30 22:29:51 UTC
Maybe a dup of bug 117256 ?
Comment 6 Xisco Faulí 2018-05-31 14:45:27 UTC
(In reply to Xavier Van Wijmeersch from comment #4)
> about 34 seconds needed to export to pdf (578pages)
> 
> Version: 6.1.0.0.alpha1+
> Build ID: 212807f77b78c69263f8aae51dcdc73e8017c53a
> CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
> Locale: nl-BE (en_US.UTF-8); Calc: group
> 
> but with v6.0 it take a lot of time to get exported to pdf
> 
> Version: 6.0.5.0.0+
> Build ID: 1e05b2d030a97b0e7c86433bec26032b8b5d16ee
> CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
> Locale: nl-BE (en_US.UTF-8); Calc: group

@Xavier, thanks for testing!!!

@John Kjersgaard
Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Comment 7 John Kjersgaard 2018-06-03 10:00:07 UTC
Hi Xisco Fauli,

(Un)fortunately I'm on vacation and won't be back until June 23. But like Xavier I have succesfully tested the spreadsheet with LibereOfficeDev_6.1.0.0alpha1_Win_x64. The export took only 4-5 seconds.
Comment 8 Xisco Faulí 2018-06-03 21:50:04 UTC
(In reply to John Kjersgaard from comment #7)
> Hi Xisco Fauli,
> 
> (Un)fortunately I'm on vacation and won't be back until June 23. But like
> Xavier I have succesfully tested the spreadsheet with
> LibereOfficeDev_6.1.0.0alpha1_Win_x64. The export took only 4-5 seconds.

Ok, Thanks for the info.
Closing as RESOLVED WORKSFORME for the time being.