AllLangHelp_scalc.mk | 3
source/text/scalc/01/pastespecialcalc.xhp | 129 +++++++++++++++++++++++++++++
source/text/shared/01/02070000.xhp | 114 ++-----------------------
source/text/shared/01/pastespecialmenu.xhp | 13 +-
4 files changed, 146 insertions(+), 113 deletions(-)
New commits:
commit f5cae320fad8746d99075e59a16cdc6f4ecb7f1e
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Feb 16 13:45:42 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Feb 16 17:46:52 2025 +0100
Untangle help page for Paste Special.
Change-Id: Iec95eda30c0dddc1534f8303ba5eda7e643ee62c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/181749
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 90601dbdb6..9dbb9f410c 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -348,6 +348,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/MergeCellsMenu \
helpcontent2/source/text/scalc/01/NavigateMenu \
helpcontent2/source/text/scalc/01/NormalViewMode \
+ helpcontent2/source/text/scalc/01/pastespecialcalc \
+ helpcontent2/source/text/scalc/01/ODFF \
helpcontent2/source/text/scalc/01/recalculate_hard \
helpcontent2/source/text/scalc/01/SelectColumn \
helpcontent2/source/text/scalc/01/SelectData \
@@ -379,7 +381,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/statistics_test_t \
helpcontent2/source/text/scalc/01/statistics_test_z \
helpcontent2/source/text/scalc/01/stat_data \
- helpcontent2/source/text/scalc/01/ODFF \
helpcontent2/source/text/scalc/01/TableSelectAll \
helpcontent2/source/text/scalc/01/text2columns \
helpcontent2/source/text/scalc/01/ToggleFormula \
diff --git a/source/text/scalc/01/pastespecialcalc.xhp
b/source/text/scalc/01/pastespecialcalc.xhp
new file mode 100644
index 0000000000..d47629af0e
--- /dev/null
+++ b/source/text/scalc/01/pastespecialcalc.xhp
@@ -0,0 +1,129 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="text/scalc/01/pastespecialcalc.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Calc Paste Special</title>
+ <filename>/text/scalc/01/pastespecialcalc.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/PasteSpecial"
id="bm_id31541011" localize="false"/>
+<bookmark branch="hid/.uno:InsertContents" id="bm_id7770068" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/@@nowidget@@"
id="bm_id31541011" localize="false"/>
+
+<bookmark branch="index" id="bm_id31739717308367">
+ <bookmark_value>paste special;text</bookmark_value>
+ <bookmark_value>paste special;numbers</bookmark_value>
+ <bookmark_value>paste special;date & time</bookmark_value>
+ <bookmark_value>paste special;comments</bookmark_value>
+ <bookmark_value>paste special;formats</bookmark_value>
+ <bookmark_value>paste special;formula</bookmark_value>
+ <bookmark_value>paste special;objects</bookmark_value>
+ <bookmark_value>paste special;transpose</bookmark_value>
+</bookmark>
+<section id="calcpastespecial">
+ <h1 id="hd_id691739716199678"><variable id="h1"><link
href="text/scalc/01/pastespecialcalc.xhp"></link>Paste Special
(Calc)</variable></h1>
+ <paragraph role="paragraph" id="par_id851739716540406"
localize="false"><embedvar
href="text/shared/01/02070000.xhp#inhalteeinfuegentext"
markup="ignore"/></paragraph>
+ <note id="par_id3150976">This dialog appears in Calc if the clipboard
contains spreadsheet cells. For other contents in the clipboard, the <link
href="text/shared/01/02070000.xhp">default Paste Special</link> dialog
opens.</note>
+</section>
+<section id="howtoget">
+ <embed href="text/shared/00/edit_menu.xhp#pastespecial"/>
+</section>
+<h2 id="hd_id191630440520574">Presets</h2>
+<paragraph role="paragraph" id="par_id951630440692605">Choose one of the
presets to quickly load commonly used settings for Paste Special.</paragraph>
+<h3 id="hd_id41630440570501">Values Only</h3>
+<paragraph role="paragraph" id="par_id111630440722545">Pastes only cell
contents including text, numbers and dates.</paragraph>
+<h3 id="hd_id891630440587478">Values & Formats</h3>
+<paragraph role="paragraph" id="par_id511630441051343">Pastes cell contents
and formats applied to cells.</paragraph>
+<h3 id="hd_id301630440615367">Formats Only</h3>
+<paragraph role="paragraph" id="par_id851630441123702">Pastes only formats
applied to cells.</paragraph>
+<h3 id="hd_id81630440632865">Transpose All</h3>
+<paragraph role="paragraph" id="par_id41630441349354">Pastes all cell contents
with their positions transposed.</paragraph>
+<h3 id="hd_id991630441460829">Run immediately</h3>
+<paragraph role="paragraph" id="par_id331630441454811">Check this option to
load the preset and immediately apply it. When unchecked, choosing a preset
will only load the corresponding options in the dialog without pasting
anything.</paragraph>
+<tip id="par_id811630441564039">Uncheck <emph>Run immediately</emph> to load
the options from the preset and change its settings in the Paste Special dialog
before applying them by clicking <emph>OK</emph>.</tip>
+
+<h2 id="hd_id3155341">Selection</h2>
+<paragraph role="paragraph" id="par_id3152909">Select a format for the
clipboard contents that you want to paste.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/paste_all"
id="bm_id3148991" localize="false"/>
+<h3 id="hd_id3145120">Paste all</h3>
+<paragraph role="paragraph" id="par_id3146848"><ahelp
hid="modules/scalc/ui/pastespecial/paste_all">Pastes all cell contents,
comments, formats, and objects into the current document.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/text" id="bm_id3149796"
localize="false"/>
+<h3 id="hd_id3155449">Text<comment>i50436</comment></h3>
+<paragraph role="paragraph" id="par_id3149244"><ahelp
hid="modules/scalc/ui/pastespecial/text">Inserts cells containing
text.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/numbers" id="bm_id3147303"
localize="false"/>
+<h3 id="hd_id3148947">Numbers</h3>
+<paragraph role="paragraph" id="par_id3152360"><ahelp
hid="modules/scalc/ui/pastespecial/numbers">Inserts cells containing
numbers.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/datetime"
id="bm_id3154936" localize="false"/>
+<h3 id="hd_id3151054">Date & Time</h3>
+<paragraph role="paragraph" id="par_id3154226"><ahelp
hid="modules/scalc/ui/pastespecial/datetime">Inserts cells containing date and
time values.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/formulas"
id="bm_id3151210" localize="false"/>
+<h3 id="hd_id3150791">Formulas</h3>
+<paragraph role="paragraph" id="par_id3145744"><ahelp
hid="modules/scalc/ui/pastespecial/formulas">Inserts cells containing
formulae.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/comments"
id="bm_id3159149" localize="false"/>
+<h3 id="hd_id3153968">Comments</h3>
+<paragraph role="paragraph" id="par_id3156422"><ahelp
hid="modules/scalc/ui/pastespecial/comments">Inserts comments that are attached
to cells.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/formats" id="bm_id3145171"
localize="false"/>
+<h3 id="hd_id3152935">Formats</h3>
+<paragraph role="paragraph" id="par_id3125863"><ahelp
hid="modules/scalc/ui/pastespecial/formats">Inserts cell format
attributes.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/objects" id="bm_id3145202"
localize="false"/>
+<h3 id="hd_id3156282">Objects</h3>
+<paragraph role="paragraph" id="par_id3149810"><ahelp
hid="modules/scalc/ui/pastespecial/objects">Inserts objects contained within
the selected cell range. These can be OLE objects, chart objects, or drawing
objects.</ahelp></paragraph>
+
+<h2 id="hd_id3147048">Options</h2>
+<paragraph role="paragraph" id="par_id3156283">Sets the paste options for the
clipboard contents.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/link" id="bm_id3154270"
localize="false"/>
+<bookmark branch="hid/.uno:PasteAsLink" id="bm_id681736114695042"
localize="false"/>
+<h3 id="hd_id3152971">As Link</h3>
+<paragraph role="paragraph" id="par_id3146969"><ahelp
hid="modules/scalc/ui/pastespecial/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 "Paste All" option is also
selected.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145667">You can also link sheets within
the same spreadsheet. When you link to other files, a <link
href="text/shared/00/00000005.xhp#dde">DDE link</link> is automatically
created. A DDE link is inserted as a matrix formula and can only be modified as
a whole.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/transpose"
id="bm_id3145649" localize="false"/>
+<bookmark branch="hid/.uno:PasteTransposed" id="bm_id531736114716507"
localize="false"/>
+<h3 id="hd_id3147173">Transpose</h3>
+<paragraph role="paragraph" id="par_id3147223"><ahelp
hid="modules/scalc/ui/pastespecial/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><comment>i59261</comment></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/skip_empty"
id="bm_id3149485" localize="false"/>
+<h3 id="hd_id3151052">Skip empty cells</h3>
+<paragraph role="paragraph" id="par_id3148775"><ahelp
hid="modules/scalc/ui/pastespecial/skip_empty">Empty cells from the clipboard
do not replace target cells. If you use this option in conjunction with the
"Multiply" or the "Divide" operation, the operation is not applied to the
target cell of an empty cell in the clipboard.</ahelp></paragraph>
+<note id="par_id3155084">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.</note>
+
+<h2 id="hd_id3150440">Operations</h2>
+<paragraph role="paragraph" id="par_id3151351">Select the operation to apply
when you paste cells into your sheet.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/none" id="bm_id3153213"
localize="false"/>
+<h3 id="hd_id3153952">None</h3>
+<paragraph role="paragraph" id="par_id3147348"><ahelp
hid="modules/scalc/ui/pastespecial/none">Does not apply an operation when you
insert the cell range from the clipboard. The contents of the clipboard will
replace existing cell contents.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/add" id="bm_id3149064"
localize="false"/>
+<h3 id="hd_id3154988">Add</h3>
+<paragraph role="paragraph" id="par_id3159196"><ahelp
hid="modules/scalc/ui/pastespecial/add">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.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/subtract"
id="bm_id3152576" localize="false"/>
+<h3 id="hd_id3145263">Subtract</h3>
+<paragraph role="paragraph" id="par_id3154149"><ahelp
hid="modules/scalc/ui/pastespecial/subtract">Subtracts the values in the
clipboard cells from the values in the target cells.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/multiply"
id="bm_id3149667" localize="false"/>
+<h3 id="hd_id3155312">Multiply</h3>
+<paragraph role="paragraph" id="par_id3155307"><ahelp
hid="modules/scalc/ui/pastespecial/multiply">Multiplies the values in the
clipboard cells with the values in the target cells.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/divide" id="bm_id3153140"
localize="false"/>
+<h3 id="hd_id3154320">Divide</h3>
+<paragraph role="paragraph" id="par_id3155417"><ahelp
hid="modules/scalc/ui/pastespecial/divide">Divides the values in the target
cells by the values in the clipboard cells.</ahelp><comment>UFI: fixes
#i14796#</comment></paragraph>
+
+<h2 id="hd_id3146914">Shift Cells</h2>
+<paragraph role="paragraph" id="par_id3145169">Set the shift options for the
target cells when the clipboard content is inserted.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/no_shift"
id="bm_id3145208" localize="false"/>
+<h3 id="hd_id3155518">Don't shift</h3>
+<paragraph role="paragraph" id="par_id3154158"><ahelp
hid="modules/scalc/ui/pastespecial/no_shift">Inserted cells replace the target
cells.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/move_down"
id="bm_id3149020" localize="false"/>
+<h3 id="hd_id3148483">Down</h3>
+<paragraph role="paragraph" id="par_id3152962"><ahelp
hid="modules/scalc/ui/pastespecial/move_down">Target cells are shifted downward
when you insert cells from the clipboard.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/pastespecial/move_right"
id="bm_id3150043" localize="false"/>
+<h3 id="hd_id3145621">Right</h3>
+<paragraph role="paragraph" id="par_id3159264"><ahelp
hid="modules/scalc/ui/pastespecial/move_right">Target cells are shifted to the
right when you insert cells from the clipboard.</ahelp></paragraph>
+
+</body>
+</helpdocument>
diff --git a/source/text/shared/01/02070000.xhp
b/source/text/shared/01/02070000.xhp
index 8a2fbaa1b4..2c1a1d81d1 100644
--- a/source/text/shared/01/02070000.xhp
+++ b/source/text/shared/01/02070000.xhp
@@ -25,30 +25,15 @@
</topic>
</meta>
<body>
-
-<bookmark branch="hid/.uno:PasteAsLink" id="bm_id681736114695042"
localize="false"/>
-<bookmark branch="hid/.uno:PasteOnlyFormula" id="bm_id501736114699690"
localize="false"/>
-<bookmark branch="hid/.uno:PasteOnlyText" id="bm_id151736114703882"
localize="false"/>
-<bookmark branch="hid/.uno:PasteOnlyValue" id="bm_id451736114708370"
localize="false"/>
<bookmark branch="hid/.uno:PasteTextImportDialog" id="bm_id981736114712482"
localize="false"/>
-<bookmark branch="hid/.uno:PasteTransposed" id="bm_id531736114716507"
localize="false"/>
<bookmark branch="hid/.uno:PasteSpecial" id="bm_id3154100" localize="false"/>
<bookmark branch="hid/cui/ui/pastespecial/PasteSpecialDialog"
id="bm_id3154101" localize="false"/>
<bookmark branch="hid/cui/ui/pastespecial/@@nowidget@@" id="bm_id3154101"
localize="false"/>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/PasteSpecial"
id="bm_id31541011" localize="false"/>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/@@nowidget@@"
id="bm_id31541011" localize="false"/>
+
<bookmark branch="index" id="bm_id591736114105911">
<bookmark_value>paste;paste special</bookmark_value>
<bookmark_value>copy;paste special</bookmark_value>
<bookmark_value>paste special</bookmark_value>
-<bookmark_value>paste special;text</bookmark_value>
-<bookmark_value>paste special;numbers</bookmark_value>
-<bookmark_value>paste special;date & time</bookmark_value>
-<bookmark_value>paste special;comments</bookmark_value>
-<bookmark_value>paste special;formats</bookmark_value>
-<bookmark_value>paste special;formula</bookmark_value>
-<bookmark_value>paste special;objects</bookmark_value>
-<bookmark_value>paste special;transpose</bookmark_value>
</bookmark>
<section id="paste_special">
<h1 id="hd_id3147477"><variable id="paste_specialh1"><link
href="text/shared/01/02070000.xhp">Paste Special</link></variable></h1>
@@ -71,101 +56,20 @@
<bookmark branch="hid/cui/ui/pastespecial/list" id="bm_id080420080314218"
localize="false"/>
<h2 id="hd_id3153684">Selection</h2>
<paragraph role="paragraph" id="par_id3149812"><ahelp
hid="cui/ui/pastespecial/list">Select a format for the clipboard contents that
you want to paste. The available format depends on the copied or cut source
format.</ahelp></paragraph>
+
+ <switch select="appl">
+ <case select="CALC">
+ <h3 id="hd_id631739723778181">Use Text Import dialog</h3>
+ <paragraph role="paragraph" id="par_id351739723768701">Opens the <link
href="text/shared/00/00000208.xhp">Text Import</link> dialog to set the import
options for delimited data.</paragraph>
+ </case>
+</switch>
+
<switch select="appl">
<case select="WRITER">
<paragraph role="paragraph" id="par_id3147653">When you paste HTML data into
a text document, you can choose "<emph>HTML format</emph>" or "<emph>HTML
format without comments</emph>". The second choice is the default; it pastes
all HTML data, but no comments.</paragraph>
</case>
</switch>
-<bookmark branch="hid/.uno:InsertContents" id="bm_id7770068" localize="false"/>
-<switch select="appl">
-<case select="CALC">
-
- <h2 id="hd_id3155420">Paste Special</h2>
- <paragraph role="paragraph" id="par_id3150976">This dialog appears in Calc
if the clipboard contains spreadsheet cells.</paragraph>
- <h2 id="hd_id191630440520574">Presets</h2>
- <paragraph role="paragraph" id="par_id951630440692605">Choose one of the
presets to quickly load commonly used settings for Paste Special.</paragraph>
- <h3 id="hd_id41630440570501">Values Only</h3>
- <paragraph role="paragraph" id="par_id111630440722545">Pastes only cell
contents including text, numbers and dates.</paragraph>
- <h3 id="hd_id891630440587478">Values & Formats</h3>
- <paragraph role="paragraph" id="par_id511630441051343">Pastes cell contents
and formats applied to cells.</paragraph>
- <h3 id="hd_id301630440615367">Formats Only</h3>
- <paragraph role="paragraph" id="par_id851630441123702">Pastes only formats
applied to cells.</paragraph>
- <h3 id="hd_id81630440632865">Transpose All</h3>
- <paragraph role="paragraph" id="par_id41630441349354">Pastes all cell
contents with their positions transposed.</paragraph>
- <h3 id="hd_id991630441460829">Run immediately</h3>
- <paragraph role="paragraph" id="par_id331630441454811">Check this option to
load the preset and immediately apply it. When unchecked, choosing a preset
will only load the corresponding options in the dialog without pasting
anything.</paragraph>
- <tip id="par_id811630441564039">Uncheck <emph>Run immediately</emph> to load
the options from the preset and change its settings in the Paste Special dialog
before applying them by clicking <emph>OK</emph>.</tip>
- <h2 id="hd_id3155341">Selection</h2>
- <paragraph role="paragraph" id="par_id3152909">Select a format for the
clipboard contents that you want to paste.</paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/paste_all"
id="bm_id3148991" localize="false"/>
-<h3 id="hd_id3145120">Paste all</h3>
- <paragraph role="paragraph" id="par_id3146848"><ahelp
hid="modules/scalc/ui/pastespecial/paste_all">Pastes all cell contents,
comments, formats, and objects into the current document.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/text" id="bm_id3149796"
localize="false"/>
-<h3 id="hd_id3155449">Text<comment>i50436</comment></h3>
- <paragraph role="paragraph" id="par_id3149244"><ahelp
hid="modules/scalc/ui/pastespecial/text">Inserts cells containing
text.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/numbers" id="bm_id3147303"
localize="false"/>
-<h3 id="hd_id3148947">Numbers</h3>
- <paragraph role="paragraph" id="par_id3152360"><ahelp
hid="modules/scalc/ui/pastespecial/numbers">Inserts cells containing
numbers.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/datetime"
id="bm_id3154936" localize="false"/>
-<h3 id="hd_id3151054">Date & Time</h3>
- <paragraph role="paragraph" id="par_id3154226"><ahelp
hid="modules/scalc/ui/pastespecial/datetime">Inserts cells containing date and
time values.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/formulas"
id="bm_id3151210" localize="false"/>
-<h3 id="hd_id3150791">Formulas</h3>
- <paragraph role="paragraph" id="par_id3145744"><ahelp
hid="modules/scalc/ui/pastespecial/formulas">Inserts cells containing
formulae.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/comments"
id="bm_id3159149" localize="false"/>
-<h3 id="hd_id3153968">Comments</h3>
- <paragraph role="paragraph" id="par_id3156422"><ahelp
hid="modules/scalc/ui/pastespecial/comments">Inserts comments that are attached
to cells.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/formats" id="bm_id3145171"
localize="false"/>
-<h3 id="hd_id3152935">Formats</h3>
- <paragraph role="paragraph" id="par_id3125863"><ahelp
hid="modules/scalc/ui/pastespecial/formats">Inserts cell format
attributes.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/objects" id="bm_id3145202"
localize="false"/>
-<h3 id="hd_id3156282">Objects</h3>
- <paragraph role="paragraph" id="par_id3149810"><ahelp
hid="modules/scalc/ui/pastespecial/objects">Inserts objects contained within
the selected cell range. These can be OLE objects, chart objects, or drawing
objects.</ahelp></paragraph>
-<h2 id="hd_id3150440">Operations</h2>
- <paragraph role="paragraph" id="par_id3151351">Select the operation to apply
when you paste cells into your sheet.</paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/none" id="bm_id3153213"
localize="false"/>
-<h3 id="hd_id3153952">None</h3>
- <paragraph role="paragraph" id="par_id3147348"><ahelp
hid="modules/scalc/ui/pastespecial/none">Does not apply an operation when you
insert the cell range from the clipboard. The contents of the clipboard will
replace existing cell contents.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/add" id="bm_id3149064"
localize="false"/>
-<h3 id="hd_id3154988">Add</h3>
- <paragraph role="paragraph" id="par_id3159196"><ahelp
hid="modules/scalc/ui/pastespecial/add">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.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/subtract"
id="bm_id3152576" localize="false"/>
-<h3 id="hd_id3145263">Subtract</h3>
- <paragraph role="paragraph" id="par_id3154149"><ahelp
hid="modules/scalc/ui/pastespecial/subtract">Subtracts the values in the
clipboard cells from the values in the target cells.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/multiply"
id="bm_id3149667" localize="false"/>
-<h3 id="hd_id3155312">Multiply</h3>
- <paragraph role="paragraph" id="par_id3155307"><ahelp
hid="modules/scalc/ui/pastespecial/multiply">Multiplies the values in the
clipboard cells with the values in the target cells.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/divide" id="bm_id3153140"
localize="false"/>
-<h3 id="hd_id3154320">Divide</h3>
- <paragraph role="paragraph" id="par_id3155417"><ahelp
hid="modules/scalc/ui/pastespecial/divide">Divides the values in the target
cells by the values in the clipboard cells.</ahelp><comment>UFI: fixes
#i14796#</comment></paragraph>
-<h2 id="hd_id3147048">Options</h2>
- <paragraph role="paragraph" id="par_id3156283">Sets the paste options for
the clipboard contents.</paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/skip_empty"
id="bm_id3149485" localize="false"/>
-<h3 id="hd_id3151052">Skip empty cells</h3>
- <paragraph role="paragraph" id="par_id3148775"><ahelp
hid="modules/scalc/ui/pastespecial/skip_empty">Empty cells from the clipboard
do not replace target cells. If you use this option in conjunction with the
"Multiply" or the "Divide" operation, the operation is not applied to the
target cell of an empty cell in the clipboard.</ahelp></paragraph>
-
- <note id="par_id3155084">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.</note>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/transpose"
id="bm_id3145649" localize="false"/>
-<h3 id="hd_id3147173">Transpose</h3>
- <paragraph role="paragraph" id="par_id3147223"><ahelp
hid="modules/scalc/ui/pastespecial/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><comment>i59261</comment></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/link" id="bm_id3154270"
localize="false"/>
-<h3 id="hd_id3152971">Link</h3>
- <paragraph role="paragraph" id="par_id3146969"><ahelp
hid="modules/scalc/ui/pastespecial/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 "Paste All" option is also
selected.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3145667">You can also link sheets within
the same spreadsheet. When you link to other files, a <link
href="text/shared/00/00000005.xhp#dde">DDE link</link> is automatically
created. A DDE link is inserted as a matrix formula and can only be modified as
a whole.</paragraph>
-<h2 id="hd_id3146914">Shift Cells</h2>
- <paragraph role="paragraph" id="par_id3145169">Set the shift options for the
target cells when the clipboard content is inserted.</paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/no_shift"
id="bm_id3145208" localize="false"/>
-<h3 id="hd_id3155518">Don't shift</h3>
- <paragraph role="paragraph" id="par_id3154158"><ahelp
hid="modules/scalc/ui/pastespecial/no_shift">Inserted cells replace the target
cells.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/move_down"
id="bm_id3149020" localize="false"/>
-<h3 id="hd_id3148483">Down</h3>
- <paragraph role="paragraph" id="par_id3152962"><ahelp
hid="modules/scalc/ui/pastespecial/move_down">Target cells are shifted downward
when you insert cells from the clipboard.</ahelp></paragraph>
-<bookmark branch="hid/modules/scalc/ui/pastespecial/move_right"
id="bm_id3150043" localize="false"/>
-<h3 id="hd_id3145621">Right</h3>
- <paragraph role="paragraph" id="par_id3159264"><ahelp
hid="modules/scalc/ui/pastespecial/move_right">Target cells are shifted to the
right when you insert cells from the clipboard.</ahelp></paragraph>
- </case>
-</switch>
<section id="relatedtopics">
<embed href="text/shared/01/pasteunformatted.xhp#pasteunformattedh1"/>
</section>
diff --git a/source/text/shared/01/pastespecialmenu.xhp
b/source/text/shared/01/pastespecialmenu.xhp
index bf2a517b2a..ae2d3c7298 100644
--- a/source/text/shared/01/pastespecialmenu.xhp
+++ b/source/text/shared/01/pastespecialmenu.xhp
@@ -17,14 +17,13 @@
</meta>
<body>
<bookmark branch="hid/.uno:PasteSpecialMenu" id="bm_id981697471080216"
localize="false"/>
- <bookmark id="bm_id611584804540669" branch="hid/.uno:PasteOnly"
localize="false"/>
- <bookmark id="bm_id611584804640669" branch="hid/.uno:PasteOnlyFormula"
localize="false"/>
- <bookmark id="bm_id611584804740669" branch="hid/.uno:PasteOnlyText"
localize="false"/>
- <bookmark id="bm_id611584804840669" branch="hid/.uno:PasteOnlyValue"
localize="false"/>
+ <bookmark branch="hid/.uno:PasteOnlyFormula" id="bm_id501736114699690"
localize="false"/>
+ <bookmark branch="hid/.uno:PasteOnlyText" id="bm_id151736114703882"
localize="false"/>
+ <bookmark branch="hid/.uno:PasteOnlyValue" id="bm_id451736114708370"
localize="false"/>
<bookmark branch="index" id="bm_id201584826135259">
-<bookmark_value>paste special;only text (spreadsheet)</bookmark_value>
-<bookmark_value>paste special;only numbers (spreadsheet)</bookmark_value>
-<bookmark_value>paste special;only formula (spreadsheet)</bookmark_value>
+<bookmark_value>paste only text (spreadsheet)</bookmark_value>
+<bookmark_value>paste only numbers (spreadsheet)</bookmark_value>
+<bookmark_value>paste only formula (spreadsheet)</bookmark_value>
</bookmark>
<section id="pastespecialmenu">
<h1 id="hd_id361584804540671"><variable id="pastespecialmenuh1"><link
href="text/shared/01/pastespecialmenu.xhp">Paste Special
Menu</link></variable></h1>
