summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorStanislav Horacek <stanislav.horacek@gmail.com>2016-10-30 16:03:54 +0100
committerOlivier Hallot <olivier.hallot@edx.srv.br>2016-10-31 11:14:04 +0000
commitafded9511ec67e7181ffcc2614bf4c676539efcd (patch)
tree13dce361c6604f2214cec0eda02a58d0b09f0689 /source/text/scalc
parent129393b348cf785721113200e54fe7d243dbd403 (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.xhp6
-rw-r--r--source/text/scalc/guide/finding.xhp4
-rw-r--r--source/text/scalc/guide/integer_leading_zero.xhp4
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 &amp; 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">=&amp;+STYLE(IF(CURRENT()&gt;3;"Red";"Green"))</item></paragraph>
- <paragraph id="par_id3146975" role="listitem" xml-lang="en-US">The "&amp;" 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">=&amp;+STYLE(IF(CURRENT()&gt;3;"Red";"Green"))</item></paragraph>
+ <paragraph id="par_id3146975" role="listitem" xml-lang="en-US">The "&amp;" 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 &amp; Replace</emph> to open the Find &amp; 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 &amp; 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">&amp;</item></paragraph>
+ <paragraph id="par_id3155068" role="listitem" xml-lang="en-US">In the <emph>Replace</emph> box, enter <item type="input">&amp;</item></paragraph>
</listitem>
<listitem>
<paragraph id="par_id3149018" role="listitem" xml-lang="en-US">Check <emph>Regular expressions</emph></paragraph>