diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-01-06 18:36:24 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-01-06 22:40:11 +0100 |
commit | 2fcd5b8983cf33e93df135530776ce3a3bb3f0ae (patch) | |
tree | 287d01345c103e1402d7ed889f9f362c51f28b12 | |
parent | 7b4b8a46283741f14935a5bf69a224ac04f1a1f0 (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.xhp | 23 | ||||
-rw-r--r-- | 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> |