diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-11-01 09:46:09 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-11-01 14:12:09 +0100 |
| commit | d050546d948767191446369a451e4e0267fa4272 (patch) | |
| tree | 92739155b08cf14d808330dc72644658119100b2 /source/text | |
| parent | 1d8bcb189aeeff79f51d23c88c13ff9970a2700a (diff) | |
tdf#155876 UI cmds Calc-Insert menu (12)
+ refactoring of Insert Pivot Table
Change-Id: Idbdebf2b77a5fdd77fd6ca617bf1a488362a5fbe
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158759
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/scalc/00/00000412.xhp | 151 | ||||
| -rw-r--r-- | source/text/scalc/01/12090000.xhp | 6 | ||||
| -rw-r--r-- | source/text/scalc/01/12090100.xhp | 30 |
3 files changed, 104 insertions, 83 deletions
diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp index 50de754f22..720fe4734b 100644 --- a/source/text/scalc/00/00000412.xhp +++ b/source/text/scalc/00/00000412.xhp @@ -20,32 +20,33 @@ <meta> <topic id="textscalc0000000412xml" indexer="exclude" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Data Menu</title> + <title id="tit">Data Menu</title> <filename>/text/scalc/00/00000412.xhp</filename> </topic> </meta> <body> <h1 id="hd_id3145136">Data Menu</h1> - <paragraph role="paragraph" id="par_id8366954" xml-lang="en-US"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3147399" xml-lang="en-US"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3150443" xml-lang="en-US"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph> + + <paragraph role="paragraph" id="par_id8366954"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3147399"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3145345"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3150443"><variable id="dnsrt">Choose <emph>Data - Sort...</emph>.</variable></paragraph> <paragraph role="paragraph" id="par_id641584647437810"><variable id="datasortascending">Choose <menuitem>Data - Sort Ascending</menuitem></variable></paragraph> <paragraph role="paragraph" id="par_id711584647447316"><variable id="datasortdescending">Choose <menuitem>Data - Sort Descending</menuitem></variable></paragraph> <section id="sort_criteria"> - <paragraph role="paragraph" id="par_id3148491" xml-lang="en-US">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph> - <paragraph role="paragraph" id="par_id3154516" xml-lang="en-US"><variable id="onthestandardbar">On <emph>Standard</emph> bar, click</variable></paragraph> + <paragraph role="paragraph" id="par_id3148491">Choose <emph>Data - Sort - Sort Criteria</emph> tab.</paragraph> + <paragraph role="paragraph" id="par_id3154516"><variable id="onthestandardbar">On <emph>Standard</emph> bar, click</variable></paragraph> <section id="sysort_criteria"> <section id="sortascending"> <table id="tbl_id3156023"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US"> - <image id="img_id3150543" src="cmd/sc_sortup.png" width="1cm" height="1cm"><alt id="alt_id3150543" xml-lang="en-US">Icon Sort Ascending</alt></image> + <paragraph role="paragraph" id="par_id3148663"> + <image id="img_id3150543" src="cmd/sc_sortup.png" width="1cm" height="1cm"><alt id="alt_id3150543">Icon Sort Ascending</alt></image> </paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">Sort Ascending</paragraph> + <paragraph role="paragraph" id="par_id3150767">Sort Ascending</paragraph> </tablecell> </tablerow> </table> @@ -54,119 +55,139 @@ <table id="tbl_id3256023"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"> - <image id="img_id3125863" src="cmd/sc_sortdown.png" width="1cm" height="1cm"><alt id="alt_id3125863" xml-lang="en-US">Icon Sort Descending</alt></image> + <paragraph role="paragraph" id="par_id3153969"> + <image id="img_id3125863" src="cmd/sc_sortdown.png" width="1cm" height="1cm"><alt id="alt_id3125863">Icon Sort Descending</alt></image> </paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3145364" xml-lang="en-US">Sort Descending</paragraph> + <paragraph role="paragraph" id="par_id3145364">Sort Descending</paragraph> </tablecell> </tablerow> </table> </section> </section> </section> - <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph> - <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3146984"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3155308"><variable id="dnftr">Choose <emph>Data - More Filters</emph>.</variable></paragraph> <section id="autofilter"> - <paragraph role="paragraph" id="par_id3148646" xml-lang="en-US">Choose <emph>Data - AutoFilter</emph>.</paragraph> - <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph> + <paragraph role="paragraph" id="par_id3148646">Choose <emph>Data - AutoFilter</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3151113">On <emph>Tools</emph> bar or <emph>Table Data</emph> bar, click</paragraph> <section id="syautofilter"> <table id="tbl_id3155418"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"> - <image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413" xml-lang="en-US">Icon</alt></image></paragraph> + <paragraph role="paragraph" id="par_id3145799"> + <image id="img_id3149413" src="cmd/sc_datafilterautofilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3149413">Icon</alt></image></paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3149401" xml-lang="en-US">AutoFilter</paragraph> + <paragraph role="paragraph" id="par_id3149401">AutoFilter</paragraph> </tablecell> </tablerow> </table> </section> </section> - <paragraph role="paragraph" id="par_id3156278" xml-lang="en-US"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph> + <paragraph role="paragraph" id="par_id3156278"><variable id="dnfspz">Choose <emph>Data - More Filters - Advanced Filter...</emph> .</variable></paragraph> <section id="filter_options"> - <paragraph role="paragraph" id="par_id3153764" xml-lang="en-US">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph> - <paragraph role="paragraph" id="par_id3155444" xml-lang="en-US">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph> + <paragraph role="paragraph" id="par_id3153764">Choose <emph>Data - More Filters - Standard Filter... - Options</emph> label.</paragraph> + <paragraph role="paragraph" id="par_id3155444">Choose <emph>Data - More Filters - Advanced Filter... - Options</emph> label.</paragraph> </section> <section id="reset_filter"> - <paragraph role="paragraph" id="par_id3156382" xml-lang="en-US">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph> - <paragraph role="paragraph" id="par_id3155961" xml-lang="en-US">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3156382">Choose <emph>Data - More Filters - Reset Filter</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3155961">On <emph>Table Data</emph> bar, click <emph>Reset Filter/Sort</emph>.</paragraph> <table id="tbl_id3146919"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"> - <image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792" xml-lang="en-US">Icon</alt></image></paragraph> + <paragraph role="paragraph" id="par_id3148485"> + <image id="img_id3145792" src="cmd/sc_removefilter.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145792">Icon</alt></image></paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3149207" xml-lang="en-US">Reset Filter/Sort</paragraph> + <paragraph role="paragraph" id="par_id3149207">Reset Filter/Sort</paragraph> </tablecell> </tablerow> </table> </section> - <paragraph role="paragraph" id="par_id3152778" xml-lang="en-US"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3166424" xml-lang="en-US"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3154574" xml-lang="en-US"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph> - <paragraph role="paragraph" id="par_id3151277" xml-lang="en-US"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph> - <paragraph role="paragraph" id="par_id3145133" xml-lang="en-US"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph> - <paragraph role="paragraph" id="par_id3150367" xml-lang="en-US"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph> - <paragraph role="paragraph" id="par_id3154486" xml-lang="en-US"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph> - <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3155809" xml-lang="en-US"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3148701" xml-lang="en-US"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3159223" xml-lang="en-US"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3152778"><variable id="dnaftas">Choose <emph>Data - More Filter - Hide AutoFilter</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3166424"><variable id="dntegs">Choose <emph>Data - Subtotals</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154574"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs.</variable></paragraph> + <paragraph role="paragraph" id="par_id3151277"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3145133"><variable id="datengueltig">Choose <emph>Data - Validity</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3152992"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3150367"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3154486"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab.</variable></paragraph> + <paragraph role="paragraph" id="par_id3146978"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3155809"><variable id="dnksd">Choose <emph>Data - Consolidate</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3148701"><variable id="dngld">Choose <emph>Data - Group and Outline</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3153815"><variable id="dngda">Choose <emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id3159223"><variable id="dngde">Choose <emph>Data - Group and Outline - Show Details</emph>.</variable></paragraph> <section id="data_outline_group"> - <paragraph role="paragraph" id="par_id3146870" xml-lang="en-US">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph> - <paragraph role="paragraph" id="par_id3144507" xml-lang="en-US">F12</paragraph> - <paragraph role="paragraph" id="par_id3144772" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph> + <paragraph role="paragraph" id="par_id3146870">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3144507">F12</paragraph> + <paragraph role="paragraph" id="par_id3144772">On <emph>Tools</emph> bar, click</paragraph> <section id="sygroup"> <table id="tbl_id3154532"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3149438" xml-lang="en-US"> - <image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287" xml-lang="en-US">Icon</alt></image></paragraph> + <paragraph role="paragraph" id="par_id3149438"> + <image id="img_id3153287" src="cmd/sc_group.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153287">Icon</alt></image></paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US">Group</paragraph> + <paragraph role="paragraph" id="par_id3150214">Group</paragraph> </tablecell> </tablerow> </table> </section> </section> <section id="data_outline_ungroup"> - <paragraph role="paragraph" id="par_id3146781" xml-lang="en-US">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph> - <paragraph role="paragraph" id="par_id3150892" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> - <paragraph role="paragraph" id="par_id3155097" xml-lang="en-US">On <emph>Tools</emph> bar, click</paragraph> + <paragraph role="paragraph" id="par_id3146781">Choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph> + <paragraph role="paragraph" id="par_id3150892"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F12</paragraph> + <paragraph role="paragraph" id="par_id3155097">On <emph>Tools</emph> bar, click</paragraph> <section id="syungroup"> <table id="tbl_id3143223"> <tablerow> <tablecell> - <paragraph role="paragraph" id="par_id3150048" xml-lang="en-US"> - <image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914" xml-lang="en-US">Icon</alt></image></paragraph> + <paragraph role="paragraph" id="par_id3150048"> + <image id="img_id3155914" src="cmd/sc_ungroup.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155914">Icon</alt></image></paragraph> </tablecell> <tablecell> - <paragraph role="paragraph" id="par_id3153555" xml-lang="en-US">Ungroup</paragraph> + <paragraph role="paragraph" id="par_id3153555">Ungroup</paragraph> </tablecell> </tablerow> </table> </section> </section> - <paragraph role="paragraph" id="par_id3153008" xml-lang="en-US"><variable id="dnglagl">Choose <emph>Data - Group and Outline - AutoOutline</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3154709" xml-lang="en-US"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove Outline</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id1774346" xml-lang="en-US"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables).</variable></paragraph> - <paragraph role="paragraph" id="par_id3155759" xml-lang="en-US"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3154625" xml-lang="en-US"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3147558" xml-lang="en-US"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph> + <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="insertpivot"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3154625"><variable id="dndpa">Choose <emph>Insert - Pivot Table</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_id641698842008451">Choose <menuitem>Data - Pivot Table - Insert or Edit</menuitem>.</paragraph> + <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> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id401698842094888"> + <tablerow> + <tablecell> + <paragraph id="par_id401698842094889" role="paragraph"><image src="cmd/lc_datadatapilotrun.svg" id="img_id691698842094890" width="1cm" height="1cm"><alt id="alt_id81698842094891">Icon Pivot Table</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id301698842094893" role="paragraph">Pivot Table</paragraph> + </tablecell> + </tablerow> + </table> + </section> + + <paragraph role="paragraph" id="par_id3147558"><variable id="dndq">Choose <emph>Insert - Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option <emph>Data source registered in $[officename]</emph>.</variable></paragraph> <section id="insert_pivot_table"> - <paragraph role="paragraph" id="par_id3153297" xml-lang="en-US">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" xml-lang="en-US">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> + <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" xml-lang="en-US"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3151344" xml-lang="en-US"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3150397" xml-lang="en-US"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_idN10B8F" xml-lang="en-US"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph> + <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> + <paragraph role="paragraph" id="par_id3150397"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph> + <paragraph role="paragraph" id="par_idN10B8F"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12090000.xhp b/source/text/scalc/01/12090000.xhp index 7d0f7c9166..0e01b8e7dc 100644 --- a/source/text/scalc/01/12090000.xhp +++ b/source/text/scalc/01/12090000.xhp @@ -19,14 +19,14 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0112090000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Pivot Table</title> +<title id="tit">Pivot Table</title> <filename>/text/scalc/01/12090000.xhp</filename> </topic> </meta> <body> <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" xml-lang="en-US">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">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"/> @@ -36,6 +36,6 @@ <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" xml-lang="en-US"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph> +<paragraph role="paragraph" id="par_idN105FB"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12090100.xhp b/source/text/scalc/01/12090100.xhp index 4a3a609591..48f4cab4a6 100644 --- a/source/text/scalc/01/12090100.xhp +++ b/source/text/scalc/01/12090100.xhp @@ -19,35 +19,35 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0112090100xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Select Source</title> +<title id="tit">Select Source</title> <filename>/text/scalc/01/12090100.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="hid/.uno:DataDataPilotRun" id="bm_id3153822" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/SelectSourceDialog" id="bm_id3153823" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/@@nowidget@@" id="bm_id3153823" localize="false"/> +<bookmark branch="hid/.uno:DataDataPilotRun" id="bm_id3153822" 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 - Select Source</link></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" xml-lang="en-US"><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 your table.</ahelp></paragraph> </section> </section> <section id="howtoget"> - <embed href="text/scalc/00/00000412.xhp#dndpa"/> + <embed href="text/scalc/00/00000412.xhp#insertpivot"/> </section> <h2 id="hd_id3154760">Selection</h2> -<paragraph role="paragraph" id="par_id3150543" xml-lang="en-US">Select a data source for the pivot table.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/selection" id="bm_id3154908" localize="false"/> +<paragraph role="paragraph" id="par_id3150543">Select a data source for the pivot table.</paragraph> +<bookmark branch="hid/modules/scalc/ui/selectsource/selection" id="bm_id3154908" localize="false"/> <h3 id="hd_id3148799">Current Selection</h3> -<paragraph role="paragraph" id="par_id3125865" xml-lang="en-US"><ahelp hid=".">Uses the selected cells as the data source for the pivot table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3125865"><ahelp hid=".">Uses the selected cells as the data source for the pivot table.</ahelp></paragraph> <note id="par_id3150011">The data columns in the pivot table use the same number format as the first data row in the current selection.</note> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/database" id="bm_id3149664" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/selectsource/database" id="bm_id3149664" localize="false"/> <h3 id="hd_id3147348">Data source registered in $[officename]</h3> -<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US"><ahelp hid=".">Uses a table or query in a database that is registered in $[officename] as the data source for the pivot table.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectsource/external" id="bm_id3153876" localize="false"/> +<paragraph role="paragraph" id="par_id3145271"><ahelp hid=".">Uses a table or query in a database that is registered in $[officename] as the data source for the pivot table.</ahelp></paragraph> +<bookmark branch="hid/modules/scalc/ui/selectsource/external" id="bm_id3153876" localize="false"/> <h3 id="hd_id3146119">External source/interface</h3> -<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US"><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" xml-lang="en-US"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph> +<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> </body> </helpdocument> |