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

Great it's resolved for you, I have been caught out by this.

On 29/03/18 09:44, Hylton Conacher (ZR1HPC) wrote:
> Hi Steve,
>
> On 2018/03/27 22:20, Steve Edmonds wrote:
> > Hi.
> > Have you checked Format>Print ranges and checked View>Page break to 
> > see that the graphs fit on the page.
> > Does File>Prit preview show all graphs.
>
> Checked the Format of the page being correctly orientated etc and 
> Print Preview did NOT show all images.
> So I defined the print range as the whole page, which I thought would 
> have been standard printing practice i.e. if I say print sheets 
> 1,3,4,5 then the entire sheets of 1, 3, 4, 5 should be selected and 
> printed but apparently Libreoffice didn't think like I did.
> I amended all the sheets and defined the print range as the entire 
> sheet and then all graphs showed on Print Preview. I Exported as PDF 
> and viola' all graphs appeared.
>
> Thanks, I'll certainly remember to check print range in future.
>
> Regards
> Hylton
> > Steve
> >
> > On 28/03/18 09:01, Hylton Conacher (ZR1HPC) wrote:
> > > Hi,
> > >
> > > I have a large spreadsheet of 23 sheets of which all but two contain 
> > > full page graphs i.e. at 200% magnification the graph stretches 
> > > until column K and down to row 25.
> > >
> > > On a monthly basis I need to select 11 of the sheets, 10 of which 
> > > hold graphs and Export as PDF into a single PDF. The 'export' works 
> > > but only on 6 pages, whilst the others are lost in the ether. The 
> > > PDF created is an Archive PDF/A, duplicate field names are allowed 
> > > and View PDF after export is selected with lossless compression of 
> > > the selected sheets.
> > > I have tried creating the PDF as a Hybrid PDF with the same results 
> > > although no warning about transparency.
> > >
> > > Viewing in Adobe Reader afterwards only produces some of the sheets 
> > > and does not begin with the first sheet selected.
> > >
> > > I am using Version: 5.4.6.2
> > > Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
> > > CPU threads: 4; OS: Mac OS X 10.13.3; UI render: default;
> > > Locale: en-ZA (en_ZA.UTF-8); Calc: group
> > >
> > > Please advise as there are approximately 1500 people who receive the 
> > > graphs and could therefore want to try Libreoffice themselves.
> > >
> > > I have searched the Bugzilla and not found one that matches so have 
> > > created a new one titled: Bug 116667 - FILESAVE: Export as PDF
> > >
> > > Any comments?
> > >
> > > Hylton
> > > P.S.:I am on the Libreoffice users mailing list and can be reached 
> > > privately via mailto:hylton@conacher.co.za


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