6/17/2023 0 Comments Pdf print selection![]() ![]() Sheets with pivot tables that span multiple sheets seem to be the primary culprit: selecting these for printing seems to have higher likelihood of messing up the output.See page 21 and 22 in the example PDF linked above, it says " of 31", then " of 30" (similar oddity can be observed with CutePDF) Total page count varies throughout the PDF document.As I expand my sheet selection and print to PDF, at some point it starts "losing" pages at the end of the document. If I select only the last couple of sheets, they get included in the PDF as they should.Printing to a physical printer prints all pages (good!).CutePDF writer gives the same (bad) results.Using regular "Save As" and selecting PDF gives the same (bad) results.All pages have same print quality ( was noted as a potential issue elsewhere).The last page looks like this:Ĭheck the last page of the resulting PDF. I can reproduce the issue consistently with this example file.Įxample PDF output also available (note the two last sheets are missing). Specifically, the last couple of sheets/pages are omitted from the result, which is a huge issue, since it basically renders the file useless for its purpose (= PDF report generation).įile has mixed orientation (Landscape/Portrait), many of the sheets span multiple printed pages, and the last two sheets are static one-pagers that are - even though I selected them - not included in the PDF. ![]() This happens when using File > Save As (PDF) as well. When I select sheets (Shift+Click to multiselect) in a macro-free workbook that each may or may not span multiple printed pages, select File > Print (using Microsoft Print to PDF, selecting "Print Active Sheets"), all pages don't get included in the PDF. ![]()
0 Comments
Leave a Reply. |