summaryrefslogtreecommitdiff
path: root/source/text/scalc/guide
diff options
context:
space:
mode:
authorStanislav Horacek <stanislav.horacek@gmail.com>2020-12-29 10:33:36 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-01-04 14:44:43 +0100
commit9c9690285ccb3e2116626b84f6747f9f71d35b20 (patch)
tree445ffa8eb07270a57ec25fdaa4d9ee8a8ab335d2 /source/text/scalc/guide
parentc832000c08c6c348d8c1e4914477d6820a42656d (diff)
"page fields" in pivot table have been renamed to "filters"
Change-Id: I4b13bdbb91e5953833a518a5068b7db45147a3ea Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108447 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/guide')
-rw-r--r--source/text/scalc/guide/datapilot_createtable.xhp6
-rw-r--r--source/text/scalc/guide/datapilot_edittable.xhp2
-rw-r--r--source/text/scalc/guide/pivotchart_filter.xhp4
3 files changed, 6 insertions, 6 deletions
diff --git a/source/text/scalc/guide/datapilot_createtable.xhp b/source/text/scalc/guide/datapilot_createtable.xhp
index d03151a4d6..4610d17099 100644
--- a/source/text/scalc/guide/datapilot_createtable.xhp
+++ b/source/text/scalc/guide/datapilot_createtable.xhp
@@ -37,13 +37,13 @@
<paragraph xml-lang="en-US" id="par_id3156023" role="listitem">Position the cursor within a range of cells containing values, row and column headings.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3147264" role="listitem">Choose <emph>Insert - Pivot Table</emph>. The <emph>Select Source</emph> dialog appears. Choose <emph>Current selection</emph> and confirm with <emph>OK</emph>. The table headings are shown as buttons in the <emph>Pivot Table</emph> dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields".</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147264" role="listitem">Choose <emph>Insert - Pivot Table</emph>. The <emph>Select Source</emph> dialog appears. Choose <emph>Current selection</emph> and confirm with <emph>OK</emph>. The table headings are shown as buttons in the <emph>Pivot Table</emph> dialog. Drag these buttons as required and drop them into the layout areas "Filters", "Column Fields", "Row Fields" and "Data Fields".</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id3150868" role="listitem">Drag the desired buttons into one of the four areas.</paragraph>
</listitem>
</list>
- <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph">Drag a button to the <emph>Page Fields</emph> area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph">Drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154011" role="paragraph">If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data.</paragraph>
<list type="unordered">
<listitem>
@@ -64,7 +64,7 @@
<paragraph xml-lang="en-US" id="par_id3147338" role="listitem">To open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph>
</listitem>
</list>
- <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph">Exit the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Page Fields</emph> area. The pivot table is inserted further down.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph">Exit the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Filters</emph> area. The pivot table is inserted further down.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
<section id="relatedtopics">
diff --git a/source/text/scalc/guide/datapilot_edittable.xhp b/source/text/scalc/guide/datapilot_edittable.xhp
index 0c3d67f33e..6016004c4c 100644
--- a/source/text/scalc/guide/datapilot_edittable.xhp
+++ b/source/text/scalc/guide/datapilot_edittable.xhp
@@ -34,7 +34,7 @@
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3150868" role="paragraph">Click one of the buttons in the pivot table and hold the mouse button down. A special symbol will appear next to the mouse pointer.</paragraph>
<paragraph xml-lang="en-US" id="par_id3145786" role="paragraph">By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row.</paragraph>
- <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph">In the Pivot Table dialog, you can drag a button to the <emph>Page Fields</emph> area to create a button and a listbox on top of the pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the pivot table to use another page field as a filter.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph">In the Pivot Table dialog, you can drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the pivot table to use another page field as a filter.</paragraph>
<paragraph xml-lang="en-US" id="par_id3147434" role="paragraph">To remove a button from the table, just drag it out of the pivot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156442" role="paragraph">To edit the pivot table, click a cell inside the pivot table and open the context menu. In the context menu you find the command <emph>Edit Layout</emph>, which displays the <emph>Pivot Table</emph> dialog for the current pivot table.</paragraph>
<paragraph xml-lang="en-US" id="par_id2666096" role="paragraph">In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph>
diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp
index 7327a4dcc3..11ccabb53c 100644
--- a/source/text/scalc/guide/pivotchart_filter.xhp
+++ b/source/text/scalc/guide/pivotchart_filter.xhp
@@ -21,7 +21,7 @@
<paragraph role="heading" id="hd_id201525166689277" level="2" xml-lang="en-US">Pivot chart field buttons</paragraph>
- <paragraph role="paragraph" id="par_id751525167435160" xml-lang="en-US">Pivot chart buttons are unique to pivot charts, normal charts don't have them. The buttons shows the layout of the pivot table, which are the pivot table fields. If present, page fields are displayed in the top. Row fields are displayed on the bottom of the chart next to each other and the legend shows the buttons from column fields stacked.</paragraph>
+ <paragraph role="paragraph" id="par_id751525167435160" xml-lang="en-US">Pivot chart buttons are unique to pivot charts, normal charts don't have them. The buttons shows the layout of the pivot table, which are the pivot table fields. If present, filters are displayed in the top. Row fields are displayed on the bottom of the chart next to each other and the legend shows the buttons from column fields stacked.</paragraph>
<paragraph role="paragraph" id="par_id681525167692377" xml-lang="en-US">
<image src="media/helpimg/sc_PivotChartButtons.png" id="img_id801525167692378" width="604px" height="340px"><alt xml-lang="en-US" id="alt_id881525167692378">Pivot chart buttons</alt></image>
@@ -29,7 +29,7 @@
<paragraph role="paragraph" id="par_id851525167448337" xml-lang="en-US">The buttons have a pop-up action attached to them. If there is some filtering applied, then the arrow turns blue (similar to the pivot table), so it is easier to see when a field has any filter applied.</paragraph>
- <paragraph role="paragraph" id="par_id401525167457977" xml-lang="en-US">Existing page fields shows what is filtered: when nothing is filtered "- all -" is shown, when some data is filtered, then "- multiple -" is shown and when only one value is not filtered, the value is shown.</paragraph>
+ <paragraph role="paragraph" id="par_id401525167457977" xml-lang="en-US">Existing filters shows what is filtered: when nothing is filtered "- all -" is shown, when some data is filtered, then "- multiple -" is shown and when only one value is not filtered, the value is shown.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>