source/text/scalc/04/01020000.xhp | 81 ++++++++++++++++++--------------------
1 file changed, 39 insertions(+), 42 deletions(-)
New commits:
commit 66d9968bba9fe381183387089509ed928ee8a6d9
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Feb 10 20:47:55 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Feb 11 00:53:26 2020 +0100
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.hal...@libreoffice.org>
diff --git a/source/text/scalc/04/01020000.xhp
b/source/text/scalc/04/01020000.xhp
index b59110d9e..a06582031 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
