tdf#129554 keyboard shortcuts for Pivot dialog

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

1 files changed, 39 insertions, 42 deletions

diff --git a/source/text/scalc/04/01020000.xhp b/source/text/scalc/04/01020000.xhp
index b59110d9ec..a065820312 100644
--- a/source/text/scalc/04/01020000.xhp
+++ b/source/text/scalc/04/01020000.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,9 +16,7 @@
  *   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">
+<helpdocument version="1.0">
 <meta>
 <topic id="textscalc0401020000xml" indexer="include" status="PUBLISH">
 <title id="tit" xml-lang="en-US">Shortcut Keys for Spreadsheets</title>
@@ -33,8 +28,8 @@
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145801"><bookmark_value>spreadsheets; shortcut keys in</bookmark_value>
 <bookmark_value>shortcut keys; spreadsheets</bookmark_value>
 <bookmark_value>sheet ranges; filling</bookmark_value>
-</bookmark><comment>mw deleted "matrices;..."</comment><paragraph role="heading" id="hd_id3145801" xml-lang="en-US" level="1"><variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Shortcut Keys for Spreadsheets</link>
-</variable></paragraph>
+</bookmark><comment>mw deleted "matrices;..."</comment><h1 id="hd_id3145801"><variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Shortcut Keys for Spreadsheets</link>
+</variable></h1>
 <embed href="text/shared/00/00000099.xhp#keys"/>
 </section>
 <paragraph role="paragraph" id="par_id3155067" xml-lang="en-US">To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select="sys"><caseinline select="MAC">Option
@@ -45,7 +40,7 @@
 <paragraph role="paragraph" id="par_id3150207" xml-lang="en-US">To select multiple sheets in a spreadsheet, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet.</paragraph>
 <paragraph role="paragraph" id="par_id3166432" xml-lang="en-US">To insert a manual line break in a cell, click in the cell, and then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph>
 <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US">To delete the contents of selected cells, press Backspace. This opens the <link href="text/scalc/01/02150000.xhp" name="Delete Contents">Delete Contents</link> dialog, where you choose which contents of the cell you want to delete. To delete the contents of selected cells without a dialog, press the Delete key.</paragraph>
-<paragraph role="heading" id="hd_id3145386" xml-lang="en-US" level="2">Navigating in Spreadsheets</paragraph>
+<h2 id="hd_id3145386">Navigating in Spreadsheets</h2>
 <table id="tbl_id5963927">
 <tablerow>
 <tablecell>
@@ -288,8 +283,8 @@
 </tablecell>
 </tablerow>
 </table>
-<paragraph role="note" id="par_id8070314" xml-lang="en-US">The ` key is located next to the "1" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function.</paragraph>
-<paragraph role="heading" id="hd_id3148756" xml-lang="en-US" level="2">Function Keys Used in Spreadsheets</paragraph>
+<note id="par_id8070314">The ` key is located next to the "1" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function.</note>
+<h2 id="hd_id3148756">Function Keys Used in Spreadsheets</h2>
 <table id="tbl_id5384685">
 <tablerow>
 <tablecell>
@@ -531,7 +526,7 @@
 </tablecell>
 </tablerow>
 </table>
-<paragraph role="heading" id="hd_id3156013" xml-lang="en-US" level="2">Formatting Cells Using Shortcut Keys</paragraph>
+<h2 id="hd_id3156013">Formatting Cells Using Shortcut Keys</h2>
 <paragraph role="paragraph" id="par_id3153979" xml-lang="en-US">The following cell formats can be applied with the keyboard:</paragraph>
 <table id="tbl_id6533097">
 <tablerow>
@@ -602,7 +597,9 @@
 </tablerow>
 </table>
 <section id="datenpiloten">
-<paragraph role="heading" id="hd_id3154205" xml-lang="en-US" level="2">Using the pivot table</paragraph>
+<h2 id="hd_id3154205">Using the pivot table</h2>
+  <paragraph role="paragraph" id="par_id631581375238556">The shortcut keys below are for the <emph>Pivot Table Layout</emph> dialog.</paragraph>
+
 <table id="tbl_id2419507">
 <tablerow>
 <tablecell>
