1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir<helpdocument version="1.0"> 3cdf0e10cSrcweir 4*ce44d6c1SAndrew Rist<!--*********************************************************** 5*ce44d6c1SAndrew Rist * 6*ce44d6c1SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*ce44d6c1SAndrew Rist * or more contributor license agreements. See the NOTICE file 8*ce44d6c1SAndrew Rist * distributed with this work for additional information 9*ce44d6c1SAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*ce44d6c1SAndrew Rist * to you under the Apache License, Version 2.0 (the 11*ce44d6c1SAndrew Rist * "License"); you may not use this file except in compliance 12*ce44d6c1SAndrew Rist * with the License. You may obtain a copy of the License at 13*ce44d6c1SAndrew Rist * 14*ce44d6c1SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*ce44d6c1SAndrew Rist * 16*ce44d6c1SAndrew Rist * Unless required by applicable law or agreed to in writing, 17*ce44d6c1SAndrew Rist * software distributed under the License is distributed on an 18*ce44d6c1SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*ce44d6c1SAndrew Rist * KIND, either express or implied. See the License for the 20*ce44d6c1SAndrew Rist * specific language governing permissions and limitations 21*ce44d6c1SAndrew Rist * under the License. 22*ce44d6c1SAndrew Rist * 23*ce44d6c1SAndrew Rist ***********************************************************--> 24*ce44d6c1SAndrew Rist 25*ce44d6c1SAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir<meta> 29cdf0e10cSrcweir <topic id="textscalcguidebordersxhp" indexer="include" status="PUBLISH"> 30cdf0e10cSrcweir <title xml-lang="en-US" id="tit">User Defined Borders in Cells </title> 31cdf0e10cSrcweir <filename>/text/scalc/guide/borders.xhp</filename> 32cdf0e10cSrcweir </topic> 33cdf0e10cSrcweir </meta> 34cdf0e10cSrcweir <body> 35cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3457441"><bookmark_value>cells;borders</bookmark_value> 36cdf0e10cSrcweir <bookmark_value>line arrangements with cells</bookmark_value> 37cdf0e10cSrcweir <bookmark_value>borders;cells</bookmark_value> 38cdf0e10cSrcweir</bookmark><comment>MW made "line arrangement;" a one level entry</comment> 39cdf0e10cSrcweir<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> 40cdf0e10cSrcweir</variable></paragraph> 41cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id2320017" role="paragraph" l10n="NEW">You can apply a variety of different lines to selected cells.</paragraph> 42cdf0e10cSrcweir <list type="ordered"> 43cdf0e10cSrcweir <listitem> 44cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8055665" role="paragraph" l10n="NEW">Select the cell or a block of cells.</paragraph> 45cdf0e10cSrcweir </listitem> 46cdf0e10cSrcweir <listitem> 47cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id9181188" role="paragraph" l10n="NEW">Choose <item type="menuitem">Format - Cells</item>.</paragraph> 48cdf0e10cSrcweir </listitem> 49cdf0e10cSrcweir <listitem> 50cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id9947508" role="paragraph" l10n="NEW">In the dialog, click the <emph>Borders</emph> tab.</paragraph> 51cdf0e10cSrcweir </listitem> 52cdf0e10cSrcweir <listitem> 53cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id7907956" role="paragraph" l10n="NEW">Choose the border options you want to apply and click OK.</paragraph> 54cdf0e10cSrcweir </listitem> 55cdf0e10cSrcweir </list> 56cdf0e10cSrcweir <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> 57cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id4454481" role="heading" level="2" l10n="NEW">Selection of cells</paragraph> 58cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id7251503" role="paragraph" l10n="NEW">Depending on the selection of cells, the area looks different.</paragraph> 59cdf0e10cSrcweir <table id="tbl_id4423352"> 60cdf0e10cSrcweir <tablerow> 61cdf0e10cSrcweir <tablecell> 62cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8716696" role="tablehead" l10n="NEW">Selection</paragraph> 63cdf0e10cSrcweir </tablecell> 64cdf0e10cSrcweir <tablecell> 65cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id4677877" role="tablehead" l10n="NEW">Line arrangement area</paragraph> 66cdf0e10cSrcweir </tablecell> 67cdf0e10cSrcweir </tablerow> 68cdf0e10cSrcweir <tablerow> 69cdf0e10cSrcweir <tablecell> 70cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id807824" role="tablecontent" l10n="NEW">One cell</paragraph> 71cdf0e10cSrcweir </tablecell> 72cdf0e10cSrcweir <tablecell> 73cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8473464" role="tablecontent" l10n="NEW"> 74cdf0e10cSrcweir<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> 75cdf0e10cSrcweir </image></paragraph> 76cdf0e10cSrcweir </tablecell> 77cdf0e10cSrcweir </tablerow> 78cdf0e10cSrcweir <tablerow> 79cdf0e10cSrcweir <tablecell> 80cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3509933" role="tablecontent" l10n="NEW">Cells in a column</paragraph> 81cdf0e10cSrcweir </tablecell> 82cdf0e10cSrcweir <tablecell> 83cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id6635639" role="tablecontent" l10n="NEW"> 84cdf0e10cSrcweir<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> 85cdf0e10cSrcweir </image></paragraph> 86cdf0e10cSrcweir </tablecell> 87cdf0e10cSrcweir </tablerow> 88cdf0e10cSrcweir <tablerow> 89cdf0e10cSrcweir <tablecell> 90cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8073366" role="tablecontent" l10n="NEW">Cells in a row</paragraph> 91cdf0e10cSrcweir </tablecell> 92cdf0e10cSrcweir <tablecell> 93cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id6054567" role="tablecontent" l10n="NEW"> 94cdf0e10cSrcweir<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> 95cdf0e10cSrcweir </image></paragraph> 96cdf0e10cSrcweir </tablecell> 97cdf0e10cSrcweir </tablerow> 98cdf0e10cSrcweir <tablerow> 99cdf0e10cSrcweir <tablecell> 100cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id466322" role="tablecontent" l10n="NEW">Cells in a block of 2x2 or more</paragraph> 101cdf0e10cSrcweir </tablecell> 102cdf0e10cSrcweir <tablecell> 103cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id4511551" role="tablecontent" l10n="NEW"> 104cdf0e10cSrcweir<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> 105cdf0e10cSrcweir </image></paragraph> 106cdf0e10cSrcweir </tablecell> 107cdf0e10cSrcweir </tablerow> 108cdf0e10cSrcweir </table> 109cdf0e10cSrcweir 110cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id5383465" role="note" l10n="NEW">You cannot apply borders to multiple selections.</paragraph> 111cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id7790154" role="heading" level="2" l10n="NEW">Default Settings</paragraph> 112cdf0e10cSrcweir <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> 113cdf0e10cSrcweir <list type="unordered"> 114cdf0e10cSrcweir <listitem> 115cdf0e10cSrcweir <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> 116cdf0e10cSrcweir </listitem> 117cdf0e10cSrcweir <listitem> 118cdf0e10cSrcweir <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> 119cdf0e10cSrcweir </listitem> 120cdf0e10cSrcweir <listitem> 121cdf0e10cSrcweir <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> 122cdf0e10cSrcweir </listitem> 123cdf0e10cSrcweir </list> 124cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id8989226" role="heading" level="3" l10n="NEW">Examples</paragraph> 125cdf0e10cSrcweir <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> 126cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8119754" role="paragraph" l10n="NEW"> 127cdf0e10cSrcweir<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> 128cdf0e10cSrcweir </image></paragraph> 129cdf0e10cSrcweir <list type="unordered"> 130cdf0e10cSrcweir <listitem> 131cdf0e10cSrcweir <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> 132cdf0e10cSrcweir </listitem> 133cdf0e10cSrcweir <listitem> 134cdf0e10cSrcweir <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> 135cdf0e10cSrcweir </listitem> 136cdf0e10cSrcweir <listitem> 137cdf0e10cSrcweir <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> 138cdf0e10cSrcweir </listitem> 139cdf0e10cSrcweir </list> 140cdf0e10cSrcweir <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> 141cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3593554" role="heading" level="2" l10n="NEW">User Defined Settings</paragraph> 142cdf0e10cSrcweir <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> 143cdf0e10cSrcweir <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> 144cdf0e10cSrcweir <table id="tbl_id5196996"> 145cdf0e10cSrcweir <tablerow> 146cdf0e10cSrcweir <tablecell> 147cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8037659" role="tablehead" l10n="NEW">Line types</paragraph> 148cdf0e10cSrcweir </tablecell> 149cdf0e10cSrcweir <tablecell> 150cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id2305978" role="tablehead" l10n="NEW">Image</paragraph> 151cdf0e10cSrcweir </tablecell> 152cdf0e10cSrcweir <tablecell> 153cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8716086" role="tablehead" l10n="NEW">Meaning</paragraph> 154cdf0e10cSrcweir </tablecell> 155cdf0e10cSrcweir </tablerow> 156cdf0e10cSrcweir <tablerow> 157cdf0e10cSrcweir <tablecell> 158cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3978087" role="tablecontent" l10n="NEW">A black line</paragraph> 159cdf0e10cSrcweir </tablecell> 160cdf0e10cSrcweir <tablecell> 161cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id4065065" role="tablecontent" l10n="NEW"> 162cdf0e10cSrcweir<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> 163cdf0e10cSrcweir </image></paragraph> 164cdf0e10cSrcweir </tablecell> 165cdf0e10cSrcweir <tablecell> 166cdf0e10cSrcweir <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> 167cdf0e10cSrcweir </tablecell> 168cdf0e10cSrcweir </tablerow> 169cdf0e10cSrcweir <tablerow> 170cdf0e10cSrcweir <tablecell> 171cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id1209143" role="tablecontent" l10n="NEW">A gray line</paragraph> 172cdf0e10cSrcweir </tablecell> 173cdf0e10cSrcweir <tablecell> 174cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id6653340" role="tablecontent" l10n="NEW"> 175cdf0e10cSrcweir<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> 176cdf0e10cSrcweir </image></paragraph> 177cdf0e10cSrcweir </tablecell> 178cdf0e10cSrcweir <tablecell> 179cdf0e10cSrcweir <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> 180cdf0e10cSrcweir </tablecell> 181cdf0e10cSrcweir </tablerow> 182cdf0e10cSrcweir <tablerow> 183cdf0e10cSrcweir <tablecell> 184cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id5374919" role="tablecontent" l10n="NEW">A white line</paragraph> 185cdf0e10cSrcweir </tablecell> 186cdf0e10cSrcweir <tablecell> 187cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id52491" role="tablecontent" l10n="NEW"> 188cdf0e10cSrcweir<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> 189cdf0e10cSrcweir </image></paragraph> 190cdf0e10cSrcweir </tablecell> 191cdf0e10cSrcweir <tablecell> 192cdf0e10cSrcweir <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> 193cdf0e10cSrcweir </tablecell> 194cdf0e10cSrcweir </tablerow> 195cdf0e10cSrcweir </table> 196cdf0e10cSrcweir 197cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id7282937" role="heading" level="3" l10n="NEW">Examples</paragraph> 198cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id4230780" role="paragraph" l10n="NEW">Select a single cell, then choose <emph>Format - Cells - Borders</emph>.</paragraph> 199cdf0e10cSrcweir <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> 200cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id5149693" role="paragraph" l10n="NEW"> 201cdf0e10cSrcweir<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> 202cdf0e10cSrcweir </image></paragraph> 203cdf0e10cSrcweir <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> 204cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id6342051" role="paragraph" l10n="NEW"> 205cdf0e10cSrcweir<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> 206cdf0e10cSrcweir </image></paragraph> 207cdf0e10cSrcweir <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> 208cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id2882778" role="paragraph" l10n="NEW"> 209cdf0e10cSrcweir<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> 210cdf0e10cSrcweir </image></paragraph> 211cdf0e10cSrcweir <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> 212cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id2102420" role="paragraph" l10n="NEW"> 213cdf0e10cSrcweir<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> 214cdf0e10cSrcweir </image></paragraph> 215cdf0e10cSrcweir <section id="relatedtopics"> 216cdf0e10cSrcweir<switch select="appl"> 217cdf0e10cSrcweir<case select="WRITER"><embed href="text/swriter/guide/border_page.xhp#border_page"/> 218cdf0e10cSrcweir</case> 219cdf0e10cSrcweir</switch><embed href="text/shared/guide/border_paragraph.xhp#border_paragraph"/> 220cdf0e10cSrcweir </section> 221cdf0e10cSrcweir </body> 222cdf0e10cSrcweir</helpdocument>
