1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textscalcguidebordersxhp" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">User Defined Borders in Cells </title> 31*b1cdbd2cSJim Jagielski <filename>/text/scalc/guide/borders.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3457441"><bookmark_value>cells;borders</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>line arrangements with cells</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>borders;cells</bookmark_value> 38*b1cdbd2cSJim Jagielski</bookmark><comment>MW made "line arrangement;" a one level entry</comment> 39*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id4544816" role="heading" level="1" l10n="NEW"><variable id="borders"><link href="text/scalc/guide/borders.xhp">User Defined Borders in Cells</link> 40*b1cdbd2cSJim Jagielski</variable></paragraph> 41*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2320017" role="paragraph" l10n="NEW">You can apply a variety of different lines to selected cells.</paragraph> 42*b1cdbd2cSJim Jagielski <list type="ordered"> 43*b1cdbd2cSJim Jagielski <listitem> 44*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8055665" role="paragraph" l10n="NEW">Select the cell or a block of cells.</paragraph> 45*b1cdbd2cSJim Jagielski </listitem> 46*b1cdbd2cSJim Jagielski <listitem> 47*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id9181188" role="paragraph" l10n="NEW">Choose <item type="menuitem">Format - Cells</item>.</paragraph> 48*b1cdbd2cSJim Jagielski </listitem> 49*b1cdbd2cSJim Jagielski <listitem> 50*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id9947508" role="paragraph" l10n="NEW">In the dialog, click the <emph>Borders</emph> tab.</paragraph> 51*b1cdbd2cSJim Jagielski </listitem> 52*b1cdbd2cSJim Jagielski <listitem> 53*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id7907956" role="paragraph" l10n="NEW">Choose the border options you want to apply and click OK.</paragraph> 54*b1cdbd2cSJim Jagielski </listitem> 55*b1cdbd2cSJim Jagielski </list> 56*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1342204" role="paragraph" l10n="NEW">The options in the <emph>Line arrangement</emph> area can be used to apply multiple border styles.</paragraph> 57*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id4454481" role="heading" level="2" l10n="NEW">Selection of cells</paragraph> 58*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id7251503" role="paragraph" l10n="NEW">Depending on the selection of cells, the area looks different.</paragraph> 59*b1cdbd2cSJim Jagielski <table id="tbl_id4423352"> 60*b1cdbd2cSJim Jagielski <tablerow> 61*b1cdbd2cSJim Jagielski <tablecell> 62*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8716696" role="tablehead" l10n="NEW">Selection</paragraph> 63*b1cdbd2cSJim Jagielski </tablecell> 64*b1cdbd2cSJim Jagielski <tablecell> 65*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4677877" role="tablehead" l10n="NEW">Line arrangement area</paragraph> 66*b1cdbd2cSJim Jagielski </tablecell> 67*b1cdbd2cSJim Jagielski </tablerow> 68*b1cdbd2cSJim Jagielski <tablerow> 69*b1cdbd2cSJim Jagielski <tablecell> 70*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id807824" role="tablecontent" l10n="NEW">One cell</paragraph> 71*b1cdbd2cSJim Jagielski </tablecell> 72*b1cdbd2cSJim Jagielski <tablecell> 73*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8473464" role="tablecontent" l10n="NEW"> 74*b1cdbd2cSJim Jagielski<image id="img_id1737113" src="res/helpimg/border_ca_1.png" width="1.2602in" height="1.5937in"><alt xml-lang="en-US" id="alt_id1737113">borders with one cell selected</alt> 75*b1cdbd2cSJim Jagielski </image></paragraph> 76*b1cdbd2cSJim Jagielski </tablecell> 77*b1cdbd2cSJim Jagielski </tablerow> 78*b1cdbd2cSJim Jagielski <tablerow> 79*b1cdbd2cSJim Jagielski <tablecell> 80*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3509933" role="tablecontent" l10n="NEW">Cells in a column</paragraph> 81*b1cdbd2cSJim Jagielski </tablecell> 82*b1cdbd2cSJim Jagielski <tablecell> 83*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6635639" role="tablecontent" l10n="NEW"> 84*b1cdbd2cSJim Jagielski<image id="img_id1680959" src="res/helpimg/border_ca_2.png" width="1.2602in" height="1.5937in"><alt xml-lang="en-US" id="alt_id1680959">borders with a column selected</alt> 85*b1cdbd2cSJim Jagielski </image></paragraph> 86*b1cdbd2cSJim Jagielski </tablecell> 87*b1cdbd2cSJim Jagielski </tablerow> 88*b1cdbd2cSJim Jagielski <tablerow> 89*b1cdbd2cSJim Jagielski <tablecell> 90*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8073366" role="tablecontent" l10n="NEW">Cells in a row</paragraph> 91*b1cdbd2cSJim Jagielski </tablecell> 92*b1cdbd2cSJim Jagielski <tablecell> 93*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6054567" role="tablecontent" l10n="NEW"> 94*b1cdbd2cSJim Jagielski<image id="img_id9623096" src="res/helpimg/border_ca_3.png" width="1.2602in" height="1.5937in"><alt xml-lang="en-US" id="alt_id9623096">borders with a row selected</alt> 95*b1cdbd2cSJim Jagielski </image></paragraph> 96*b1cdbd2cSJim Jagielski </tablecell> 97*b1cdbd2cSJim Jagielski </tablerow> 98*b1cdbd2cSJim Jagielski <tablerow> 99*b1cdbd2cSJim Jagielski <tablecell> 100*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id466322" role="tablecontent" l10n="NEW">Cells in a block of 2x2 or more</paragraph> 101*b1cdbd2cSJim Jagielski </tablecell> 102*b1cdbd2cSJim Jagielski <tablecell> 103*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4511551" role="tablecontent" l10n="NEW"> 104*b1cdbd2cSJim Jagielski<image id="img_id8139591" src="res/helpimg/border_ca_4.png" width="1.2602in" height="1.5937in"><alt xml-lang="en-US" id="alt_id8139591">borders with a block selected</alt> 105*b1cdbd2cSJim Jagielski </image></paragraph> 106*b1cdbd2cSJim Jagielski </tablecell> 107*b1cdbd2cSJim Jagielski </tablerow> 108*b1cdbd2cSJim Jagielski </table> 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5383465" role="note" l10n="NEW">You cannot apply borders to multiple selections.</paragraph> 111*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id7790154" role="heading" level="2" l10n="NEW">Default Settings</paragraph> 112*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2918485" role="paragraph" l10n="NEW">Click one of the <emph>Default</emph> icons to set or reset multiple borders.</paragraph> 113*b1cdbd2cSJim Jagielski <list type="unordered"> 114*b1cdbd2cSJim Jagielski <listitem> 115*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1836909" role="listitem" l10n="NEW">The thin gray lines inside an icon show the borders that will be reset or cleared.</paragraph> 116*b1cdbd2cSJim Jagielski </listitem> 117*b1cdbd2cSJim Jagielski <listitem> 118*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5212561" role="listitem" l10n="NEW">The dark lines inside an icon show the lines that will be set using the selected line style and color.</paragraph> 119*b1cdbd2cSJim Jagielski </listitem> 120*b1cdbd2cSJim Jagielski <listitem> 121*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4818872" role="listitem" l10n="NEW">The thick gray lines inside an icon show the lines that will not be changed.</paragraph> 122*b1cdbd2cSJim Jagielski </listitem> 123*b1cdbd2cSJim Jagielski </list> 124*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id8989226" role="heading" level="3" l10n="NEW">Examples</paragraph> 125*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id622577" role="paragraph" l10n="NEW">Select a block of about 8x8 cells, then choose <emph>Format - Cells - Borders</emph>.</paragraph> 126*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8119754" role="paragraph" l10n="NEW"> 127*b1cdbd2cSJim Jagielski<image id="img_id7261268" src="res/helpimg/border_ca_5.png" width="1.0937in" height="0.2189in"><alt xml-lang="en-US" id="alt_id7261268">default icon row of Borders tab page</alt> 128*b1cdbd2cSJim Jagielski </image></paragraph> 129*b1cdbd2cSJim Jagielski <list type="unordered"> 130*b1cdbd2cSJim Jagielski <listitem> 131*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8964201" role="listitem" l10n="NEW">Click the left icon to clear all lines. This removes all outer borders, all inner lines, and all diagonal lines.</paragraph> 132*b1cdbd2cSJim Jagielski </listitem> 133*b1cdbd2cSJim Jagielski <listitem> 134*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6048463" role="listitem" l10n="NEW">Click the second icon from the left to set an outer border and to remove all other lines.</paragraph> 135*b1cdbd2cSJim Jagielski </listitem> 136*b1cdbd2cSJim Jagielski <listitem> 137*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1495406" role="listitem" 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> 138*b1cdbd2cSJim Jagielski </listitem> 139*b1cdbd2cSJim Jagielski </list> 140*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id9269386" role="paragraph" l10n="NEW">Now you can continue to see which lines the other icons will set or remove.</paragraph> 141*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3593554" role="heading" level="2" l10n="NEW">User Defined Settings</paragraph> 142*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4018066" role="paragraph" 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> 143*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8004699" role="paragraph" l10n="NEW">Repeatedly click an edge or a corner to switch through the three different states.</paragraph> 144*b1cdbd2cSJim Jagielski <table id="tbl_id5196996"> 145*b1cdbd2cSJim Jagielski <tablerow> 146*b1cdbd2cSJim Jagielski <tablecell> 147*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8037659" role="tablehead" l10n="NEW">Line types</paragraph> 148*b1cdbd2cSJim Jagielski </tablecell> 149*b1cdbd2cSJim Jagielski <tablecell> 150*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2305978" role="tablehead" l10n="NEW">Image</paragraph> 151*b1cdbd2cSJim Jagielski </tablecell> 152*b1cdbd2cSJim Jagielski <tablecell> 153*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8716086" role="tablehead" l10n="NEW">Meaning</paragraph> 154*b1cdbd2cSJim Jagielski </tablecell> 155*b1cdbd2cSJim Jagielski </tablerow> 156*b1cdbd2cSJim Jagielski <tablerow> 157*b1cdbd2cSJim Jagielski <tablecell> 158*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3978087" role="tablecontent" l10n="NEW">A black line</paragraph> 159*b1cdbd2cSJim Jagielski </tablecell> 160*b1cdbd2cSJim Jagielski <tablecell> 161*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4065065" role="tablecontent" l10n="NEW"> 162*b1cdbd2cSJim Jagielski<image id="img_id9379863" src="res/helpimg/border_ca_7.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id9379863">solid line for user defined border</alt> 163*b1cdbd2cSJim Jagielski </image></paragraph> 164*b1cdbd2cSJim Jagielski </tablecell> 165*b1cdbd2cSJim Jagielski <tablecell> 166*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6987823" role="tablecontent" 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> 167*b1cdbd2cSJim Jagielski </tablecell> 168*b1cdbd2cSJim Jagielski </tablerow> 169*b1cdbd2cSJim Jagielski <tablerow> 170*b1cdbd2cSJim Jagielski <tablecell> 171*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1209143" role="tablecontent" l10n="NEW">A gray line</paragraph> 172*b1cdbd2cSJim Jagielski </tablecell> 173*b1cdbd2cSJim Jagielski <tablecell> 174*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6653340" role="tablecontent" l10n="NEW"> 175*b1cdbd2cSJim Jagielski<image id="img_id6972563" src="res/helpimg/border_ca_gray.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id6972563">gray line for user defined border</alt> 176*b1cdbd2cSJim Jagielski </image></paragraph> 177*b1cdbd2cSJim Jagielski </tablecell> 178*b1cdbd2cSJim Jagielski <tablecell> 179*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2278817" role="tablecontent" 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> 180*b1cdbd2cSJim Jagielski </tablecell> 181*b1cdbd2cSJim Jagielski </tablerow> 182*b1cdbd2cSJim Jagielski <tablerow> 183*b1cdbd2cSJim Jagielski <tablecell> 184*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5374919" role="tablecontent" l10n="NEW">A white line</paragraph> 185*b1cdbd2cSJim Jagielski </tablecell> 186*b1cdbd2cSJim Jagielski <tablecell> 187*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id52491" role="tablecontent" l10n="NEW"> 188*b1cdbd2cSJim Jagielski<image id="img_id3801080" src="res/helpimg/border_ca_white.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id3801080">white line for user defined border</alt> 189*b1cdbd2cSJim Jagielski </image></paragraph> 190*b1cdbd2cSJim Jagielski </tablecell> 191*b1cdbd2cSJim Jagielski <tablecell> 192*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id372325" role="tablecontent" l10n="NEW">A white line is shown when the corresponding line of the selected cells will be removed.</paragraph> 193*b1cdbd2cSJim Jagielski </tablecell> 194*b1cdbd2cSJim Jagielski </tablerow> 195*b1cdbd2cSJim Jagielski </table> 196*b1cdbd2cSJim Jagielski 197*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id7282937" role="heading" level="3" l10n="NEW">Examples</paragraph> 198*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id4230780" role="paragraph" l10n="NEW">Select a single cell, then choose <emph>Format - Cells - Borders</emph>.</paragraph> 199*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id1712393" role="paragraph" 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> 200*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5149693" role="paragraph" l10n="NEW"> 201*b1cdbd2cSJim Jagielski<image id="img_id9467452" src="res/helpimg/border_ca_6.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id9467452">setting a thin lower border</alt> 202*b1cdbd2cSJim Jagielski </image></paragraph> 203*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5759453" role="paragraph" l10n="NEW">Choose a thicker line style and click the lower edge. This sets a thicker line as a lower border.</paragraph> 204*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id6342051" role="paragraph" l10n="NEW"> 205*b1cdbd2cSJim Jagielski<image id="img_id7431562" src="res/helpimg/border_ca_7.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id7431562">setting a thick line as a border</alt> 206*b1cdbd2cSJim Jagielski </image></paragraph> 207*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id5775322" role="paragraph" 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> 208*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2882778" role="paragraph" l10n="NEW"> 209*b1cdbd2cSJim Jagielski<image id="img_id8155766.00000001" src="res/helpimg/border_ca_8.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id8155766.00000001">removing lower border</alt> 210*b1cdbd2cSJim Jagielski </image></paragraph> 211*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id8102053" role="paragraph" 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> 212*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id2102420" role="paragraph" l10n="NEW"> 213*b1cdbd2cSJim Jagielski<image id="img_id5380718" src="res/helpimg/border_ca_9.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id5380718">advanced example for cell borders</alt> 214*b1cdbd2cSJim Jagielski </image></paragraph> 215*b1cdbd2cSJim Jagielski <section id="relatedtopics"> 216*b1cdbd2cSJim Jagielski<switch select="appl"> 217*b1cdbd2cSJim Jagielski<case select="WRITER"><embed href="text/swriter/guide/border_page.xhp#border_page"/> 218*b1cdbd2cSJim Jagielski</case> 219*b1cdbd2cSJim Jagielski</switch><embed href="text/shared/guide/border_paragraph.xhp#border_paragraph"/> 220*b1cdbd2cSJim Jagielski </section> 221*b1cdbd2cSJim Jagielski </body> 222*b1cdbd2cSJim Jagielski</helpdocument>
