Ask Your Question
1

PDF export size bigger than with OpenOffice

asked 2013-08-23 21:02:30 +0100

RickCP gravatar image

updated 2016-01-02 19:04:22 +0100

Alex Kemp gravatar image

I have a spreadsheet that I use as a template for invoices. It was created with OpenOffice many years ago. Since then, I used the export to pdf function to create a pdf version of my 1 page invoices. The file size of the generated pdfs was an average of 50kb.

I recently installed LibreOffice. When I open the same ods file and do the exact same export to pdf, the file size is around 250kb!! Five times bigger!! There are no images in the file and I played with all the options in the export to pdf dialog with no avail (actually some options make the file even bigger).

Any idea what could be making these pdfs so big now? How can I make the pdf file size more efficient?

Thanks.

edit retag flag offensive close merge delete

6 Answers

Sort by » oldest newest most voted
1

answered 2014-03-16 02:08:03 +0100

oztony gravatar image

updated 2014-03-16 02:09:33 +0100

Using LibreOffice Version 4.1.3.2 on Linux Mint 64 bit machine. I recently discovered that certain Calc spreadsheets with a simple page of figures would produce a very much larger PDF file. One of my simple spreadsheets was producing a 1.5MB file from a 22kB ODS or XLS file.

Yet there are no embedded files, and only a subset of Times New Roman and ArialMT fonts. Compression is set to the default 85% JPEG.

After some experimentation I discovered that it was the cell borders that caused the bloating.

A simple one-page test file without cell borders was 31.2kb. The same file with borders set to a 0.05pt line vertically & Horizontally across all cells was 31.6kb. But if I then changed the vertical borders to a dashed line rather than a continuous one, the PDF grew to 103.3kb. If I changed ALL of the cell borders (horizontal and vertical) to a dashed line, ths PDF size blew out to 577kb.

It seems that the dashed line is somehow causing issues. So if anyone is experiencing similar PDF bloat from Calc, check the border formatting in the spreadsheet.

edit flag offensive delete link more

Comments

There are many factors involved in export to PDF. In any case, there does appear to be a significant increase in PDF file size (for the same export settings) when the original ODS contains dotted / dashed, rather than solid, borders. Figures I get here under Debian 7 using v4.1.4.2 for a single A4 page of plain figures: no borders, 8.2kB; solid borders, 8.7kB; dashed borders, 783.2kB.

oweng gravatar imageoweng ( 2014-03-16 06:21:52 +0100 )edit
0

answered 2013-08-23 21:21:27 +0100

m.a.riosv gravatar image

Some options in Menu/File/Export as PDF, can change the pdf size:

  • Images, lossless compression.

  • Embed OpenDocument file, this options keeps the ods file inside the pdf, and when the pdf is open in LibreOffice, the embedded ods is open.

  • Embed standard fonts.

edit flag offensive delete link more

Comments

Thanks, I tried all those options (on/off) with no avail

RickCP gravatar imageRickCP ( 2013-08-23 22:24:38 +0100 )edit
0

answered 2013-08-23 22:07:12 +0100

David gravatar image

You don't mention which version you're using. With LibreOffice 4.1, there is now font embedding for all the apps.

In Writer, it seems you can disable (or enable) this feature in the document's properties. Also Calc? Would this have anything to do with the PDF export size?

edit flag offensive delete link more

Comments

I'm using Version 4.0.4.2.

RickCP gravatar imageRickCP ( 2013-08-23 22:25:33 +0100 )edit
0

answered 2015-12-28 22:49:06 +0100

wryta gravatar image

Same problem. A one page christmas letter with about 1 MB of jpeg images and one paragraph text ballooned to 9.1 MB, which makes it unsuitable for email and time consuming with Dropbox. The images are compressed as much as practical.

Version 1.0.0.5

edit flag offensive delete link more

Comments

duplicate line deleted

wryta gravatar imagewryta ( 2015-12-28 22:44:34 +0100 )edit
0

answered 2016-04-14 12:11:31 +0100

after some tries, I archived a reasonable PDF document size by disabling:

General->Hybrid... General->Archive... General->Tagged... General->Create PDF...

into PDF Options window.

This set the PDF file size from about 6Mb to 800kb

edit flag offensive delete link more
0

answered 2015-12-30 18:53:45 +0100

Well I had the same issue (and not only with LO). Under Linux (but I suppose it's the same with other OS) I created a script that converts the PDF to PS and then the PS back to PDF with ghostscript and it shrinks them a lot with no visible decay. I had some issues with Impress in terms of size and transparency and I found that disabling PDF/A-1a solved the issue and produced smaller files. It goes without saying that Jpeg compression should be on (I use 90%) and reduce image resolution (for video 75DPI works for me).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2013-08-23 21:02:30 +0100

Seen: 3,663 times

Last updated: Apr 14 '16