tdf#155876 UI cmds Calc-Sheet menu (38)

+ Data menu for Calc, Pivot tables.
+ refactoring

Change-Id: Ie9a39198d84b180558b8d84681cf2f455b3e2e6f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161373
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

5 files changed, 109 insertions, 22 deletions

diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp
index 0fb0988003..488bafc7e9 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -289,7 +289,11 @@
     <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>
-    <paragraph role="paragraph" id="par_id3155759"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph>
+
+    <section id="pivotmenu">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3155759"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph>
+    </section>
 
     <section id="insertpivot">
         <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -298,6 +302,7 @@
         <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
         <paragraph role="paragraph" id="par_id741698842068169">Choose <menuitem>Insert - Pivot Table</menuitem>.</paragraph>
         <paragraph role="paragraph" id="par_id71698842082244">Choose <menuitem>Data - Pivot Table</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id591703713858518">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Insert or Edit Pivot Table</menuitem>.</paragraph>
         <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
         <table id="tab_id401698842094888">
             <tablerow>
@@ -316,8 +321,48 @@
         <paragraph role="paragraph" id="par_id3153297">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Current selection</emph>.</paragraph>
         <paragraph role="paragraph" id="par_id3145118">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph>
     </section>
-    <paragraph role="paragraph" id="par_id3153294"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
-    <paragraph role="paragraph" id="par_id3151344"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
+
+    <section id="refreshpivot">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3153294"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id971703714377500">Choose <menuitem>Data - Refresh Pivot Table</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id141703714382620">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Refresh</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_context"/>
+        <paragraph role="paragraph" id="par_id61703714423387">Choose <menuitem>Refresh</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+        <table id="tab_id971703714454286">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id681703714454287" role="paragraph"><image src="cmd/lc_recalcpivottable.svg" id="img_id461703714454288" width="1cm"  height="1cm"><alt id="alt_id871703714454289">Icon Refresh Pivot Table</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id921703714454291" role="paragraph">Refresh Pivot Table</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+    </section>
+
+    <section id="deletepivot">
+        <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+        <paragraph role="paragraph" id="par_id3151344"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+        <paragraph role="paragraph" id="par_id1001703715498579">Choose <menuitem>Data - Delete Pivot Table</menuitem>.</paragraph>
+        <paragraph role="paragraph" id="par_id651703715502131">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Delete</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_context"/>
+        <paragraph role="paragraph" id="par_id741703715505778">Choose <menuitem>Delete</menuitem>.</paragraph>
+        <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+        <table id="tab_id861703715519188">
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id1001703715519189" role="paragraph"><image src="cmd/lc_deletepivottable.svg" id="img_id931703715519190" width="1cm"  height="1cm"><alt id="alt_id241703715519191">Icon Delete Pivot Table</alt></image></paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id901703715519193" role="paragraph">Delete Pivot Table</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
+    </section>
 
     <section id="refreshrange">
         <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/12090000.xhp b/source/text/scalc/01/12090000.xhp
index 0e01b8e7dc..f0ae23af14 100644
--- a/source/text/scalc/01/12090000.xhp
+++ b/source/text/scalc/01/12090000.xhp
@@ -24,18 +24,30 @@
 </topic>
 </meta>
 <body>
+<bookmark branch="hid/.uno:DataPilotMenu" id="bm_id171703711749436" localize="false"/>
 <section id="pivot_table">
 <h1 id="hd_id3150275"><link href="text/scalc/01/12090000.xhp">Pivot Table</link></h1>
-<paragraph role="paragraph" id="par_id3153562">A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.</paragraph>
+<paragraph role="paragraph" id="par_id3153562">Opens a submenu to create or edit a pivot table. A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.</paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000412.xhp#dndtpt"/>
+  <embed href="text/scalc/00/00000412.xhp#pivotmenu"/>
 </section>
 <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
-<h2 id="hd_id3155923"><link href="text/scalc/01/12090100.xhp">Create</link></h2>
+<h2 id="hd_id3155923"><link href="text/scalc/01/12090100.xhp">Insert or Edit</link></h2>
 <embed href="text/scalc/01/12090100.xhp#pivot_table"/>
 <embed href="text/scalc/01/12090200.xhp#refresh"/>
 <embed href="text/scalc/01/12090300.xhp#delete"/>
 <paragraph role="paragraph" id="par_idN105FB"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph>
