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