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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: borders.xhp,v $
* $Revision: 1.7 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidebordersxhp" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">User Defined Borders in Cells </title>
<filename>text/scalc/guide/borders.xhp</filename>
</topic>
<history>
<created date="2005-11-01T15:03:17">Cell Borders</created>
<lastedited date="2006-06-13T14:09:32"/>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3457441"><bookmark_value>cells;borders</bookmark_value>
<bookmark_value>line arrangement;cells</bookmark_value>
<bookmark_value>borders;cells</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id4544816" xml-lang="en-US" level="1" l10n="NEW"><variable id="borders"><link href="text/scalc/guide/borders.xhp">User Defined Borders in Cells</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id2320017" xml-lang="en-US" l10n="NEW">You can apply a variety of different lines to selected cells.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id8055665" xml-lang="en-US" l10n="NEW">Select the cell or a block of cells.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id9181188" xml-lang="en-US" l10n="NEW">Choose <item type="menuitem">Format - Cells</item>.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id9947508" xml-lang="en-US" l10n="NEW">In the dialog, click the <emph>Borders</emph> tab.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id7907956" xml-lang="en-US" l10n="NEW">Choose the border options you want to apply and click OK.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id1342204" xml-lang="en-US" l10n="NEW">The options in the <emph>Line arrangement</emph> area can be used to apply multiple border styles.</paragraph>
<paragraph role="heading" id="hd_id4454481" xml-lang="en-US" level="2" l10n="NEW">Selection of cells</paragraph>
<paragraph role="paragraph" id="par_id7251503" xml-lang="en-US" l10n="NEW">Depending on the selection of cells, the area looks different.</paragraph>
<table id="tbl_id4423352">
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id8716696" xml-lang="en-US" l10n="NEW">Selection</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id4677877" xml-lang="en-US" l10n="NEW">Line arrangement area</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id807824" xml-lang="en-US" l10n="NEW">One cell</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id8473464" xml-lang="en-US" l10n="NEW">
<image id="img_id1737113" src="res/helpimg/border_ca_1.png" width="1.2709inch" height="1.6146inch"><alt id="alt_id1737113" xml-lang="en-US">borders with one cell selected</alt>
</image></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3509933" xml-lang="en-US" l10n="NEW">Cells in a column</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6635639" xml-lang="en-US" l10n="NEW">
<image id="img_id1680959" src="res/helpimg/border_ca_2.png" width="1.2917inch" height="1.6146inch"><alt id="alt_id1680959" xml-lang="en-US">borders with a column selected</alt>
</image></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id8073366" xml-lang="en-US" l10n="NEW">Cells in a row</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6054567" xml-lang="en-US" l10n="NEW">
<image id="img_id9623096" src="res/helpimg/border_ca_3.png" width="1.2811inch" height="1.6146inch"><alt id="alt_id9623096" xml-lang="en-US">borders with a row selected</alt>
</image></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id466322" xml-lang="en-US" l10n="NEW">Cells in a block of 2x2 or more</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4511551" xml-lang="en-US" l10n="NEW">
<image id="img_id8139591" src="res/helpimg/border_ca_4.png" width="1.2917inch" height="1.6252inch"><alt id="alt_id8139591" xml-lang="en-US">borders with a block selected</alt>
</image></paragraph>
</tablecell>
</tablerow>
</table>
<paragraph role="note" id="par_id5383465" xml-lang="en-US" l10n="NEW">You cannot apply borders to multiple selections.</paragraph>
<paragraph role="heading" id="hd_id7790154" xml-lang="en-US" level="2" l10n="NEW">Default settings</paragraph>
<paragraph role="paragraph" id="par_id2918485" xml-lang="en-US" l10n="NEW">Click one of the <emph>Default</emph> icons to set or reset multiple borders.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id1836909" xml-lang="en-US" l10n="NEW">The thin gray lines inside an icon show the borders that will be reset or cleared.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id5212561" xml-lang="en-US" l10n="NEW">The dark lines inside an icon show the lines that will be set using the selected line style and color.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id4818872" xml-lang="en-US" l10n="NEW">The thick gray lines inside an icon show the lines that will not be changed.</paragraph>
</listitem>
</list>
<paragraph role="heading" id="hd_id8989226" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph>
<paragraph role="paragraph" id="par_id622577" xml-lang="en-US" l10n="NEW">Select a block of about 8x8 cells, then choose <emph>Format - Cells - Borders</emph>.</paragraph>
<paragraph role="paragraph" id="par_id8119754" xml-lang="en-US" l10n="NEW">
<image id="img_id7261268" src="res/helpimg/border_ca_5.png" width="1.1354inch" height="0.25inch"><alt id="alt_id7261268" xml-lang="en-US">default icon row of Borders tab page</alt>
</image></paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id8964201" xml-lang="en-US" l10n="NEW">Click the left icon to clear all lines. This removes all outer borders, all inner lines, and all diagonal lines.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id6048463" xml-lang="en-US" l10n="NEW">Click the second icon from the left to set an outer border and to remove all other lines.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id1495406" xml-lang="en-US" l10n="NEW">Click the rightmost icon to set an outer border. The inner lines are not changed, except the diagonal lines, which will be removed.<comment>is this a bug?</comment></paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id9269386" xml-lang="en-US" l10n="NEW">Now you can continue to see which lines the other icons will set or remove.</paragraph>
<paragraph role="heading" id="hd_id3593554" xml-lang="en-US" level="2" l10n="NEW">User defined settings</paragraph>
<paragraph role="paragraph" id="par_id4018066" xml-lang="en-US" l10n="NEW">In the <emph>User defined</emph> area, you can click to set or remove individual lines. The preview shows lines in three different states. </paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id8004699" xml-lang="en-US" l10n="NEW">Repeatedly click an edge or a corner to switch through the three different states.</paragraph>
</listitem>
</list>
<table id="tbl_id5196996">
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id8037659" xml-lang="en-US" l10n="NEW">Line types</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id2305978" xml-lang="en-US" l10n="NEW">Image</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id8716086" xml-lang="en-US" l10n="NEW">Meaning</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3978087" xml-lang="en-US" l10n="NEW">A black line</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4065065" xml-lang="en-US" l10n="NEW">
<image id="img_id9379863" src="res/helpimg/border_ca_7.png" width="1.2811inch" height="1.1354inch"><alt id="alt_id9379863" xml-lang="en-US">solid line for user defined border</alt>
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6987823" xml-lang="en-US" l10n="NEW">A black line sets the corresponding line of the selected cells. The line is shown as a dotted line when you choose the 0.05 pt line style. Double lines are shown when you select a double line style.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1209143" xml-lang="en-US" l10n="NEW">A gray line</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6653340" xml-lang="en-US" l10n="NEW">
<image id="img_id6972563" src="res/helpimg/border_ca_gray.png" width="1.2709inch" height="1.1563inch"><alt id="alt_id6972563" xml-lang="en-US">gray line for user defined border</alt>
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2278817" xml-lang="en-US" l10n="NEW">A gray line is shown when the corresponding line of the selected cells will not be changed. No line will be set or removed at this position.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id5374919" xml-lang="en-US" l10n="NEW">A white line</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id52491" xml-lang="en-US" l10n="NEW">
<image id="img_id3801080" src="res/helpimg/border_ca_white.png" width="1.2811inch" height="1.1354inch"><alt id="alt_id3801080" xml-lang="en-US">white line for user defined border</alt>
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id372325" xml-lang="en-US" l10n="NEW">A white line is shown when the corresponding line of the selected cells will be removed.</paragraph>
</tablecell>
</tablerow>
</table>
<paragraph role="heading" id="hd_id7282937" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph>
<paragraph role="paragraph" id="par_id4230780" xml-lang="en-US" l10n="NEW">Select a single cell, then choose <emph>Format - Cells - Borders</emph>.</paragraph>
<paragraph role="paragraph" id="par_id1712393" xml-lang="en-US" l10n="NEW">Click the lower edge to set a very thin line as a lower border. All other lines will be removed from the cell.</paragraph>
<paragraph role="paragraph" id="par_id5149693" xml-lang="en-US" l10n="NEW">
<image id="img_id9467452" src="res/helpimg/border_ca_6.png" width="1.2709inch" height="1.1563inch"><alt id="alt_id9467452" xml-lang="en-US">setting a thin lower border</alt>
</image></paragraph>
<paragraph role="paragraph" id="par_id5759453" xml-lang="en-US" l10n="NEW">Choose a thicker line style and click the lower edge. This sets a thicker line as a lower border.</paragraph>
<paragraph role="paragraph" id="par_id6342051" xml-lang="en-US" l10n="NEW">
<image id="img_id7431562" src="res/helpimg/border_ca_7.png" width="1.2811inch" height="1.1354inch"><alt id="alt_id7431562" xml-lang="en-US">setting a thick line as a border</alt>
</image></paragraph>
<paragraph role="paragraph" id="par_id5775322" xml-lang="en-US" l10n="NEW">Click the second <emph>Default</emph> icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border.</paragraph>
<paragraph role="paragraph" id="par_id2882778" xml-lang="en-US" l10n="NEW">
<image id="img_id8155766.00000001" src="res/helpimg/border_ca_8.png" width="1.2709inch" height="1.1354inch"><alt id="alt_id8155766.00000001" xml-lang="en-US">removing lower border</alt>
</image></paragraph>
<paragraph role="paragraph" id="par_id8102053" xml-lang="en-US" l10n="NEW">You can combine several line types and styles. The last image shows how to set thick outer borders (the thick black lines), while any diagonal lines inside the cell will not be touched (gray lines).</paragraph>
<paragraph role="paragraph" id="par_id2102420" xml-lang="en-US" l10n="NEW">
<image id="img_id5380718" src="res/helpimg/border_ca_9.png" width="1.2709inch" height="1.1563inch"><alt id="alt_id5380718" xml-lang="en-US">advanced example for cell borders</alt>
</image></paragraph>
<section id="relatedtopics">
<switch select="appl">
<case select="WRITER"><embed href="text/swriter/guide/border_page.xhp#border_page"/>
</case>
</switch>
<embed href="text/shared/guide/border_paragraph.xhp#border_paragraph"/>
</section>
</body>
</helpdocument>
|