+      <section id="relatedtopics">
+         <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+         <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
+         <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
+         <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
+         <embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/>
+         <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
+         <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
+         <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+         <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
+      </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/12090100.xhp b/source/text/scalc/01/12090100.xhp
index 48f4cab4a6..689c51da39 100644
--- a/source/text/scalc/01/12090100.xhp
+++ b/source/text/scalc/01/12090100.xhp
@@ -25,12 +25,13 @@
 </meta>
 <body>
 <bookmark branch="hid/.uno:DataDataPilotRun" id="bm_id3153822" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-InsertPivotTable" id="bm_id331703713702883" localize="false"/>
 <bookmark branch="hid/modules/scalc/ui/selectsource/SelectSourceDialog" id="bm_id3153823" localize="false"/>
 <bookmark branch="hid/modules/scalc/ui/selectsource/@@nowidget@@" id="bm_id3153823" localize="false"/>
 <section id="pivot_table_h1">
 <h1 id="hd_id3153663"><link href="text/scalc/01/12090100.xhp">Pivot Table</link></h1>
 <section id="pivot_table">
-<paragraph role="paragraph" id="par_id3145119"><ahelp hid=".uno:DataDataPilotRun">Opens a dialog where you can select the source for your pivot table, and then create your table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145119"><ahelp hid=".uno:DataDataPilotRun">Opens a dialog where you can select the source for your pivot table, and then create or edit your table.</ahelp></paragraph>
 </section>
 </section>
 <section id="howtoget">
@@ -49,5 +50,16 @@
 <h3 id="hd_id3146119">External source/interface</h3>
 <paragraph role="paragraph" id="par_id3145647"><ahelp hid=".">Opens the <emph>External Source</emph> dialog where you can select the OLAP data source for the pivot table.</ahelp></paragraph>
 <paragraph role="paragraph" id="par_idN10670"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph>
+      <section id="relatedtopics">
+         <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+         <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
+         <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
+         <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
+         <embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/>
+         <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
+         <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
+         <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+         <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
+      </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/12090200.xhp b/source/text/scalc/01/12090200.xhp
index 131c88832c..8e92c77461 100644
--- a/source/text/scalc/01/12090200.xhp
+++ b/source/text/scalc/01/12090200.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="textscalc0112090200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Refresh</title>
+<title id="tit">Refresh</title>
 <filename>/text/scalc/01/12090200.xhp</filename>
 </topic>
 <history>
@@ -30,14 +27,26 @@
 </history>
 </meta>
 <body>
+<bookmark branch="hid/.uno:RecalcPivotTable" id="bm_id3145069" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-RecalcPivotTable" id="bm_id631703715328718" localize="false"/>
 <section id="refresh">
-<bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id3145069" localize="false"/>
 <h1 id="hd_id3151385"><link href="text/scalc/01/12090200.xhp">Refresh</link></h1>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid=".uno:RecalcPivotTable">Updates the pivot table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149456"><ahelp hid=".uno:RecalcPivotTable">Updates the pivot table.</ahelp></paragraph>
 </section>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US">After you import an Excel spreadsheet that contains a pivot table, click in the table, and then choose <emph>Data - Pivot Table - Refresh</emph>.</paragraph>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000412.xhp#dndpak"/>
+  <embed href="text/scalc/00/00000412.xhp#refreshpivot"/>
 </section>
+<tip id="par_id3150400">After you import an Excel spreadsheet that contains a pivot table, click in the table, and then choose <emph>Data - Pivot Table - Refresh</emph>.</tip>
+      <section id="relatedtopics">
+         <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+         <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
+         <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
+         <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
+         <embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/>
+         <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
+         <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
+         <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+         <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
+      </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/12090300.xhp b/source/text/scalc/01/12090300.xhp
index b488b85aa4..d66e48905c 100644
--- a/source/text/scalc/01/12090300.xhp
+++ b/source/text/scalc/01/12090300.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,22 +16,33 @@
  *   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="textscalc0112090300xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Delete</title>
+<title id="tit">Delete</title>
 <filename>/text/scalc/01/12090300.xhp</filename>
 </topic>
 </meta>
 <body>
+<bookmark branch="hid/.uno:DeletePivotTable" id="bm_id3148491" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-DeletePivotTable" id="bm_id891703715746514" localize="false"/>
 <section id="delete">
-<bookmark branch="hid/.uno:DeletePivotTable" xml-lang="en-US" id="bm_id3148491" localize="false"/>
 <h1 id="hd_id3150276"><link href="text/scalc/01/12090300.xhp">Delete</link></h1>
-<paragraph role="paragraph" id="par_id3159400" xml-lang="en-US"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected pivot table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3159400"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected pivot table.</ahelp></paragraph>
 </section>
 <section id="howtoget">
-<embed href="text/scalc/00/00000412.xhp#dndploe"/>
+<embed href="text/scalc/00/00000412.xhp#deletepivot"/>
 </section>
+      <section id="relatedtopics">
+         <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+         <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
+         <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
+         <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
+         <embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/>
+         <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
+         <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
+         <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+         <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/>
+      </section>
 </body>
 </helpdocument>