From 2fcd5b8983cf33e93df135530776ce3a3bb3f0ae Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@libreoffice.org>
Date: Mon, 6 Jan 2025 18:36:24 -0300
Subject: tdf#160178 Add bookmarks to Pivot Table Gouping

Also fix the "How to get" section.

Change-Id: I22d5d707397d37ceb7ad45a8c42b128146eb742e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/179846
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
---
 source/text/scalc/00/00000412.xhp | 23 ++++++++++++++++++++++-
 source/text/scalc/01/12090400.xhp | 35 ++++++++++++++++++++---------------
 2 files changed, 42 insertions(+), 16 deletions(-)

diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp
index 4f04fda696..2a4462659a 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -568,7 +568,28 @@
             </tablerow>
         </table>
     </section>
-    <paragraph role="paragraph" id="par_idN10B8F"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph>
+
+    <section id="grouping">
+        <paragraph role="paragraph" id="par_id301736198469192">With cursor placed in a pivot table:</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_idN10B8F"><menuitem>Choose Data - Group and Outline - Group</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id431736198551350">Choose <menuitem>Data - Group</menuitem></paragraph>
+        <paragraph role="paragraph" id="par_id961736198706930">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"/>
+        <table id="tab_id761736198726165">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id1001736198726165" role="paragraph"><image src="cmd/lc_group.svg" id="img_id451736198726165" width="1cm"  height="1cm"><alt id="alt_id831736198726165">Icon Group</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id921736198726165" role="paragraph">Group</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+        <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+        <paragraph role="paragraph" id="par_id521736198766553" localize="false"><keycode>F12</keycode></paragraph>
+    </section>
 
     <section id="recalculate_hard">
         <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/12090400.xhp b/source/text/scalc/01/12090400.xhp
index b4006ec09f..45ec18b545 100644
--- a/source/text/scalc/01/12090400.xhp
+++ b/source/text/scalc/01/12090400.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,40 +16,47 @@
  *   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="textscalc0112090400xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Grouping</title>
+<title id="tit">Grouping</title>
 <filename>/text/scalc/01/12090400.xhp</filename>
 </topic>
 </meta>
 <body>
+
+<bookmark branch="hid/modules/scalc/ui/groupbynumber/PivotTableGroupByNumber" id="bm_id721736196686493" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/groupbynumber/@@nowidget@@" id="bm_id721836196686493" localize="false"/>
+<bookmark branch="index" id="bm_id321736196693683">
+<bookmark_value>pivot table;group by numbers</bookmark_value>
+<bookmark_value>pivot table;group by dates</bookmark_value>
+</bookmark>
 <h1 id="par_idN1054D">Grouping</h1>
-<paragraph role="paragraph" id="par_idN10551" xml-lang="en-US">Grouping pivot tables displays the <emph>Grouping</emph> dialog for either values or dates.</paragraph>
+<paragraph role="paragraph" id="par_idN10551">Grouping pivot tables displays the <emph>Grouping</emph> dialog for either values or dates.</paragraph>
 <section id="howtoget">
   <embed href="text/scalc/00/00000412.xhp#grouping"/>
 </section>
+
 <h2 id="par_idN10568">Start</h2>
-<paragraph role="paragraph" id="par_idN1056C" xml-lang="en-US">Specifies the start of the grouping.</paragraph>
+<paragraph role="paragraph" id="par_idN1056C">Specifies the start of the grouping.</paragraph>
 <h3 id="par_idN1056F">Automatically</h3>
-<paragraph role="paragraph" id="par_idN10573" xml-lang="en-US">Specifies whether to start grouping at the smallest value.</paragraph>
+<paragraph role="paragraph" id="par_idN10573">Specifies whether to start grouping at the smallest value.</paragraph>
 <h3 id="par_idN10576">Manually at</h3>
-<paragraph role="paragraph" id="par_idN1057A" xml-lang="en-US">Specifies whether to enter the start value for grouping yourself.</paragraph>
+<paragraph role="paragraph" id="par_idN1057A">Specifies whether to enter the start value for grouping yourself.</paragraph>
 <h2 id="par_idN1057D">End</h2>
-<paragraph role="paragraph" id="par_idN10581" xml-lang="en-US">Specifies the end of the grouping.</paragraph>
+<paragraph role="paragraph" id="par_idN10581">Specifies the end of the grouping.</paragraph>
 <h3 id="par_idN10584">Automatically</h3>
-<paragraph role="paragraph" id="par_idN10588" xml-lang="en-US">Specifies whether to end grouping at the largest value.</paragraph>
+<paragraph role="paragraph" id="par_idN10588">Specifies whether to end grouping at the largest value.</paragraph>
 <h3 id="par_idN1058B">Manually at</h3>
-<paragraph role="paragraph" id="par_idN1058F" xml-lang="en-US">Specifies whether to enter the end value for grouping yourself.</paragraph>
+<paragraph role="paragraph" id="par_idN1058F">Specifies whether to enter the end value for grouping yourself.</paragraph>
 <h2 id="par_idN10592">Group by</h2>
-<paragraph role="paragraph" id="par_idN10596" xml-lang="en-US">Specifies the value range by which every group's limits are calculated.</paragraph>
+<paragraph role="paragraph" id="par_idN10596">Specifies the value range by which every group's limits are calculated.</paragraph>
 <h3 id="par_idN10599">Number of days</h3>
-<paragraph role="paragraph" id="par_idN1059D" xml-lang="en-US">In the case of grouping date values, specifies the number of days to group by.</paragraph>
+<paragraph role="paragraph" id="par_idN1059D">In the case of grouping date values, specifies the number of days to group by.</paragraph>
 <h3 id="par_idN105A0">Intervals</h3>
-<paragraph role="paragraph" id="par_idN105A4" xml-lang="en-US">In the case of grouping date values, specifies the intervals to group by.</paragraph>
+<paragraph role="paragraph" id="par_idN105A4">In the case of grouping date values, specifies the intervals to group by.</paragraph>
 <section id="relatedtopics">
-<paragraph role="paragraph" id="par_idN105B2" xml-lang="en-US" localize="false">
+<paragraph role="paragraph" id="par_idN105B2" localize="false">
 	<embedvar href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
 </paragraph>
 </section>
-- 
cgit