1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at 13 * 14 * http://www.apache.org/licenses/LICENSE-2.0 15 * 16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License. 22 * 23 ***********************************************************--> 24 25 26 27 28<meta> 29<topic id="textscalc0104050000xml" indexer="include"> 30<title id="tit" xml-lang="en-US">Insert Sheet</title> 31<filename>/text/scalc/01/04050000.xhp</filename> 32</topic> 33</meta> 34<body> 35<bookmark xml-lang="en-US" branch="index" id="bm_id4522232"><bookmark_value>sheets;creating</bookmark_value> 36</bookmark> 37<bookmark xml-lang="en-US" branch="hid/sc:ModalDialog:RID_SCDLG_INSERT_TABLE" id="bm_id3151384" localize="false"/> 38<bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id1669896" localize="false"/> 39<bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id3153896" localize="false"/> 40<paragraph role="heading" id="hd_id3155629" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Sheet</paragraph> 41<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="2"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file. 42</variable></paragraph> 43<section id="howtoget"> 44<embed href="text/scalc/00/00000404.xhp#eitab"/> 45</section> 46<paragraph role="heading" id="hd_id3154684" xml-lang="en-US" level="2" l10n="U" oldref="19">Position</paragraph> 47<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US" l10n="U" oldref="20">Specifies where the new sheet is to be inserted into your document.</paragraph> 48<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_BEFORE" id="bm_id3155131" localize="false"/> 49<paragraph role="heading" id="hd_id3154123" xml-lang="en-US" level="3" l10n="U" oldref="21">Before current sheet</paragraph> 50<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:RB_BEFORE">Inserts a new sheet directly before the current sheet.</ahelp></paragraph> 51<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_BEHIND" id="bm_id3147434" localize="false"/> 52<paragraph role="heading" id="hd_id3155414" xml-lang="en-US" level="3" l10n="U" oldref="23">After current sheet</paragraph> 53<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:RB_BEHIND">Inserts a new sheet directly after the current sheet.</ahelp></paragraph> 54<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2" l10n="CHG" oldref="25">Sheet</paragraph> 55<paragraph role="paragraph" id="par_id3154012" xml-lang="en-US" l10n="U" oldref="26">Specifies whether a new sheet or an existing sheet is inserted into the document.</paragraph> 56<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_NEW" id="bm_id3145750" localize="false"/> 57<paragraph role="heading" id="hd_id3147350" xml-lang="en-US" level="2" l10n="CHG" oldref="3">New sheet</paragraph> 58<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="CHG" oldref="4"><ahelp hid="SC_RADIOBUTTON_RID_SCDLG_INSERT_TABLE_RB_NEW">Creates a new sheet. Enter a sheet name in the <emph>Name</emph> field. Allowed characters are letters, numbers, spaces, and the underline character.</ahelp></paragraph> 59<bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCDLG_INSERT_TABLE:NF_COUNT" id="bm_id3153157" localize="false"/> 60<paragraph role="heading" id="hd_id3155418" xml-lang="en-US" level="3" l10n="CHG" oldref="27">No. of sheets</paragraph> 61<paragraph role="paragraph" id="par_id3148457" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="SC:NUMERICFIELD:RID_SCDLG_INSERT_TABLE:NF_COUNT">Specifies the number of sheets to be created.</ahelp></paragraph> 62<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_INSERT_TABLE:ED_TABNAME" id="bm_id3154510" localize="false"/> 63<paragraph role="heading" id="hd_id3149379" xml-lang="en-US" level="3" l10n="U" oldref="7">Name</paragraph> 64<paragraph role="paragraph" id="par_id3150718" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="SC:EDIT:RID_SCDLG_INSERT_TABLE:ED_TABNAME">Specifies the name of the new sheet.</ahelp></paragraph> 65<embed href="text/scalc/guide/rename_table.xhp#rename_table"/> 66<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_FROMFILE" id="bm_id3150328" localize="false"/> 67<paragraph role="heading" id="hd_id3155066" xml-lang="en-US" level="2" l10n="U" oldref="9">From File</paragraph> 68<paragraph role="paragraph" id="par_id3153714" xml-lang="en-US" l10n="CHG" oldref="10"><ahelp hid="SC_RADIOBUTTON_RID_SCDLG_INSERT_TABLE_RB_FROMFILE">Inserts a sheet from an existing file into the current document.</ahelp></paragraph> 69<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_INSERT_TABLE:BTN_BROWSE" id="bm_id3150044" localize="false"/> 70<paragraph role="heading" id="hd_id3149020" xml-lang="en-US" level="3" l10n="U" oldref="15">Browse</paragraph> 71<paragraph role="paragraph" id="par_id3159267" xml-lang="en-US" l10n="CHG" oldref="16"><ahelp hid="SC:PUSHBUTTON:RID_SCDLG_INSERT_TABLE:BTN_BROWSE">Opens a dialog for selecting a file.</ahelp></paragraph> 72<bookmark xml-lang="en-US" branch="hid/sc:MultiListBox:RID_SCDLG_INSERT_TABLE:LB_TABLES" id="bm_id3146314" localize="false"/> 73<paragraph role="heading" id="hd_id3149255" xml-lang="en-US" level="3" l10n="U" oldref="29">Available Sheets</paragraph> 74<paragraph role="paragraph" id="par_id3155336" xml-lang="en-US" l10n="U" oldref="30"><ahelp hid="SC:MULTILISTBOX:RID_SCDLG_INSERT_TABLE:LB_TABLES">If you selected a file by using the <emph>Browse</emph> button, the sheets contained in it are displayed in the list box. The file path is displayed below this box. Select the sheet to be inserted from the list box.</ahelp></paragraph> 75<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSERT_TABLE:CB_LINK" id="bm_id3149814" localize="false"/> 76<paragraph role="heading" id="hd_id3145791" xml-lang="en-US" level="3" l10n="U" oldref="17">Link</paragraph> 77<paragraph role="paragraph" id="par_id3152580" xml-lang="en-US" l10n="CHG" oldref="18"><ahelp hid="SC_CHECKBOX_RID_SCDLG_INSERT_TABLE_CB_LINK">Select to insert the sheet as a link instead as a copy. The links can be updated to show the current contents.</ahelp></paragraph> 78</body> 79</helpdocument> 80