diff options
author | Stanislav Horacek <stanislav.horacek@gmail.com> | 2016-10-30 16:03:54 +0100 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@edx.srv.br> | 2016-10-31 11:14:04 +0000 |
commit | afded9511ec67e7181ffcc2614bf4c676539efcd (patch) | |
tree | 13dce361c6604f2214cec0eda02a58d0b09f0689 /source/text/scalc | |
parent | 129393b348cf785721113200e54fe7d243dbd403 (diff) |
update description of Find and Replace dialog
Change-Id: I40af15d57e568eebdb5fe145e6a8bc9c8d6845b0
Reviewed-on: https://gerrit.libreoffice.org/30396
Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Diffstat (limited to 'source/text/scalc')
-rw-r--r-- | source/text/scalc/guide/cellstyle_by_formula.xhp | 6 | ||||
-rw-r--r-- | source/text/scalc/guide/finding.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/guide/integer_leading_zero.xhp | 4 |
3 files changed, 7 insertions, 7 deletions
diff --git a/source/text/scalc/guide/cellstyle_by_formula.xhp b/source/text/scalc/guide/cellstyle_by_formula.xhp index 87212b578f..f7c19604b9 100644 --- a/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -48,12 +48,12 @@ <paragraph id="par_id3148797" role="listitem" xml-lang="en-US">Select the menu command <emph>Edit - Find & Replace</emph>.</paragraph> </listitem> <listitem> - <paragraph id="par_id3150767" role="listitem" xml-lang="en-US">For the <item type="menuitem">Search for</item> term, enter: .<item type="literal">*</item></paragraph> + <paragraph id="par_id3150767" role="listitem" xml-lang="en-US">For the <item type="menuitem">Find</item> term, enter: .<item type="literal">*</item></paragraph> <paragraph id="par_id3153770" role="listitem" xml-lang="en-US">".*" is a regular expression that designates the contents of the current cell.</paragraph> </listitem> <listitem> - <paragraph id="par_id3153143" role="listitem" xml-lang="en-US">Enter the following formula in the <item type="menuitem">Replace with</item> field: <item type="literal">=&+STYLE(IF(CURRENT()>3;"Red";"Green"))</item></paragraph> - <paragraph id="par_id3146975" role="listitem" xml-lang="en-US">The "&" symbol designates the current contents of the <emph>Search for</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> + <paragraph id="par_id3153143" role="listitem" xml-lang="en-US">Enter the following formula in the <item type="menuitem">Replace</item> field: <item type="literal">=&+STYLE(IF(CURRENT()>3;"Red";"Green"))</item></paragraph> + <paragraph id="par_id3146975" role="listitem" xml-lang="en-US">The "&" symbol designates the current contents of the <emph>Find</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> </listitem> <listitem> <paragraph id="par_id3149262" role="listitem" xml-lang="en-US">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> diff --git a/source/text/scalc/guide/finding.xhp b/source/text/scalc/guide/finding.xhp index 76c7161c63..734f040f19 100644 --- a/source/text/scalc/guide/finding.xhp +++ b/source/text/scalc/guide/finding.xhp @@ -61,7 +61,7 @@ <paragraph role="paragraph" id="par_id6549272" xml-lang="en-US" l10n="NEW">Choose <emph>Edit - Find & Replace</emph> to open the Find & Replace dialog.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id6529740" xml-lang="en-US" l10n="NEW">Enter the text to find in the <emph>Search for</emph> text box.</paragraph> +<paragraph role="paragraph" id="par_id6529740" xml-lang="en-US">Enter the text to find in the <emph>Find</emph> text box.</paragraph> </listitem> <listitem> <paragraph role="paragraph" id="par_id9121982" xml-lang="en-US" l10n="NEW">Either click <emph>Find Next</emph> or <emph>Find All</emph>.</paragraph> @@ -73,7 +73,7 @@ <paragraph role="paragraph" id="par_id2394482" xml-lang="en-US" l10n="NEW">If you closed the dialog, you can press a key combination (<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F) to find the next cell without opening the dialog. </paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id631733" xml-lang="en-US" l10n="NEW">By default, Calc searches the current sheet. Click <emph>More Options</emph>, then enable <emph>Search in all sheets</emph> to search through all sheets of the document.</paragraph> +<paragraph role="paragraph" id="par_id631733" xml-lang="en-US">By default, Calc searches the current sheet. Check the <emph>All sheets</emph> box to search through all sheets of the document.</paragraph> </listitem> </list> <paragraph role="paragraph" id="par_id7811822" xml-lang="en-US" l10n="NEW">When you click <emph>Find All</emph>, Calc selects all cells that contain your entry. Now you can for example set all found cells to bold, or apply a Cell Style to all at once.</paragraph> diff --git a/source/text/scalc/guide/integer_leading_zero.xhp b/source/text/scalc/guide/integer_leading_zero.xhp index 5bf8bb63f2..8380d830bd 100644 --- a/source/text/scalc/guide/integer_leading_zero.xhp +++ b/source/text/scalc/guide/integer_leading_zero.xhp @@ -62,10 +62,10 @@ <paragraph id="par_id3154944" role="listitem" xml-lang="en-US">Choose <emph>Edit - Find & Replace</emph></paragraph> </listitem> <listitem> - <paragraph id="par_id3154510" role="listitem" xml-lang="en-US">In the <emph>Search for</emph> box, enter <item type="input">^[0-9]</item></paragraph> + <paragraph id="par_id3154510" role="listitem" xml-lang="en-US">In the <emph>Find</emph> box, enter <item type="input">^[0-9]</item></paragraph> </listitem> <listitem> - <paragraph id="par_id3155068" role="listitem" xml-lang="en-US">In the <emph>Replace with</emph> box, enter <item type="input">&</item></paragraph> + <paragraph id="par_id3155068" role="listitem" xml-lang="en-US">In the <emph>Replace</emph> box, enter <item type="input">&</item></paragraph> </listitem> <listitem> <paragraph id="par_id3149018" role="listitem" xml-lang="en-US">Check <emph>Regular expressions</emph></paragraph> |