1 <?xml version=
"1.0" encoding=
"UTF-8"?>
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: 06030000.xhp,v $
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 ************************************************************************
36 <helpdocument version=
"1.0">
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>
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>
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>
56 <section id=
"howtoget">
57 <embed href=
"text/scalc/00/00000406.xhp#exdektv"/>
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"/>