Created attachment 140924 [details] Data and graphs that are used I have a large spreadshhet of 23 sheets of which all but two contain full page graphs ie 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 the first selected graph is created asa PDF, the other 10 pages 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 lossloess compression pf the selected sheets. Viewubg in Adone Reader afterwards only produces 6 of the 9 sheets, complsining sbout trsnsparencies. 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.
More precisely: Hi, I have a large spreadsheet of 23 sheets of which all but two contain full page graphs ie 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 pf 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 think more than an issue, is defining the right parameters for the job, like e.g. creating the appropriated pages style for any kind of sheets, defining print ranges, etc. In the sample file all sheets have the same style. Not to get what is wanted, means necessarily there is a bug, but a need to prepare the spreadsheet to get it. Please ask the question on https://ask.libreoffice.org/en/questions/, if your language it's not English maybe there is one on your language, or in the mailing list http://nabble.documentfoundation.org/. Taking a look to the documentation can help a lot, https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Steve Edmonds solved my issue via direct email. Steve 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 ie if I say print sheeets 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
FIXED it's not right, no code patch relative to the bug was done, not a bug at all.