Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Another way to keep unwanted columns or rows from printing is to Group
those columns or rows (Data > Group and Outline > Group) .  Before printing
use the "Minus" icon to collapse.  After printing use the "Plus" sign to
expand.  This method provides a fast clickable control which is also a
vise-able reminder of the Group when collapsed.


On Tue, Jan 31, 2017 at 5:36 AM, Brian Barker <b.m.barker@btinternet.com>
wrote:

At 22:46 30/01/2017 +0000, Budge Noname wrote:

On 30/01/17 15:25, Brian Barker wrote:

At 13:21 30/01/2017 +0000, Budge Noname wrote:

I am trying to hide some columns when printing.


You can hide entire columns using Format | Column > | Hide (or
right-click | Hide on the column header).


When I did this the space occupied by the hidden columns was still in the
print layout so objective not achieved.


You may need to close the file and reopen it to sort things out. Very easy.

o Create a separate sheet for printing purposes, containing only the
required columns. You need to create *formulae* referring to your original
sheet on that sheet, not just to paste values - so that values there update
automatically as you work on your main sheet.


I refer to this as a brute force approach but it is what I ended up doing.


Nothing brutish I can see.

In fact I copied only the wanted columns to next sheet and printed from
that.


If you copied values, you didn't do what I suggested - which may be less
brutish than what you did. If you create *formulae* instead of values, you
need do this only once. The second sheet used for printing will
automatically update as you work on your editing sheet and can always be
what you print.

Brian Barker

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.