source/text/scalc/00/00000404.xhp | 48 ++++++------
source/text/scalc/00/00000412.xhp | 151 +++++++++++++++++++++-----------------
source/text/scalc/01/04060000.xhp | 88 +++++++++++-----------
source/text/scalc/01/12090000.xhp | 6 -
source/text/scalc/01/12090100.xhp | 30 +++----
5 files changed, 174 insertions(+), 149 deletions(-)
New commits:
commit ba53126a2a008a50119d82c9f904eee70df3dbd4
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 1 10:08:09 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 1 14:12:19 2023 +0100
tdf#155876 UI cmds Calc-Insert menu (13)
+ refactoring of Insert Functions
Change-Id: I8f09d6f9f4a44d7c41ba86046b94c27612b81f12
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158760
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index a582672a59..599499f251 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -47,7 +47,7 @@
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3149656">
-<image id="img_id3154365" src="cmd/sc_inscellsctrl.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3154365">Icon</alt></image></paragraph>
+<image id="img_id3154365" src="cmd/sc_inscellsctrl.png" width="1cm"
height="1cm"><alt id="alt_id3154365">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3151041">Insert Cells</paragraph>
@@ -62,7 +62,7 @@
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3145273">
-<image id="img_id3145364" src="cmd/sc_insertcellsdown.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3145364">Icon</alt></image></paragraph>
+<image id="img_id3145364" src="cmd/sc_insertcellsdown.png" width="1cm"
height="1cm"><alt id="alt_id3145364">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3146985">Insert Cells Down</paragraph>
@@ -76,7 +76,7 @@
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3144766">
-<image id="img_id3154942" src="cmd/sc_insertcellsright.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3154942">Icon</alt></image></paragraph>
+<image id="img_id3154942" src="cmd/sc_insertcellsright.png" width="1cm"
height="1cm"><alt id="alt_id3154942">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3145646">Insert Cells Right</paragraph>
@@ -90,7 +90,7 @@
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3153838">
-<image id="img_id3153710" src="cmd/sc_insertrows.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3153710">Icon</alt></image></paragraph>
+<image id="img_id3153710" src="cmd/sc_insertrows.png" width="1cm"
height="1cm"><alt id="alt_id3153710">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3150324">Insert Rows</paragraph>
@@ -104,7 +104,7 @@
<tablerow>
<tablecell>
<paragraph role="paragraph" id="par_id3147363">
-<image id="img_id3145232" src="cmd/sc_insertcolumns.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3145232">Icon</alt></image></paragraph>
+<image id="img_id3145232" src="cmd/sc_insertcolumns.png" width="1cm"
height="1cm"><alt id="alt_id3145232">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph role="paragraph" id="par_id3155334">Insert Columns</paragraph>
@@ -113,25 +113,29 @@
</table>
</section>
<paragraph role="paragraph" id="par_idN1082F"><variable id="eitabfile">Choose
<menuitem>Sheet - Insert Sheet from File</menuitem>.</variable></paragraph>
-<section id="insert_function">
-<paragraph role="paragraph" id="par_id3155115">Choose <menuitem>Insert -
Function</menuitem>.</paragraph>
-<paragraph role="paragraph" id="par_id3152582"><switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F2</paragraph>
- <paragraph role="paragraph" id="par_id3153269">On the <emph>Formula</emph>
bar, click</paragraph>
-<section id="syfunction_wizard">
-<table id="tbl_id3145258">
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3150515">
-<image id="img_id3150884" src="sw/res/sc20556.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3150884">Icon</alt></image></paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="paragraph" id="par_id3154370">Function Wizard</paragraph>
-</tablecell>
-</tablerow>
-</table>
+<section id="insert_function">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3155115">Choose <menuitem>Insert -
Function</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id271698843588067">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Function</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <section id="syfunction_wizard">
+ <table id="tbl_id3145258">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3150515"><image
id="img_id3150884" src="cmd/lc_dbviewfunctions.svg" width="1cm"
height="1cm"><alt id="alt_id3150884">Icon Function
Wizzard</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3154370">Function
Wizard</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id3152582"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ F2</keycode></paragraph>
</section>
-</section>
+
<paragraph role="paragraph" id="par_id3156288"><variable
id="eikada"><emph>Insert - Function</emph> - Category <emph>Database</emph>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3155809"><variable
id="eikadaze"><emph>Insert - Function</emph> - Category <emph>Date &
Time</emph>
diff --git a/source/text/scalc/01/04060000.xhp
b/source/text/scalc/01/04060000.xhp
index 91b457e60e..56e3a6a436 100644
--- a/source/text/scalc/01/04060000.xhp
+++ b/source/text/scalc/01/04060000.xhp
@@ -22,89 +22,89 @@
<meta>
<topic id="textscalc0104060000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Function Wizard</title>
+<title id="tit">Function Wizard</title>
<filename>/text/scalc/01/04060000.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147426"><bookmark_value>inserting functions; Function
Wizard</bookmark_value>
+<bookmark branch="index" id="bm_id3147426"><bookmark_value>inserting
functions; Function Wizard</bookmark_value>
<bookmark_value>functions;Function Wizard</bookmark_value>
<bookmark_value>wizards; functions</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/functionpage/FunctionPage"
id="bm_id3145749" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/functionpage/@@nowidget@@"
id="bm_id3145749" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_CALC" id="bm_id3145750"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:FunctionDialog" id="bm_id1185225"
localize="false"/>
+<bookmark branch="hid/formula/ui/functionpage/FunctionPage" id="bm_id3145749"
localize="false"/>
+<bookmark branch="hid/formula/ui/functionpage/@@nowidget@@" id="bm_id3145749"
localize="false"/>
+<bookmark branch="hid/SC_HID_INSWIN_CALC" id="bm_id3145750" localize="false"/>
+<bookmark branch="hid/.uno:FunctionDialog" id="bm_id1185225" localize="false"/>
<section id="function_wizard">
<h1 id="hd_id3147426"><link
href="text/scalc/01/04060000.xhp">Function</link></h1>
-<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US"><variable
id="funktionsautopilottext"><ahelp hid=".">Opens the <emph>Function
Wizard</emph>, which helps you to interactively create
formulas.</ahelp></variable></paragraph>
+<paragraph role="paragraph" id="par_id3145271"><variable
id="funktionsautopilottext"><ahelp hid=".">Opens the <emph>Function
Wizard</emph>, which helps you to interactively create
formulas.</ahelp></variable></paragraph>
</section>
<paragraph role="paragraph" id="par_id491577286833512">Before you start the
Wizard, select a cell or a range of cells from the current sheet, in order to
determine the position at which the formula will be inserted.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#insert_function"/>
</section>
<note id="par_id8007446">You can download the complete ODFF (OpenDocument
Format Formula) specification from the <link
href="https://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt";><emph>OASIS</emph></link>
web site.</note>
-<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US">The
<emph>Function Wizard</emph> has two tabs: <emph>Functions</emph> is used to
create formulas, and <emph>Structure</emph> is used to check the formula
build.</paragraph>
+<paragraph role="paragraph" id="par_id3159153">The <emph>Function
Wizard</emph> has two tabs: <emph>Functions</emph> is used to create formulas,
and <emph>Structure</emph> is used to check the formula build.</paragraph>
<h2 id="hd_id3154490">Functions Tab</h2>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/functionpage/search"
id="bm_id1185225" localize="false"/>
+<bookmark branch="hid/formula/ui/functionpage/search" id="bm_id1185225"
localize="false"/>
<h3 id="hd_id3154731">Search</h3>
-<paragraph role="paragraph" id="par_id3155440" xml-lang="en-US"><ahelp
hid="formula/ui/functionpage/search">Search for a part of the function
name.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/functionpage/category"
id="bm_id1185226" localize="false"/>
+<paragraph role="paragraph" id="par_id3155440"><ahelp
hid="formula/ui/functionpage/search">Search for a part of the function
name.</ahelp></paragraph>
+<bookmark branch="hid/formula/ui/functionpage/category" id="bm_id1185226"
localize="false"/>
<h3 id="hd_id3154730">Category</h3>
-<paragraph role="paragraph" id="par_id3153417" xml-lang="en-US"><variable
id="kategorienliste"><ahelp hid="formula/ui/functionpage/category">Lists all
the categories to which the different functions are assigned. Select a category
to view the appropriate functions in the list field below.</ahelp> Select "All"
to view all functions in alphabetical order, irrespective of category. "Last
Used" lists the functions you have most recently used.
+<paragraph role="paragraph" id="par_id3153417"><variable
id="kategorienliste"><ahelp hid="formula/ui/functionpage/category">Lists all
the categories to which the different functions are assigned. Select a category
to view the appropriate functions in the list field below.</ahelp> Select "All"
to view all functions in alphabetical order, irrespective of category. "Last
Used" lists the functions you have most recently used.
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3149378" xml-lang="en-US">You can browse
the full <link href="text/scalc/01/04060100.xhp"><emph>List of Categories and
Functions</emph></link>.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/functionpage/function"
id="bm_id1185227" localize="false"/>
+<paragraph role="paragraph" id="par_id3149378">You can browse the full <link
href="text/scalc/01/04060100.xhp"><emph>List of Categories and
Functions</emph></link>.</paragraph>
+<bookmark branch="hid/formula/ui/functionpage/function" id="bm_id1185227"
localize="false"/>
<h3 id="hd_id3150749">Function</h3>
-<paragraph role="paragraph" id="par_id3155445" xml-lang="en-US"><ahelp
hid="formula/ui/functionpage/function">Displays the functions found under the
selected category. Double-click to select a function.</ahelp> A single-click
displays a short function description.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/array"
id="bm_id1185228" localize="false"/>
+<paragraph role="paragraph" id="par_id3155445"><ahelp
hid="formula/ui/functionpage/function">Displays the functions found under the
selected category. Double-click to select a function.</ahelp> A single-click
displays a short function description.</paragraph>
+<bookmark branch="hid/formula/ui/formuladialog/array" id="bm_id1185228"
localize="false"/>
<h3 id="hd_id3159264">Array</h3>
-<paragraph role="paragraph" id="par_id3149566" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/array">Specifies that the selected function is
inserted into the selected cell range as an array formula.</ahelp> Array
formulas operate on multiple cells. Each cell in the array contains the
formula, not as a copy but as a common formula shared by all matrix
cells.</paragraph>
-<paragraph role="paragraph" id="par_id3155959" xml-lang="en-US">The
<emph>Array</emph> option is identical to the <switchinline
select="sys"><caseinline
select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph>
command, which is used to enter and confirm formulas in the sheet. The formula
is inserted as a matrix formula indicated by two braces: <emph>{
}</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3149566"><ahelp
hid="formula/ui/formuladialog/array">Specifies that the selected function is
inserted into the selected cell range as an array formula.</ahelp> Array
formulas operate on multiple cells. Each cell in the array contains the
formula, not as a copy but as a common formula shared by all matrix
cells.</paragraph>
+<paragraph role="paragraph" id="par_id3155959">The <emph>Array</emph> option
is identical to the <switchinline select="sys"><caseinline
select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph>
command, which is used to enter and confirm formulas in the sheet. The formula
is inserted as a matrix formula indicated by two braces: <emph>{
}</emph>.</paragraph>
<note id="par_id3152993">The maximum size of an array range is 128 by 128
cells.</note>
<h3 id="hd_id3150367">Argument Input Fields</h3>
-<paragraph role="paragraph" id="par_id3145587" xml-lang="en-US">When you
double-click a function, the argument input field(s) appear on the right side
of the dialog. To select a cell reference as an argument, click directly into
the cell, or drag across the required range on the sheet while holding down the
mouse button. You can also enter numerical and other values or references
directly into the corresponding fields in the dialog. When using <link
href="text/scalc/01/04060102.xhp"><emph>date entries</emph></link>, make sure
you use the correct format. Click <emph>OK</emph> to insert the result into the
spreadsheet.</paragraph>
+<paragraph role="paragraph" id="par_id3145587">When you double-click a
function, the argument input field(s) appear on the right side of the dialog.
To select a cell reference as an argument, click directly into the cell, or
drag across the required range on the sheet while holding down the mouse
button. You can also enter numerical and other values or references directly
into the corresponding fields in the dialog. When using <link
href="text/scalc/01/04060102.xhp"><emph>date entries</emph></link>, make sure
you use the correct format. Click <emph>OK</emph> to insert the result into the
spreadsheet.</paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/result"
id="bm_id1185233" localize="false"/>
+<bookmark branch="hid/formula/ui/formuladialog/result" id="bm_id1185233"
localize="false"/>
<h3 id="hd_id3149408">Function Result</h3>
-<paragraph role="paragraph" id="par_id3155809" xml-lang="en-US">As soon you
enter arguments in the function, the result is calculated. This preview informs
you if the calculation can be carried out with the arguments given. If the
arguments result in an error, the corresponding <link
href="text/scalc/05/02140000.xhp"><emph>error code</emph></link> is
displayed.</paragraph>
-<paragraph role="paragraph" id="par_id3148700" xml-lang="en-US">The required
arguments are indicated by names in bold print.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/parameter/FX1"
id="bm_id1185230" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/parameter/FX2"
id="bm_id1185231" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/parameter/FX3"
id="bm_id1185232" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/parameter/FX4"
id="bm_id1185233" localize="false"/>
+<paragraph role="paragraph" id="par_id3155809">As soon you enter arguments in
the function, the result is calculated. This preview informs you if the
calculation can be carried out with the arguments given. If the arguments
result in an error, the corresponding <link
href="text/scalc/05/02140000.xhp"><emph>error code</emph></link> is
displayed.</paragraph>
+<paragraph role="paragraph" id="par_id3148700">The required arguments are
indicated by names in bold print.</paragraph>
+<bookmark branch="hid/formula/ui/parameter/FX1" id="bm_id1185230"
localize="false"/>
+<bookmark branch="hid/formula/ui/parameter/FX2" id="bm_id1185231"
localize="false"/>
+<bookmark branch="hid/formula/ui/parameter/FX3" id="bm_id1185232"
localize="false"/>
+<bookmark branch="hid/formula/ui/parameter/FX4" id="bm_id1185233"
localize="false"/>
<h3 id="hd_id3153064">f(x) (depending on the selected function)</h3>
-<paragraph role="paragraph" id="par_id3157980" xml-lang="en-US"><ahelp
hid=".">Allows you to access a subordinate level of the <emph>Function
Wizard</emph> in order to nest another function within the function, instead of
a value or reference.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3157980"><ahelp hid=".">Allows you to
access a subordinate level of the <emph>Function Wizard</emph> in order to nest
another function within the function, instead of a value or
reference.</ahelp></paragraph>
<h3 id="hd_id3145076">Argument/Parameter/Cell Reference (depending on the
selected function)</h3>
-<paragraph role="paragraph" id="par_id3159097" xml-lang="en-US">The number of
visible text fields depends on the function. Enter arguments either directly
into the argument fields or by clicking a cell in the table.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/formula/ui/formuladialog/formula_result" id="bm_id1185239"
localize="false"/>
+<paragraph role="paragraph" id="par_id3159097">The number of visible text
fields depends on the function. Enter arguments either directly into the
argument fields or by clicking a cell in the table.</paragraph>
+<bookmark branch="hid/formula/ui/formuladialog/formula_result"
id="bm_id1185239" localize="false"/>
<h3 id="hd_id3154957">Result</h3>
-<paragraph role="paragraph" id="par_id3150211" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/formula_result">Displays the calculation result
or an error message.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/ed_formula"
id="bm_id1185234" localize="false"/>
+<paragraph role="paragraph" id="par_id3150211"><ahelp
hid="formula/ui/formuladialog/formula_result">Displays the calculation result
or an error message.</ahelp></paragraph>
+<bookmark branch="hid/formula/ui/formuladialog/ed_formula" id="bm_id1185234"
localize="false"/>
<h3 id="hd_id3151304">Formula</h3>
-<paragraph role="paragraph" id="par_id3149898" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/ed_formula">Displays the created formula. Type
your entries directly, or create the formula using the
wizard.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/back"
id="bm_id1185235" localize="false"/>
+<paragraph role="paragraph" id="par_id3149898"><ahelp
hid="formula/ui/formuladialog/ed_formula">Displays the created formula. Type
your entries directly, or create the formula using the
wizard.</ahelp></paragraph>
+<bookmark branch="hid/formula/ui/formuladialog/back" id="bm_id1185235"
localize="false"/>
<h3 id="hd_id3153249">Back</h3>
-<paragraph role="paragraph" id="par_id3152869" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/back">Moves the focus back through the formula
components, marking them as it does so.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3152869"><ahelp
hid="formula/ui/formuladialog/back">Moves the focus back through the formula
components, marking them as it does so.</ahelp></paragraph>
<tip id="par_id3146966">To select a single function from a complex formula
consisting of several functions, double-click the function in the formula
window.</tip>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/next"
id="bm_id1185236" localize="false"/>
+<bookmark branch="hid/formula/ui/formuladialog/next" id="bm_id1185236"
localize="false"/>
<h3 id="hd_id3155762">Next</h3>
-<paragraph role="paragraph" id="par_id3149316" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/next">Moves forward through the formula
components in the formula window.</ahelp> This button can also be used to
assign functions to the formula. If you select a function and click the
<emph>Next</emph> button, the selection appears in the formula
window.</paragraph>
+<paragraph role="paragraph" id="par_id3149316"><ahelp
hid="formula/ui/formuladialog/next">Moves forward through the formula
components in the formula window.</ahelp> This button can also be used to
assign functions to the formula. If you select a function and click the
<emph>Next</emph> button, the selection appears in the formula
window.</paragraph>
<tip id="par_id3159262">Double-click a function in the selection window to
transfer it to the formula window.</tip>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/ok"
id="bm_id1185238" localize="false"/>
+<bookmark branch="hid/formula/ui/formuladialog/ok" id="bm_id1185238"
localize="false"/>
<h3 id="hd_id3150534">OK</h3>
-<paragraph role="paragraph" id="par_id3153029" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/ok">Ends the <emph>Function Wizard</emph>, and
transfers the formula to the selected cells.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/formuladialog/cancel"
id="bm_id1185237" localize="false"/>
+<paragraph role="paragraph" id="par_id3153029"><ahelp
hid="formula/ui/formuladialog/ok">Ends the <emph>Function Wizard</emph>, and
transfers the formula to the selected cells.</ahelp></paragraph>
+<bookmark branch="hid/formula/ui/formuladialog/cancel" id="bm_id1185237"
localize="false"/>
<h3 id="hd_id3148745">Cancel</h3>
-<paragraph role="paragraph" id="par_id3147402" xml-lang="en-US"><ahelp
hid="formula/ui/formuladialog/cancel">Closes the dialog without implementing
the formula.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147402"><ahelp
hid="formula/ui/formuladialog/cancel">Closes the dialog without implementing
the formula.</ahelp></paragraph>
<h2 id="hd_id3147610">Structure tab</h2>
-<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US">On this page,
you can view the structure of the function.</paragraph>
+<paragraph role="paragraph" id="par_id3153122">On this page, you can view the
structure of the function.</paragraph>
<note id="par_id3149350">If you start the <emph>Function Wizard</emph> while
the cell cursor is positioned in a cell that already contains a function, the
<emph>Structure</emph> tab is opened and shows the composition of the current
formula.</note>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/structpage/struct"
id="bm_id1185240" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/formula/ui/structpage/StructPage"
id="bm_id671598996689983" localize="false"/>
+<bookmark branch="hid/formula/ui/structpage/struct" id="bm_id1185240"
localize="false"/>
+<bookmark branch="hid/formula/ui/structpage/StructPage"
id="bm_id671598996689983" localize="false"/>
<h3 id="hd_id3149014">Structure</h3>
-<paragraph role="paragraph" id="par_id3150481" xml-lang="en-US"><ahelp
hid="formula/ui/structpage/struct">Displays a hierarchical representation of
the current function.</ahelp> You can hide or show the arguments by a click on
the plus or minus sign in front.</paragraph>
+<paragraph role="paragraph" id="par_id3150481"><ahelp
hid="formula/ui/structpage/struct">Displays a hierarchical representation of
the current function.</ahelp> You can hide or show the arguments by a click on
the plus or minus sign in front.</paragraph>
<note id="par_id3148886">Blue dots denote correctly entered arguments. Red
dots indicate incorrect data types. For example: if the SUM function has one
argument entered as text, this is highlighted in red as SUM only permits number
entries.</note>
</body>
</helpdocument>
commit d050546d948767191446369a451e4e0267fa4272
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 1 09:46:09 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 1 14:12:09 2023 +0100
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.hal...@libreoffice.org>
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>
