merge the formfield patch from ooo-build
[ooovba.git] / helpcontent2 / source / text / scalc / 01 / 06030000.xhp
blob625d7d815997499b7aa1d231f4789afc0f6b8c05
1 <?xml version="1.0" encoding="UTF-8"?>
4 <!--
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 *
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: 06030000.xhp,v $
14 * $Revision: 1.7 $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
34 -->
36 <helpdocument version="1.0">
37 <meta>
38 <topic id="textscalc0106030000xml" indexer="include" status="PUBLISH">
39 <title id="tit" xml-lang="en-US">Detective</title>
40 <filename>/text/scalc/01/06030000.xhp</filename>
41 </topic>
42 <history>
43 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
44 <lastedited date="2006-03-21T12:43:49">converted from old format - fpe</lastedited>
45 </history>
46 </meta>
47 <body>
48 <section id="detektiv">
49 <bookmark xml-lang="en-US" branch="index" id="bm_id3151245"><bookmark_value>cell links search</bookmark_value>
50 <bookmark_value>searching; links in cells</bookmark_value>
51 <bookmark_value>traces;precedents and dependents</bookmark_value>
52 </bookmark><comment>mw made "searching..." a two level entry</comment>
53 <paragraph role="heading" id="hd_id3151245" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/06030000.xhp" name="Detective">Detective</link></paragraph>
54 <paragraph role="paragraph" id="par_id3151211" xml-lang="en-US" l10n="U" oldref="2">This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.</paragraph>
55 </section>
56 <section id="howtoget">
57 <embed href="text/scalc/00/00000406.xhp#exdektv"/>
58 </section>
59 <paragraph role="paragraph" id="par_id3150447" xml-lang="en-US" l10n="U" oldref="3">Once you have defined a trace, you can point with the mouse cursor to the trace. The mouse cursor will change its shape. Double-click the trace with this cursor to select the referenced cell at the end of the trace. <comment>If you define an icon in the spreadsheet, you can put your cursor on it. It will change into a magnifying glass with reference arrows. Double-click the visible icon to select the cell at the furthest end of the icon.</comment></paragraph>
60 <embed href="text/scalc/01/06030100.xhp#spurzumvorgaenger"/>
61 <embed href="text/scalc/01/06030200.xhp#spurzumvorgaengerentfernen"/>
62 <embed href="text/scalc/01/06030300.xhp#spurzumnachfolger"/>
63 <embed href="text/scalc/01/06030400.xhp#spurzumnachfolgerentfernen"/>
64 <embed href="text/scalc/01/06030500.xhp#allespurenentfernen"/>
65 <embed href="text/scalc/01/06030600.xhp#spurzumfehler"/>
66 <embed href="text/scalc/01/06030800.xhp#dateneinkreisen"/>
67 <embed href="text/scalc/01/06030900.xhp#spurenaktualisieren"/>
68 <embed href="text/scalc/01/06031000.xhp#autoaktu"/>
69 <embed href="text/scalc/01/06030700.xhp#fuellmodus"/>
70 </body>
71 </helpdocument>