1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textscalcguidefindingxhp" indexer="include"> 27<title id="tit" xml-lang="en-US">Finding and Replacing in Calc</title> 28<filename>/text/scalc/guide/finding.xhp</filename> 29</topic> 30</meta> 31<body> 32<section id="finding_text"> 33<bookmark xml-lang="en-US" branch="index" id="bm_id3769341"> 34<bookmark_value>searching, see also finding</bookmark_value> 35<bookmark_value>finding;formulas/values/text/objects</bookmark_value> 36<bookmark_value>replacing; cell contents</bookmark_value> 37<bookmark_value>formatting;multiple cell texts</bookmark_value> 38</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> 39<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> 40</variable></paragraph> 41<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> 42</section> 43<paragraph role="heading" id="hd_id3610644" xml-lang="en-US" level="2" l10n="NEW">The Find & Replace dialog</paragraph> 44<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> 45<paragraph role="heading" id="hd_id2423780" xml-lang="en-US" level="3" l10n="NEW">To find formulas or values</paragraph> 46<paragraph role="paragraph" id="par_id2569658" xml-lang="en-US" l10n="NEW">You can specify in the Find & Replace dialog either to find the parts of a formula or the results of a calculation.</paragraph> 47<list type="ordered"> 48<listitem> 49<paragraph role="paragraph" id="par_id6394238" xml-lang="en-US" l10n="NEW">Choose <emph>Edit - Find & Replace</emph> to open the Find & Replace dialog.</paragraph> 50</listitem> 51<listitem> 52<paragraph role="paragraph" id="par_id7214270" xml-lang="en-US" l10n="NEW">Click <emph>More Options</emph> to expand the dialog.</paragraph> 53</listitem> 54<listitem> 55<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> 56</listitem> 57</list> 58<paragraph role="paragraph" id="par_id1331217" xml-lang="en-US" l10n="NEW">With "Formulas" you will find all parts of the formulas. </paragraph> 59<paragraph role="paragraph" id="par_id393993" xml-lang="en-US" l10n="NEW">With "Values" you will find the results of the calculations. </paragraph> 60<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> 61<paragraph role="heading" id="hd_id7359233" xml-lang="en-US" level="3" l10n="NEW">Finding text</paragraph> 62<list type="ordered"> 63<listitem> 64<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> 65</listitem> 66<listitem> 67<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> 68</listitem> 69<listitem> 70<paragraph role="paragraph" id="par_id9121982" xml-lang="en-US" l10n="NEW">Either click <emph>Find</emph> or <emph>Find All</emph>.</paragraph> 71</listitem> 72</list> 73<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> 74<list type="ordered"> 75<listitem> 76<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> 77</listitem> 78<listitem> 79<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> 80</listitem> 81</list> 82<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> 83<paragraph role="heading" id="hd_id8531449" xml-lang="en-US" level="2" l10n="NEW">The Navigator</paragraph> 84<list type="ordered"> 85<listitem> 86<paragraph role="paragraph" id="par_id9183935" xml-lang="en-US" l10n="NEW">Choose <emph>View - Navigator</emph> to open the Navigator window.</paragraph> 87</listitem> 88</list> 89<paragraph role="paragraph" id="par_id946684" xml-lang="en-US" l10n="NEW">The Navigator is the main tool for finding and selecting objects.</paragraph> 90<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> 91<section id="relatedtopics"> 92<embed href="text/swriter/guide/search_regexp.xhp#search_regexp"/> 93<embed href="text/shared/01/02100001.xhp#02100001"/> 94<embed href="text/swriter/guide/finding.xhp#finding"/> 95</section> 96</body> 97</helpdocument> 98