Fwd: Re: off-list Re: [libreoffice-users] LO Calc - Find in a column

I'm forwarding this off-list reply so that others can get help.

Kevin Suo


-------- Original Message --------
Subject:     Re: off-list Re: [libreoffice-users] LO Calc - Find in a column
Date:     Sat, 08 Jun 2013 18:02:09 +0800
From:     Kevin Suo / 锁琨珑 <suokunlong@gmail.com>
To:     Tom Davies <tomdavies04@yahoo.co.uk>



Hi Tom,

I see from you screenshot that your cells selected are all empty. I
tried and found that if selected some cells with no value, the "current
selection only" option is really greyed out, but if you select some
cells with value (even only one cell has value), that option is available.

You may try it by yourself.

Best Regards,

Kevin Suo from China.

于 06/08/2013 05:40 PM, Tom Davies 写道:
> Hi ) I think i have selected a few cells in this blank spreadsheet
> and still got the option greyed-out?  Possibly i've done something
> wrong. Could also be that i haven't got experimental features
> switched on or that i've got something else wrong with my settings.
> I might try renaming my user profile later if you think it looks like
> i am trying the right sort of thing. Regards from Tom :)
>
>
> ------------------------------------------------------------------------
*From:* Kevin Suo / 锁琨珑 <suokunlong@gmail.com>
> *To:* Tom Davies <tomdavies04@yahoo.co.uk> *Cc:*
> "users@global.libreoffice.org" <users@global.libreoffice.org> *Sent:*
> Saturday, 8 June 2013, 3:03 *Subject:* Re: [libreoffice-users] LO
> Calc - Find in a column
>
> You are welcome. That option is greyed when there is no selection of
> cells.
>
> Kevin Suo Beijing, China.
>
> 06/07/2013 05:44 PM, Tom Davies:
> > Hi :) Thanks but that option was greyed out for me so i didn't
> > notice it. Regards from Tom :)
> ------------------------------------------------------------------------
>
>  *From:* Suo Kunlong <suokunlong@gmail.com
> <mailto:suokunlong@gmail.com>>
> > *To:* users@global.libreoffice.org
> <mailto:users@global.libreoffice.org>
> > *Sent:* Friday, 7 June 2013, 10:35 *Subject:* Re:
> > [libreoffice-users] LO Calc - Find in a column
> >
> >
> > 06/07/2013 05:07 PM, Ian Whitfield :
> > > Hi All
> > >
> > > Is it possible to get Calc to search/Find in a specific
> column??
> > > I have a three column list of names, (A=First, B-Surname,
> C=Former
> > > Name), with about 3000 entries and want to get the Search
> function
> > > (CTRL-F) to look in just the specific column related to the
> > Search. I
> > > have tried to pre-select the column, (right-click), but the
> Search
> > > function still looks at all the columns.
> > >
> > > PCLOS 2013 and LO 3.6.5.2
> > >
> > > Thanks for any help.
> > >
> > > IanW Pretoria RSA
> > Select a column, then "Find & Replace (CTRL+H)", and make
> sure the
> > "Current Selection Only" option is selected within "More
> Options". You
> > may also use regular expressions if you wish.
> >
> > Best Regards,
> >
> > Kevin Suo 锁琨珑 Beijing, China
> >
> > -- To unsubscribe e-mail to:
> users+unsubscribe@global.libreoffice.org
> <mailto:unsubscribe@global.libreoffice.org>
> > <mailto:unsubscribe@global.libreoffice.org
> <mailto: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
> <mailto: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