Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.