Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 11/14/2013 10:31 AM, Jay Lozier wrote:
On Wed, 2013-11-13 at 22:16 -0800, Sunil Agrawal wrote: 
I am using Calc (actually soffice) in a headless manner (using
—headless). I am running it on a server that doesn’t have X server and
communicating with soffice using JOD converter.

Generally it hasn’t been a problem, however when I export the
spreadsheet to PDF, wide spreadsheets get truncated and take multiple
pages, which is highly undesirable.

However, when I run the same program on my local dev machine, which
has X server running, the output PDF gets auto scaled to a certain

Can you please direct me how to get auto scaling on server that
doesn’t have X server running? When running in headless mode, what OS
setting are picked up by LibreOffice. What do I need to set them on my

I have spent couple of days trying out different options, e.g. using
Xvfb on my server with different screen sizes, but to no avail.

Any help is appreciated.



When I have exported a document to a pdf file the conversion using the
default page such as A4, US Letter, etc. to paginate the document. Also,
normally the pagination uses the default orientation (portrait or

The issue is why are your using a pdf document and not using ods format
or even another format for your documents. The pdf format is often used
for file sharing when the recipient is expected to only view the results
and not edit them.

Also, which version of LO are you using and which OS are you using; it
sounds like Linux?

For the original question - exporting it to PDF without truncating. . . .
I tend to export it to PDF but set my paper size to a larger size, like
8.5 by 14 or 11 by 17 inches, then print it out with the printer option
of shrinking the page to fit the paper size you need.  Since I use
CUPS-PDF for Linux and doPDF for Windows, I can export the document to
PDF of a larger size and then use the external PDF "printers" to shrink
the larger page size to a letter page size.

I have done this many times with a Writer document and a few time with a
Calc graphics printout.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.