Re: [libreoffice-users] Export as PDF using Calc

On Thu, 2013-11-14 at 08:49 -0800, Sunil Agrawal wrote: 
> Hi Jay,
> Thanks for the response. I am using Linux and tried LO 3.5 and 4.0 but
> same behavior. I want to share the doc and the recipient might not
> have LO hence the need to convert to PDF.
>
> Any insights will be appreciated.
> Sunil

Sunil,

Try export/saving as xls or xlsx instead of pdf. xls is probably the
better format for MSO users because MS apparently likes to tweak the
xlsx format with every MSO release. This will preserve the formatting
and the formulas.

If format and formulas are not important to the others you can save as a
csv file. The problem is some users might panic when the import wizard
opens in their spreadsheet program.

I am not sure how do this when working headless.

Jay 
> On Thu, Nov 14, 2013 at 7:31 AM, Jay Lozier <jslozier@gmail.com> wrote:
> > On Wed, 2013-11-13 at 22:16 -0800, Sunil Agrawal wrote:
> > > Hi,
> > > 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
> > > extent.
> > >
> > > 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
> > > server?
> > >
> > > 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.
> > > TIA,
> > >
> > > Sunil
> > Sunil,
> >
> > 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
> > landscape).
> >
> > 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?
> >
> > --
> > Jay Lozier
> > jslozier@gmail.com
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be deleted

-- 
Jay Lozier
jslozier@gmail.com


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted