02070000.xhp (e638d64b) 02070000.xhp (84046d64)
1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file

--- 162 unchanged lines hidden (view full) ---

171<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_TRANSPOSE" id="bm_id3145649" localize="false"/>
172<paragraph role="heading" id="hd_id3147173" xml-lang="en-US" level="3" l10n="U" oldref="33"><switchinline select="appl"><caseinline select="CALC">Transpose
173</caseinline></switchinline></paragraph>
174<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>
175</caseinline></switchinline><comment>i59261</comment></paragraph>
176<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_LINK" id="bm_id3154270" localize="false"/>
177<paragraph role="heading" id="hd_id3152971" xml-lang="en-US" level="3" l10n="U" oldref="35"><switchinline select="appl"><caseinline select="CALC">Link
178</caseinline></switchinline></paragraph>
1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file

--- 162 unchanged lines hidden (view full) ---

171<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_TRANSPOSE" id="bm_id3145649" localize="false"/>
172<paragraph role="heading" id="hd_id3147173" xml-lang="en-US" level="3" l10n="U" oldref="33"><switchinline select="appl"><caseinline select="CALC">Transpose
173</caseinline></switchinline></paragraph>
174<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>
175</caseinline></switchinline><comment>i59261</comment></paragraph>
176<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_INSCONT:BTN_LINK" id="bm_id3154270" localize="false"/>
177<paragraph role="heading" id="hd_id3152971" xml-lang="en-US" level="3" l10n="U" oldref="35"><switchinline select="appl"><caseinline select="CALC">Link
178</caseinline></switchinline></paragraph>
179<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>
179<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>
180</caseinline></switchinline></paragraph>
181<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.
182</caseinline></switchinline></paragraph>
183<paragraph role="heading" id="hd_id3146914" xml-lang="en-US" level="2" l10n="U" oldref="57"><switchinline select="appl"><caseinline select="CALC">Shift Cells
184</caseinline></switchinline></paragraph>
185<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.
186</caseinline></switchinline></paragraph>
187<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_MV_NONE" id="bm_id3145208" localize="false"/>

--- 16 unchanged lines hidden --- 		180</caseinline></switchinline></paragraph>
181<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.
182</caseinline></switchinline></paragraph>
183<paragraph role="heading" id="hd_id3146914" xml-lang="en-US" level="2" l10n="U" oldref="57"><switchinline select="appl"><caseinline select="CALC">Shift Cells
184</caseinline></switchinline></paragraph>
185<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.
186</caseinline></switchinline></paragraph>
187<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSCONT:BTN_MV_NONE" id="bm_id3145208" localize="false"/>

--- 16 unchanged lines hidden ---