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


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>
    *To:* 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>
    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.