| finding.xhp (82a98929) | finding.xhp (f773ab65) |
|---|---|
| 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 --- 41 unchanged lines hidden (view full) --- 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> | 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 --- 41 unchanged lines hidden (view full) --- 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> | 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> | 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> | 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> | 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> | 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"> --- 13 unchanged lines hidden --- | 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"> --- 13 unchanged lines hidden --- |