1<?xml version="1.0" encoding="UTF-8"?> 2 3 4<!--*********************************************************************** 5 * 6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 7 * 8 * Copyright 2000, 2010 Oracle and/or its affiliates. 9 * 10 * OpenOffice.org - a multi-platform office productivity suite 11 * 12 * This file is part of OpenOffice.org. 13 * 14 * OpenOffice.org is free software: you can redistribute it and/or modify 15 * it under the terms of the GNU Lesser General Public License version 3 16 * only, as published by the Free Software Foundation. 17 * 18 * OpenOffice.org is distributed in the hope that it will be useful, 19 * but WITHOUT ANY WARRANTY; without even the implied warranty of 20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 21 * GNU Lesser General Public License version 3 for more details 22 * (a copy is included in the LICENSE file that accompanied this code). 23 * 24 * You should have received a copy of the GNU Lesser General Public License 25 * version 3 along with OpenOffice.org. If not, see 26 * <http://www.openoffice.org/license.html> 27 * for a copy of the LGPLv3 License. 28 * 29 ************************************************************************--> 30 31 32 33<helpdocument version="1.0"> 34<meta> 35<topic id="textscalc0000000404xml" indexer="exclude" status="PUBLISH"> 36<title id="tit" xml-lang="en-US">Insert Menu</title> 37<filename>/text/scalc/00/00000404.xhp</filename> 38</topic> 39<history> 40<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 41<lastedited date="2005-11-10T14:06:38">converted from old format - fpe</lastedited> 42</history> 43</meta> 44<body> 45<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Menu</paragraph> 46<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="36"><variable id="eimaum">Choose <emph>Insert - Manual Break</emph> 47</variable></paragraph> 48<paragraph role="paragraph" id="par_id3149398" xml-lang="en-US" l10n="U" oldref="2"><variable id="eimaumze">Choose <emph>Insert - Manual Break - Row Break</emph> 49</variable></paragraph> 50<paragraph role="paragraph" id="par_id3150084" xml-lang="en-US" l10n="U" oldref="3"><variable id="eimaumsp">Choose <emph>Insert - Manual Break - Column Break</emph> 51</variable></paragraph> 52<section id="eize"> 53<paragraph role="paragraph" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Insert - Cells</emph> 54</paragraph> 55<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US" l10n="U" oldref="5">Open <emph>Insert Cells</emph> toolbar from Tools bar:</paragraph> 56<section id="syzelleneinfuegen"> 57<table id="tbl_id3148550"> 58<tablerow> 59<tablecell colspan="" rowspan=""> 60<paragraph role="paragraph" id="par_id3149656" xml-lang="en-US" l10n="E"> 61<image id="img_id3154365" src="res/commandimagelist/sc_inscellsctrl.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154365" xml-lang="en-US">Icon</alt> 62 </image></paragraph> 63</tablecell> 64<tablecell colspan="" rowspan=""> 65<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U" oldref="6">Insert Cells</paragraph> 66</tablecell> 67</tablerow> 68</table> 69 70</section> 71</section> 72<section id="syzellenunten"> 73<table id="tbl_id3159486"> 74<tablerow> 75<tablecell colspan="" rowspan=""> 76<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="E"> 77<image id="img_id3145364" src="res/commandimagelist/sc_insertcellsdown.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145364" xml-lang="en-US">Icon</alt> 78 </image></paragraph> 79</tablecell> 80<tablecell colspan="" rowspan=""> 81<paragraph role="paragraph" id="par_id3146985" xml-lang="en-US" l10n="U" oldref="7">Insert Cells Down</paragraph> 82</tablecell> 83</tablerow> 84</table> 85 86</section> 87<section id="syzellenrechts"> 88<table id="tbl_id3148575"> 89<tablerow> 90<tablecell colspan="" rowspan=""> 91<paragraph role="paragraph" id="par_id3144766" xml-lang="en-US" l10n="E"> 92<image id="img_id3154942" src="res/commandimagelist/sc_insertcellsright.png" width="0.222inch" height="0.222inch"><alt id="alt_id3154942" xml-lang="en-US">Icon</alt> 93 </image></paragraph> 94</tablecell> 95<tablecell colspan="" rowspan=""> 96<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="8">Insert Cells Right</paragraph> 97</tablecell> 98</tablerow> 99</table> 100 101</section> 102<section id="syzeilenganze"> 103<table id="tbl_id3154015"> 104<tablerow> 105<tablecell colspan="" rowspan=""> 106<paragraph role="paragraph" id="par_id3153838" xml-lang="en-US" l10n="E"> 107<image id="img_id3153710" src="res/commandimagelist/sc_insertrows.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153710" xml-lang="en-US">Icon</alt> 108 </image></paragraph> 109</tablecell> 110<tablecell colspan="" rowspan=""> 111<paragraph role="paragraph" id="par_id3150324" xml-lang="en-US" l10n="U" oldref="9">Insert Rows</paragraph> 112</tablecell> 113</tablerow> 114</table> 115 116</section> 117<section id="syspaltenganze"> 118<table id="tbl_id3147338"> 119<tablerow> 120<tablecell colspan="" rowspan=""> 121<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US" l10n="E"> 122<image id="img_id3145232" src="res/commandimagelist/sc_insertcolumns.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145232" xml-lang="en-US">Icon</alt> 123 </image></paragraph> 124</tablecell> 125<tablecell colspan="" rowspan=""> 126<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US" l10n="U" oldref="10">Insert Columns</paragraph> 127</tablecell> 128</tablerow> 129</table> 130 131</section> 132<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US" l10n="U" oldref="11"><variable id="eizei">Choose <emph>Insert - Rows</emph> 133</variable></paragraph> 134<paragraph role="paragraph" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="12"><variable id="eispa">Choose <emph>Insert - Columns</emph> 135</variable></paragraph> 136<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="13"><variable id="eitab">Choose <emph>Insert - Sheet</emph> 137</variable></paragraph> 138<paragraph role="paragraph" id="par_idN1082F" xml-lang="en-US" l10n="NEW"><variable id="eitabfile">Choose <emph>Insert - Sheet from file</emph> 139</variable></paragraph> 140<section id="eifu"> 141<paragraph role="paragraph" id="par_id3155115" xml-lang="en-US" l10n="U" oldref="14">Choose <emph>Insert - Function</emph> 142</paragraph> 143<paragraph role="paragraph" id="par_id3152582" xml-lang="en-US" l10n="U" oldref="34"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph> 144<paragraph role="paragraph" id="par_id3153269" xml-lang="en-US" l10n="U" oldref="15">On <emph>Formula Bar</emph>, click</paragraph> 145<section id="syfunktionsautopilot"> 146<table id="tbl_id3145258"> 147<tablerow> 148<tablecell colspan="" rowspan=""> 149<paragraph role="paragraph" id="par_id3150515" xml-lang="en-US" l10n="E"> 150<image id="img_id3150884" src="sw/imglst/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3150884" xml-lang="en-US">Icon</alt> 151 </image></paragraph> 152</tablecell> 153<tablecell colspan="" rowspan=""> 154<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="CHG" oldref="16">Function Wizard</paragraph> 155</tablecell> 156</tablerow> 157</table> 158 159</section> 160</section> 161<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="CHG" oldref="17"><variable id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph> 162</variable></paragraph> 163<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US" l10n="CHG" oldref="18"><variable id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date&Time</emph> 164</variable></paragraph> 165<paragraph role="paragraph" id="par_id3151334" xml-lang="en-US" l10n="CHG" oldref="19"><variable id="eikafi"><emph>Insert - Function</emph> - Category <emph>Financial</emph> 166</variable></paragraph> 167<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US" l10n="CHG" oldref="20"><variable id="eikain"><emph>Insert - Function</emph> - Category <emph>Information</emph> 168</variable></paragraph> 169<paragraph role="paragraph" id="par_id3159173" xml-lang="en-US" l10n="CHG" oldref="21"><variable id="eikalo"><emph>Insert - Function</emph> - Category <emph>Logical</emph> 170</variable></paragraph> 171<paragraph role="paragraph" id="par_id3153914" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="eikama"><emph>Insert - Function</emph> - Category <emph>Mathematical</emph> 172</variable></paragraph> 173<paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="eikamatrix"><emph>Insert - Function</emph> - Category <emph>Array</emph> 174</variable></paragraph> 175<paragraph role="paragraph" id="par_id3157978" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="eikasta"><emph>Insert - Function</emph> - Category <emph>Statistical</emph> 176</variable></paragraph> 177<paragraph role="paragraph" id="par_id3156016" xml-lang="en-US" l10n="CHG" oldref="25"><variable id="eikatext"><emph>Insert - Function</emph> - Category <emph>Text</emph> 178</variable></paragraph> 179<paragraph role="paragraph" id="par_id3147075" xml-lang="en-US" l10n="U" oldref="26"><variable id="efefft"><emph>Insert - Function</emph> - Category <emph>Spreadsheet</emph> 180</variable></paragraph> 181<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="CHG" oldref="27"><variable id="addin"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> 182</variable></paragraph> 183<paragraph role="paragraph" id="par_id3154059" xml-lang="en-US" l10n="CHG" oldref="38"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph> 184</variable></paragraph> 185<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="33"><variable id="funktionsliste">Choose <emph>Insert - Function List</emph> 186</variable></paragraph> 187<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="28"><variable id="einamen">Choose <emph>Insert - Names</emph> 188</variable></paragraph> 189<paragraph role="paragraph" id="par_id3146776" xml-lang="en-US" l10n="CHG" oldref="37"><variable id="eiextdata">Choose <emph>Insert - Link to External data</emph> 190</variable></paragraph> 191<section id="einafe"> 192<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="29">Choose <emph>Insert - Names - Define</emph> 193</paragraph> 194<paragraph role="paragraph" id="par_id3149385" xml-lang="en-US" l10n="U" oldref="35"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph> 195</section> 196<paragraph role="paragraph" id="par_id3145214" xml-lang="en-US" l10n="U" oldref="30"><variable id="einaei">Choose <emph>Insert - Names - Insert</emph> 197</variable></paragraph> 198<paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" l10n="U" oldref="31"><variable id="einaueb">Choose <emph>Insert - Names - Create</emph> 199</variable></paragraph> 200<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="32"><variable id="einabesch">Choose <emph>Insert - Names - Labels</emph> 201</variable></paragraph> 202</body> 203</helpdocument> 204
