source/text/scalc/00/00000412.xhp | 51 +++++++++++++++++++++++++++++++++++--- source/text/scalc/01/12090000.xhp | 18 +++++++++++-- source/text/scalc/01/12090100.xhp | 14 +++++++++- source/text/scalc/01/12090200.xhp | 25 ++++++++++++------ source/text/scalc/01/12090300.xhp | 23 +++++++++++------ 5 files changed, 109 insertions(+), 22 deletions(-)
New commits: commit 58b85d5d8886f116064102e38d98e494643fb55d Author: Olivier Hallot <[email protected]> AuthorDate: Wed Dec 27 19:53:19 2023 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Dec 27 23:54:38 2023 +0100 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 <[email protected]> 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>
