Ask Your Question

print directly only one sheet PDF Calc [closed]

asked 2013-07-02 00:11:20 +0200

Ljiljan gravatar image

I have three sheets in LO Calc and when I click Export as PDF from toolbar, all sheets are exported to PDF... is it possible to export only current sheet?

PS. I am aware that I can go to File -> Print and print current sheet as PDF or go to File -> Export PDF and then select page 1 and 2 to print...

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 01:58:30.427815


I have exactly the same question as Ljijan. I want to do what he does. The option of Export as PDF and doing the settings every time is clumsy. Would it not be possible to edit the settings used by the 'Export directly as pdf' command?

paulmichael1084 gravatar imagepaulmichael1084 ( 2017-03-03 08:58:49 +0200 )edit

This question helped me to find the function "File -> Export to PDF" which was just what I needed since the button "Export Directly as PDF" exports all sheets instead of the current sheet.

baptx gravatar imagebaptx ( 2021-04-13 16:34:26 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-07-02 01:42:57 +0200

simon gravatar image

updated 2013-07-02 01:43:45 +0200

You can add an Export to PDF button to the toolbar (as opposed the Export directly to PDF button that is there by default), which will launch the settings dialogue, if that will do?

Failing that, all I can think of would be to create a Macro which would call Export to PDF with your custom settings, and assign that to a toolbar button.

edit flag offensive delete link more

answered 2013-07-02 01:54:29 +0200

w_whalley gravatar image

Select the cells to print, then choose File/Export as PDF. Un-check the option to Embed OpenDocument file on the General tab (this activates the Range options) then set the Range to Selection. Then Export.

There are other ways to do this that may be more appropriate if you always want to export the same print range.

edit flag offensive delete link more



I know... but still, it would be nice if there is Export Current Sheet Directly to PDF :)

Ljiljan gravatar imageLjiljan ( 2013-07-02 09:48:24 +0200 )edit

It would be REALLY helpful you're right

paulmichael1084 gravatar imagepaulmichael1084 ( 2017-03-03 09:32:32 +0200 )edit

Question Tools



Asked: 2013-07-02 00:11:20 +0200

Seen: 9,092 times

Last updated: Jul 02 '13