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

Hi :)
WOW! :)  I like the sound of that!  It's kinda like an upscale of the
hide/show single columns by the sounds of it.  Doing just one action rather
than searching out and remembering to do the same action multiple times
sounds likes less error-prone.

One reason i joined this mailing list was to hear of neat tricks that
people found useful, exactly like this.
Many thanks and regards from
Tom :)



On 31 January 2017 at 17:24, Bruce Hohl <brucehohl@gmail.com> wrote:

> 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

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