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: [email protected]
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
