Hi :) Wow! That worked. It was even selected by default, as one would expect, so that it's only the seelceted area that would get searched by default.
Thanks and regards from Tom :) >________________________________ > From: Kevin Suo / 锁琨珑 <suokunl...@gmail.com> >To: "users@global.libreoffice.org" <users@global.libreoffice.org> >Cc: Tom Davies <tomdavie...@yahoo.co.uk> >Sent: Saturday, 8 June 2013, 11:07 >Subject: 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 / 锁琨珑 <suokunl...@gmail.com> >To: Tom Davies <tomdavie...@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 / 锁琨珑 <suokunl...@gmail.com> >> *To:* Tom Davies <tomdavie...@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 <suokunl...@gmail.com >> <mailto:suokunl...@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+unsubscr...@global.libreoffice.org >> <mailto:unsubscr...@global.libreoffice.org> >>> <mailto:unsubscr...@global.libreoffice.org >> <mailto:unsubscr...@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+unsubscr...@global.libreoffice.org >> <mailto:unsubscr...@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+unsubscr...@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+unsubscr...@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