@@ -614,7 +611,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3153577" xml-lang="en-US">Tab</paragraph>
+<paragraph role="tablecontent" id="hd_id3153577" xml-lang="en-US"><keycode>Tab</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3147511" xml-lang="en-US">Changes the focus by moving forwards through the areas and buttons of the dialog.</paragraph>
@@ -622,7 +619,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3154266" xml-lang="en-US">Shift+Tab</paragraph>
+<paragraph role="tablecontent" id="hd_id3154266" xml-lang="en-US"><keycode>Shift+Tab</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3155362" xml-lang="en-US">Changes the focus by moving backwards through the areas and buttons of the dialog.</paragraph>
@@ -630,7 +627,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3148484" xml-lang="en-US">Up Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3148484" xml-lang="en-US"><keycode>Up Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3149152" xml-lang="en-US">Moves the focus up one item in the current dialog area.</paragraph>
@@ -638,7 +635,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3154273" xml-lang="en-US">Down Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3154273" xml-lang="en-US"><keycode>Down Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3158424" xml-lang="en-US">Moves the focus down one item in the current dialog area.</paragraph>
@@ -646,7 +643,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3148912" xml-lang="en-US">Left Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3148912" xml-lang="en-US"><keycode>Left Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3153238" xml-lang="en-US">Moves the focus one item to the left in the current dialog area.</paragraph>
@@ -654,7 +651,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3150712" xml-lang="en-US">Right Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3150712" xml-lang="en-US"><keycode>Right Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3166458" xml-lang="en-US">Moves the focus one item to the right in the current dialog area.</paragraph>
@@ -662,7 +659,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3146947" xml-lang="en-US">Home</paragraph>
+<paragraph role="tablecontent" id="hd_id3146947" xml-lang="en-US"><keycode>Home</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3153742" xml-lang="en-US">Selects the first item in the current dialog area.</paragraph>
@@ -670,7 +667,7 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3153387" xml-lang="en-US">End</paragraph>
+<paragraph role="tablecontent" id="hd_id3153387" xml-lang="en-US"><keycode>End</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3153684" xml-lang="en-US">Selects the last item in the current dialog area.</paragraph>
@@ -678,87 +675,87 @@
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3155584" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Row"</paragraph>
+<paragraph role="tablecontent" id="hd_id3155584" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline> and the underlined character in the label "Row Fields"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3152949" xml-lang="en-US">Copies or moves the current field into the "Row" area.</paragraph>
+<paragraph role="tablecontent" id="par_id3152949" xml-lang="en-US">Copies or moves the current field into the "Row Fields" area.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3159269" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Column"</paragraph>
+<paragraph role="tablecontent" id="hd_id3159269" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline> and the underlined character in the label "Column Fields"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3149968" xml-lang="en-US">Copies or moves the current field into the "Column" area.</paragraph>
+<paragraph role="tablecontent" id="par_id3149968" xml-lang="en-US">Copies or moves the current field into the "Column Fields" area.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3149923" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> and the underlined character in the word "Data"</paragraph>
+<paragraph role="tablecontent" id="hd_id3149923" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline> and the underlined character in the label "Data Fields"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3148649" xml-lang="en-US">Copies or moves the current field into the "Data" area.</paragraph>
+<paragraph role="tablecontent" id="par_id3148649" xml-lang="en-US">Copies or moves the current field into the "Data Fields" area.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3149418" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Up Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3149423" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Option</keycode></caseinline><defaultinline><keycode>Alt</keycode></defaultinline></switchinline> and the underlined character in the label "Filters"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3154335" xml-lang="en-US">Moves the current field up one place.</paragraph>
+<paragraph role="tablecontent" id="par_id3144649" xml-lang="en-US">Copies or moves the current field into the "Filters" area.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3148462" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Down Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3149418" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Up Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3154603" xml-lang="en-US">Moves the current field down one place.</paragraph>
+<paragraph role="tablecontent" id="par_id3154335" xml-lang="en-US">Moves the current field up one place.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3145373" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3148462" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Down Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3151125" xml-lang="en-US">Moves the current field one place to the left.</paragraph>
+<paragraph role="tablecontent" id="par_id3154603" xml-lang="en-US">Moves the current field down one place.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3150423" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right Arrow</paragraph>
+<paragraph role="tablecontent" id="hd_id3145373" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Left Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3153316" xml-lang="en-US">Moves the current field one place to the right.</paragraph>
+<paragraph role="tablecontent" id="par_id3151125" xml-lang="en-US">Moves the current field one place to the left.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3149519" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home</paragraph>
+<paragraph role="tablecontent" id="hd_id3150423" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Right Arrow</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3149237" xml-lang="en-US">Moves the current field to the first place.</paragraph>
+<paragraph role="tablecontent" id="par_id3153316" xml-lang="en-US">Moves the current field one place to the right.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3145310" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End</paragraph>
+<paragraph role="tablecontent" id="hd_id3149519" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Home</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3153942" xml-lang="en-US">Moves the current field to the last place.</paragraph>
+<paragraph role="tablecontent" id="par_id3149237" xml-lang="en-US">Moves the current field to the first place.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3149933" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+O</paragraph>
+<paragraph role="tablecontent" id="hd_id3145310" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+End</keycode></paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id3154798" xml-lang="en-US">Displays the options for the current field.</paragraph>
+<paragraph role="tablecontent" id="par_id3153942" xml-lang="en-US">Moves the current field to the last place.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph role="tablecontent" id="hd_id3148418" xml-lang="en-US">Delete</paragraph>
+<paragraph role="tablecontent" id="hd_id3148418" xml-lang="en-US"><keycode>Delete</keycode></paragraph>
 </tablecell>
 <tablecell>
 <paragraph role="tablecontent" id="par_id3159251" xml-lang="en-US">Removes the current field from the area.</paragraph>