source/text/scalc/00/00000412.xhp | 96 +++++++++++++++++++++++++++++++++-----
source/text/scalc/01/12080000.xhp | 15 ++---
source/text/scalc/01/12080100.xhp | 19 +++----
source/text/scalc/01/12080200.xhp | 24 +++------
source/text/scalc/01/12080300.xhp | 31 +++++-------
source/text/scalc/01/12080400.xhp | 17 ++----
source/text/scalc/01/12080500.xhp | 47 +++++++++---------
source/text/scalc/01/12080600.xhp | 15 ++---
8 files changed, 161 insertions(+), 103 deletions(-)
New commits:
commit c66cae4936bcf19b5e98aaebcbc94139d4be9734
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Jan 4 10:27:41 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 4 15:05:07 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (48)
+ Data menu for Calc, Outline commands
+ refactoring
Change-Id: I329995051e89390ba115120c20b5f88e39513d59
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161619
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 3d8ea14655..75e29aeb62 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -354,19 +354,62 @@
</table>
</section>
- <paragraph role="paragraph" id="par_id3148701"><variable id="dngld">Choose
<emph>Data - Group and Outline</emph>.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3153815"><variable id="dngda">Choose
<emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3159223"><variable id="dngde">Choose
<emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph>
+ <section id="group_menu">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3148701"><variable
id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph>
+ </section>
+
+ <section id="show_details">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3159223"><variable
id="dngde">Choose <emph>Data - Group and Outline - Show
Details</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id181704373338815">Choose
<menuitem>Data - Show Details</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id631704374025765">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Show Details</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id451704373355285">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id531704373355287"
role="paragraph"><image src="cmd/lc_showdetail.svg" id="img_id451704373355288"
width="1cm" height="1cm"><alt id="alt_id921704373355289">Icon Show
Details</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451704373355290"
role="paragraph">Show Details</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+
+ <section id="hide_details">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153815"><variable
id="dngda">Choose <emph>Data - Group and Outline - Hide
Details</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id161704373839255">Choose
<menuitem>Data - Hide Details</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id821704373842279">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Hide Details</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id721704373860902">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id871704373860903"
role="paragraph"><image src="cmd/lc_hidedetail.svg" id="img_id91704373860904"
width="1cm" height="1cm"><alt id="alt_id101704373860905">Icon Hide
Details</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461704373860906"
role="paragraph">Hide Details</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+
<section id="data_outline_group">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3146870">Choose <emph>Data -
Group and Outline - Group</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id3144507">F12</paragraph>
- <paragraph role="paragraph" id="par_id3144772">On <emph>Tools</emph>
bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id341704370684918">Choose
<menuitem>Data - Group</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id91704370689903">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Group</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<section id="sygroup">
<table id="tbl_id3154532">
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3149438">
- <image id="img_id3153287" src="cmd/sc_group.png"
width="0.222inch" height="0.222inch"><alt
id="alt_id3153287">Icon</alt></image></paragraph>
+ <image id="img_id3153287" src="cmd/lc_group.svg"
width="1cm" height="1cm"><alt id="alt_id3153287">Icon
Group</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph"
id="par_id3150214">Group</paragraph>
@@ -374,17 +417,22 @@
</tablerow>
</table>
</section>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" localize="false"
id="par_id3144507">F12</paragraph>
</section>
<section id="data_outline_ungroup">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3146781">Choose <emph>Data -
Group and Outline - Ungroup</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id3150892"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph>
- <paragraph role="paragraph" id="par_id3155097">On <emph>Tools</emph>
bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id431704370985403">Choose
<menuitem>Data - Ungroup</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id831704370988651">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Ungroup</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<section id="syungroup">
<table id="tbl_id3143223">
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3150048">
- <image id="img_id3155914" src="cmd/sc_ungroup.png"
width="0.222inch" height="0.222inch"><alt
id="alt_id3155914">Icon</alt></image></paragraph>
+ <image id="img_id3155914" src="cmd/lc_ungroup.svg"
width="1cm" height="1cm"><alt id="alt_id3155914">Icon
Ungroup</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph"
id="par_id3153555">Ungroup</paragraph>
@@ -392,9 +440,35 @@
</tablerow>
</table>
</section>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id3150892"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
+ F12</paragraph>
+ </section>
+
+ <section id="auto_outline">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153008"><variable
id="dnglagl">Choose <emph>Data - Group and Outline -
AutoOutline</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id371704372113351">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>AutoOutline</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id21704371965013">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id301704371965014"
role="paragraph"><image src="cmd/lc_autooutline.svg" id="img_id421704371965015"
width="1cm" height="1cm"><alt id="alt_id131704371965016">Icon
AutoOutline</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11704371965018"
role="paragraph">AutoOutline</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+
+ <section id="remove_outline">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3154709"><variable
id="dnglef">Choose <emph>Data - Group and Outline - Remove
Outline</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id311704372728016">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Remove Outline</menuitem>.</paragraph>
</section>
- <paragraph role="paragraph" id="par_id3153008"><variable
id="dnglagl">Choose <emph>Data - Group and Outline -
AutoOutline</emph>.</variable></paragraph>
- <paragraph role="paragraph" id="par_id3154709"><variable
id="dnglef">Choose <emph>Data - Group and Outline - Remove
Outline</emph>.</variable></paragraph>
+
<paragraph role="paragraph" id="par_id1774346"><variable
id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for
some pivot tables).</variable></paragraph>
<section id="pivotmenu">
diff --git a/source/text/scalc/01/12080000.xhp
b/source/text/scalc/01/12080000.xhp
index 233482f1c6..36ff292db7 100644
--- a/source/text/scalc/01/12080000.xhp
+++ b/source/text/scalc/01/12080000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0112080000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Group and Outline</title>
+<title id="tit">Group and Outline</title>
<filename>/text/scalc/01/12080000.xhp</filename>
</topic>
<history>
@@ -30,18 +27,20 @@
</history>
</meta>
<body>
-<section id="group_and_outline">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3152350"><bookmark_value>sheets; outlines</bookmark_value>
+<bookmark branch="hid/.uno:GroupOutlineMenu" id="bm_id421704369584673"
localize="false"/>
+
+<bookmark branch="index" id="bm_id3152350"><bookmark_value>sheets;
outlines</bookmark_value>
<bookmark_value>outlines; sheets</bookmark_value>
<bookmark_value>hiding; sheet details</bookmark_value>
<bookmark_value>showing; sheet details</bookmark_value>
<bookmark_value>grouping;cells</bookmark_value>
</bookmark>
+<section id="group_and_outline">
<h1 id="hd_id3152350"><link href="text/scalc/01/12080000.xhp">Group and
Outline</link></h1>
-<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US">You can create
an outline of your data and group rows and columns together so that you can
collapse and expand the groups with a single click.</paragraph>
+<paragraph role="paragraph" id="par_id3150793">You can create an outline of
your data and group rows and columns together so that you can collapse and
expand the groups with a single click.</paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dngld"/>
+ <embed href="text/scalc/00/00000412.xhp#group_menu"/>
</section>
<embed href="text/scalc/01/12080100.xhp#hide_details"/>
<embed href="text/scalc/01/12080200.xhp#show_details"/>
diff --git a/source/text/scalc/01/12080100.xhp
b/source/text/scalc/01/12080100.xhp
index a4cc6dfed4..8fee28d16a 100644
--- a/source/text/scalc/01/12080100.xhp
+++ b/source/text/scalc/01/12080100.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0112080100xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Hide Details</title>
+<title id="tit">Hide Details</title>
<filename>/text/scalc/01/12080100.xhp</filename>
</topic>
<history>
@@ -30,17 +27,17 @@
</history>
</meta>
<body>
-
-
+
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-HideDetail"
id="bm_id1001704373480003" localize="false"/>
+<bookmark branch="hid/.uno:HideDetail" id="bm_id3149784" localize="false"/>
+ <bookmark branch="index" id="bm_id3155628"><bookmark_value>sheets; hiding
details</bookmark_value></bookmark>
<section id="hide_details">
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3155628"><bookmark_value>sheets; hiding
details</bookmark_value></bookmark>
-<bookmark branch="hid/.uno:HideDetail" xml-lang="en-US" id="bm_id3149784"
localize="false"/>
<h1 id="hd_id3155628"><link href="text/scalc/01/12080100.xhp">Hide
Details</link></h1>
- <paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><ahelp
hid=".uno:HideDetail" visibility="visible">Hides the details of the grouped row
or column that contains the cursor. To hide all of the grouped rows or columns,
select the outlined table, and then choose this command.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3154515"><ahelp hid=".uno:HideDetail"
visibility="visible">Hides the details of the grouped row or column that
contains the cursor. To hide all of the grouped rows or columns, select the
outlined table, and then choose this command.</ahelp></paragraph>
</section>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3153252">To show all
hidden groups, select the outlined table, and then choose <emph>Data - Group
and Outline –</emph> <link href="text/scalc/01/12080200.xhp"><emph>Show
Details</emph></link>.</paragraph>
+ <paragraph role="paragraph" id="par_id3153252">To show all hidden groups,
select the outlined table, and then choose <emph>Data - Group and Outline
–</emph> <link href="text/scalc/01/12080200.xhp"><emph>Show
Details</emph></link>.</paragraph>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dngda"/>
+ <embed href="text/scalc/00/00000412.xhp#hide_details"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080200.xhp
b/source/text/scalc/01/12080200.xhp
index d098ca0cda..4e38e25165 100644
--- a/source/text/scalc/01/12080200.xhp
+++ b/source/text/scalc/01/12080200.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,29 +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="textscalc0112080200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Show Details</title>
+<title id="tit">Show Details</title>
<filename>/text/scalc/01/12080200.xhp</filename>
</topic>
</meta>
<body>
-<section id="show_details">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3153561"><bookmark_value>tables; showing details</bookmark_value>
+<bookmark branch="index" id="bm_id3153561"><bookmark_value>tables; showing
details</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ShowDetail" id="bm_id3178188"
localize="false"/>
+<bookmark branch="hid/.uno:ShowDetail" id="bm_id3178188" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-ShowDetail"
id="bm_id511704374516580" localize="false"/>
+<section id="show_details">
<h1 id="hd_id3153561"><link href="text/scalc/01/12080200.xhp">Show
Details</link></h1>
-<paragraph role="paragraph" id="par_id3153822" xml-lang="en-US"><ahelp
hid=".uno:ShowDetail">Shows the details of the grouped row or column that
contains the cursor. To show the details of all of the grouped rows or columns,
select the outlined table, and then choose this command.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153822"><ahelp
hid=".uno:ShowDetail">Shows the details of the grouped row or column that
contains the cursor. To show the details of all of the grouped rows or columns,
select the outlined table, and then choose this command.</ahelp></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US">To hide a
selected group, choose <emph>Data - Group and Outline – </emph><link
href="text/scalc/01/12080100.xhp"><emph>Hide Details</emph></link>.</paragraph>
+<paragraph role="paragraph" id="par_id3155922">To hide a selected group,
choose <emph>Data - Group and Outline – </emph><link
href="text/scalc/01/12080100.xhp"><emph>Hide Details</emph></link>.</paragraph>
<section id="howtoget">
-<embed href="text/scalc/00/00000412.xhp#dngde"/>
+<embed href="text/scalc/00/00000412.xhp#show_details"/>
</section>
<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id6036561" xml-lang="en-US"><link
href="text/scalc/01/12080700.xhp">Show Details command in pivot
tables</link></paragraph>
+<paragraph role="paragraph" id="par_id6036561"><link
href="text/scalc/01/12080700.xhp">Show Details command in pivot
tables</link></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080300.xhp
b/source/text/scalc/01/12080300.xhp
index 1e0e799e28..ae2569a786 100644
--- a/source/text/scalc/01/12080300.xhp
+++ b/source/text/scalc/01/12080300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0112080300xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Group</title>
+<title id="tit">Group</title>
<filename>/text/scalc/01/12080300.xhp</filename>
</topic>
<history>
@@ -31,24 +28,24 @@
</meta>
<body>
-
- <section id="group">
- <bookmark branch="hid/modules/scalc/ui/groupdialog/GroupDialog"
xml-lang="en-US" id="bm_id3156329" localize="false"/>
- <bookmark branch="hid/modules/scalc/ui/groupdialog/@@nowidget@@"
xml-lang="en-US" id="bm_id3156329" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:Group" id="bm_id9177845"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Group"
id="bm_id261704369628020" localize="false"/>
+<bookmark branch="hid/.uno:Group" id="bm_id9177845" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/groupdialog/GroupDialog"
id="bm_id3156329" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/groupdialog/@@nowidget@@"
id="bm_id3156329" localize="false"/>
+<section id="group">
<h1 id="hd_id3153088"><link href="text/scalc/01/12080300.xhp">Group</link></h1>
</section>
- <paragraph role="paragraph" id="par_id3153821" xml-lang="en-US"><variable
id="gruppierung"><ahelp hid=".">Defines the selected cell range as a group of
rows or columns.</ahelp></variable></paragraph>
- <section id="howtoget">
+ <paragraph role="paragraph" id="par_id3153821"><variable
id="gruppierung"><ahelp hid=".">Defines the selected cell range as a group of
rows or columns.</ahelp></variable></paragraph>
+<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#data_outline_group"/>
</section>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3145069">When you
group a cell range, and outline icon appears in the margins next to the group.
To hide or show the group, click the icon. To ungroup the selection, choose
<emph>Data – Group and Outline -</emph> <link
href="text/scalc/01/12080400.xhp"><emph>Ungroup</emph></link>.</paragraph>
+ <paragraph role="paragraph" id="par_id3145069">When you group a cell range,
and outline icon appears in the margins next to the group. To hide or show the
group, click the icon. To ungroup the selection, choose <emph>Data – Group and
Outline -</emph> <link
href="text/scalc/01/12080400.xhp"><emph>Ungroup</emph></link>.</paragraph>
<h2 id="hd_id3125863">Include</h2>
- <bookmark branch="hid/modules/scalc/ui/groupdialog/rows" xml-lang="en-US"
id="bm_id3150770" localize="false"/><h3 id="hd_id3150448">Rows</h3>
- <paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/groupdialog/rows">Groups the selected
rows.</ahelp></paragraph>
- <bookmark branch="hid/modules/scalc/ui/groupdialog/cols" xml-lang="en-US"
id="bm_id3153771" localize="false"/><h3 id="hd_id3145786">Columns</h3>
- <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/groupdialog/cols">Groups the selected
columns.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/groupdialog/rows" id="bm_id3150770"
localize="false"/><h3 id="hd_id3150448">Rows</h3>
+ <paragraph role="paragraph" id="par_id3153194"><ahelp
hid="modules/scalc/ui/groupdialog/rows">Groups the selected
rows.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/groupdialog/cols" id="bm_id3153771"
localize="false"/><h3 id="hd_id3145786">Columns</h3>
+ <paragraph role="paragraph" id="par_id3146984"><ahelp
hid="modules/scalc/ui/groupdialog/cols">Groups the selected
columns.</ahelp></paragraph>
<note id="par_id171608652491036">Grouping and ungrouping is not tracked.
Group is greyed out when track changes is on.</note>
-
+
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080400.xhp
b/source/text/scalc/01/12080400.xhp
index 0bcd6bbb2a..d48adeaee4 100644
--- a/source/text/scalc/01/12080400.xhp
+++ b/source/text/scalc/01/12080400.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0112080400xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Ungroup</title>
+<title id="tit">Ungroup</title>
<filename>/text/scalc/01/12080400.xhp</filename>
</topic>
<history>
@@ -30,20 +27,20 @@
</history>
</meta>
<body>
-
-
+
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Ungroup"
id="bm_id561704371105676" localize="false"/>
+<bookmark branch="hid/.uno:Ungroup" id="bm_id3153561" localize="false"/>
<section id="ungroup">
-<bookmark branch="hid/.uno:Ungroup" xml-lang="en-US" id="bm_id3153561"
localize="false"/>
<h1 id="hd_id3148492"><link
href="text/scalc/01/12080400.xhp">Ungroup</link></h1>
</section>
- <paragraph role="paragraph" id="par_id3151384" xml-lang="en-US"><variable
id="gruppierungauf"><ahelp hid=".uno:Ungroup" visibility="visible">Ungroups the
selection. In a nested group, the last rows or columns that were added are
removed from the group.</ahelp></variable></paragraph>
+ <paragraph role="paragraph" id="par_id3151384"><variable
id="gruppierungauf"><ahelp hid=".uno:Ungroup" visibility="visible">Ungroups the
selection. In a nested group, the last rows or columns that were added are
removed from the group.</ahelp></variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#data_outline_ungroup"/>
</section>
<h2 id="hd_id3151210">Deactivate for</h2>
<h3 id="hd_id3156280">Rows</h3>
- <paragraph role="paragraph" id="par_id3125864" xml-lang="en-US">Removes
selected rows from a group.</paragraph>
+ <paragraph role="paragraph" id="par_id3125864">Removes selected rows from a
group.</paragraph>
<h3 id="hd_id3147230">Columns</h3>
- <paragraph role="paragraph" id="par_id3154685" xml-lang="en-US">Removes
selected columns from a group.</paragraph>
+ <paragraph role="paragraph" id="par_id3154685">Removes selected columns from
a group.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080500.xhp
b/source/text/scalc/01/12080500.xhp
index 2c517363ed..41f15f81ec 100644
--- a/source/text/scalc/01/12080500.xhp
+++ b/source/text/scalc/01/12080500.xhp
@@ -19,75 +19,76 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112080500xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">AutoOutline</title>
+<title id="tit">AutoOutline</title>
<filename>/text/scalc/01/12080500.xhp</filename>
</topic>
</meta>
<body>
+<bookmark branch="hid/.uno:AutoOutline" id="bm_id1815805" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-AutoOutline"
id="bm_id131704371750765" localize="false"/>
<section id="auto_outline">
-<bookmark xml-lang="en-US" branch="hid/.uno:AutoOutline" id="bm_id1815805"
localize="false"/>
<h1 id="hd_id3150275"><link
href="text/scalc/01/12080500.xhp">AutoOutline</link></h1>
-<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US"><ahelp
hid=".uno:AutoOutline">If the selected cell range contains formulas or
references, $[officename] automatically outlines the
selection.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145069"><ahelp
hid=".uno:AutoOutline">If the selected cell range contains formulas or
references, $[officename] automatically outlines the
selection.</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US"
localize="false"><embedvar
href="text/scalc/00/00000412.xhp#dnglagl"/></paragraph>
+<embed href="text/scalc/00/00000412.xhp#auto_outline"/>
</section>
-<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US">For example,
consider the following table:</paragraph>
+<paragraph role="paragraph" id="par_id3148798">For example, consider the
following table:</paragraph>
<table id="tbl_id3125865">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3154123"
xml-lang="en-US">January</paragraph>
+<paragraph role="tablehead" id="par_id3154123">January</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3154011"
xml-lang="en-US">February</paragraph>
+<paragraph role="tablehead" id="par_id3154011">February</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3152460"
xml-lang="en-US">March</paragraph>
+<paragraph role="tablehead" id="par_id3152460">March</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3146119" xml-lang="en-US">1st
Quarter</paragraph>
+<paragraph role="tablehead" id="par_id3146119">1st Quarter</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3155854"
xml-lang="en-US">April</paragraph>
+<paragraph role="tablehead" id="par_id3155854">April</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3148575" xml-lang="en-US">May</paragraph>
+<paragraph role="tablehead" id="par_id3148575">May</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3145271"
xml-lang="en-US">June</paragraph>
+<paragraph role="tablehead" id="par_id3145271">June</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3145648" xml-lang="en-US">2nd
Quarter</paragraph>
+<paragraph role="tablehead" id="par_id3145648">2nd Quarter</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US"
localize="false">100</paragraph>
+<paragraph role="paragraph" id="par_id3153876" localize="false">100</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145251" xml-lang="en-US"
localize="false">120</paragraph>
+<paragraph role="paragraph" id="par_id3145251" localize="false">120</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3149400" xml-lang="en-US"
localize="false">130</paragraph>
+<paragraph role="paragraph" id="par_id3149400" localize="false">130</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150328" xml-lang="en-US"
localize="false">350</paragraph>
+<paragraph role="paragraph" id="par_id3150328" localize="false">350</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155443" xml-lang="en-US"
localize="false">100</paragraph>
+<paragraph role="paragraph" id="par_id3155443" localize="false">100</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153713" xml-lang="en-US"
localize="false">100</paragraph>
+<paragraph role="paragraph" id="par_id3153713" localize="false">100</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US"
localize="false">200</paragraph>
+<paragraph role="paragraph" id="par_id3156385" localize="false">200</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145230" xml-lang="en-US"
localize="false">400</paragraph>
+<paragraph role="paragraph" id="par_id3145230" localize="false">400</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3147363" xml-lang="en-US">The cells for
the 1st and 2nd quarters each contain a sum formula for the three cells to
their left. If you apply the <emph>AutoOutline</emph> command, the table is
grouped into two quarters.</paragraph>
-<paragraph role="paragraph" id="par_id3146918" xml-lang="en-US">To remove the
outline, select the table, and then choose <link
href="text/scalc/01/12080600.xhp">Data - Group and Outline -
Remove</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3147363">The cells for the 1st and 2nd
quarters each contain a sum formula for the three cells to their left. If you
apply the <emph>AutoOutline</emph> command, the table is grouped into two
quarters.</paragraph>
+<paragraph role="paragraph" id="par_id3146918">To remove the outline, select
the table, and then choose <link href="text/scalc/01/12080600.xhp">Data - Group
and Outline - Remove</link>.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080600.xhp
b/source/text/scalc/01/12080600.xhp
index aa22adcdc5..29b1f10832 100644
--- a/source/text/scalc/01/12080600.xhp
+++ b/source/text/scalc/01/12080600.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* 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">
<meta>
<topic id="textscalc0112080600xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Remove</title>
+<title id="tit">Remove</title>
<filename>/text/scalc/01/12080600.xhp</filename>
</topic>
<history>
@@ -30,15 +27,15 @@
</history>
</meta>
<body>
-
-
+
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-ClearOutline"
id="bm_id281704372855011" localize="false"/>
+<bookmark branch="hid/.uno:ClearOutline" id="bm_id3150400" localize="false"/>
<section id="remove">
-<bookmark branch="hid/.uno:ClearOutline" xml-lang="en-US" id="bm_id3150400"
localize="false"/>
<h1 id="hd_id3148947"><link
href="text/scalc/01/12080600.xhp">Remove</link></h1>
- <paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp
hid=".uno:ClearOutline" visibility="visible">Removes the outline from the
selected cell range.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id3149656"><ahelp
hid=".uno:ClearOutline" visibility="visible">Removes the outline from the
selected cell range.</ahelp></paragraph>
</section>
<section id="howtoget">
- <embed href="text/scalc/00/00000412.xhp#dnglef"/>
+ <embed href="text/scalc/00/00000412.xhp#remove_outline"/>
</section>
</body>
</helpdocument>
