1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?>
2*b1cdbd2cSJim Jagielski<helpdocument version="1.0">
3*b1cdbd2cSJim Jagielski
4*b1cdbd2cSJim Jagielski<!--***********************************************************
5*b1cdbd2cSJim Jagielski *
6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
7*b1cdbd2cSJim Jagielski * or more contributor license agreements.  See the NOTICE file
8*b1cdbd2cSJim Jagielski * distributed with this work for additional information
9*b1cdbd2cSJim Jagielski * regarding copyright ownership.  The ASF licenses this file
10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
12*b1cdbd2cSJim Jagielski * with the License.  You may obtain a copy of the License at
13*b1cdbd2cSJim Jagielski *
14*b1cdbd2cSJim Jagielski *   http://www.apache.org/licenses/LICENSE-2.0
15*b1cdbd2cSJim Jagielski *
16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19*b1cdbd2cSJim Jagielski * KIND, either express or implied.  See the License for the
20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
21*b1cdbd2cSJim Jagielski * under the License.
22*b1cdbd2cSJim Jagielski *
23*b1cdbd2cSJim Jagielski ***********************************************************-->
24*b1cdbd2cSJim Jagielski
25*b1cdbd2cSJim Jagielski
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski
28*b1cdbd2cSJim Jagielski<meta>
29*b1cdbd2cSJim Jagielski<topic id="textscalcguidefindingxhp" indexer="include">
30*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Finding and Replacing in Calc</title>
31*b1cdbd2cSJim Jagielski<filename>/text/scalc/guide/finding.xhp</filename>
32*b1cdbd2cSJim Jagielski</topic>
33*b1cdbd2cSJim Jagielski</meta>
34*b1cdbd2cSJim Jagielski<body>
35*b1cdbd2cSJim Jagielski<section id="finding_text">
36*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3769341"><bookmark_value>searching, see also finding</bookmark_value>
37*b1cdbd2cSJim Jagielski<bookmark_value>finding;formulas/values/text/objects</bookmark_value>
38*b1cdbd2cSJim Jagielski<bookmark_value>replacing; cell contents</bookmark_value>
39*b1cdbd2cSJim Jagielski<bookmark_value>formatting;multiple cell texts</bookmark_value>
40*b1cdbd2cSJim Jagielski</bookmark><comment>2. mw deleted 2 entries, changed "finding;" and added "formatting;"</comment><comment>1. mw copied 5 entries from shared/01/02100000.xhp and changed then "finding," and "replacing;"</comment>
41*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3149204" xml-lang="en-US" level="1" l10n="NEW"><variable id="finding"><link href="text/scalc/guide/finding.xhp">Finding and Replacing in Calc</link>
42*b1cdbd2cSJim Jagielski</variable></paragraph>
43*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9363689" xml-lang="en-US" l10n="NEW">In spreadsheet documents you can find words, formulas, and styles. You can navigate from one result to the next, or you can highlight all matching cells at once, then apply another format or replace the cell content by other content.</paragraph>
44*b1cdbd2cSJim Jagielski</section>
45*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3610644" xml-lang="en-US" level="2" l10n="NEW">The Find &amp; Replace dialog</paragraph>
46*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2224494" xml-lang="en-US" l10n="NEW">Cells can contain text or numbers that were entered directly as in a text document. But cells can also contain text or numbers as the result of a calculation. For example, if a cell contains the formula =1+2 it displays the result 3. You must decide whether to search for the 1 respective 2, or to search the 3.</paragraph>
47*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id2423780" xml-lang="en-US" level="3" l10n="NEW">To find formulas or values</paragraph>
48*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2569658" xml-lang="en-US" l10n="NEW">You can specify in the Find &amp; Replace dialog either to find the parts of a formula or the results of a calculation.</paragraph>
49*b1cdbd2cSJim Jagielski<list type="ordered">
50*b1cdbd2cSJim Jagielski<listitem>
51*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id6394238" xml-lang="en-US" l10n="NEW">Choose <emph>Edit - Find &amp; Replace</emph> to open the Find &amp; Replace dialog.</paragraph>
52*b1cdbd2cSJim Jagielski</listitem>
53*b1cdbd2cSJim Jagielski<listitem>
54*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7214270" xml-lang="en-US" l10n="NEW">Click <emph>More Options</emph> to expand the dialog.</paragraph>
55*b1cdbd2cSJim Jagielski</listitem>
56*b1cdbd2cSJim Jagielski<listitem>
57*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2186346" xml-lang="en-US" l10n="NEW">Select "Formulas" or "Values" in the <emph>Search in</emph> list box.</paragraph>
58*b1cdbd2cSJim Jagielski</listitem>
59*b1cdbd2cSJim Jagielski</list>
60*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id1331217" xml-lang="en-US" l10n="NEW">With "Formulas" you will find all parts of the formulas. </paragraph>
61*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id393993" xml-lang="en-US" l10n="NEW">With "Values" you will find the results of the calculations. </paragraph>
62*b1cdbd2cSJim Jagielski<paragraph role="note" id="par_id3163853" xml-lang="en-US" l10n="NEW">Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. You see the currency symbol in the cell, but you cannot search for it.</paragraph>
63*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id7359233" xml-lang="en-US" level="3" l10n="NEW">Finding text</paragraph>
64*b1cdbd2cSJim Jagielski<list type="ordered">
65*b1cdbd2cSJim Jagielski<listitem>
66*b1cdbd2cSJim Jagielski<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>
67*b1cdbd2cSJim Jagielski</listitem>
68*b1cdbd2cSJim Jagielski<listitem>
69*b1cdbd2cSJim Jagielski<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>
70*b1cdbd2cSJim Jagielski</listitem>
71*b1cdbd2cSJim Jagielski<listitem>
72*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9121982" xml-lang="en-US" l10n="NEW">Either click <emph>Find</emph> or <emph>Find All</emph>.</paragraph>
73*b1cdbd2cSJim Jagielski</listitem>
74*b1cdbd2cSJim Jagielski</list>
75*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3808404" xml-lang="en-US" l10n="NEW">When you click <emph>Find</emph>, Calc will select the next cell that contains your text. You can watch and edit the text, then click <emph>Find</emph> again to advance to the next found cell. </paragraph>
76*b1cdbd2cSJim Jagielski<list type="ordered">
77*b1cdbd2cSJim Jagielski<listitem>
78*b1cdbd2cSJim Jagielski<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>
79*b1cdbd2cSJim Jagielski</listitem>
80*b1cdbd2cSJim Jagielski<listitem>
81*b1cdbd2cSJim Jagielski<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>
82*b1cdbd2cSJim Jagielski</listitem>
83*b1cdbd2cSJim Jagielski</list>
84*b1cdbd2cSJim Jagielski<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>
85*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id8531449" xml-lang="en-US" level="2" l10n="NEW">The Navigator</paragraph>
86*b1cdbd2cSJim Jagielski<list type="ordered">
87*b1cdbd2cSJim Jagielski<listitem>
88*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9183935" xml-lang="en-US" l10n="NEW">Choose <emph>View - Navigator</emph> to open the Navigator window.</paragraph>
89*b1cdbd2cSJim Jagielski</listitem>
90*b1cdbd2cSJim Jagielski</list>
91*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id946684" xml-lang="en-US" l10n="NEW">The Navigator is the main tool for finding and selecting objects.</paragraph>
92*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9607226" xml-lang="en-US" l10n="NEW">Use the Navigator for inserting objects and links within the same document or from other open documents.</paragraph>
93*b1cdbd2cSJim Jagielski<section id="relatedtopics">
94*b1cdbd2cSJim Jagielski<embed href="text/swriter/guide/search_regexp.xhp#search_regexp"/>
95*b1cdbd2cSJim Jagielski<embed href="text/shared/01/02100001.xhp#02100001"/>
96*b1cdbd2cSJim Jagielski<embed href="text/swriter/guide/finding.xhp#finding"/>
97*b1cdbd2cSJim Jagielski</section>
98*b1cdbd2cSJim Jagielski</body>
99*b1cdbd2cSJim Jagielski</helpdocument>
100