AllLangHelp_scalc.mk | 2
source/text/scalc/00/00000402.xhp | 25 ++++-
source/text/scalc/00/00000404.xhp | 42 ++++++++
source/text/scalc/00/sheet_menu.xhp | 11 ++
source/text/scalc/01/02140000.xhp | 113 +++++++++++-------------
source/text/scalc/01/02150000.xhp | 64 ++++++-------
source/text/scalc/01/04050100.xhp | 21 +---
source/text/scalc/01/04090000.xhp | 56 +++++------
source/text/scalc/01/Add.xhp | 29 ++++++
source/text/scalc/01/ToggleRelative.xhp | 32 ++++++
source/text/scalc/guide/relativ_absolut_ref.xhp | 26 +++--
source/text/scalc/main0116.xhp | 8 +
12 files changed, 277 insertions(+), 152 deletions(-)
New commits:
commit 4953ea62c3603c2c3f66faf67dac67ba987476c9
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Dec 12 20:17:22 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Dec 13 01:29:57 2023 +0100
tdf#155876 UI cmds Calc-Sheet menu (30)
+ Sheet menu for Calc: clear cells, references, fill
+ refactoring
Change-Id: I0c0c10af4a9983e893907aa5c0a491b5814dae22
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160657
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index e599fb8d9b..6fd3c5f682 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -323,6 +323,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/TableSelectAll \
helpcontent2/source/text/scalc/01/text2columns \
helpcontent2/source/text/scalc/01/ToggleFormula \
+ helpcontent2/source/text/scalc/01/ToggleRelative \
helpcontent2/source/text/scalc/01/ToggleSheetGrid \
helpcontent2/source/text/scalc/01/SelectUnprotectedCells \
helpcontent2/source/text/scalc/01/SelectVisibleColumns \
diff --git a/source/text/scalc/00/00000402.xhp
b/source/text/scalc/00/00000402.xhp
index 3c71881376..f587341b42 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -161,7 +161,11 @@
<paragraph role="paragraph" id="par_id131697569897269"
localize="false"><keycode>F2</keycode></paragraph>
</section>
-<paragraph id="par_id3150443" role="paragraph"><variable
id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
+<section id="fill_cells">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3150443" role="paragraph"><variable
id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
+</section>
+
<paragraph id="par_id3143267" role="paragraph"><variable id="bausunten">Choose
<emph>Sheet - Fill Cells - Down</emph>.</variable></paragraph>
<paragraph id="par_id3153880" role="paragraph"><variable
id="bausrechts">Choose <emph>Sheet - Fill Cells -
Right</emph>.</variable></paragraph>
<paragraph id="par_id3151245" role="paragraph"><variable id="bausoben">Choose
<emph>Sheet - Fill Cells - Up</emph>.</variable></paragraph>
@@ -170,8 +174,23 @@
<paragraph id="par_id3154910" role="paragraph"><variable id="bausreihe">Choose
<emph>Sheet - Fill Cells - Series</emph>.</variable></paragraph>
<section id="clear_cells">
-<paragraph id="par_id3154123" role="paragraph">Choose <emph>Sheet - Clear
Cells</emph>.</paragraph>
-<paragraph id="par_id3145785" role="paragraph">Backspace</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3154123" role="paragraph">Choose <emph>Sheet - Clear
Cells</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id281702417873169">Choose
<menuitem>Clear Contents</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id291702417761204">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id461702417761205" role="paragraph"><image
src="cmd/lc_delete.svg" id="img_id371702417761206" width="1cm"
height="1cm"><alt id="alt_id181702417761207">Icon Clear
Cells</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id831702417761209" role="paragraph">Clear
Cells</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph id="par_id3145785"
role="paragraph"><keycode>Backspace</keycode></paragraph>
</section>
<section id="delete_cells">
diff --git a/source/text/scalc/00/sheet_menu.xhp
b/source/text/scalc/00/sheet_menu.xhp
index 7c3f16c683..ca278f7fbf 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -33,6 +33,12 @@
<paragraph role="paragraph" id="par_id491702125833846">Choose
<menuitem>Sheet</menuitem>.</paragraph>
</section>
+<section id="cyclereftype">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id981702420507898">Choose
<menuitem>Sheet - Cycle Cell Reference Types</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id411702420563569"
localize="false"><keycode>F4</keycode></paragraph>
+</section>
<comment>Hide sheet</comment>
<section id="hidesheet">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/02140000.xhp
b/source/text/scalc/01/02140000.xhp
index b34f0e9a08..2c93bcc03c 100644
--- a/source/text/scalc/01/02140000.xhp
+++ b/source/text/scalc/01/02140000.xhp
@@ -1,66 +1,63 @@
<?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/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed
- * with this work for additional information regarding copyright
- * ownership. The ASF licenses this file to you under the Apache
- * License, Version 2.0 (the "License"); you may not use this file
- * except in compliance with the License. You may obtain a copy of
- * the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
-
-
-<meta>
+
+ <!--
+ * 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/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+ <meta>
<topic id="textscalc0102140000xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Fill</title>
+ <title id="tit">Fill</title>
<filename>/text/scalc/01/02140000.xhp</filename>
</topic>
</meta>
<body>
- <section id="fill">
-<bookmark xml-lang="en-US" branch="hid/.uno:FillCellsMenu" id="bm_id2939237"
localize="false"/>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id8473769"><bookmark_value>filling;selection lists</bookmark_value>
- <bookmark_value>selection lists;filling cells</bookmark_value>
-</bookmark><comment>MW inserted 2 index entries</comment>
-<h1 id="hd_id3153876"><link href="text/scalc/01/02140000.xhp">Fill</link></h1>
- <paragraph xml-lang="en-US" id="par_id3156285"
role="paragraph"><ahelp hid=".">Automatically fills cells with
content.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000402.xhp#bausfullen"/>
- </section>
- <paragraph xml-lang="en-US" id="par_id3147343" role="note">The
$[officename] Calc context menus have <link
href="text/scalc/01/02140000.xhp">additional options</link> for filling the
cells.</paragraph>
- <embed href="text/scalc/01/02140100.xhp#down"/>
- <embed href="text/scalc/01/02140200.xhp#right"/>
- <embed href="text/scalc/01/02140300.xhp#up"/>
- <embed href="text/scalc/01/02140400.xhp#left"/>
- <h2 id="hd_id3149207"><link
href="text/scalc/01/02140500.xhp">Sheet</link></h2>
- <embed href="text/scalc/01/02140500.xhp#tabellenfuellentext"/>
- <h2 id="hd_id3155111"><link
href="text/scalc/01/02140600.xhp">Series</link></h2>
- <embed href="text/scalc/01/02140600.xhp#reihenfuellentext"/>
- <paragraph xml-lang="en-US" id="par_id3152994" role="paragraph">
-<emph>Filling cells using context menus:</emph>
-</paragraph>
- <list type="unordered">
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3145384"
role="listitem">Call the <link
href="text/shared/00/00000005.xhp#contextmenu">context menu</link> when
positioned in a cell and choose <emph>Selection List</emph>.</paragraph>
- </listitem>
- <listitem>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataSelect" id="bm_id4369249"
localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3156450" role="listitem"><ahelp
hid=".uno:DataSelect">A list box containing all text found in the current
column is displayed.</ahelp> The text is sorted alphabetically and multiple
entries are listed only once.</paragraph>
- </listitem>
- <listitem>
- <paragraph xml-lang="en-US" id="par_id3148699"
role="listitem">Click one of the listed entries to copy it to the
cell.</paragraph>
- </listitem>
- </list>
- </body>
+ <bookmark branch="hid/.uno:FillCellsMenu" id="bm_id2939237"
localize="false"/>
+ <bookmark branch="index"
id="bm_id8473769"><bookmark_value>filling;selection lists</bookmark_value>
+ <bookmark_value>selection lists;filling cells</bookmark_value>
+ </bookmark><comment>MW inserted 2 index entries</comment>
+ <section id="fill">
+ <h1 id="hd_id3153876"><link href="text/scalc/01/02140000.xhp">Fill
Cells</link></h1>
+ <paragraph id="par_id3156285" role="paragraph"><ahelp
hid=".">Automatically fills cells with content.</ahelp></paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#fill_cells"/>
+ </section>
+ <embed href="text/scalc/01/02140100.xhp#down"/>
+ <embed href="text/scalc/01/02140200.xhp#right"/>
+ <embed href="text/scalc/01/02140300.xhp#up"/>
+ <embed href="text/scalc/01/02140400.xhp#left"/>
+ <h2 id="hd_id3149207"><link
href="text/scalc/01/02140500.xhp">Sheet</link></h2>
+ <embed href="text/scalc/01/02140500.xhp#tabellenfuellentext"/>
+ <h2 id="hd_id3155111"><link
href="text/scalc/01/02140600.xhp">Series</link></h2>
+ <embed href="text/scalc/01/02140600.xhp#reihenfuellentext"/>
+ <paragraph id="par_id3152994" role="paragraph">
+ <emph>Filling cells using context menus:</emph>
+ </paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id3145384" role="listitem">Call the <link
href="text/shared/00/00000005.xhp#contextmenu">context menu</link> when
positioned in a cell and choose <emph>Selection List</emph>.</paragraph>
+ </listitem>
+ <listitem>
+ <bookmark branch="hid/.uno:DataSelect" id="bm_id4369249"
localize="false"/>
+ <paragraph id="par_id3156450" role="listitem"><ahelp
hid=".uno:DataSelect">A list box containing all text found in the current
column is displayed.</ahelp> The text is sorted alphabetically and multiple
entries are listed only once.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id3148699" role="listitem">Click one of the listed
entries to copy it to the cell.</paragraph>
+ </listitem>
+ </list>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/02150000.xhp
b/source/text/scalc/01/02150000.xhp
index 7123a47657..4274401607 100644
--- a/source/text/scalc/01/02150000.xhp
+++ b/source/text/scalc/01/02150000.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,52 +16,49 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
- <helpdocument version="1.0">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc0102150000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Deleting Contents</title>
+<title id="tit">Deleting Contents</title>
<filename>/text/scalc/01/02150000.xhp</filename>
</topic>
</meta>
<body>
-<section id="del_contents">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3143284"><bookmark_value>deleting; cell contents</bookmark_value>
+<bookmark branch="index" id="bm_id3143284"><bookmark_value>deleting; cell
contents</bookmark_value>
<bookmark_value>cells; deleting contents</bookmark_value>
<bookmark_value>spreadsheets; deleting cell contents</bookmark_value>
<bookmark_value>cell contents; deleting</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:Delete" id="bm_id5511579"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/DeleteContentsDialog"
id="bm_id3145382" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/@@nowidget@@" id="bm_id3145382"
localize="false"/>
-<h1 id="hd_id3143284">Deleting Contents</h1>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><variable
id="inhalteloeschentext"><ahelp hid=".uno:Delete">Specifies the contents to be
deleted from the active cell or from a selected cell range.</ahelp>
-</variable> If several sheets are selected, all selected sheets will be
affected.</paragraph>
+<bookmark branch="hid/.uno:Delete" id="bm_id5511579" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/DeleteContentsDialog"
id="bm_id3145382" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/@@nowidget@@"
id="bm_id3145382" localize="false"/>
+<section id="del_contents">
+<h1 id="hd_id3143284">Clear Cells</h1>
+<paragraph role="paragraph" id="par_id3149456"><variable
id="inhalteloeschentext"><ahelp hid=".uno:Delete">Specifies the contents to be
deleted from the active cell or from a selected cell range.</ahelp></variable>
If several sheets are selected, all selected sheets will be
affected.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000402.xhp#clear_cells"/>
</section>
-<paragraph role="tip" id="par_id3159154" xml-lang="en-US">This dialog is also
called by pressing Backspace after the cell cursor has been activated on the
sheet.</paragraph>
-<paragraph role="tip" id="par_id3145367" xml-lang="en-US">Pressing Delete
deletes content without calling the dialog or changing formats.</paragraph>
-<paragraph role="tip" id="par_id3153951" xml-lang="en-US">Use <emph>Cut</emph>
on the Standard bar to delete contents and formats without the
dialog.</paragraph>
+<tip id="par_id3159154">This dialog is also called by pressing Backspace after
the cell cursor has been activated on the sheet.</tip>
+<tip id="par_id3145367">Pressing Delete deletes content without calling the
dialog or changing formats.</tip>
+<tip id="par_id3153951">Use <emph>Cut</emph> on the Standard bar to delete
contents and formats without the dialog.</tip>
<h2 id="hd_id3148575">Selection</h2>
-<paragraph role="paragraph" id="par_id3149665" xml-lang="en-US">This area
lists the options for deleting contents.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/deleteall" id="bm_id3144766"
localize="false"/><h3 id="hd_id3146975">Delete All</h3>
-<paragraph role="paragraph" id="par_id3154729" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/deleteall">Deletes all content from the
selected cell range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/text"
id="bm_id3147394" localize="false"/><h3
id="hd_id3156286">Text<comment>i50439</comment></h3>
-<paragraph role="paragraph" id="par_id3154015" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/text">Deletes text only. Formats,
formulas, numbers and dates are not affected.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/numbers" id="bm_id3156276"
localize="false"/><h3 id="hd_id3153840">Numbers</h3>
-<paragraph role="paragraph" id="par_id3148405" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/numbers">Deletes numbers only. Formats and
formulas remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/datetime" id="bm_id3154757"
localize="false"/><h3 id="hd_id3155764">Date & time</h3>
-<paragraph role="paragraph" id="par_id3149567" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/datetime">Deletes date and time values.
Formats, text, numbers and formulas remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/formulas" id="bm_id3149256"
localize="false"/><h3 id="hd_id3154703">Formulas</h3>
-<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/formulas">Deletes formulas. Text, numbers,
formats, dates and times remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/comments" id="bm_id3152775"
localize="false"/><h3 id="hd_id3150300">Comments</h3>
-<paragraph role="paragraph" id="par_id3154658" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/comments">Deletes comments added to cells.
All other elements remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/formats" id="bm_id3145258"
localize="false"/><h3 id="hd_id3155112">Formats</h3>
-<paragraph role="paragraph" id="par_id3146134" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/formats">Deletes format attributes applied
to cells. All cell content remains unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/deletecontents/objects" id="bm_id3152582"
localize="false"/><h3 id="hd_id3150088">Objects</h3>
-<paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/deletecontents/objects">Deletes objects. All cell content
remains unchanged.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149665">This area lists the options for
deleting contents.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/deleteall"
id="bm_id3144766" localize="false"/><h3 id="hd_id3146975">Delete All</h3>
+<paragraph role="paragraph" id="par_id3154729"><ahelp
hid="modules/scalc/ui/deletecontents/deleteall">Deletes all content from the
selected cell range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/text" id="bm_id3147394"
localize="false"/><h3 id="hd_id3156286">Text<comment>i50439</comment></h3>
+<paragraph role="paragraph" id="par_id3154015"><ahelp
hid="modules/scalc/ui/deletecontents/text">Deletes text only. Formats,
formulas, numbers and dates are not affected.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/numbers"
id="bm_id3156276" localize="false"/><h3 id="hd_id3153840">Numbers</h3>
+<paragraph role="paragraph" id="par_id3148405"><ahelp
hid="modules/scalc/ui/deletecontents/numbers">Deletes numbers only. Formats and
formulas remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/datetime"
id="bm_id3154757" localize="false"/><h3 id="hd_id3155764">Date & time</h3>
+<paragraph role="paragraph" id="par_id3149567"><ahelp
hid="modules/scalc/ui/deletecontents/datetime">Deletes date and time values.
Formats, text, numbers and formulas remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/formulas"
id="bm_id3149256" localize="false"/><h3 id="hd_id3154703">Formulas</h3>
+<paragraph role="paragraph" id="par_id3148485"><ahelp
hid="modules/scalc/ui/deletecontents/formulas">Deletes formulas. Text, numbers,
formats, dates and times remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/comments"
id="bm_id3152775" localize="false"/><h3 id="hd_id3150300">Comments</h3>
+<paragraph role="paragraph" id="par_id3154658"><ahelp
hid="modules/scalc/ui/deletecontents/comments">Deletes comments added to cells.
All other elements remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/formats"
id="bm_id3145258" localize="false"/><h3 id="hd_id3155112">Formats</h3>
+<paragraph role="paragraph" id="par_id3146134"><ahelp
hid="modules/scalc/ui/deletecontents/formats">Deletes format attributes applied
to cells. All cell content remains unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/objects"
id="bm_id3152582" localize="false"/><h3 id="hd_id3150088">Objects</h3>
+<paragraph role="paragraph" id="par_id3152990"><ahelp
hid="modules/scalc/ui/deletecontents/objects">Deletes objects. All cell content
remains unchanged.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/ToggleRelative.xhp
b/source/text/scalc/01/ToggleRelative.xhp
new file mode 100644
index 0000000000..dd07a043a1
--- /dev/null
+++ b/source/text/scalc/01/ToggleRelative.xhp
@@ -0,0 +1,32 @@
+<?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="textscalc01ToggleRelativexhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Toggle Relative Adressing</title>
+ <filename>/text/scalc/01/ToggleRelative.xhp</filename>
+ </topic>
+ </meta>
+<body>
+<bookmark branch="hid/.uno:ToggleRelative" id="bm_id991702418291729"
localize="false"/>
+<section id="cycle_types">
+ <h1 id="hd_id81702418438740"><variable id="h1"><link
href="text/scalc/01/ToggleRelative.xhp">Cycle Cell Reference
Types</link></variable></h1>
+ <paragraph id="par_id361702418438742" role="paragraph">Cycles between
absolute and relative addressing of cell reference in the formula.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#cyclereftype"/>
+</section>
+<embed href="text/scalc/guide/relativ_absolut_ref.xhp#abs_rel_types"/>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id301702418791608"
localize="false"><embedvar
href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/relativ_absolut_ref.xhp
b/source/text/scalc/guide/relativ_absolut_ref.xhp
index fd14ade9e5..e302c97141 100644
--- a/source/text/scalc/guide/relativ_absolut_ref.xhp
+++ b/source/text/scalc/guide/relativ_absolut_ref.xhp
@@ -19,7 +19,7 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalcguiderelativ_absolut_refxml" indexer="include"
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Addresses and References, Absolute and
Relative</title>
+<title id="tit">Addresses and References, Absolute and Relative</title>
<filename>/text/scalc/guide/relativ_absolut_ref.xhp</filename>
</topic>
<history>
@@ -27,7 +27,7 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3156423"><bookmark_value>addressing; relative and
absolute</bookmark_value>
+<bookmark branch="index" id="bm_id3156423"><bookmark_value>addressing;
relative and absolute</bookmark_value>
<bookmark_value>references; absolute/relative</bookmark_value>
<bookmark_value>absolute addresses in spreadsheets</bookmark_value>
<bookmark_value>relative addresses</bookmark_value>
@@ -49,17 +49,21 @@
<embed href="text/scalc/guide/cellreferences.xhp#otherdocref"/>
<embed href="text/scalc/01/04060199.xhp#referenceoperators"/>
<h2 id="hd_id3163712">Relative Addressing</h2>
-<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US">The cell in
column A, row 1 is addressed as A1. You can address a range of adjacent cells
by first entering the coordinates of the upper left cell of the area, then a
colon followed by the coordinates of the lower right cell. For example, the
square formed by the first four cells in the upper left corner is addressed as
A1:B2.</paragraph>
-<paragraph role="paragraph" id="par_id3154730" xml-lang="en-US">By addressing
an area in this way, you are making a relative reference to A1:B2. Relative
here means that the reference to this area will be adjusted automatically when
you copy the formulas.</paragraph>
+<paragraph role="paragraph" id="par_id3146119">The cell in column A, row 1 is
addressed as A1. You can address a range of adjacent cells by first entering
the coordinates of the upper left cell of the area, then a colon followed by
the coordinates of the lower right cell. For example, the square formed by the
first four cells in the upper left corner is addressed as A1:B2.</paragraph>
+<paragraph role="paragraph" id="par_id3154730">By addressing an area in this
way, you are making a relative reference to A1:B2. Relative here means that the
reference to this area will be adjusted automatically when you copy the
formulas.</paragraph>
<h2 id="hd_id3149377">Absolute Addressing</h2>
-<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US">Absolute
referencing is the opposite of relative addressing. A dollar sign is placed
before each letter and number in an absolute reference, for example,
$A$1:$B$2.</paragraph>
-<tip id="par_id3147338">$[officename] can convert the current reference, in
which the cursor is positioned in the input line, from relative to absolute and
vice versa by pressing F4. If you start with a relative address such as A1, the
first time you press this key combination, both row and column are set to
absolute references ($A$1). The second time, only the row (A$1), and the third
time, only the column ($A1). If you press the key combination once more, both
column and row references are switched back to relative (A1)</tip>
-<paragraph role="paragraph" id="par_id3153963" xml-lang="en-US">$[officename]
Calc shows the references to a formula. If, for example, you click the formula
=SUM(A1:C5;D15:D24) in a cell, the two referenced areas in the sheet will be
highlighted in color. For example, the formula component "A1:C5" may be in blue
and the cell range in question bordered in the same shade of blue. The next
formula component "D15:D24" can be marked in red in the same way.</paragraph>
+<paragraph role="paragraph" id="par_id3154943">Absolute referencing is the
opposite of relative addressing. A dollar sign is placed before each letter and
number in an absolute reference, for example, $A$1:$B$2.</paragraph>
+
+<section id="abs_rel_types">
+ <tip id="par_id3147338">$[officename] can convert the current reference,
in which the cursor is positioned in the input line, from relative to absolute
and vice versa by pressing <keycode>F4</keycode>. If you start with a relative
address such as A1, the first time you press this key combination, both row and
column are set to absolute references ($A$1). The second time, only the row
(A$1), and the third time, only the column ($A1). If you press the key
combination once more, both column and row references are switched back to
relative (A1)</tip>
+</section>
+
+<paragraph role="paragraph" id="par_id3153963">$[officename] Calc shows the
references to a formula. If, for example, you click the formula
=SUM(A1:C5;D15:D24) in a cell, the two referenced areas in the sheet will be
highlighted in color. For example, the formula component "A1:C5" may be in blue
and the cell range in question bordered in the same shade of blue. The next
formula component "D15:D24" can be marked in red in the same way.</paragraph>
<h2 id="hd_id3154704">When to Use Relative and Absolute References</h2>
-<paragraph role="paragraph" id="par_id3147346" xml-lang="en-US">What
distinguishes a relative reference? Assume you want to calculate in cell E1 the
sum of the cells in range A1:B2. The formula to enter into E1 would be:
=SUM(A1:B2). If you later decide to insert a new column in front of column A,
the elements you want to add would then be in B1:C2 and the formula would be in
F1, not in E1. After inserting the new column, you would therefore have to
check and correct all formulas in the sheet, and possibly in other
sheets.</paragraph>
-<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US">Fortunately,
$[officename] does this work for you. After having inserted a new column A, the
formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers
will also be automatically adjusted when a new row 1 is inserted. Absolute and
relative references are always adjusted in $[officename] Calc whenever the
referenced area is moved. But be careful if you are copying a formula since in
that case only the relative references will be adjusted, not the absolute
references.</paragraph>
-<paragraph role="paragraph" id="par_id3145791" xml-lang="en-US">Absolute
references are used when a calculation refers to one specific cell in your
sheet. If a formula that refers to exactly this cell is copied relatively to a
cell below the original cell, the reference will also be moved down if you did
not define the cell coordinates as absolute.</paragraph>
-<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US">Aside from
when new rows and columns are inserted, references can also change when an
existing formula referring to particular cells is copied to another area of the
sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to
calculate the sum for the adjacent column to the right, simply copy this
formula to the cell to the right. The copy of the formula in column B will be
automatically adjusted to =SUM(B1:B9).</paragraph>
+<paragraph role="paragraph" id="par_id3147346">What distinguishes a relative
reference? Assume you want to calculate in cell E1 the sum of the cells in
range A1:B2. The formula to enter into E1 would be: =SUM(A1:B2). If you later
decide to insert a new column in front of column A, the elements you want to
add would then be in B1:C2 and the formula would be in F1, not in E1. After
inserting the new column, you would therefore have to check and correct all
formulas in the sheet, and possibly in other sheets.</paragraph>
+<paragraph role="paragraph" id="par_id3155335">Fortunately, $[officename] does
this work for you. After having inserted a new column A, the formula
=SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers will also
be automatically adjusted when a new row 1 is inserted. Absolute and relative
references are always adjusted in $[officename] Calc whenever the referenced
area is moved. But be careful if you are copying a formula since in that case
only the relative references will be adjusted, not the absolute
references.</paragraph>
+<paragraph role="paragraph" id="par_id3145791">Absolute references are used
when a calculation refers to one specific cell in your sheet. If a formula that
refers to exactly this cell is copied relatively to a cell below the original
cell, the reference will also be moved down if you did not define the cell
coordinates as absolute.</paragraph>
+<paragraph role="paragraph" id="par_id3147005">Aside from when new rows and
columns are inserted, references can also change when an existing formula
referring to particular cells is copied to another area of the sheet. Assume
you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum
for the adjacent column to the right, simply copy this formula to the cell to
the right. The copy of the formula in column B will be automatically adjusted
to =SUM(B1:B9).</paragraph>
<section id="relatedtopics">
<embed
href="text/scalc/guide/value_with_name.xhp#value_with_name"/><comment>mw
changed link target from "address_byname" to "value_with_name"</comment><embed
href="text/scalc/guide/address_auto.xhp#address_auto"/>
</section>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index e2f9f1815a..9e525c979e 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -48,8 +48,10 @@
<embed href="text/scalc/01/Add.xhp#addatend"/>
<embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
<embed href="text/scalc/01/04090000.xhp#extdata"/>
-
+<embed href="text/scalc/01/02170000.xhp#deletesheet"/>
+<embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
<embed href="text/scalc/01/02140000.xhp#fill"/>
+
<embed href="text/scalc/01/02150000.xhp#del_contents"/>
<h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy
Sheet</link></h2>
commit dfd902c240c11e611732f1c26345869354a56ba6
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Dec 12 18:36:27 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Dec 13 01:29:42 2023 +0100
tdf#155876 UI cmds Calc-Sheet menu (29)
+ Sheet menu for Calc, insert sheets, external links
+ refactoring
Change-Id: I79838e7b1f25240a2a0932138c2cd62e70feea6d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160656
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 3344595ebb..e599fb8d9b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -181,6 +181,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/12120100 \
helpcontent2/source/text/scalc/01/12120200 \
helpcontent2/source/text/scalc/01/12120300 \
+ helpcontent2/source/text/scalc/01/Add \
helpcontent2/source/text/scalc/01/calculate \
helpcontent2/source/text/scalc/01/cell_styles \
helpcontent2/source/text/scalc/01/calculation_accuracy \
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index e1217da2ea..7473556970 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -194,7 +194,27 @@
</tablerow>
</table>
</section>
-<paragraph role="paragraph" id="par_idN1082F"><variable id="eitabfile">Choose
<menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
+
+<section id="insertfromfile">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_idN1082F"><variable
id="eitabfile">Choose <menuitem>Sheet - Insert Sheet from
File</menuitem>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id151702403498564">Choose
<menuitem>Insert - Insert Sheet - From File</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id601702404855774">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Insert Sheet from File</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id281702403424406">Choose
<menuitem>Insert Sheet - From file</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id281702403654889">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id791702403654890" role="paragraph"><image
src="cmd/lc_insert.svg" id="img_id131702403654891" width="1cm"
height="1cm"><alt id="alt_id501702403654892">Icon Insert Sheet from
File</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481702403654894" role="paragraph">Insert Sheet
From File</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
<section id="insert_function">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -243,7 +263,25 @@
<paragraph role="paragraph" id="par_id3154059"><variable
id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose
<menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3146776"><variable id="eiextdata">Choose
<menuitem>Sheet - External Links</menuitem>.</variable></paragraph>
+
+<section id="extlink">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3146776"><variable
id="eiextdata">Choose <menuitem>Sheet - External
Links</menuitem>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id561702405100757">Choose <menuitem>Data
- External Links</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id21702405171182">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id631702405171183" role="paragraph"><image
src="cmd/lc_insertexternaldatasource.svg" id="img_id121702405171184"
width="1cm" height="1cm"><alt id="alt_id151702405171185">Icon External
Links</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id411702405171187" role="paragraph">External
Links</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
<section id="define_name">
<paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named
Ranges and Expressions - Define</menuitem>.</paragraph>
<paragraph role="paragraph" id="par_id3149385"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
diff --git a/source/text/scalc/00/sheet_menu.xhp
b/source/text/scalc/00/sheet_menu.xhp
index 01842a167f..7c3f16c683 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -164,7 +164,10 @@
</tablerow>
</table>
</section>
-
+<section id="addsheetatend">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id231702400095820">Choose
<menuitem>Sheet - Insert Sheet at End</menuitem>.</paragraph>
+</section>
<comment>Insert sheet</comment>
<section id="insert_sheet">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/04050100.xhp
b/source/text/scalc/01/04050100.xhp
index ea6f804a54..8c641283cc 100644
--- a/source/text/scalc/01/04050100.xhp
+++ b/source/text/scalc/01/04050100.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,30 +16,28 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
- <helpdocument version="1.0">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc0104050100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Sheet from file</title>
+<title id="tit">Sheet from file</title>
<filename>/text/scalc/01/04050100.xhp</filename>
</topic>
</meta>
<body>
+<bookmark branch="hid/.uno:InsertSheetFromFile" id="bm_id1850337"
localize="false"/>
<section id="sheetfromfile">
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertSheetFromFile"
id="bm_id1850337" localize="false"/>
-<h1 id="par_idN105C1"><link href="text/scalc/01/04050100.xhp">Sheet from
file</link></h1>
-<paragraph role="paragraph" id="par_idN105D1" xml-lang="en-US"><ahelp
hid=".">Inserts a sheet from a different spreadsheet file.</ahelp></paragraph>
+<h1 id="par_idN105C1"><link href="text/scalc/01/04050100.xhp">Insert Sheet
from file</link></h1>
+<paragraph role="paragraph" id="par_idN105D1"><ahelp hid=".">Inserts a sheet
from a different spreadsheet file.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000404.xhp#eitabfile"/>
+ <embed href="text/scalc/00/00000404.xhp#insertfromfile"/>
</section>
<list type="ordered">
<listitem>
-<paragraph role="paragraph" id="par_idN105F7" xml-lang="en-US">Use the <link
href="text/shared/01/01020000.xhp">File - Open</link> dialog to locate the
spreadsheet.</paragraph>
+<paragraph role="paragraph" id="par_idN105F7">Use the <link
href="text/shared/01/01020000.xhp">File - Open</link> dialog to locate the
spreadsheet.</paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_idN10609" xml-lang="en-US">In the <link
href="text/scalc/01/04050000.xhp">Insert Sheet</link> dialog, select the sheet
that you want to insert.</paragraph>
+<paragraph role="paragraph" id="par_idN10609">In the <link
href="text/scalc/01/04050000.xhp">Insert Sheet</link> dialog, select the sheet
that you want to insert.</paragraph>
</listitem>
</list>
</body>
diff --git a/source/text/scalc/01/04090000.xhp
b/source/text/scalc/01/04090000.xhp
index 5e85c8fe30..126d9e6282 100644
--- a/source/text/scalc/01/04090000.xhp
+++ b/source/text/scalc/01/04090000.xhp
@@ -22,37 +22,37 @@
<meta>
<topic id="textscalc0104090000xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">External Links</title>
+ <title id="tit">External Links</title>
<filename>/text/scalc/01/04090000.xhp</filename>
</topic>
- </meta>
- <body>
- <section id="extdata">
- <paragraph xml-lang="en-US" id="par_id3153361" role="paragraph"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/browse"
id="bm_id3151041" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3153192" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Open a file
dialog to locate the file containing the data you want to
insert.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertExternalDataSource"
id="bm_id3748965" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog" id="bm_id3150441"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/externaldata/@@nowidget@@" id="bm_id3150441"
localize="false"/>
-<h1 id="hd_id3145785"><link href="text/scalc/01/04090000.xhp">External
Links</link></h1>
- <paragraph xml-lang="en-US" id="par_id3149262"
role="paragraph"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an
HTML, Calc, CSV or Excel file into the current sheet as a link. The data must
be located within a named range.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/scalc/00/00000404.xhp#eiextdata"/>
- </section>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/url"
id="bm_id3148577" localize="false"/>
+</meta>
+<body>
+ <paragraph id="par_id3153361" role="paragraph" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/externaldata/browse"
id="bm_id3151041" localize="false"/>
+ <bookmark branch="hid/.uno:InsertExternalDataSource" id="bm_id3748965"
localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog"
id="bm_id3150441" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/externaldata/@@nowidget@@"
id="bm_id3150441" localize="false"/>
+<section id="extdata">
+ <h1 id="hd_id3145785"><link href="text/scalc/01/04090000.xhp">External
Links</link></h1>
+ <paragraph id="par_id3149262" role="paragraph"><ahelp
hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, CSV or
Excel file into the current sheet as a link. The data must be located within a
named range.</ahelp></paragraph>
+</section>
+ <paragraph id="par_id3153192" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Open a file
dialog to locate the file containing the data you want to
insert.</ahelp></paragraph>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000404.xhp#extlink"/>
+</section>
+<bookmark branch="hid/modules/scalc/ui/externaldata/url" id="bm_id3148577"
localize="false"/>
<h2 id="hd_id3146984">URL of external data source.</h2>
-<paragraph xml-lang="en-US" id="par_id3145366" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that
contains the data that you want to insert, and then press Enter.</ahelp>
Alternatively, click <emph>Browse</emph> button to select the file name from a
file dialog that opens. Only then will the URL be requested from the network or
file system.</paragraph>
-<paragraph xml-lang="en-US" id="par_id621519313666202" role="note"><link
href="text/shared/00/00000208.xhp">A dialog for CSV data import</link> appears
when linking to external CSV file.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ranges"
id="bm_id3153876" localize="false"/>
+<paragraph id="par_id3145366" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that
contains the data that you want to insert, and then press Enter.</ahelp>
Alternatively, click <emph>Browse</emph> button to select the file name from a
file dialog that opens. Only then will the URL be requested from the network or
file system.</paragraph>
+<note id="par_id621519313666202"><link href="text/shared/00/00000208.xhp">A
dialog for CSV data import</link> appears when linking to external CSV
file.</note>
+<bookmark branch="hid/modules/scalc/ui/externaldata/ranges" id="bm_id3153876"
localize="false"/>
<h2 id="hd_id3145251">Available tables/ranges</h2>
- <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range
that you want to insert.</ahelp> If the selected Calc or Excel document
contains no named range, spreadsheet data cannot be inserted and
<emph>OK</emph> button will remain inactive </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/reload"
id="bm_id3153418" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/delay"
id="bm_id3150718" localize="false"/>
+<paragraph id="par_id3147397" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range
that you want to insert.</ahelp> If the selected Calc or Excel document
contains no named range, spreadsheet data cannot be inserted and
<emph>OK</emph> button will remain inactive </paragraph>
+<bookmark branch="hid/modules/scalc/ui/externaldata/reload" id="bm_id3153418"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/externaldata/delay" id="bm_id3150718"
localize="false"/>
<h2 id="hd_id3154492">Update every</h2>
- <paragraph xml-lang="en-US" id="par_id3154017" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/delay">Enter the number of seconds to wait
before the external data are reloaded into the current
document.</ahelp></paragraph>
- <section id="relatedtopics">
- <embed href="text/scalc/guide/webquery.xhp#webquery"/>
- </section>
- </body>
+<paragraph id="par_id3154017" role="paragraph"><ahelp
hid="modules/scalc/ui/externaldata/delay">Enter the number of seconds to wait
before the external data are reloaded into the current
document.</ahelp></paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/guide/webquery.xhp#webquery"/>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/Add.xhp b/source/text/scalc/01/Add.xhp
new file mode 100644
index 0000000000..1c5c3f4427
--- /dev/null
+++ b/source/text/scalc/01/Add.xhp
@@ -0,0 +1,29 @@
+<?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/Add.xhp" indexer="include" status="PUBLISH">
+ <title id="tit">Insert Sheet at End</title>
+ <filename>/text/scalc/01/Add.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:Add" id="bm_id991702399745390" localize="false"/>
+ <section id="addatend">
+ <h1 id="hd_id611702399875408"><variable id="h1"><link
href="text/scalc/01/Add.xhp">Insert Sheet at End</link></variable></h1>
+ <paragraph id="par_id701702399875410" role="paragraph">Adds a new
sheet at end of the spreadsheet document.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#addsheetatend"/>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index a009981faf..e2f9f1815a 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -44,6 +44,10 @@
<embed href="text/shared/01/DeleteRows.xhp#delete_rows"/>
<embed href="text/shared/01/DeleteColumns.xhp#delete_columns"/>
<embed href="text/scalc/01/02190000.xhp#del_page_break"/>
+<embed href="text/scalc/01/04050000.xhp#insertsheet"/>
+<embed href="text/scalc/01/Add.xhp#addatend"/>
+<embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
+<embed href="text/scalc/01/04090000.xhp#extdata"/>
<embed href="text/scalc/01/02140000.xhp#fill"/>
<embed href="text/scalc/01/02150000.xhp#del_contents"/>
