1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textscalcguidefindingxhp" indexer="include">
<title id="tit" xml-lang="en-US">Finding and Replacing in Calc</title>
<filename>/text/scalc/guide/finding.xhp</filename>
</topic>
</meta>
<body>
<section id="finding_text">
<bookmark xml-lang="en-US" branch="index" id="bm_id3769341"><bookmark_value>searching, see also finding</bookmark_value>
<bookmark_value>finding;formulas/values/text/objects</bookmark_value>
<bookmark_value>replacing; cell contents</bookmark_value>
<bookmark_value>formatting;multiple cell texts</bookmark_value>
</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>
<paragraph role="heading" id="hd_id3149204" xml-lang="en-US" level="1"><variable id="finding"><link href="text/scalc/guide/finding.xhp">Finding and Replacing in Calc</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id9363689" xml-lang="en-US">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>
</section>
<paragraph role="heading" id="hd_id3610644" xml-lang="en-US" level="2">The Find & Replace dialog</paragraph>
<paragraph role="paragraph" id="par_id2224494" xml-lang="en-US">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>
<paragraph role="heading" id="hd_id2423780" xml-lang="en-US" level="3">To find formulas or values</paragraph>
<paragraph role="paragraph" id="par_id2569658" xml-lang="en-US">You can specify in the Find & Replace dialog either to find the parts of a formula or the results of a calculation.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id6394238" xml-lang="en-US">Choose <emph>Edit - Find & Replace</emph> to open the Find & Replace dialog.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id7214270" xml-lang="en-US">Click <emph>More Options</emph> to expand the dialog.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id2186346" xml-lang="en-US">Select "Formulas" or "Values" in the <emph>Search in</emph> list box.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id1331217" xml-lang="en-US">With "Formulas" you will find all parts of the formulas. </paragraph>
<paragraph role="paragraph" id="par_id393993" xml-lang="en-US">With "Values" you will find the results of the calculations. </paragraph>
<paragraph role="note" id="par_id3163853">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. These symbols are included in searches when the Formatted Display search option is activated.</paragraph>
<paragraph role="heading" id="hd_id7359233" xml-lang="en-US" level="3">Finding text</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id6549272" xml-lang="en-US">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">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">Either click <emph>Find Next</emph> or <emph>Find All</emph>.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id3808404" xml-lang="en-US">When you click <emph>Find Next</emph>, Calc will select the next cell that contains your text. You can watch and edit the text, then click <emph>Find Next</emph> again to advance to the next found cell. </paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id2394482" xml-lang="en-US">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">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">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>
<paragraph role="heading" id="hd_id8531449" xml-lang="en-US" level="2">The Navigator</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id9183935" xml-lang="en-US">Choose <emph>View - Navigator</emph> to open the Navigator window.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id946684" xml-lang="en-US">The Navigator is the main tool for finding and selecting objects.</paragraph>
<paragraph role="paragraph" id="par_id9607226" xml-lang="en-US">Use the Navigator for inserting objects and links within the same document or from other open documents.</paragraph>
<section id="relatedtopics">
<embed href="text/swriter/guide/search_regexp.xhp#search_regexp"/>
<embed href="text/shared/01/02100001.xhp#02100001"/>
<embed href="text/swriter/guide/finding.xhp#finding"/>
</section>
</body>
</helpdocument>
|
