AllLangHelp_scalc.mk | 10 +
source/text/scalc/00/00000402.xhp | 129 ++++++++++++++++++++++++
source/text/scalc/01/02190000.xhp | 6 -
source/text/scalc/01/02210000.xhp | 13 ++
source/text/scalc/01/EditSelectMenu.xhp | 39 +++++++
source/text/scalc/01/JumpToNextTableSel.xhp | 36 ++++++
source/text/scalc/01/JumpToPrevTableSel.xhp | 36 ++++++
source/text/scalc/01/SelectColumn.xhp | 32 +++++
source/text/scalc/01/SelectData.xhp | 40 +++++++
source/text/scalc/01/SelectRow.xhp | 32 +++++
source/text/scalc/01/SelectUnprotectedCells.xhp | 36 ++++++
source/text/scalc/01/SelectVisibleColumns.xhp | 36 ++++++
source/text/scalc/01/SelectVisibleRows.xhp | 34 ++++++
source/text/scalc/01/TableSelectAll.xhp | 37 ++++++
source/text/scalc/guide/cellcopy.xhp | 30 ++---
source/text/scalc/guide/multitables.xhp | 2
source/text/scalc/main0102.xhp | 1
source/text/shared/00/edit_menu.xhp | 5
source/text/shared/01/02090000.xhp | 4
source/text/shared/01/pastespecialmenu.xhp | 16 +-
20 files changed, 544 insertions(+), 30 deletions(-)
New commits:
commit 020c1cb426fa951da23f51c1d93b59259ec87608
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Oct 17 11:55:45 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Oct 17 19:45:34 2023 +0200
tdf#155876 UI cmds Calc (03)
+ refactoring
+ Edit - Select menu and commands
Change-Id: I2c1e7c37cf40184391f04c29b0b6f49f43bef0e5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158087
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 2721534351..5dc4e85648 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/databar_more_options \
helpcontent2/source/text/scalc/01/default_number_formats \
helpcontent2/source/text/scalc/01/duplicate_sheet \
+ helpcontent2/source/text/scalc/01/EditSelectMenu \
helpcontent2/source/text/scalc/01/events_sheet \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
helpcontent2/source/text/scalc/01/format_graphic \
@@ -282,9 +283,14 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_year \
helpcontent2/source/text/scalc/01/func_yearfrac \
helpcontent2/source/text/scalc/01/hide_sheet \
+ helpcontent2/source/text/scalc/01/JumpToNextTableSel \
+ helpcontent2/source/text/scalc/01/JumpToPrevTableSel \
helpcontent2/source/text/scalc/01/live_data_stream \
helpcontent2/source/text/scalc/01/MergeCellsMenu \
helpcontent2/source/text/scalc/01/recalculate_hard \
+ helpcontent2/source/text/scalc/01/SelectColumn \
+ helpcontent2/source/text/scalc/01/SelectData \
+ helpcontent2/source/text/scalc/01/SelectRow \
helpcontent2/source/text/scalc/01/shared_spreadsheet \
helpcontent2/source/text/scalc/01/sheet_tab_color \
helpcontent2/source/text/scalc/01/solver \
@@ -307,7 +313,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
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/SelectUnprotectedCells \
+ helpcontent2/source/text/scalc/01/SelectVisibleColumns \
+ helpcontent2/source/text/scalc/01/SelectVisibleRows \
helpcontent2/source/text/scalc/01/zoom \
helpcontent2/source/text/scalc/01/xml_source \
helpcontent2/source/text/scalc/02/06010000 \
diff --git a/source/text/scalc/00/00000402.xhp
b/source/text/scalc/00/00000402.xhp
index 302ee6a74e..670c386a3a 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -26,6 +26,135 @@
</meta>
<body>
<h1 id="hd_id3147303">Edit Menu</h1>
+<section id="selectmenu">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id661697474090143">Choose <menuitem>Edit
- Select</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id121697473927566">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id131697473927567" role="paragraph"><image
src="cmd/lc_selecttables.svg" id="img_id501697473927568" width="1cm"
height="1cm"><alt id="alt_id121697473927569">Icon
Select</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611697473927571"
role="paragraph">Select</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+<section id="tableselectall">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id261697492871523">Choose <menuitem>Edit
- Select - Select all Sheets</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id961697496077471">Open context menu of
a sheet tab, choose <menuitem>Select all Sheets</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id341697495544816">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id271697495544817" role="paragraph"><image
src="cmd/lc_tableselectall.svg" id="img_id321697495544818" width="1cm"
height="1cm"><alt id="alt_id131697495544819">Icon Select all
Sheets</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id801697495544821" role="paragraph">Select all
Sheets</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="selecttables">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id821697495109787">Choose <menuitem>Edit
- Select - Select Sheets</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id321697495708770">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481697495708771" role="paragraph"><image
src="cmd/lc_selecttables.svg" id="img_id751697495708772" width="1cm"
height="1cm"><alt id="alt_id841697495708773">Icon Select
Sheets</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id521697495708775" role="paragraph">Select
Sheets</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
+<section id="jum2nextsheetsel">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id161697505868298">Choose
<menuitem>Edit - Select - Select to Next Sheet</menuitem>.</paragraph>
+</section>
+
+<section id="jum2prevsheetsel">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id341697505913056">Choose
<menuitem>Edit - Select - Select to Previous Sheet</menuitem>.</paragraph>
+</section>
+<section id="selectrow">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id131697543729327">Choose <menuitem>Edit
- Select - Select Row</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id801697544973540">On the
<menuitem>Home</menuitem> menu of the <menuitem>Home</menuitem> tab, choose
<menuitem>Select Row</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id751697544995896">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id371697544995897" role="paragraph"><image
src="cmd/lc_entirerow.svg" id="img_id591697544995898" width="1cm"
height="1cm"><alt id="alt_id411697544995899">Icon Select
Row</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451697544995901" role="paragraph">Select
Row</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id571697545173893"><keycode>Shift +
Space</keycode></paragraph>
+</section>
+
+<section id="selectcolumn">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id471697545255067">Choose <menuitem>Edit
- Select - Select Column</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id91697545315343">On the
<menuitem>Home</menuitem> menu of the <menuitem>Home</menuitem> tab, choose
<menuitem>Select Column</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id391697545337469">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id171697545337470" role="paragraph"><image
src="cmd/lc_entirecolumn.svg" id="img_id821697545337471" width="1cm"
height="1cm"><alt id="alt_id111697545337472">Icon Select
Column</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341697545337474" role="paragraph">Select
Column</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id641697545402329"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Space</keycode></paragraph>
+</section>
+<section id="selectdataarea">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id391697547370340">Choose <menuitem>Edit
- Select - Select Data Area</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id81697547878841">On the
<menuitem>Home</menuitem> menu of the <menuitem>Home</menuitem> tab, choose
<menuitem>Select Data Area</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id791697547448431">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id611697547448432" role="paragraph"><image
src="cmd/lc_selectdb.svg" id="img_id691697547448433" width="1cm"
height="1cm"><alt id="alt_id891697547448434">Icon Select Data
Area</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id581697547448436" role="paragraph">Select Data
Area</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id611697547563412"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ *</keycode> (asterisk)</paragraph>
+</section>
+<section id="selectunprotectedcells">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id891697551686832">Choose
<menuitem>Edit - Select - Select Unprotected Cells</menuitem>.</paragraph>
+</section>
+<section id="selectvisiblerows">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id461697551778402">Choose
<menuitem>Edit - Select - Select Visible Rows</menuitem>.</paragraph>
+</section>
+<section id="selectvisiblecolumns">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id821697551802937">Choose
<menuitem>Edit - Select - Select Visible Columns</menuitem>.</paragraph>
+</section>
+
<paragraph id="par_id3155555" role="paragraph" xml-lang="en-US"><variable
id="kopffuss">Choose <emph>Insert - Headers and
Footers</emph>.</variable></paragraph>
<paragraph id="par_id3159233" role="paragraph" xml-lang="en-US"><variable
id="bkopfzeile">Choose <emph>Insert - Headers and Footers - Header and
Footer</emph> tabs.</variable></paragraph>
<paragraph id="par_id3150443" role="paragraph" xml-lang="en-US"><variable
id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/02190000.xhp
b/source/text/scalc/01/02190000.xhp
index a51a85b921..20f3be084e 100644
--- a/source/text/scalc/01/02190000.xhp
+++ b/source/text/scalc/01/02190000.xhp
@@ -20,7 +20,7 @@
<meta>
<topic id="textscalc0102190000xml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Delete Page Break</title>
+ <title id="tit">Delete Page Break</title>
<filename>/text/scalc/01/02190000.xhp</filename>
</topic>
</meta>
@@ -28,10 +28,10 @@
<body>
<section id="del_page_break">
-<bookmark xml-lang="en-US" branch="hid/.uno:DelBreakMenu" id="bm_id8417004"
localize="false"/>
+<bookmark branch="hid/.uno:DelBreakMenu" id="bm_id8417004" localize="false"/>
<h1 id="hd_id3150541"><link href="text/scalc/01/02190000.xhp">Delete Page
Break</link></h1>
-<paragraph id="par_id3154365" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Choose the type of page break that you want to
delete.</ahelp></paragraph>
+<paragraph id="par_id3154365" role="paragraph"><ahelp hid=".">Choose the type
of page break that you want to delete.</ahelp></paragraph>
</section>
<section id="howtoget">
diff --git a/source/text/scalc/01/02210000.xhp
b/source/text/scalc/01/02210000.xhp
index 9a36f37102..39f077b5e6 100644
--- a/source/text/scalc/01/02210000.xhp
+++ b/source/text/scalc/01/02210000.xhp
@@ -29,10 +29,19 @@
<body>
<bookmark branch="hid/.uno:SelectTables" id="bm_id3154758" localize="false"/>
-<h1 id="hd_id3156023">Selecting Sheets</h1>
- <paragraph role="paragraph" id="par_id3147265"><variable
id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables"
visibility="visible">Selects multiple sheets.</ahelp></variable></paragraph>
<bookmark branch="hid/SC_HID_SELECTTABLES" id="bm_id3154126"
localize="false"/>
+<section id="selectsheets">
+ <h1 id="hd_id3156023"><variable id="h1"><link
href="text/scalc/01/02210000.xhp">Select Sheets</link></variable></h1>
+ <paragraph role="paragraph" id="par_id3147265"><variable
id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables"
visibility="visible">Opens the <emph>Select Sheets</emph> dialog to select
multiple sheets.</ahelp></variable></paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selecttables"/>
+</section>
<h2 id="hd_id3125863">Selected Sheets</h2>
<paragraph role="paragraph" id="par_id3153969"><ahelp
hid="SC_HID_SELECTTABLES">Lists the sheets in the current document. To select a
sheet, press the up or down arrow keys to move to a sheet in the list. To add a
sheet to the selection, hold down <switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
while pressing the arrow keys and then press Spacebar. To select a range of
sheets, hold down Shift and press the arrow keys. </ahelp></paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id321697493573426"
localize="false"><embedvar href="text/scalc/guide/multitables.xhp#multitables"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/EditSelectMenu.xhp
b/source/text/scalc/01/EditSelectMenu.xhp
new file mode 100644
index 0000000000..d2bc5da104
--- /dev/null
+++ b/source/text/scalc/01/EditSelectMenu.xhp
@@ -0,0 +1,39 @@
+<?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="textscalc01EditSelectMenuxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select</title>
+ <filename>/text/scalc/01/EditSelectMenu.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:EditSelectMenu" id="bm_id471697472857353"
localize="false"/>
+ <section id="selectmenu">
+ <h1 id="hd_id181697472927867"><variable id="h1"><link
href="text/scalc/01/EditSelectMenu.xhp">Select</link></variable></h1>
+ <paragraph id="par_id121697472927868" role="paragraph">Opens a menu
for specific sheet selections.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectmenu"/>
+ </section>
+ <embed href="text/scalc/01/TableSelectAll.xhp#tableselectall"/>
+ <embed href="text/scalc/01/02210000.xhp#selectsheets"/>
+ <embed href="text/scalc/01/JumpToNextTableSel.xhp#JumpToNextTableSel"/>
+ <embed href="text/scalc/01/JumpToPrevTableSel.xhp#JumpToPrevTableSel"/>
+ <embed href="text/scalc/01/SelectRow.xhp#selectrow"/>
+ <embed href="text/scalc/01/SelectColumn.xhp#selectcolumn"/>
+ <embed href="text/scalc/01/SelectData.xhp#selectdataarea"/>
+ <embed
href="text/scalc/01/SelectUnprotectedCells.xhp#selectunprotectedcells"/>
+ <embed href="text/scalc/01/SelectVisibleRows.xhp#selectvisiblerows"/>
+ <embed href="text/scalc/01/SelectVisibleColumns.xhp#selectvisiblecolumns"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/JumpToNextTableSel.xhp
b/source/text/scalc/01/JumpToNextTableSel.xhp
new file mode 100644
index 0000000000..146b8f6a6b
--- /dev/null
+++ b/source/text/scalc/01/JumpToNextTableSel.xhp
@@ -0,0 +1,36 @@
+<?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/JumpToNextTableSel.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select to Next Sheet</title>
+ <filename>/text/scalc/01/JumpToNextTableSel.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:JumpToNextTableSel" id="bm_id351697504966666"
localize="false"/>
+<bookmark branch="index" id="bm_id801697546069561">
+ <bookmark_value>select;to the next sheet</bookmark_value>
+</bookmark>
+ <section id="JumpToNextTableSel">
+ <h1 id="hd_id841697505362733"><variable id="h1"><link
href="text/scalc/01/JumpToNextTableSel.xhp">Select to Next
Sheet</link></variable></h1>
+ <paragraph id="par_id291697505362735" role="paragraph">Select to next
sheet in the document.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#jum2nextsheetsel"/>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id321697493573426"
localize="false"><embedvar href="text/scalc/guide/multitables.xhp#multitables"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/JumpToPrevTableSel.xhp
b/source/text/scalc/01/JumpToPrevTableSel.xhp
new file mode 100644
index 0000000000..38bfa5ec4b
--- /dev/null
+++ b/source/text/scalc/01/JumpToPrevTableSel.xhp
@@ -0,0 +1,36 @@
+<?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/JumpToPrevTableSel.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select to Previous Sheet</title>
+ <filename>/text/scalc/01/JumpToPrevTableSel.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:JumpToPrevTableSel" id="bm_id351697504966666"
localize="false"/>
+<bookmark branch="index" id="bm_id911697545975417">
+ <bookmark_value>select;to the previous sheet</bookmark_value>
+</bookmark>
+ <section id="JumpToPrevTableSel">
+ <h1 id="hd_id841697505362733"><variable id="h1"><link
href="text/scalc/01/JumpToPrevTableSel.xhp">Select to Previous
Sheet</link></variable></h1>
+ <paragraph id="par_id291697505362735" role="paragraph">Select to
previous sheet in the document.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#jum2prevsheetsel"/>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id321697493573426"
localize="false"><embedvar href="text/scalc/guide/multitables.xhp#multitables"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectColumn.xhp
b/source/text/scalc/01/SelectColumn.xhp
new file mode 100644
index 0000000000..91ccc1258b
--- /dev/null
+++ b/source/text/scalc/01/SelectColumn.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="textscalc01SelectColumnxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select Column</title>
+ <filename>/text/scalc/01/SelectColumn.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:SelectColumn" id="bm_id861697506504395"
localize="false"/>
+ <section id="selectcolumn">
+ <h1 id="hd_id91697506550043"><variable id="h1"><link
href="text/scalc/01/SelectColumn.xhp">Select Column</link></variable></h1>
+ <paragraph id="par_id931697506550045" role="paragraph">Select the
entire column where the cursor is placed or the columns of the current cell
selection.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectcolumn"/>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectData.xhp
b/source/text/scalc/01/SelectData.xhp
new file mode 100644
index 0000000000..7d114847e5
--- /dev/null
+++ b/source/text/scalc/01/SelectData.xhp
@@ -0,0 +1,40 @@
+<?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="textscalc01SelectDataxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select Data</title>
+ <filename>/text/scalc/01/SelectData.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+<bookmark branch="hid/.uno:SelectData" id="bm_id681697546146788"
localize="false"/>
+<bookmark branch="index" id="bm_id571697548030826">
+ <bookmark_value>select;block of data</bookmark_value>
+ <bookmark_value>select;data area</bookmark_value>
+</bookmark>
+<section id="selectdataarea">
+ <h1 id="hd_id171697546202709"><variable id="h1"><link
href="text/scalc/01/SelectData.xhp">Select Data Area</link></variable></h1>
+ <paragraph id="par_id821697546202712" role="paragraph">Selects the data
area where the cursor or selection is located.</paragraph>
+</section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectdataarea"/>
+ </section>
+<paragraph role="paragraph" id="par_id911697547125155">To select the data
area, the cursor must be inside or adjacent to a block of data.</paragraph>
+
+<paragraph role="paragraph" id="par_id21697547130354">If the cursor is not
adjacent to a block of data, the selection returns the cell where the cursor is
placed.</paragraph>
+
+<paragraph role="paragraph" id="par_id391697547137174">If the cell is adjacent
to two blocks of data, the selection is the rectangular area that wraps the two
blocks of data.</paragraph>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectRow.xhp
b/source/text/scalc/01/SelectRow.xhp
new file mode 100644
index 0000000000..41aa99f511
--- /dev/null
+++ b/source/text/scalc/01/SelectRow.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="textscalc01SelectRowxhp" indexer="include" status="PUBLISH">
+ <title id="tit">Select Row</title>
+ <filename>/text/scalc/01/SelectRow.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:SelectRow" id="bm_id861697506504395"
localize="false"/>
+ <section id="selectrow">
+ <h1 id="hd_id91697506550043"><variable id="h1"><link
href="text/scalc/01/SelectRow.xhp">Select Row</link></variable></h1>
+ <paragraph id="par_id931697506550045" role="paragraph">Select the
entire row where the cursor is placed or the rows of the current cell
selection.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectrow"/>
+ </section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectUnprotectedCells.xhp
b/source/text/scalc/01/SelectUnprotectedCells.xhp
new file mode 100644
index 0000000000..fb39c65947
--- /dev/null
+++ b/source/text/scalc/01/SelectUnprotectedCells.xhp
@@ -0,0 +1,36 @@
+<?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="textscalc01SelectUnprotectedCellsxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select Unprotected Cells</title>
+ <filename>/text/scalc/01/SelectUnprotectedCells.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:SelectUnprotectedCells" id="bm_id861697506504395"
localize="false"/>
+<bookmark branch="index" id="bm_id331697550336670">
+ <bookmark_value>select;unprotected cells</bookmark_value>
+</bookmark>
+ <section id="selectunprotectedcells">
+ <h1 id="hd_id91697506550043"><variable id="h1"><link
href="text/scalc/01/SelectUnprotectedCells.xhp">Select Unprotected
Cells</link></variable></h1>
+ <paragraph id="par_id931697506550045" role="paragraph">Select the
unprotected cells.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectunprotectedcells"/>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id231697552424575"
localize="false"><embedvar
href="text/scalc/guide/cell_protect.xhp#cell_protect"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectVisibleColumns.xhp
b/source/text/scalc/01/SelectVisibleColumns.xhp
new file mode 100644
index 0000000000..94a101c5d2
--- /dev/null
+++ b/source/text/scalc/01/SelectVisibleColumns.xhp
@@ -0,0 +1,36 @@
+<?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="textscalc01SelectVisibleColumnsxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select Visible Columns</title>
+ <filename>/text/scalc/01/SelectVisibleColumns.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+<bookmark branch="hid/.uno:SelectVisibleColumns" id="bm_id861697506504395"
localize="false"/>
+<bookmark branch="index" id="bm_id401697550910277">
+ <bookmark_value>select;visible columns</bookmark_value>
+</bookmark>
+ <section id="selectvisiblecolumns">
+ <h1 id="hd_id91697506550043"><variable id="h1"><link
href="text/scalc/01/SelectVisibleColumns.xhp">Select Visible
Columns</link></variable></h1>
+ <paragraph id="par_id931697506550045" role="paragraph">Select the
visible columns.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectvisiblecolumns"/>
+ </section>
+ <paragraph role="paragraph" id="par_id711697553770827">The command
only selects the visible columns. Commands applied to the selected visible
columns does not applies on hidden columns.</paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id51697553497322"
localize="false"><embedvar href="text/scalc/guide/cellcopy.xhp#cellcopy"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/SelectVisibleRows.xhp
b/source/text/scalc/01/SelectVisibleRows.xhp
new file mode 100644
index 0000000000..b248923a6a
--- /dev/null
+++ b/source/text/scalc/01/SelectVisibleRows.xhp
@@ -0,0 +1,34 @@
+<?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="textscalc01SelectVisibleRowsxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select Visible Rows</title>
+ <filename>/text/scalc/01/SelectVisibleRows.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+
+<bookmark branch="hid/.uno:SelectVisibleRows" id="bm_id861697506504395"
localize="false"/>
+ <section id="selectvisiblerows">
+ <h1 id="hd_id91697506550043"><variable id="h1"><link
href="text/scalc/01/SelectVisibleRows.xhp">Select Visible
Rows</link></variable></h1>
+ <paragraph id="par_id931697506550045" role="paragraph">Select the
visible rows.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#selectvisiblerows"/>
+ </section>
+ <paragraph role="paragraph" id="par_id711697553770827">The command only
selects the visible rows. Commands applied to the selected visible rows does
not applies on hidden rows.</paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id51697553497322"
localize="false"><embedvar href="text/scalc/guide/cellcopy.xhp#cellcopy"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/TableSelectAll.xhp
b/source/text/scalc/01/TableSelectAll.xhp
new file mode 100644
index 0000000000..0e1bdbddda
--- /dev/null
+++ b/source/text/scalc/01/TableSelectAll.xhp
@@ -0,0 +1,37 @@
+<?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="textscalc01TableSelectAllxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Select all Sheets</title>
+ <filename>/text/scalc/01/TableSelectAll.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark id="bm_id741697477288950" branch="hid/.uno:TableSelectAll"
localize="false"/>
+ <bookmark branch="index" id="bm_id931697546015630">
+ <bookmark_value>select;all cells in sheet</bookmark_value>
+ </bookmark>
+ <section id="tableselectall">
+ <h1 id="hd_id771697477288952"><variable id="h1"><link
href="text/scalc/01/TableSelectAll.xhp">Select all Sheets</link></variable></h1>
+ <paragraph id="par_id491697477288954" role="paragraph">Selects all the
sheets in your document.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#tableselectall"/>
+ </section>
+ <paragraph role="paragraph" id="par_id3155261">To select all of the cells
on a sheet, click the button at the intersection of the column and row header
in the top left corner of the sheet.</paragraph>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id321697493573426"
localize="false"><embedvar href="text/scalc/guide/multitables.xhp#multitables"
markup="ignore"/></paragraph>
+ <paragraph role="paragraph" id="par_id141697548510404"
localize="false"><embedvar href="text/scalc/01/EditSelectMenu.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
+
diff --git a/source/text/scalc/guide/cellcopy.xhp
b/source/text/scalc/guide/cellcopy.xhp
index 57b3986ddd..b6e072d615 100644
--- a/source/text/scalc/guide/cellcopy.xhp
+++ b/source/text/scalc/guide/cellcopy.xhp
@@ -22,12 +22,12 @@
<meta>
<topic id="textscalcguidecellcopyxml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Only Copy Visible Cells</title>
+ <title id="tit">Only Copy Visible Cells</title>
<filename>/text/scalc/guide/cellcopy.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150440"><bookmark_value>cells;
copying/deleting/formatting/moving</bookmark_value>
+<bookmark branch="index" id="bm_id3150440"><bookmark_value>cells;
copying/deleting/formatting/moving</bookmark_value>
<bookmark_value>rows;visible and invisible</bookmark_value>
<bookmark_value>copying; visible cells only</bookmark_value>
<bookmark_value>formatting;visible cells only</bookmark_value>
@@ -37,35 +37,35 @@
<bookmark_value>filters;copying visible cells only</bookmark_value>
<bookmark_value>hidden cells</bookmark_value>
</bookmark><comment>mw changed "cells;"</comment>
-<paragraph xml-lang="en-US" id="hd_id3150440" role="heading"
level="1"><variable id="cellcopy"><link
href="text/scalc/guide/cellcopy.xhp">Only Copy Visible Cells</link>
-</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3148577" role="paragraph">Assume
you have hidden a few rows in a cell range. Now you want to copy, delete, or
format only the remaining visible rows.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154729"
role="paragraph">$[officename] behavior depends on how the cells were made
invisible, by a filter or manually.</paragraph>
+<h1 id="hd_id3150440"><variable id="cellcopy"><link
href="text/scalc/guide/cellcopy.xhp">Only Copy Visible Cells</link>
+</variable></h1>
+ <paragraph id="par_id3148577" role="paragraph">Assume you have hidden a
few rows in a cell range. Now you want to copy, delete, or format only the
remaining visible rows.</paragraph>
+ <paragraph id="par_id3154729" role="paragraph">$[officename] behavior
depends on how the cells were made invisible, by a filter or
manually.</paragraph>
<table id="tbl_id3154942">
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3155603"
role="tablehead">Method and Action</paragraph>
+ <paragraph id="par_id3155603" role="tablehead">Method and
Action</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3150751"
role="tablehead">Result</paragraph>
+ <paragraph id="par_id3150751"
role="tablehead">Result</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149018"
role="tablecontent">Cells were filtered by AutoFilters, standard filters or
advanced filters.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150044"
role="tablecontent">Copy, delete, move, or format a selection of currently
visible cells.</paragraph>
+ <paragraph id="par_id3149018" role="tablecontent">Cells were
filtered by AutoFilters, standard filters or advanced filters.</paragraph>
+ <paragraph id="par_id3150044" role="tablecontent">Copy, delete,
move, or format a selection of currently visible cells.</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3146918"
role="tablecontent">Only the visible cells of the selection are copied,
deleted, moved, or formatted.</paragraph>
+ <paragraph id="par_id3146918" role="tablecontent">Only the
visible cells of the selection are copied, deleted, moved, or
formatted.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3166427"
role="tablecontent">Cells were hidden using the <emph>Hide</emph> command in
the context menu of the row or column headers, or through an <link
href="text/scalc/01/12080000.xhp">outline</link>.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152990"
role="tablecontent">Copy, delete, move, or format a selection of currently
visible cells.</paragraph>
+ <paragraph id="par_id3166427" role="tablecontent">Cells were
hidden using the <emph>Hide</emph> command in the context menu of the row or
column headers, or through an <link
href="text/scalc/01/12080000.xhp">outline</link>.</paragraph>
+ <paragraph id="par_id3152990" role="tablecontent">Copy, delete,
move, or format a selection of currently visible cells.</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154371"
role="tablecontent">By default, all cells of the selection, including the
hidden cells, are copied, deleted, moved, or formatted. Restrict the selection
to visible rows choosing <menuitem>Edit - Select - Select Visible Rows
Only</menuitem> or to visible columns choosing <menuitem>Edit - Select - Select
Visible Columns Only</menuitem>.</paragraph>
+ <paragraph id="par_id3154371" role="tablecontent">By default,
all cells of the selection, including the hidden cells, are copied, deleted,
moved, or formatted. Restrict the selection to visible rows choosing
<menuitem>Edit - Select - Select Visible Rows Only</menuitem> or to visible
columns choosing <menuitem>Edit - Select - Select Visible Columns
Only</menuitem>.</paragraph>
</tablecell>
</tablerow>
</table>
@@ -76,4 +76,4 @@
<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/multitables.xhp
b/source/text/scalc/guide/multitables.xhp
index 50a2b58238..551e5d8fec 100644
--- a/source/text/scalc/guide/multitables.xhp
+++ b/source/text/scalc/guide/multitables.xhp
@@ -39,10 +39,10 @@
<bookmark branch="hid/FID_TAB_EVENTS" id="bm_id906582498"
localize="false"/><comment>Sheet Events</comment>
<paragraph id="par_id05092009140203598" role="paragraph"><ahelp hid="."
visibility="hidden">Opens a dialog box where you can assign macros to sheet
events.</ahelp></paragraph>
-<bookmark branch="hid/.uno:TableSelectAll" id="bm_id9065824" localize="false"/>
<paragraph id="par_id050920091402035" role="paragraph"><ahelp hid="."
visibility="hidden">Click to select all sheets in the
document.</ahelp></paragraph>
<bookmark branch="hid/.uno:TableDeselectAll" id="bm_id9065825"
localize="false"/>
<paragraph id="par_id0509200914020391" role="paragraph"><ahelp hid="."
visibility="hidden">Click to deselect all sheets in the document, except the
current sheet.</ahelp></paragraph>
+
<h2 id="hd_id3154491">Selecting Multiple Sheets</h2>
<paragraph id="par_id3145251" role="paragraph">The sheet tab of the
current sheet is always visible in white in front of the other sheet tabs. The
other sheet tabs are gray when they are not selected. By clicking other sheet
tabs while pressing <switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
you can select multiple sheets.</paragraph>
<paragraph id="par_idN106B7" role="paragraph">You can use
Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page
Up or Page Down to select multiple sheets using the keyboard.</paragraph>
diff --git a/source/text/scalc/main0102.xhp b/source/text/scalc/main0102.xhp
index 29dca1b447..4e83358605 100644
--- a/source/text/scalc/main0102.xhp
+++ b/source/text/scalc/main0102.xhp
@@ -42,6 +42,7 @@
<embed href="text/shared/01/02060000.xhp#paste"/>
<embed href="text/shared/01/pastespecialmenu.xhp#pastespecialmenu"/>
<embed href="text/shared/01/02090000.xhp#select_all"/>
+<embed href="text/scalc/01/EditSelectMenu.xhp#selectmenu"/>
<embed href="text/shared/01/menu_edit_find.xhp#find"/>
<embed href="text/shared/01/02100000.xhp#find_and_replace"/>
<embed href="text/shared/01/02230000.xhp#track_changes"/>
diff --git a/source/text/shared/00/edit_menu.xhp
b/source/text/shared/00/edit_menu.xhp
index 2f9c984d5f..ead293e5f9 100644
--- a/source/text/shared/00/edit_menu.xhp
+++ b/source/text/shared/00/edit_menu.xhp
@@ -228,6 +228,11 @@
</section>
<embed href="text/shared/00/00000004.xhp#from_keyboard"/>
<paragraph role="paragraph" id="par_id3152417"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ A</keycode></paragraph>
+ <switch select="appl">
+ <case select="CALC">
+ <paragraph role="paragraph"
id="par_id721697471791843"><switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Shift + Space</keycode></paragraph>
+ </case>
+ </switch>
</section>
<section id="changes">
diff --git a/source/text/shared/01/02090000.xhp
b/source/text/shared/01/02090000.xhp
index fb759db56e..5a5944689f 100644
--- a/source/text/shared/01/02090000.xhp
+++ b/source/text/shared/01/02090000.xhp
@@ -28,9 +28,9 @@
</history>
</meta>
<body>
-<section id="select_all">
<bookmark branch="hid/.uno:SelectAll" id="bm_id3159079" localize="false"/>
<bookmark branch="hid/.uno:Select" id="bm_id9111451" localize="false"/>
+<section id="select_all">
<h1 id="hd_id3145138"><link href="text/shared/01/02090000.xhp">Select
All</link></h1>
<paragraph role="paragraph" id="par_id3149999"><variable
id="allestext"><ahelp hid=".">Selects the entire content of the current file,
frame, or text object.</ahelp></variable></paragraph>
</section>
@@ -38,7 +38,7 @@
<section id="howtoget">
<embed href="text/shared/00/edit_menu.xhp#select_all"/>
</section>
-<bookmark branch="hid/.uno:TableSelectAll" id="bm_id4889160" localize="false"/>
+
<paragraph role="paragraph" id="par_id3154046"><switchinline
select="appl"><caseinline select="CALC">To select all of the sheets in a
spreadsheet file, right-click the name tab of a sheet, and then choose
<emph>Select All
Sheets</emph>.</caseinline><defaultinline/></switchinline></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/01/pastespecialmenu.xhp
b/source/text/shared/01/pastespecialmenu.xhp
index 4136710402..bf2a517b2a 100644
--- a/source/text/shared/01/pastespecialmenu.xhp
+++ b/source/text/shared/01/pastespecialmenu.xhp
@@ -16,13 +16,7 @@
</topic>
</meta>
<body>
- <section id="pastespecialmenu">
- <h1 id="hd_id361584804540671"><variable id="pastespecialmenuh1"><link
href="text/shared/01/pastespecialmenu.xhp">Paste Special
Menu</link></variable></h1>
- <paragraph id="par_id721584804540674" role="paragraph"><ahelp
hid=".">Inserts the contents of the clipboard into the current file in a format
that you can specify.</ahelp></paragraph>
- </section>
- <section id="howtoget">
- <embed href="text/shared/00/edit_menu.xhp#pastespecialmenu"/>
- </section>
+ <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"/>
@@ -32,6 +26,14 @@
<bookmark_value>paste special;only numbers (spreadsheet)</bookmark_value>
<bookmark_value>paste special;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>
+ <paragraph id="par_id721584804540674" role="paragraph"><ahelp
hid=".">Inserts the contents of the clipboard into the current file in a format
that you can specify.</ahelp></paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/shared/00/edit_menu.xhp#pastespecialmenu"/>
+ </section>
+
<embed href="text/shared/01/pasteunformatted.xhp#pasteunformatted"/>
<switch select="appl">
<case select="CALC">
