summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2025-01-06 18:36:24 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2025-01-06 22:40:11 +0100
commit2fcd5b8983cf33e93df135530776ce3a3bb3f0ae (patch)
tree287d01345c103e1402d7ed889f9f362c51f28b12
parent7b4b8a46283741f14935a5bf69a224ac04f1a1f0 (diff)
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>
-rw-r--r--source/text/scalc/00/00000412.xhp23
-rw-r--r--source/text/scalc/01/12090400.xhp35
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>