Issue 59696 - Option "Print only Selected Sheets" missing in PDF export dialog
Summary: Option "Print only Selected Sheets" missing in PDF export dialog
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 99805 (view as issue list)
Depends on:
Blocks: PDFexport
  Show dependency tree
Reported: 2005-12-23 08:29 UTC by bobharvey
Modified: 2014-06-02 08:55 UTC (History)
5 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bobharvey 2005-12-23 08:29:59 UTC
When exporting to PDF it is possible to select a page range, but in order to  
export from just the current spreadsheet tab it is necessary first to print  
preview and note the page numbers. Because numbering reflects the whole sheet 
this could easily result in a document numbered from page 42 onwards. 
I would like to see the selection options expanded to four:  
* All sheets  
* Current sheet  
* page [...]  
* selection  
I intend to raise the same suggestion for sub-component "printing"
Comment 1 lars 2005-12-23 17:10:16 UTC
according to I 
reassign this issue to requirements and set the status to new
Comment 2 bobharvey 2006-07-01 10:58:59 UTC
Still no target for this one?  It really would be useful, you know.
Comment 3 bobharvey 2006-07-21 21:08:41 UTC
Any thoughts on this one and on ?
Comment 4 bobharvey 2007-08-30 13:17:07 UTC
Quite surprised this is still unconsidered.  I'd have hoped it would make it
into the 2.x series, but can we at least hope for it in 3.x?
Comment 5 bobharvey 2008-03-02 07:59:45 UTC
Is this so very difficult?
Comment 6 bobharvey 2008-08-13 22:10:21 UTC
I have just been experimenting with version 3.0 Beta 2 on XP.

It appears that at some point since I made the original report there has arisen
a sort of work-around.  If no particular range on a tab is selected, then
selecting 'selection' on the export to pdf dialogue will export only the current

This works quite nicely, and just about produces the results I was interested
in.  But the ergonomic could be a little more obvious when export to pdf is
selected, so I suppose this cannot be closed yet.

The sister issue, 59697, for printing appears to have been addressed.
Comment 7 kruitje 2008-11-16 14:27:08 UTC
As you can see in Adobe Acrobat, converting a spreadsheet to pdf can be done by 
selecting which sheet you want to add to the pdf.
We need this extra before switching to Open Office.
If you need more information please send an email.

Comment 8 Rainer Bielefeld 2014-06-02 08:46:31 UTC
(a) This is not an enhancement request. Currently it's hard work to do a PDF 
    export for particular shees. PDF export Dialog does not offer such an 
    options, and to find out the page numbers you will have to export the 
    only way is "trial and error".
(b) The inconsistence to print dialog is not comprehensible.
(c) Same mess with LibO 4.2
Comment 9 Rainer Bielefeld 2014-06-02 08:55:12 UTC
*** Issue 99805 has been marked as a duplicate of this issue. ***