source/text/scalc/00/00000412.xhp | 18 ++++
source/text/scalc/01/12090102.xhp | 153 +++++++++++++++++++-------------------
2 files changed, 97 insertions(+), 74 deletions(-)
New commits:
commit 5f88bf40a9be9b3bfbf21fbd0e2677c009ad76dd
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Jun 3 20:58:18 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Jun 4 13:32:06 2025 +0200
tdf#164296 Add information on compact pivot table layout.
Change-Id: I48f66daf5e928cde6282ff2110966b22afdd0093
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/186155
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index cd73ad2b04..efd099e242 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -506,8 +506,24 @@
<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">Choose <emph>Insert -
Pivot Table</emph>, in the <emph>Select Source</emph> dialog choose the option
<emph>Current selection</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3153297">Choose <menuitem>Insert
- Pivot Table</menuitem>, in the <menuitem>Select Source</menuitem> dialog
choose the option <menuitem>Current selection</menuitem> or <menuitem>Named
Range</menuitem> in the drop-down list.</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>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id261748987889947">Place the
cursor inside the pivot table and select <menuitem>Data - Pivot
Table</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id261748987475181">Place the
cursor inside the pivot table and select
<menuitem>Properties</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id231748987954567">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id261748987954570"
role="paragraph"><image src="cmd/lc_datadatapilotrun.svg"
id="img_id181748987954572" width="1cm" height="1cm"><alt
id="alt_id611748987954575">Icon Pivot Table</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171748987954580"
role="paragraph">Pivot Table</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
</section>
<section id="refreshpivot">
diff --git a/source/text/scalc/01/12090102.xhp
b/source/text/scalc/01/12090102.xhp
index ee0327dbf9..0d5c42f965 100644
--- a/source/text/scalc/01/12090102.xhp
+++ b/source/text/scalc/01/12090102.xhp
@@ -22,86 +22,93 @@
<meta>
<topic id="textscalc0112090102xml" indexer="include">
- <title xml-lang="en-US" id="tit">Pivot Table</title>
+ <title id="tit">Pivot Table</title>
<filename>/text/scalc/01/12090102.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2306894"><bookmark_value>pivot table function;show
details</bookmark_value>
-<bookmark_value>pivot table function;drill down</bookmark_value>
-</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataPilotExec" id="bm_id3154514"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/PivotTableLayout"
id="bm_id31545141" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/@@nowidget@@"
id="bm_id31545141" localize="false"/>
-<h1 id="hd_id3149165">Pivot Table</h1>
- <paragraph xml-lang="en-US" id="par_id3155922" role="paragraph"><ahelp
hid=".uno:DataPilotExec">Specify the layout of the table that is generated by
the pivot table.</ahelp></paragraph>
- <section id="howtoget">
+ <bookmark branch="index" id="bm_id2306894"><bookmark_value>pivot table
function;show details</bookmark_value>
+ <bookmark_value>pivot table function;drill down</bookmark_value>
+ </bookmark>
+ <bookmark branch="hid/.uno:DataPilotExec" id="bm_id3154514"
localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/PivotTableLayout"
id="bm_id31545141" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/@@nowidget@@"
id="bm_id31545141" localize="false"/>
+ <h1 id="hd_id3149165">Pivot Table</h1>
+ <paragraph id="par_id3155922" role="paragraph"><ahelp
hid=".uno:DataPilotExec">Specify the layout of the table that is generated by
the pivot table.</ahelp></paragraph>
+ <section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#insert_pivot_table"/>
- </section>
- <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
- <paragraph xml-lang="en-US" id="par_id3148798" role="paragraph">The
pivot table displays data fields as buttons which you can drag and drop to
define the pivot table.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-fields"
id="bm_id3335062" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-column"
id="bm_id9569689" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-row"
id="bm_id7529526" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-data"
id="bm_id2920621" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-page"
id="bm_id7411420" localize="false"/><comment>UFI: changed help id from 59001 to
dply_page</comment>
-<h2 id="hd_id3154908">Layout</h2>
- <paragraph xml-lang="en-US" id="par_id3150768" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/listbox-fields">To define the
layout of a pivot table, drag and drop data field buttons onto the
<emph>Filters, Row Fields, Column Fields</emph> and <emph>Data Fields</emph>
areas.</ahelp> You can also use drag and drop to rearrange the data fields on a
pivot table.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147229"
role="paragraph">$[officename] automatically adds a caption to buttons that are
dragged into the <emph>Data Fields </emph>area. The caption contains the name
of the data field as well as the formula that created the data.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145749" role="paragraph">To
change the function that is used by a data field, double-click a button in the
<emph>Data Fields</emph> area to open the <link
href="text/scalc/01/12090105.xhp">Data Field</link> dialog. You can also
double-click buttons in the <emph>Row Fields</emph> or <emph>Column
Fields</emph> areas.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/more" id="bm_id4284798"
localize="false"/>
-<h2 id="hd_id3154944">More</h2>
- <paragraph xml-lang="en-US" id="par_id3145647" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/more">Displays or hides additional
options for defining the pivot table.</ahelp></paragraph>
- <h2 id="hd_id3151073">Result</h2>
- <paragraph xml-lang="en-US" id="par_id3155417" role="paragraph">Specify
the settings for displaying the results of the pivot table.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-edit"
id="bm_id7418660" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-button"
id="bm_id7418760" localize="false"/>
-<h3 id="hd_id0509200913025625">Selection from</h3>
- <paragraph xml-lang="en-US" id="par_id0509200913025615"
role="paragraph"><ahelp hid=".">Select the area that contains the data for the
current pivot table.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-edit"
id="bm_id7419660" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-list"
id="bm_id2334665" localize="false"/>
-<h2 id="hd_id3155603">Results to</h2>
- <paragraph xml-lang="en-US" id="par_id3153838" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/destination-edit">Select the area
where you want to display the results of the pivot table.</ahelp></paragraph>
- <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
- <paragraph xml-lang="en-US" id="par_id3155961" role="warning">If the
selected area contains data, the pivot table overwrites the data. To prevent
the loss of existing data, let the pivot table automatically select the area to
display the results.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows"
id="bm_id7835016" localize="false"/>
-<h2 id="hd_id3147364">Ignore empty rows</h2>
- <paragraph xml-lang="en-US" id="par_id3154022" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows">Ignores
empty fields in the data source.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-identify-categories"
id="bm_id5103305" localize="false"/>
-<h2 id="hd_id3155114">Identify categories</h2>
- <paragraph xml-lang="en-US" id="par_id3145257" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-identify-categories">Automatically
assigns rows without labels to the category of the row
above.</ahelp><comment>i93137</comment></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-columns"
id="bm_id2163457" localize="false"/>
-<h2 id="hd_id3149207">Show totals column</h2>
- <paragraph xml-lang="en-US" id="par_id3166426" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-total-columns">Calculates
and displays the grand total of the column calculation.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-rows"
id="bm_id3748588" localize="false"/>
-<h2 id="hd_id3150364">Show totals row</h2>
- <paragraph xml-lang="en-US" id="par_id3152583" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-total-rows">Calculates and
displays the grand total of the row calculation.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-add-filter"
id="bm_id6004516" localize="false"/>
-<h2 id="par_idN10897">Add filter</h2>
- <paragraph xml-lang="en-US" id="par_idN1089B" role="paragraph"><ahelp
hid=".">Adds a Filter button to pivot tables that are based on spreadsheet
data.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataPilotFilter" id="bm_id6278267"
localize="false"/>
-<paragraph xml-lang="en-US" id="par_idN108B2" role="paragraph"><ahelp
hid=".">Opens the Filter dialog.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-drill-to-details"
id="bm_id7366252" localize="false"/>
-<h2 id="par_idN108C9">Enable drill to details</h2>
- <paragraph xml-lang="en-US" id="par_idN108CD" role="paragraph"><ahelp
hid=".">Select this check box and double-click an item label in the table to
show or hide details for the item. Clear this check box and double-click a cell
in the table to edit the contents of the cell.</ahelp></paragraph>
- <h2 id="par_idN108DC">To examine details inside a pivot table</h2>
- <paragraph xml-lang="en-US" id="par_idN108E0" role="paragraph">Do one of
the following:</paragraph>
- <list type="unordered">
+ </section>
+ <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+ <paragraph id="par_id3148798" role="paragraph">The pivot table displays
data fields as buttons which you can drag and drop to define the pivot
table.</paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-fields"
id="bm_id3335062" localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-column"
id="bm_id9569689" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-row"
id="bm_id7529526" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-data"
id="bm_id2920621" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-page"
id="bm_id7411420" localize="false"/><comment>UFI: changed help id from 59001 to
dply_page</comment>
+ <h2 id="hd_id3154908">Layout</h2>
+ <paragraph id="par_id3150768" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/listbox-fields">To define the
layout of a pivot table, drag and drop data field buttons onto the
<emph>Filters, Row Fields, Column Fields</emph> and <emph>Data Fields</emph>
areas.</ahelp> You can also use drag and drop to rearrange the data fields on a
pivot table.</paragraph>
+ <paragraph id="par_id3147229" role="paragraph">$[officename] automatically
adds a caption to buttons that are dragged into the <emph>Data
Fields</emph>area. The caption contains the name of the data field as well as
the formula that created the data.</paragraph>
+ <paragraph id="par_id3145749" role="paragraph">To change the function that
is used by a data field, double-click a button in the <emph>Data Fields</emph>
area to open the <link href="text/scalc/01/12090105.xhp">Data Field</link>
dialog. You can also double-click buttons in the <emph>Row Fields</emph> or
<emph>Column Fields</emph> areas.</paragraph>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/more"
id="bm_id4284798" localize="false"/>
+ <h2 id="hd_id3154944">Options</h2>
+ <paragraph id="par_id3145647" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/more">Displays or hides additional
options for defining the pivot table.</ahelp></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows"
id="bm_id7835016" localize="false"/>
+ <h3 id="hd_id3147364">Ignore empty rows</h3>
+ <paragraph id="par_id3154022" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows">Ignores
empty fields in the data source.</ahelp></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-identify-categories"
id="bm_id5103305" localize="false"/>
+ <h3 id="hd_id3155114">Identify categories</h3>
+ <paragraph id="par_id3145257" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-identify-categories">Automatically
assigns rows without labels to the category of the row
above.</ahelp><comment>i93137</comment></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-columns"
id="bm_id2163457" localize="false"/>
+ <h3 id="hd_id3149207">Show totals column</h3>
+ <paragraph id="par_id3166426" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-total-columns">Calculates
and displays the grand total of the column calculation.</ahelp></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-rows"
id="bm_id3748588" localize="false"/>
+ <h3 id="hd_id3150364">Show totals row</h3>
+ <paragraph id="par_id3152583" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/check-total-rows">Calculates and
displays the grand total of the row calculation.</ahelp></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-add-filter"
id="bm_id6004516" localize="false"/>
+ <h3 id="par_idN10897">Add filter</h3>
+ <paragraph id="par_idN1089B" role="paragraph"><ahelp hid=".">Adds a Filter
button to pivot tables that are based on spreadsheet data.</ahelp></paragraph>
+ <bookmark branch="hid/.uno:DataPilotFilter" id="bm_id6278267"
localize="false"/>
+ <paragraph id="par_idN108B2" role="paragraph"><ahelp hid=".">Opens the
Filter dialog.</ahelp></paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-drill-to-details"
id="bm_id7366252" localize="false"/>
+ <h3 id="par_idN108C9">Enable drill to details</h3>
+ <paragraph id="par_idN108CD" role="paragraph"><ahelp hid=".">Select this
check box and double-click an item label in the table to show or hide details
for the item. Clear this check box and double-click a cell in the table to edit
the contents of the cell.</ahelp></paragraph>
+
+ <paragraph role="paragraph" id="par_idN108DC">To examine details inside a
pivot table, do one of the following:</paragraph>
+ <list type="unordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_idN108E6"
role="paragraph">Select a range of cells and choose <emph>Data - Group and
Outline - Show Details</emph>.</paragraph>
+ <paragraph id="par_idN108E6" role="paragraph">Select a range of
cells and choose <emph>Data - Group and Outline - Show
Details</emph>.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_idN108EE"
role="paragraph">Double-click a field in the table.</paragraph>
+ <paragraph id="par_idN108EE" role="paragraph">Double-click a
field in the table.</paragraph>
</listitem>
- </list>
- <paragraph xml-lang="en-US" id="par_idN108F1" role="paragraph">If you
double-click a field which has adjacent fields at the same level, the
<emph>Show Detail</emph> dialog opens:</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/showdetaildialog/ShowDetails" id="bm_id9630726"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/showdetaildialog/dimsTreeview" id="bm_id9630726"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/showdetaildialog/@@nowidget@@" id="bm_id9630726"
localize="false"/>
-<h2 id="par_idN10900">Show Detail</h2>
- <paragraph xml-lang="en-US" id="par_idN10904" role="paragraph"><ahelp
hid=".">Choose the field that you want to view the details
for.</ahelp></paragraph>
- <section id="relatedtopics">
- <paragraph xml-lang="en-US" id="par_id3149817" role="paragraph"><link
href="text/scalc/04/01020000.xhp">Pivot table shortcut keys</link></paragraph>
- </section>
- </body>
+ </list>
+ <paragraph id="par_idN108F1" role="paragraph">If you double-click a field
which has adjacent fields at the same level, the <emph>Show Detail</emph>
dialog opens:</paragraph>
+ <bookmark branch="hid/modules/scalc/ui/showdetaildialog/ShowDetails"
id="bm_id9630726" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/showdetaildialog/dimsTreeview"
id="bm_id9630726" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/showdetaildialog/@@nowidget@@"
id="bm_id9630726" localize="false"/>
+ <h2 id="par_idN10900">Show expand / collapse buttons</h2>
+ <paragraph role="paragraph" id="par_id781748994091291">Shows outline
buttons to expand and collapse, to make the pivot table with the compact layout
more usable.</paragraph>
+
+ <h2 id="hd_id3151073">Source and Destination</h2>
+ <paragraph id="par_id3155417" role="paragraph">Specify the settings for
displaying the results of the pivot table.</paragraph>
+ <bookmark branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-edit"
id="bm_id7418660" localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-button"
id="bm_id7418760" localize="false"/>
+ <h3 id="hd_id0509200913025625">Source</h3>
+ <paragraph id="par_id0509200913025615" role="paragraph"><ahelp
hid=".">Selects the area that contains the data for the current pivot
table.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id481748990290369"><emph>Named
Range</emph>: selects the named range from the drop-down list.</paragraph>
+ <paragraph role="paragraph"
id="par_id291748990482150"><emph>Selection</emph>: selects the area that
contains the data of the pivot table.</paragraph>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-edit"
id="bm_id7419660" localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-list"
id="bm_id2334665" localize="false"/>
+ <h3 id="hd_id3155603">Destination</h3>
+ <paragraph id="par_id3153838" role="paragraph"><ahelp
hid="modules/scalc/ui/pivottablelayoutdialog/destination-edit">Select the area
where you want to display the results of the pivot table.</ahelp></paragraph>
+ <paragraph role="paragraph" id="par_id891748991289882"><emph>New
sheet</emph>: creates a sheet in the document to receive the pivot
table.</paragraph>
+ <paragraph role="paragraph" id="par_id231748991293890"><emph>Named
Range</emph>: selects the named range from the drop-down list.</paragraph>
+ <paragraph role="paragraph"
id="par_id151748991297890"><emph>Selection</emph>: selects the top left cell of
the created pivot table.</paragraph>
+ <warning id="par_id3155961">If the selected area contains data, the pivot
table overwrites the data. To prevent the loss of existing data, choose
<emph>New Sheet</emph>.</warning>
+ <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
+
+ <section id="relatedtopics">
+ <paragraph id="par_id3149817" role="paragraph"><link
href="text/scalc/04/01020000.xhp">Pivot table shortcut keys</link></paragraph>
+ </section>
+</body>
</helpdocument>
