1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?>
2*b1cdbd2cSJim Jagielski<helpdocument version="1.0">
3*b1cdbd2cSJim Jagielski
4*b1cdbd2cSJim Jagielski<!--***********************************************************
5*b1cdbd2cSJim Jagielski *
6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
7*b1cdbd2cSJim Jagielski * or more contributor license agreements.  See the NOTICE file
8*b1cdbd2cSJim Jagielski * distributed with this work for additional information
9*b1cdbd2cSJim Jagielski * regarding copyright ownership.  The ASF licenses this file
10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
12*b1cdbd2cSJim Jagielski * with the License.  You may obtain a copy of the License at
13*b1cdbd2cSJim Jagielski *
14*b1cdbd2cSJim Jagielski *   http://www.apache.org/licenses/LICENSE-2.0
15*b1cdbd2cSJim Jagielski *
16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19*b1cdbd2cSJim Jagielski * KIND, either express or implied.  See the License for the
20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
21*b1cdbd2cSJim Jagielski * under the License.
22*b1cdbd2cSJim Jagielski *
23*b1cdbd2cSJim Jagielski ***********************************************************-->
24*b1cdbd2cSJim Jagielski
25*b1cdbd2cSJim Jagielski
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski
28*b1cdbd2cSJim Jagielski<meta>
29*b1cdbd2cSJim Jagielski<topic id="textshared0102070000xml" indexer="include">
30*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Paste Special</title>
31*b1cdbd2cSJim Jagielski<filename>/text/shared/01/02070000.xhp</filename>
32*b1cdbd2cSJim Jagielski</topic>
33*b1cdbd2cSJim Jagielski</meta>
34*b1cdbd2cSJim Jagielski<body>
35*b1cdbd2cSJim Jagielski<!-- removed HID SO3:MODALDIALOG:MD_PASTE_OBJECT -->
36*b1cdbd2cSJim Jagielski<!-- removed HID SID_PASTE2 -->
37*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:PasteClipboard" id="bm_id3149987" localize="false"/>
38*b1cdbd2cSJim Jagielski<!-- removed HID FN_PASTESPECIAL -->
39*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:PasteSpecial" id="bm_id3154100" localize="false"/>
40*b1cdbd2cSJim Jagielski<!-- removed HID FID_PASTE_CONTENTS -->
41*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3147477" xml-lang="en-US" level="1" l10n="U" oldref="1">Paste Special</paragraph>
42*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US" l10n="U" oldref="2"><variable id="inhalteeinfuegentext"><ahelp hid=".uno:PasteSpecial">Inserts the contents of the clipboard into the current file in a format that you can specify.</ahelp>
43*b1cdbd2cSJim Jagielski</variable></paragraph>
44*b1cdbd2cSJim Jagielski<switch select="appl">
45*b1cdbd2cSJim Jagielski<case select="WRITER">
46*b1cdbd2cSJim Jagielski<section id="howtoget">
47*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000402.xhp#inhalte"/>
48*b1cdbd2cSJim Jagielski</section>
49*b1cdbd2cSJim Jagielski</case>
50*b1cdbd2cSJim Jagielski</switch>
51*b1cdbd2cSJim Jagielski<switch select="appl">
52*b1cdbd2cSJim Jagielski<case select="CALC">
53*b1cdbd2cSJim Jagielski<section id="Section1">
54*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000402.xhp#inhalte"/>
55*b1cdbd2cSJim Jagielski</section>
56*b1cdbd2cSJim Jagielski</case>
57*b1cdbd2cSJim Jagielski</switch>
58*b1cdbd2cSJim Jagielski<switch select="appl">
59*b1cdbd2cSJim Jagielski<case select="IMPRESS">
60*b1cdbd2cSJim Jagielski<section id="Section2">
61*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000402.xhp#inhalte"/>
62*b1cdbd2cSJim Jagielski</section>
63*b1cdbd2cSJim Jagielski</case>
64*b1cdbd2cSJim Jagielski</switch>
65*b1cdbd2cSJim Jagielski<switch select="appl">
66*b1cdbd2cSJim Jagielski<case select="DRAW">
67*b1cdbd2cSJim Jagielski<section id="Section3">
68*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000402.xhp#inhalte"/>
69*b1cdbd2cSJim Jagielski</section>
70*b1cdbd2cSJim Jagielski</case>
71*b1cdbd2cSJim Jagielski</switch>
72*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_PASTE_DLG" id="bm_id3156410" localize="false"/>
73*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3147576" xml-lang="en-US" level="3" l10n="U" oldref="5">Source</paragraph>
74*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3149388" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="HID_PASTE_DLG">Displays the source of the clipboard contents.</ahelp></paragraph>
75*b1cdbd2cSJim Jagielski<!-- removed HID SO3:LISTBOX:MD_PASTE_OBJECT:LB_INSERT_LIST -->
76*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:ListBox:MD_PASTE_OBJECT:LB_INSERT_LIST" id="bm_id080420080314218" localize="false"/>
77*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3153684" xml-lang="en-US" level="3" l10n="U" oldref="7">Selection</paragraph>
78*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3149812" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SO3:LISTBOX:MD_PASTE_OBJECT:LB_INSERT_LIST">Select a format for the clipboard contents that you want to paste.</ahelp></paragraph>
79*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3147653" xml-lang="en-US" l10n="U" oldref="68"><switchinline select="appl"><caseinline select="WRITER">When you paste HTML data into a text document, you can choose "HTML format" or "HTML format without comments". The second choice is the default; it pastes all HTML data, but no comments.
80*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
81*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:InsertContents" id="bm_id7770068" localize="false"/>
82*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:InsertContents" id="bm_id3156152" localize="false"/>
83*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3155420" xml-lang="en-US" level="2" l10n="U" oldref="15"><switchinline select="appl"><caseinline select="CALC">Paste Special
84*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
85*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3150976" xml-lang="en-US" l10n="U" oldref="16"><switchinline select="appl"><caseinline select="CALC">This dialog appears in Calc if the clipboard contains spreadsheet cells.
86*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
87*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3155341" xml-lang="en-US" level="2" l10n="U" oldref="17"><switchinline select="appl"><caseinline select="CALC">Selection
88*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
89*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3152909" xml-lang="en-US" l10n="U" oldref="40"><switchinline select="appl"><caseinline select="CALC">Select a format for the clipboard contents that you want to paste.
90*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
91*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSALL" id="bm_id3148991" localize="false"/>
92*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3145120" xml-lang="en-US" level="3" l10n="U" oldref="41"><switchinline select="appl"><caseinline select="CALC">Paste all
93*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
94*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3146848" xml-lang="en-US" l10n="U" oldref="42"><switchinline select="appl"><caseinline select="CALC"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSALL">Pastes all cell contents, comments, formats, and objects into the current document.</ahelp>
95*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
96*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSSTRINGS" id="bm_id3149796" localize="false"/>
97*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3155449" xml-lang="en-US" level="3" l10n="CHG" oldref="43"><switchinline select="appl"><caseinline select="CALC">Text
98*b1cdbd2cSJim Jagielski</caseinline></switchinline><comment>i50436</comment></paragraph>
99*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US" l10n="CHG" oldref="44"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSSTRINGS"><switchinline select="appl"><caseinline select="CALC">Inserts cells containing text.
100*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
101*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSNUMBERS" id="bm_id3147303" localize="false"/>
102*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3148947" xml-lang="en-US" level="3" l10n="U" oldref="45"><switchinline select="appl"><caseinline select="CALC">Numbers
103*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
104*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3152360" xml-lang="en-US" l10n="U" oldref="46"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSNUMBERS"><switchinline select="appl"><caseinline select="CALC">Inserts cells containing numbers.
105*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
106*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSDATETIME" id="bm_id3154936" localize="false"/>
107*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3151054" xml-lang="en-US" level="3" l10n="U" oldref="47"><switchinline select="appl"><caseinline select="CALC">Date &amp; Time
108*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
109*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3154226" xml-lang="en-US" l10n="U" oldref="48"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSDATETIME"><switchinline select="appl"><caseinline select="CALC">Inserts cells containing date and time values.
110*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
111*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSFORMULAS" id="bm_id3151210" localize="false"/>
112*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="3" l10n="U" oldref="49"><switchinline select="appl"><caseinline select="CALC">Formulas
113*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
114*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3145744" xml-lang="en-US" l10n="U" oldref="50"><switchinline select="appl"><caseinline select="CALC"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSFORMULAS">Inserts cells containing formulae.</ahelp>
115*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
116*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSNOTES" id="bm_id3159149" localize="false"/>
117*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3153968" xml-lang="en-US" level="3" l10n="U" oldref="51"><switchinline select="appl"><caseinline select="CALC">Comments
118*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
119*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US" l10n="U" oldref="52"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSNOTES"><switchinline select="appl"><caseinline select="CALC">Inserts comments that are attached to cells. If you want to add the comments to the existing cell content, select the "Add" operation.
120*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
121*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSATTRS" id="bm_id3145171" localize="false"/>
122*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3152935" xml-lang="en-US" level="3" l10n="U" oldref="53"><switchinline select="appl"><caseinline select="CALC">Formats
123*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
124*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US" l10n="U" oldref="54"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSATTRS"><switchinline select="appl"><caseinline select="CALC">Inserts cell format attributes.
125*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
126*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_INSOBJECTS" id="bm_id3145202" localize="false"/>
127*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3156282" xml-lang="en-US" level="3" l10n="U" oldref="65"><switchinline select="appl"><caseinline select="CALC">Objects
128*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
129*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3149810" xml-lang="en-US" l10n="U" oldref="66"><ahelp hid="SC_CHECKBOX_RID_SCDLG_INSCONT_BTN_INSOBJECTS"><switchinline select="appl"><caseinline select="CALC">Inserts objects contained within the selected cell range. These can be OLE objects, chart objects, or drawing objects.
130*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
131*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3150440" xml-lang="en-US" level="2" l10n="U" oldref="19"><switchinline select="appl"><caseinline select="CALC">Operations
132*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
133*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3151351" xml-lang="en-US" l10n="U" oldref="38"><switchinline select="appl"><caseinline select="CALC">Select the operation to apply when you paste cells into your sheet.
134*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
135*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_OP_NOOP" id="bm_id3153213" localize="false"/>
136*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3153952" xml-lang="en-US" level="3" l10n="U" oldref="20"><switchinline select="appl"><caseinline select="CALC">None
137*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
138*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_OP_NOOP"><switchinline select="appl"><caseinline select="CALC">Does not apply an operation when you insert the cell range from the clipboard. The contents of the clipboard will replace existing cell contents.
139*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
140*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_OP_ADD" id="bm_id3149064" localize="false"/>
141*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3154988" xml-lang="en-US" level="3" l10n="U" oldref="22"><switchinline select="appl"><caseinline select="CALC">Add
142*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
143*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3159196" xml-lang="en-US" l10n="CHG" oldref="23"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_OP_ADD"><switchinline select="appl"><caseinline select="CALC">Adds the values in the clipboard cells to the values in the target cells. Also, if the clipboard only contains comments, adds the comments to the target cells.
144*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
145*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_OP_SUB" id="bm_id3152576" localize="false"/>
146*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3145263" xml-lang="en-US" level="3" l10n="U" oldref="24"><switchinline select="appl"><caseinline select="CALC">Subtract
147*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
148*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3154149" xml-lang="en-US" l10n="CHG" oldref="25"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_OP_SUB"><switchinline select="appl"><caseinline select="CALC">Subtracts the values in the clipboard cells from the values in the target cells.
149*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
150*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_OP_MUL" id="bm_id3149667" localize="false"/>
151*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3155312" xml-lang="en-US" level="3" l10n="U" oldref="26"><switchinline select="appl"><caseinline select="CALC">Multiply
152*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
153*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3155307" xml-lang="en-US" l10n="CHG" oldref="27"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_OP_MUL"><switchinline select="appl"><caseinline select="CALC">Multiplies the values in the clipboard cells with the values in the target cells.
154*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
155*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_OP_DIV" id="bm_id3153140" localize="false"/>
156*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3154320" xml-lang="en-US" level="3" l10n="U" oldref="28"><switchinline select="appl"><caseinline select="CALC">Divide
157*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
158*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3155417" xml-lang="en-US" l10n="CHG" oldref="29"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_OP_DIV"><switchinline select="appl"><caseinline select="CALC">Divides the values in the target cells by the values in the clipboard cells.
159*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp><comment>UFI: fixes #i14796#</comment></paragraph>
160*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3147048" xml-lang="en-US" level="2" l10n="U" oldref="55"><switchinline select="appl"><caseinline select="CALC">Options
161*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
162*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="56"><switchinline select="appl"><caseinline select="CALC">Sets the paste options for the clipboard contents.
163*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
164*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY" id="bm_id3149485" localize="false"/>
165*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3151052" xml-lang="en-US" level="3" l10n="U" oldref="30"><switchinline select="appl"><caseinline select="CALC">Skip empty cells
166*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
167*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3148775" xml-lang="en-US" l10n="U" oldref="31"><switchinline select="appl"><caseinline select="CALC"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY">Empty cells from the clipboard do not replace target cells. If you use this option in conjunction with the <emph>Multiply</emph> or the <emph>Divide</emph> operation, the operation is not applied to the target cell of an empty cell in the clipboard.</ahelp>
168*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
169*b1cdbd2cSJim Jagielski<switch select="appl">
170*b1cdbd2cSJim Jagielski<case select="CALC">
171*b1cdbd2cSJim Jagielski<paragraph role="note" id="par_id3155084" xml-lang="en-US" l10n="U" oldref="32">If you select a mathematical operation and clear the<emph> Skip empty cells </emph>box, empty cells in the clipboard are treated as zeroes. For example, if you apply the <emph>Multiply</emph> operation, the target cells are filled with zeroes.</paragraph>
172*b1cdbd2cSJim Jagielski</case>
173*b1cdbd2cSJim Jagielski</switch>
174*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_TRANSPOSE" id="bm_id3145649" localize="false"/>
175*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3147173" xml-lang="en-US" level="3" l10n="U" oldref="33"><switchinline select="appl"><caseinline select="CALC">Transpose
176*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
177*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3147223" xml-lang="en-US" l10n="CHG" oldref="34"><switchinline select="appl"><caseinline select="CALC"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_TRANSPOSE">The rows of the range in the clipboard are pasted to become columns of the output range. The columns of the range in the clipboard are pasted to become rows.</ahelp>
178*b1cdbd2cSJim Jagielski</caseinline></switchinline><comment>i59261</comment></paragraph>
179*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_LINK" id="bm_id3154270" localize="false"/>
180*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3152971" xml-lang="en-US" level="3" l10n="U" oldref="35"><switchinline select="appl"><caseinline select="CALC">Link
181*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
182*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="36"><switchinline select="appl"><caseinline select="CALC"><ahelp hid="SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_LINK">Inserts the cell range as a link, so that changes made to the cells in the source file are updated in the target file. To ensure that changes made to empty cells in the source file are updated in the target file, ensure that the <emph>Insert All</emph> option is also selected. </ahelp>
183*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
184*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3145667" xml-lang="en-US" l10n="U" oldref="37"><switchinline select="appl"><caseinline select="CALC">You can also link sheets within the same spreadsheet. When you link to other files, a <link href="text/shared/00/00000005.xhp#dde" name="DDE link">DDE link</link> is automatically created. A DDE link is inserted as a matrix formula and can only be modified as a whole.
185*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
186*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3146914" xml-lang="en-US" level="2" l10n="U" oldref="57"><switchinline select="appl"><caseinline select="CALC">Shift Cells
187*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
188*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3145169" xml-lang="en-US" l10n="U" oldref="58"><switchinline select="appl"><caseinline select="CALC">Set the shift options for the target cells when the clipboard content is inserted.
189*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
190*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_MV_NONE" id="bm_id3145208" localize="false"/>
191*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3155518" xml-lang="en-US" level="3" l10n="U" oldref="59"><switchinline select="appl"><caseinline select="CALC">Don't shift
192*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
193*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3154158" xml-lang="en-US" l10n="U" oldref="60"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_MV_NONE"><switchinline select="appl"><caseinline select="CALC">Inserted cells replace the target cells.
194*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
195*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_MV_DOWN" id="bm_id3149020" localize="false"/>
196*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3148483" xml-lang="en-US" level="3" l10n="U" oldref="61"><switchinline select="appl"><caseinline select="CALC">Down
197*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
198*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3152962" xml-lang="en-US" l10n="U" oldref="62"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_MV_DOWN"><switchinline select="appl"><caseinline select="CALC">Target cells are shifted downward when you insert cells from the clipboard.
199*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
200*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_MV_RIGHT" id="bm_id3150043" localize="false"/>
201*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3145621" xml-lang="en-US" level="3" l10n="U" oldref="63"><switchinline select="appl"><caseinline select="CALC">Right
202*b1cdbd2cSJim Jagielski</caseinline></switchinline></paragraph>
203*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3159264" xml-lang="en-US" l10n="U" oldref="64"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSCONT:BTN_MV_RIGHT"><switchinline select="appl"><caseinline select="CALC">Target cells are shifted to the right when you insert cells from the clipboard.
204*b1cdbd2cSJim Jagielski</caseinline></switchinline></ahelp></paragraph>
205*b1cdbd2cSJim Jagielski</body>
206*b1cdbd2cSJim Jagielski</helpdocument>
207