blob: 35e0b4e1d3d5e91e72e5f07bb95ac21dc245efcb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112080500xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">AutoOutline</title>
<filename>/text/scalc/01/12080500.xhp</filename>
</topic>
</meta>
<body>
<section id="auto_outline">
<bookmark xml-lang="en-US" branch="hid/.uno:AutoOutline" id="bm_id1815805" localize="false"/>
<h1 id="hd_id3150275"><link href="text/scalc/01/12080500.xhp" name="AutoOutline">AutoOutline</link></h1>
<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US"><ahelp hid=".uno:AutoOutline">If the selected cell range contains formulas or references, $[officename] automatically outlines the selection.</ahelp></paragraph>
</section>
<section id="howtoget">
<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US" localize="false"><embedvar href="text/scalc/00/00000412.xhp#dnglagl"/></paragraph>
</section>
<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US">For example, consider the following table:</paragraph>
<table id="tbl_id3125865">
<tablerow>
<tablecell>
<paragraph role="tablehead" id="par_id3154123" xml-lang="en-US">January</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3154011" xml-lang="en-US">February</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3152460" xml-lang="en-US">March</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3146119" xml-lang="en-US">1st Quarter</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3155854" xml-lang="en-US">April</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3148575" xml-lang="en-US">May</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3145271" xml-lang="en-US">June</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3145648" xml-lang="en-US">2nd Quarter</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US" localize="false">100</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3145251" xml-lang="en-US" localize="false">120</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3149400" xml-lang="en-US" localize="false">130</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3150328" xml-lang="en-US" localize="false">350</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3155443" xml-lang="en-US" localize="false">100</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3153713" xml-lang="en-US" localize="false">100</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" localize="false">200</paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3145230" xml-lang="en-US" localize="false">400</paragraph>
</tablecell>
</tablerow>
</table>
<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US">The cells for the 1st and 2nd quarters each contain a sum formula for the three cells to their left. If you apply the <emph>AutoOutline</emph> command, the table is grouped into two quarters.</paragraph>
<paragraph role="paragraph" id="par_id3146918" xml-lang="en-US">To remove the outline, select the table, and then choose <link href="text/scalc/01/12080600.xhp" name="Data - Group and Outline - Remove">Data - Group and Outline - Remove</link>.</paragraph>
</body>
</helpdocument>
|
