Re: [libreoffice-users] Help with applying filters please.

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-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