merge the formfield patch from ooo-build
[ooovba.git] / helpcontent2 / source / text / scalc / 01 / 02160000.xhp
blobcf75986115768bf6cdc2e2d243bc98abd09a13ff
1 <?xml version="1.0" encoding="UTF-8"?>
5 <!--
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 *
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: 02160000.xhp,v $
15 * $Revision: 1.8 $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
35 -->
38 <helpdocument version="1.0">
39 <meta>
40 <topic id="textscalc0102160000xml" indexer="include" status="PUBLISH">
41 <title xml-lang="en-US" id="tit">Delete Cells</title>
42 <filename>/text/scalc/01/02160000.xhp</filename>
43 </topic>
44 </meta>
45 <body>
49 <bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>cells; deleting cells</bookmark_value>
50 <bookmark_value>columns; deleting</bookmark_value>
51 <bookmark_value>rows; deleting</bookmark_value>
52 <bookmark_value>spreadsheets; deleting cells</bookmark_value>
53 <bookmark_value>deleting;cells/rows/columns</bookmark_value>
54 </bookmark>
55 <comment>MW made one "deleting;" entry out of 3</comment>
57 <bookmark xml-lang="en-US" branch="hid/FID_DELETE_CELL" id="bm_id512529" localize="false"/>
59 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteCell" id="bm_id3151115" localize="false"/>
60 <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1" l10n="U" oldref="1">Delete Cells</paragraph>
61 <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph" l10n="U" oldref="2"><variable id="zellenloeschentext"><ahelp hid=".uno:DeleteCell">Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space.</ahelp>
62 </variable> Note that the selected delete option is stored and reloaded when the dialog is next called.</paragraph>
63 <section id="howtoget">
65 <embed href="text/scalc/00/00000402.xhp#bzelo"/>
67 </section>
68 <paragraph xml-lang="en-US" id="hd_id3149121" role="heading" level="2" l10n="U" oldref="3">Selection</paragraph>
69 <paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="U" oldref="4">This area contains options for specifying how sheets are displayed after deleting cells.</paragraph>
71 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSUP" id="bm_id3154755" localize="false"/>
72 <paragraph xml-lang="en-US" id="hd_id3155767" role="heading" level="3" l10n="U" oldref="5">Shift cells up</paragraph>
73 <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph" l10n="U" oldref="6"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSUP">Fills the space produced by the deleted cells with the cells underneath it.</ahelp></paragraph>
75 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSLEFT" id="bm_id3147346" localize="false"/>
76 <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="3" l10n="U" oldref="7">Shift cells left</paragraph>
77 <paragraph xml-lang="en-US" id="par_id3154702" role="paragraph" l10n="U" oldref="8"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSLEFT">Fills the resulting space by the cells to the right of the deleted cells.</ahelp></paragraph>
79 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_DELROWS" id="bm_id3149566" localize="false"/>
81 <bookmark xml-lang="en-US" branch="hid/SID_DEL_ROWS" id="bm_id167872" localize="false"/>
83 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteRows" id="bm_id3149565" localize="false"/>
84 <paragraph xml-lang="en-US" id="hd_id3146918" role="heading" level="3" l10n="U" oldref="9">Delete entire row(s)</paragraph>
85 <paragraph xml-lang="en-US" id="par_id3148487" role="paragraph" l10n="U" oldref="10"><ahelp hid=".uno:DeleteRows">After selecting at least one cell, deletes the entire row from the sheet.</ahelp></paragraph>
87 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_DELCOLS" id="bm_id3150342" localize="false"/>
89 <bookmark xml-lang="en-US" branch="hid/SID_DEL_COLS" id="bm_id8964231" localize="false"/>
91 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteColumns" id="bm_id3159240" localize="false"/>
92 <paragraph xml-lang="en-US" id="hd_id3155114" role="heading" level="3" l10n="U" oldref="11">Delete entire column(s)</paragraph>
93 <paragraph xml-lang="en-US" id="par_id3150086" role="paragraph" l10n="U" oldref="12"><ahelp hid=".uno:DeleteColumns">After selecting at least one cell, deletes the entire column from the sheet.</ahelp></paragraph>
94 <section id="relatedtopics">
96 <paragraph xml-lang="en-US" id="par_id3166424" role="paragraph" l10n="C"><link href="text/scalc/01/02150000.xhp" name="Deleting Cells">Deleting Cells</link></paragraph>
98 </section>
99 </body>
100 </helpdocument>