Re: [libreoffice-users] How to print a section of a SS

On 19/10/2021 14:05, Brian Barker wrote:
> The documentation thinks it is a bug. Under "Using print ranges", it says:
> "You can define which range of cells on a spreadsheet are to be printed or exported to a PDF. The cells 
> on the sheet that are not part of the defined print range are not printed or exported. Also, any sheets 
> without a defined print range are not printed or exported."

I find it exports to pdf as advertised. If I select and define a range on one of the sheets, just 
that gets exported but care is needed because different dialogues are involved and they can 
conflict.

There is the defining of print ranges where if you have defined nothing and go to format > print 
ranges > edit, you will see that by default the print range of each sheet is defined as 'entire sheet' 
.  You can, if you think of it, change that on each sheet to 'none'.

If you use export as pdf, the export dialogue again has a range selection possibility : All, Pages, 
Selection/Selected sheet(s).

I doubt whether many people think of checking  "format > print ranges > edit"  if they have never 
set a range in the first place.

Philip



--
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/
Privacy Policy: https://www.documentfoundation.org/privacy