1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: 00000404.xhp,v $
13 * $Revision: 1.10.4.1 $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
36 <helpdocument version=
"1.0">
38 <topic id=
"textscalc0000000404xml" indexer=
"exclude" status=
"PUBLISH">
39 <title id=
"tit" xml-lang=
"en-US">Insert Menu
</title>
40 <filename>/text/scalc/
00/
00000404.xhp
</filename>
43 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
44 <lastedited date=
"2005-11-10T14:06:38">converted from old format - fpe
</lastedited>
48 <paragraph role=
"heading" id=
"hd_id3149346" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1">Insert Menu
</paragraph>
49 <paragraph role=
"paragraph" id=
"par_id3149095" xml-lang=
"en-US" l10n=
"U" oldref=
"36"><variable id=
"eimaum">Choose
<emph>Insert - Manual Break
</emph>
50 </variable></paragraph>
51 <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>
52 </variable></paragraph>
53 <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>
54 </variable></paragraph>
56 <paragraph role=
"paragraph" id=
"par_id3149784" xml-lang=
"en-US" l10n=
"U" oldref=
"4">Choose
<emph>Insert - Cells
</emph>
58 <paragraph role=
"paragraph" id=
"par_id3154514" xml-lang=
"en-US" l10n=
"U" oldref=
"5">Open
<emph>Insert Cells
</emph> toolbar from Tools bar:
</paragraph>
59 <section id=
"syzelleneinfuegen">
60 <table id=
"tbl_id3148550">
62 <tablecell colspan=
"" rowspan=
"">
63 <paragraph role=
"paragraph" id=
"par_id3149656" xml-lang=
"en-US" l10n=
"E">
64 <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>
67 <tablecell colspan=
"" rowspan=
"">
68 <paragraph role=
"paragraph" id=
"par_id3151041" xml-lang=
"en-US" l10n=
"U" oldref=
"6">Insert Cells
</paragraph>
75 <section id=
"syzellenunten">
76 <table id=
"tbl_id3159486">
78 <tablecell colspan=
"" rowspan=
"">
79 <paragraph role=
"paragraph" id=
"par_id3145273" xml-lang=
"en-US" l10n=
"E">
80 <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>
83 <tablecell colspan=
"" rowspan=
"">
84 <paragraph role=
"paragraph" id=
"par_id3146985" xml-lang=
"en-US" l10n=
"U" oldref=
"7">Insert Cells Down
</paragraph>
90 <section id=
"syzellenrechts">
91 <table id=
"tbl_id3148575">
93 <tablecell colspan=
"" rowspan=
"">
94 <paragraph role=
"paragraph" id=
"par_id3144766" xml-lang=
"en-US" l10n=
"E">
95 <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>
98 <tablecell colspan=
"" rowspan=
"">
99 <paragraph role=
"paragraph" id=
"par_id3145646" xml-lang=
"en-US" l10n=
"U" oldref=
"8">Insert Cells Right
</paragraph>
105 <section id=
"syzeilenganze">
106 <table id=
"tbl_id3154015">
108 <tablecell colspan=
"" rowspan=
"">
109 <paragraph role=
"paragraph" id=
"par_id3153838" xml-lang=
"en-US" l10n=
"E">
110 <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>
113 <tablecell colspan=
"" rowspan=
"">
114 <paragraph role=
"paragraph" id=
"par_id3150324" xml-lang=
"en-US" l10n=
"U" oldref=
"9">Insert Rows
</paragraph>
120 <section id=
"syspaltenganze">
121 <table id=
"tbl_id3147338">
123 <tablecell colspan=
"" rowspan=
"">
124 <paragraph role=
"paragraph" id=
"par_id3147363" xml-lang=
"en-US" l10n=
"E">
125 <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>
128 <tablecell colspan=
"" rowspan=
"">
129 <paragraph role=
"paragraph" id=
"par_id3155334" xml-lang=
"en-US" l10n=
"U" oldref=
"10">Insert Columns
</paragraph>
135 <paragraph role=
"paragraph" id=
"par_id3148485" xml-lang=
"en-US" l10n=
"U" oldref=
"11"><variable id=
"eizei">Choose
<emph>Insert - Rows
</emph>
136 </variable></paragraph>
137 <paragraph role=
"paragraph" id=
"par_id3153200" xml-lang=
"en-US" l10n=
"U" oldref=
"12"><variable id=
"eispa">Choose
<emph>Insert - Columns
</emph>
138 </variable></paragraph>
139 <paragraph role=
"paragraph" id=
"par_id3149033" xml-lang=
"en-US" l10n=
"U" oldref=
"13"><variable id=
"eitab">Choose
<emph>Insert - Sheet
</emph>
140 </variable></paragraph>
141 <paragraph role=
"paragraph" id=
"par_idN1082F" xml-lang=
"en-US" l10n=
"NEW"><variable id=
"eitabfile">Choose
<emph>Insert - Sheet from file
</emph>
142 </variable></paragraph>
144 <paragraph role=
"paragraph" id=
"par_id3155115" xml-lang=
"en-US" l10n=
"U" oldref=
"14">Choose
<emph>Insert - Function
</emph>
146 <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>
147 <paragraph role=
"paragraph" id=
"par_id3153269" xml-lang=
"en-US" l10n=
"U" oldref=
"15">On
<emph>Formula Bar
</emph>, click
</paragraph>
148 <section id=
"syfunktionsautopilot">
149 <table id=
"tbl_id3145258">
151 <tablecell colspan=
"" rowspan=
"">
152 <paragraph role=
"paragraph" id=
"par_id3150515" xml-lang=
"en-US" l10n=
"E">
153 <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>
156 <tablecell colspan=
"" rowspan=
"">
157 <paragraph role=
"paragraph" id=
"par_id3154370" xml-lang=
"en-US" l10n=
"CHG" oldref=
"16">Function Wizard
</paragraph>
164 <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>
165 </variable></paragraph>
166 <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>
167 </variable></paragraph>
168 <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>
169 </variable></paragraph>
170 <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>
171 </variable></paragraph>
172 <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>
173 </variable></paragraph>
174 <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>
175 </variable></paragraph>
176 <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>
177 </variable></paragraph>
178 <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>
179 </variable></paragraph>
180 <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>
181 </variable></paragraph>
182 <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>
183 </variable></paragraph>
184 <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>
185 </variable></paragraph>
186 <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>
187 </variable></paragraph>
188 <paragraph role=
"paragraph" id=
"par_id3155383" xml-lang=
"en-US" l10n=
"U" oldref=
"33"><variable id=
"funktionsliste">Choose
<emph>Insert - Function List
</emph>
189 </variable></paragraph>
190 <paragraph role=
"paragraph" id=
"par_id3153250" xml-lang=
"en-US" l10n=
"U" oldref=
"28"><variable id=
"einamen">Choose
<emph>Insert - Names
</emph>
191 </variable></paragraph>
192 <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>
193 </variable></paragraph>
194 <section id=
"einafe">
195 <paragraph role=
"paragraph" id=
"par_id3143222" xml-lang=
"en-US" l10n=
"U" oldref=
"29">Choose
<emph>Insert - Names - Define
</emph>
197 <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>
199 <paragraph role=
"paragraph" id=
"par_id3145214" xml-lang=
"en-US" l10n=
"U" oldref=
"30"><variable id=
"einaei">Choose
<emph>Insert - Names - Insert
</emph>
200 </variable></paragraph>
201 <paragraph role=
"paragraph" id=
"par_id3153558" xml-lang=
"en-US" l10n=
"U" oldref=
"31"><variable id=
"einaueb">Choose
<emph>Insert - Names - Create
</emph>
202 </variable></paragraph>
203 <paragraph role=
"paragraph" id=
"par_id3153483" xml-lang=
"en-US" l10n=
"U" oldref=
"32"><variable id=
"einabesch">Choose
<emph>Insert - Names - Labels
</emph>
204 </variable></paragraph>