source/text/sbasic/shared/01170101.xhp | 226 ++++++++++++++++-----------------
source/text/scalc/01/04060101.xhp | 156 +++++++++++-----------
source/text/scalc/01/04060103.xhp | 2
source/text/scalc/01/04060105.xhp | 2
source/text/scalc/main0200.xhp | 2
source/text/sdraw/main0200.xhp | 3
source/text/shared/00/00000002.xhp | 2
source/text/shared/00/00000005.xhp | 2
source/text/shared/01/02100200.xhp | 3
9 files changed, 196 insertions(+), 202 deletions(-)
New commits:
commit 1653fc7e7a458eea57fe1547650abc1a76a42c03
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Apr 14 22:45:22 2021 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Apr 15 11:15:43 2021 +0200
Fix sort in Help pages
+ some L10n fix too
Change-Id: Ib380ec77e7c5779b5008f155272f9f26a9cccac5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114119
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/sbasic/shared/01170101.xhp
b/source/text/sbasic/shared/01170101.xhp
index eda7765b4..35768089c 100644
--- a/source/text/sbasic/shared/01170101.xhp
+++ b/source/text/sbasic/shared/01170101.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="textsbasicshared01170101xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">General</title>
@@ -30,414 +25,415 @@
</meta>
<body>
<section id="general">
-<paragraph role="heading" id="hd_id3147436" xml-lang="en-US" level="1"><link
href="text/sbasic/shared/01170101.xhp" name="General">General</link></paragraph>
+<h1 id="hd_id3147436"><link href="text/sbasic/shared/01170101.xhp"
name="General">General</link></h1>
<paragraph role="paragraph" id="par_id3155855" xml-lang="en-US">Define the
properties for the selected control or dialog. The available properties depend
on the type of control selected. The following properties therefore are not
available for every type of control.</paragraph>
</section>
-<sort order="asc"><section id="Section64">
-<!-- removed HID HID_PROP_IMAGE_ALIGN --><paragraph role="heading"
id="hd_id3148647" xml-lang="en-US" level="2">Alignment</paragraph>
+<sort order="asc" descendant="h2">
+ <section id="Section64">
+<!-- removed HID HID_PROP_IMAGE_ALIGN --><h2 id="hd_id3148647">Alignment</h2>
<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US"><ahelp
hid="HID_PROP_IMAGE_ALIGN">Specify the alignment option for the selected
control.</ahelp></paragraph>
</section>
<section id="Section63">
-<paragraph role="heading" id="hd_id3153189" xml-lang="en-US"
level="2">AutoFill</paragraph>
+<h2 id="hd_id3153189">AutoFill</h2>
<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to enable the AutoFill function for the selected control.
</ahelp></paragraph>
</section>
-<section id="Section62"><paragraph role="heading" id="hd_id3155307"
xml-lang="en-US" level="2">Background color</paragraph>
+<section id="Section62"><h2 id="hd_id3155307">Background color</h2>
<paragraph role="paragraph" id="par_id3145251" xml-lang="en-US"><ahelp
hid=".">Specify the background color for the current
control.</ahelp></paragraph>
</section>
<section id="Section61">
-<paragraph role="heading" id="hd_id3151076" xml-lang="en-US" level="2">Large
change</paragraph>
+<h2 id="hd_id3151076">Large change</h2>
<paragraph role="paragraph" id="par_id3148457" xml-lang="en-US"><ahelp
hid=".">Specify the number of units to scroll when a user clicks in the area
between the slider and the arrows on a scrollbar.</ahelp></paragraph>
</section>
-<section id="Section60"><paragraph role="heading" id="hd_id3153876"
xml-lang="en-US" level="2">Border</paragraph>
+<section id="Section60"><h2 id="hd_id3153876">Border</h2>
<paragraph role="paragraph" id="par_id3154017" xml-lang="en-US"><ahelp
hid=".">Specify the border type for the current control.</ahelp></paragraph>
</section>
<section id="Section59">
-<paragraph role="heading" id="hd_id3150749" xml-lang="en-US" level="2">Button
type</paragraph>
+<h2 id="hd_id3150749">Button type</h2>
<paragraph role="paragraph" id="par_id3155064" xml-lang="en-US"><ahelp
hid=".">Select a button type. Button types determine what type of action is
initiated.</ahelp></paragraph>
</section>
-<section id="Section58"><paragraph role="heading" id="hd_id3149019"
xml-lang="en-US" level="2">Character set</paragraph>
+<section id="Section58"><h2 id="hd_id3149019">Character set</h2>
<paragraph role="paragraph" id="par_id3148406" xml-lang="en-US"><ahelp
hid=".">Select the font to be used for displaying the contents of the current
control.</ahelp></paragraph>
</section>
<section id="Section57">
-<paragraph role="heading" id="hd_id3147341" xml-lang="en-US"
level="2">Currency symbol</paragraph>
+<h2 id="hd_id3147341">Currency symbol</h2>
<paragraph role="paragraph" id="par_id3146315" xml-lang="en-US"><ahelp
hid=".">Enter the currency symbol to be used for currency
controls.</ahelp></paragraph>
</section>
<section id="Section44">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATE"
id="bm_id856349" localize="false"/><paragraph role="heading" id="hd_id7936643"
xml-lang="en-US" level="2">Date</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATE"
id="bm_id856349" localize="false"/><h2 id="hd_id7936643">Date</h2>
<paragraph role="paragraph" id="par_id2293771" xml-lang="en-US"><ahelp
hid=".">Specify the default date to be shown in the Date
control.</ahelp></paragraph>
</section>
<section id="Section56">
-<paragraph role="heading" id="hd_id3153965" xml-lang="en-US" level="2">Date
format</paragraph>
+<h2 id="hd_id3153965">Date format</h2>
<paragraph role="paragraph" id="par_id3155334" xml-lang="en-US"><ahelp
hid=".">Specify the desired format for a date control. A date control
interprets the user input depending on this format setting.</ahelp></paragraph>
</section>
<section id="Section55">
-<paragraph role="heading" id="hd_id3154663" xml-lang="en-US" level="2">Date
max.</paragraph>
+<h2 id="hd_id3154663">Date max.</h2>
<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"><ahelp
hid=".">Specify the upper limit for a date control.</ahelp></paragraph>
</section>
<section id="Section54">
-<paragraph role="heading" id="hd_id3152778" xml-lang="en-US" level="2">Date
min.</paragraph>
+<h2 id="hd_id3152778">Date min.</h2>
<paragraph role="paragraph" id="par_id3154120" xml-lang="en-US"><ahelp
hid=".">Specify the lower limit for a date control.</ahelp></paragraph>
</section>
<section id="Section53">
-<paragraph role="heading" id="hd_id3154573" xml-lang="en-US" level="2">Decimal
accuracy</paragraph>
+<h2 id="hd_id3154573">Decimal accuracy</h2>
<paragraph role="paragraph" id="par_id3166426" xml-lang="en-US"><ahelp
hid=".">Specify the number of decimal places displayed for a numerical or
currency control.</ahelp></paragraph>
</section>
<section id="Section52">
-<paragraph role="heading" id="hd_id3159091" xml-lang="en-US" level="2">Default
button</paragraph>
+<h2 id="hd_id3159091">Default button</h2>
<paragraph role="paragraph" id="par_id3154200" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to make the current button control the default selection.
Pressing <emph>Return</emph> in the dialog activates the default
button.</ahelp></paragraph>
</section>
<section id="Section66">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REPEAT_DELAY"
id="bm_id1620227" localize="false"/><paragraph role="heading" id="par_idN108BA"
xml-lang="en-US" level="2">Delay</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REPEAT_DELAY"
id="bm_id1620227" localize="false"/><h2 id="par_idN108BA">Delay</h2>
<paragraph role="paragraph" id="par_idN108D0" xml-lang="en-US"><ahelp
hid=".">Specifies the delay in milliseconds between scrollbar trigger
events.</ahelp> A trigger event occurs when you click a scrollbar arrow or
click the background area in a scrollbar. Repeated trigger events occur if you
keep the mouse button pressed when you click a scrollbar arrow or background
area in a scrollbar. If you want, you can include valid time units with the
number that you enter, for example, 2 s or 500 ms.</paragraph>
</section>
-<section id="Section51"><paragraph role="heading" id="hd_id3151278"
xml-lang="en-US" level="2">Dropdown</paragraph>
+<section id="Section51"><h2 id="hd_id3151278">Dropdown</h2>
<paragraph role="paragraph" id="par_id3155113" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to enable the dropdown option for list or combo box
controls. A dropdown control field has an arrow button which you can click to
open a list of the existing form entries.</ahelp></paragraph>
</section>
<section id="Section50">
-<paragraph role="heading" id="hd_id3151216" xml-lang="en-US"
level="2">Enabled</paragraph>
+<h2 id="hd_id3151216">Enabled</h2>
<paragraph role="paragraph" id="par_id3150517" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to enable the control. If the control is disabled, it is
grayed out in the dialog.</ahelp></paragraph>
</section>
<section id="Section49">
-<paragraph role="heading" id="hd_id3155379" xml-lang="en-US" level="2">Edit
mask</paragraph>
+<h2 id="hd_id3155379">Edit mask</h2>
<paragraph role="paragraph" id="par_id3155509" xml-lang="en-US"><ahelp
hid=".">Specify the edit mask for a pattern control. This is a character code
that defines the input format for the control.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3154485" xml-lang="en-US">You need to
specify a masking character for each input character of the edit mask to
restrict the input to the values that are listed in the following
table:</paragraph>
<table id="tbl_id3152986">
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablehead" id="par_id3155809" xml-lang="en-US"> Character
</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablehead" id="par_id3148702"
xml-lang="en-US">Meaning</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3156199"
xml-lang="en-US">L</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3156199" localize="false"
xml-lang="en-US">L</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3148869" xml-lang="en-US">A text
constant. This character cannot be modified by the user. </paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3156016"
xml-lang="en-US">a</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3156016" localize="false"
xml-lang="en-US">a</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3157983" xml-lang="en-US">The
characters a-z can be entered here. If a capital letter is entered, it is
automatically converted to a lowercase letter.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3148607"
xml-lang="en-US">A</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3148607" localize="false"
xml-lang="en-US">A</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US">The
characters A-Z can be entered here. If a lowercase letter is entered, it is
automatically converted to a capital letter</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3149126"
xml-lang="en-US">c</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3149126" localize="false"
xml-lang="en-US">c</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3151304" xml-lang="en-US">The
characters a-z and 0-9 can be entered here. If a capital letter is entered, it
is automatically converted to a lowercase letter.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3152870"
xml-lang="en-US">C</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3152870" localize="false"
xml-lang="en-US">C</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3155071" xml-lang="en-US">The
characters a-z and 0-9 can be entered here. If a lowercase letter is entered,
it is automatically converted to a capital letter</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3159230"
xml-lang="en-US">N</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3159230" localize="false"
xml-lang="en-US">N</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154650" xml-lang="en-US">Only the
characters 0-9 can be entered.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3149383"
xml-lang="en-US">x</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3149383" localize="false"
xml-lang="en-US">x</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3153489" xml-lang="en-US">All
printable characters can be entered.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3146967"
xml-lang="en-US">X</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3146967" localize="false"
xml-lang="en-US">X</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154707" xml-lang="en-US">All
printable characters can be entered. If a lowercase letter is used, it is
automatically converted to a capital letter.</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="Section72">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EDITABLE"
id="bm_id533463" localize="false"/><paragraph role="heading" id="hd_id2128971"
xml-lang="en-US" level="2">Editable</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EDITABLE"
id="bm_id533463" localize="false"/><h2 id="hd_id2128971">Editable</h2>
<paragraph role="paragraph" id="par_id6519974" xml-lang="en-US"><ahelp
hid=".">Specifies whether the nodes of the tree control are
editable.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id4591814" xml-lang="en-US">The default
value is FALSE.</paragraph>
</section>
-<section id="Section48"><paragraph role="heading" id="hd_id3149317"
xml-lang="en-US" level="2">Graphics</paragraph>
+<section id="Section48"><h2 id="hd_id3149317">Graphics</h2>
<paragraph role="paragraph" id="par_id3147546" xml-lang="en-US"><ahelp
hid=".">Specify the source of the graphics for a button or an image control.
Click "..." to select a file.</ahelp></paragraph>
</section>
<section id="Section47">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_HEIGHT"
id="bm_id8097170" localize="false"/><paragraph role="heading" id="hd_id3154627"
xml-lang="en-US" level="2">Height</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_HEIGHT"
id="bm_id8097170" localize="false"/><h2 id="hd_id3154627">Height</h2>
<paragraph role="paragraph" id="par_id3155754" xml-lang="en-US"><ahelp
hid=".">Specify the height of the current control or the
dialog.</ahelp></paragraph>
</section>
<section id="Section46">
-<paragraph role="heading" id="hd_id3153072" xml-lang="en-US" level="2">Help
text</paragraph>
+<h2 id="hd_id3153072">Help text</h2>
<paragraph role="paragraph" id="par_id3147502" xml-lang="en-US"><ahelp
hid=".">Enter a help text that is displayed as a tip (bubble help) when the
mouse rests over the control.</ahelp></paragraph>
</section>
<section id="Section45">
-<paragraph role="heading" id="hd_id3154400" xml-lang="en-US" level="2">Help
URL</paragraph>
+<h2 id="hd_id3154400">Help URL</h2>
<paragraph role="paragraph" id="par_id3150431" xml-lang="en-US"><ahelp
hid=".">Specify the help URL that is called when you press F1 while the focus
is on a particular control. For example, use the format HID:1234 to call the
Help-ID with the number 1234.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id4171269" xml-lang="en-US">Set the
environment variable HELP_DEBUG to 1 to view the Help-IDs as extended help
tips.</paragraph>
</section>
<section id="Section43">
-<paragraph role="heading" id="hd_id3159260" xml-lang="en-US"
level="2">Incr./decrement value</paragraph>
+<h2 id="hd_id3159260">Incr./decrement value</h2>
<paragraph role="paragraph" id="par_id3145233" xml-lang="en-US"><ahelp
hid=".">Specify the increment and decrement interval for spin button
controls.</ahelp></paragraph>
</section>
<section id="Section73">
-<bookmark xml-lang="en-US"
branch="hid/EXTENSIONS_HID_PROP_INVOKES_STOP_NOT_EDITING" id="bm_id9407025"
localize="false"/><paragraph role="heading" id="hd_id539262" xml-lang="en-US"
level="2">Invokes stop mode editing</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/EXTENSIONS_HID_PROP_INVOKES_STOP_NOT_EDITING" id="bm_id9407025"
localize="false"/><h2 id="hd_id539262">Invokes stop mode editing</h2>
<paragraph role="paragraph" id="par_id234382" xml-lang="en-US"><ahelp
hid=".">Specifies what happens when editing is interrupted by selecting another
node in the tree, a change in the tree's data, or by some other
means.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id6591082" xml-lang="en-US">Setting this
property to TRUE causes the changes to be automatically saved when editing is
interrupted. FALSE means that editing is canceled and changes are
lost.</paragraph>
<paragraph role="paragraph" id="par_id9298074" xml-lang="en-US">The default
value is FALSE.</paragraph>
</section>
-<section id="Section42"><paragraph role="heading" id="hd_id3150536"
xml-lang="en-US" level="2">Label</paragraph>
+<section id="Section42"><h2 id="hd_id3150536">Label</h2>
<paragraph role="paragraph" id="par_id3146324" xml-lang="en-US"><ahelp
hid=".">Specifies the label of the current control. The label is displayed
along with the control.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3146816" xml-lang="en-US">You can create
multi-line <emph>labels</emph> by inserting manual line breaks in the label
using <emph>Shift+Enter</emph>.</paragraph>
</section>
<section id="Section41">
-<paragraph role="heading" id="hd_id3150457" xml-lang="en-US" level="2">Line
Count</paragraph>
+<h2 id="hd_id3150457">Line Count</h2>
<paragraph role="paragraph" id="par_id3149143" xml-lang="en-US"><ahelp
hid=".">Enter the number of lines to be displayed for a list control. For combo
boxes, this setting is only active if the dropdown option is enabled.
</ahelp></paragraph>
</section>
<section id="Section3">
-<paragraph role="heading" id="hd_id7468489" xml-lang="en-US"
level="2">Scrollbar</paragraph>
+<h2 id="hd_id7468489">Scrollbar</h2>
<paragraph role="paragraph" id="par_id7706228" xml-lang="en-US">Adds the
scrollbar type that you specify to a text box.</paragraph>
</section>
<section id="Section40">
-<paragraph role="heading" id="hd_id3153121" xml-lang="en-US" level="2">Small
change</paragraph>
+<h2 id="hd_id3153121">Small change</h2>
<paragraph role="paragraph" id="par_id3157875" xml-lang="en-US"><ahelp
hid=".">Specify the number of units to scroll when a user clicks an arrow on a
scrollbar.</ahelp></paragraph>
</section>
-<section id="Section39"><paragraph role="heading" id="hd_id3145221"
xml-lang="en-US" level="2">List entries</paragraph>
+<section id="Section39"><h2 id="hd_id3145221">List entries</h2>
<paragraph role="paragraph" id="par_id3154580" xml-lang="en-US"><ahelp
hid=".">Specify the entries for a list control. One line takes one list entry.
Press <emph>Shift+Enter</emph> to insert a new line.</ahelp></paragraph>
</section>
<section id="Section38">
-<paragraph role="heading" id="hd_id3149723" xml-lang="en-US" level="2">Literal
mask</paragraph>
+<h2 id="hd_id3149723">Literal mask</h2>
<paragraph role="paragraph" id="par_id3150656" xml-lang="en-US"><ahelp
hid=".">Specify the initial values to be displayed in a pattern control. This
helps the user to identify which values are allowed in a pattern control. The
literal mask is restricted by the format specified by the edit
mask.</ahelp></paragraph>
</section>
<section id="Section37">
-<paragraph role="heading" id="hd_id3149015" xml-lang="en-US" level="2">Manual
line break</paragraph>
+<h2 id="hd_id3149015">Manual line break</h2>
<paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to allow manual line breaks inside multiline
controls.</ahelp></paragraph>
</section>
<section id="Section36">
-<paragraph role="heading" id="hd_id3150463" xml-lang="en-US" level="2">Max.
text length</paragraph>
+<h2 id="hd_id3150463">Max. text length</h2>
<paragraph role="paragraph" id="par_id3150745" xml-lang="en-US"><ahelp
hid=".">Specify the maximum number of characters that the user can
enter.</ahelp></paragraph>
</section>
-<section id="Section35"><paragraph role="heading" id="hd_id3154675"
xml-lang="en-US" level="2">Multiline Input</paragraph>
+<section id="Section35"><h2 id="hd_id3154675">Multiline Input</h2>
<paragraph role="paragraph" id="par_id3144741" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to allow the input of multiple lines in the control. Press
Enter to insert a manual line break in the control.</ahelp></paragraph>
</section>
<section id="Section34">
-<paragraph role="heading" id="hd_id3154848" xml-lang="en-US"
level="2">Multiselection</paragraph>
+<h2 id="hd_id3154848">Multiselection</h2>
<paragraph role="paragraph" id="par_id3151235" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to allow the selection of multiple entries in list
controls.</ahelp></paragraph>
</section>
-<section id="Section33"><paragraph role="heading" id="hd_id3148887"
xml-lang="en-US" level="2">Name</paragraph>
+<section id="Section33"><h2 id="hd_id3148887">Name</h2>
<paragraph role="paragraph" id="par_id3154548" xml-lang="en-US"><ahelp
hid=".">Insert a name for the current control. This name is used to identify
the control.</ahelp></paragraph>
</section>
-<section id="Section32"><paragraph role="heading" id="hd_id3148739"
xml-lang="en-US" level="2">Order</paragraph>
+<section id="Section32"><h2 id="hd_id3148739">Order</h2>
<paragraph role="paragraph" id="par_id3149252" xml-lang="en-US"><ahelp
hid=".">Specify the order in which the controls receive the focus when the Tab
key is pressed in the dialog.</ahelp> On entering a dialog, the control with
the lowest order (0) receives the focus. Pressing the <emph>Tab</emph> key the
successively focuses the other controls as specified by their order
number.</paragraph>
<paragraph role="paragraph" id="par_id3155259" xml-lang="en-US">Initially, the
controls receive numbers in the order they are added to the dialog. You can
change the order numbers for controls. $[officename] Basic updates the order
numbers automatically to avoid duplicate numbers. Controls that cannot be
focused are also assigned a value but these controls are skipped when using the
Tab key.</paragraph>
</section>
<section id="Section31">
-<paragraph role="heading" id="hd_id3149511" xml-lang="en-US"
level="2">Orientation</paragraph>
+<h2 id="hd_id3149511">Orientation</h2>
<paragraph role="paragraph" id="par_id3153780" xml-lang="en-US"><ahelp
hid=".">Specify the orientation for a scrollbar control.</ahelp></paragraph>
</section>
<section id="Section30">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_STEP"
id="bm_id8616901" localize="false"/><paragraph role="heading" id="hd_id3154374"
xml-lang="en-US" level="2">Page (step)</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_STEP"
id="bm_id8616901" localize="false"/><h2 id="hd_id3154374">Page (step)</h2>
<paragraph role="paragraph" id="par_id3154109" xml-lang="en-US"><ahelp
hid=".">Specify the number of the dialog page to which the current control is
assigned or the page number of the dialog you want to edit.</ahelp> If a dialog
has only one page set its <emph>Page (Step)</emph> value to
<emph>0</emph>.</paragraph>
<paragraph role="paragraph" id="par_id3148580" xml-lang="en-US">Select
<emph>Page (Step)</emph> = 0 to make a control visible on every dialog
page.</paragraph>
<paragraph role="paragraph" id="par_id3146144" xml-lang="en-US">To switch
between dialog pages at run time, you need to create a macro that changes the
value of <emph>Page (Step)</emph>.</paragraph>
</section>
<section id="Section29">
-<paragraph role="heading" id="hd_id3154558" xml-lang="en-US"
level="2">Password characters</paragraph>
+<h2 id="hd_id3154558">Password characters</h2>
<paragraph role="paragraph" id="par_id3152787" xml-lang="en-US"><ahelp
hid=".">Enter a character to be displayed instead of the characters that are
typed. This can be used for entering passwords in text
controls.</ahelp></paragraph>
</section>
<section id="Section28">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_POSITIONX"
id="bm_id8632160" localize="false"/><paragraph role="heading" id="hd_id3148750"
xml-lang="en-US" level="2">PositionX</paragraph><paragraph role="paragraph"
id="par_id3154517" xml-lang="en-US"><ahelp hid=".">Specify the distance of the
current control from the left side of the dialog.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_POSITIONX"
id="bm_id8632160" localize="false"/><h2
id="hd_id3148750">PositionX</h2><paragraph role="paragraph" id="par_id3154517"
xml-lang="en-US"><ahelp hid=".">Specify the distance of the current control
from the left side of the dialog.</ahelp></paragraph>
</section>
<section id="Section27">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_POSITIONY"
id="bm_id7651905" localize="false"/><paragraph role="heading" id="hd_id3152767"
xml-lang="en-US" level="2">PositionY</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_POSITIONY"
id="bm_id7651905" localize="false"/><h2 id="hd_id3152767">PositionY</h2>
<paragraph role="paragraph" id="par_id3159082" xml-lang="en-US"><ahelp
hid=".">Specify the distance of the current control from the top of the
dialog.</ahelp></paragraph>
</section>
<section id="Section26">
-<paragraph role="heading" id="hd_id3159213" xml-lang="en-US" level="2">Prefix
symbol</paragraph>
+<h2 id="hd_id3159213">Prefix symbol</h2>
<paragraph role="paragraph" id="par_id3149688" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to display the currency symbol prefix in currency controls
when a number was entered.</ahelp></paragraph>
</section>
<section id="Section25">
-<paragraph role="heading" id="hd_id3149728" xml-lang="en-US"
level="2">Print</paragraph>
+<h2 id="hd_id3149728">Print</h2>
<paragraph role="paragraph" id="par_id3150001" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to include the current control in a document's
printout.</ahelp></paragraph>
</section>
<section id="Section24">
-<paragraph role="heading" id="hd_id3154671" xml-lang="en-US"
level="2">Progress value</paragraph>
+<h2 id="hd_id3154671">Progress value</h2>
<paragraph role="paragraph" id="par_id3146849" xml-lang="en-US"><ahelp
hid=".">Specify a progress value for a progress bar control.</ahelp></paragraph>
</section>
<section id="Section23">
-<paragraph role="heading" id="hd_id3153112" xml-lang="en-US"
level="2">Progress value max.</paragraph>
+<h2 id="hd_id3153112">Progress value max.</h2>
<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US"><ahelp
hid=".">Specify the maximum value of a progress bar control.</ahelp></paragraph>
</section>
<section id="Section22">
-<paragraph role="heading" id="hd_id3153569" xml-lang="en-US"
level="2">Progress value min.</paragraph>
+<h2 id="hd_id3153569">Progress value min.</h2>
<paragraph role="paragraph" id="par_id3154506" xml-lang="en-US"><ahelp
hid=".">Specify the minimum value of a progress bar control.</ahelp></paragraph>
</section>
-<section id="Section21"><paragraph role="heading" id="hd_id3150134"
xml-lang="en-US" level="2">Read-only</paragraph>
+<section id="Section21"><h2 id="hd_id3150134">Read-only</h2>
<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to prevent the user from editing the value of the current
control. The control is enabled and can be focused but not
modified.</ahelp></paragraph>
</section>
<section id="Section65">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REPEAT"
id="bm_id2982573" localize="false"/><paragraph role="heading" id="par_idN11112"
xml-lang="en-US" level="2">Repeat<comment>UFI: see spec
spinbutton_form_control.sxw</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REPEAT"
id="bm_id2982573" localize="false"/><h2 id="par_idN11112">Repeat<comment>UFI:
see spec spinbutton_form_control.sxw</comment></h2>
<paragraph role="paragraph" id="par_idN11128" xml-lang="en-US"><ahelp
hid=".">Repeats trigger events when you keep the mouse button pressed on a
control such as a spin button.</ahelp></paragraph>
</section>
<section id="Section71">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ROOT_DISPLAYED"
id="bm_id1578722" localize="false"/><paragraph role="heading" id="hd_id9579149"
xml-lang="en-US" level="2">Root displayed<comment>see
http://specs.openoffice.org/appwide/dialog_ide/New_Tree_Control_in_IDE.odt</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ROOT_DISPLAYED"
id="bm_id1578722" localize="false"/><h2 id="hd_id9579149">Root
displayed<comment>see
http://specs.openoffice.org/appwide/dialog_ide/New_Tree_Control_in_IDE.odt</comment></h2>
<paragraph role="paragraph" id="par_id7126987" xml-lang="en-US"><ahelp
hid=".">Specifies if the root node of the tree control is
displayed.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id9174779" xml-lang="en-US">If Root
displayed is set to FALSE, the root node of a model is no longer a valid node
for the tree control and can't be used with any method of
XTreeControl.</paragraph>
<paragraph role="paragraph" id="par_id594195" xml-lang="en-US">The default
value is TRUE.</paragraph>
</section>
<section id="Section74">
-<paragraph role="heading" id="hd_id7534409" xml-lang="en-US" level="2">Row
height</paragraph>
+<h2 id="hd_id7534409">Row height</h2>
<paragraph role="paragraph" id="par_id6471755" xml-lang="en-US"><ahelp
hid=".">Specifies the height of each row of a tree control, in
pixels.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id2909329" xml-lang="en-US">If the
specified value is less than or equal to zero, the row height is the maximum
height of all rows.</paragraph>
<paragraph role="paragraph" id="par_id4601580" xml-lang="en-US">The default
value is 0.</paragraph>
</section>
<section id="Section20">
-<paragraph role="heading" id="hd_id3148761" xml-lang="en-US"
level="2">Scale</paragraph>
+<h2 id="hd_id3148761">Scale</h2>
<paragraph role="paragraph" id="par_id3159134" xml-lang="en-US"><ahelp
hid=".">Scales the image to fit the control size.</ahelp></paragraph>
</section>
<section id="Scrollbar">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_HSCROLL"
id="bm_id3149895" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_VSCROLL"
id="bm_id3149517" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOW_SCROLLBARS"
id="bm_id6053651" localize="false"/><paragraph role="heading" id="hd_id7597277"
xml-lang="en-US" level="2">Scrollbar</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOW_SCROLLBARS"
id="bm_id6053651" localize="false"/><h2 id="hd_id7597277">Scrollbar</h2>
<paragraph role="paragraph" id="par_id986968" xml-lang="en-US"><ahelp
hid=".">Adds the scrollbar type that you specify to a text
box.</ahelp></paragraph>
</section>
<section id="Section19">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE"
id="bm_id3150294" localize="false"/><paragraph role="heading" id="hd_id3147370"
xml-lang="en-US" level="2">Scroll value</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE"
id="bm_id3150294" localize="false"/><h2 id="hd_id3147370">Scroll value</h2>
<paragraph role="paragraph" id="par_id3159622" xml-lang="en-US"><ahelp
hid=".">Specify the initial value of a scrollbar control. This determines the
position of the scrollbar slider.</ahelp></paragraph>
</section>
<section id="Section18">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MAX"
id="bm_id3148873" localize="false"/><paragraph role="heading" id="hd_id3155440"
xml-lang="en-US" level="2">Scroll value max.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MAX"
id="bm_id3148873" localize="false"/><h2 id="hd_id3155440">Scroll value max.</h2>
<paragraph role="paragraph" id="par_id3148877" xml-lang="en-US"><ahelp
hid=".">Specify the maximum value of a scrollbar control.</ahelp></paragraph>
</section>
<section id="Section67">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MIN"
id="bm_id6626483" localize="false"/><paragraph role="heading" id="par_idN111E4"
xml-lang="en-US" level="2">Scroll value min.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SCROLLVALUE_MIN"
id="bm_id6626483" localize="false"/><h2 id="par_idN111E4">Scroll value min.</h2>
<paragraph role="paragraph" id="par_idN111E8" xml-lang="en-US"><ahelp
hid=".">Specify the minimum value of a scrollbar control.</ahelp></paragraph>
</section>
<section id="Section69">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOWS_HANDLES"
id="bm_id7286904" localize="false"/><paragraph role="heading" id="hd_id543534"
xml-lang="en-US" level="2">Show handles</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOWS_HANDLES"
id="bm_id7286904" localize="false"/><h2 id="hd_id543534">Show handles</h2>
<paragraph role="paragraph" id="par_id5060884" xml-lang="en-US"><ahelp
hid=".">Specifies whether the handles of the nodes should be
displayed.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id4974822" xml-lang="en-US">The handles
are dotted lines that visualize the hierarchy of the tree control.</paragraph>
<paragraph role="paragraph" id="par_id7687307" xml-lang="en-US">The default
value is TRUE.</paragraph>
</section>
<section id="Section70">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOWS_ROOT_HANDLES"
id="bm_id2047486" localize="false"/><paragraph role="heading" id="hd_id4062013"
xml-lang="en-US" level="2">Show root handles</paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SHOWS_ROOT_HANDLES"
id="bm_id2047486" localize="false"/><h2 id="hd_id4062013">Show root handles</h2>
<paragraph role="paragraph" id="par_id3314004" xml-lang="en-US"><ahelp
hid=".">Specifies whether the handles of the nodes should also be displayed at
root level.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id2396313" xml-lang="en-US">The default
value is TRUE.</paragraph>
</section>
<section id="Section17">
-<paragraph role="heading" id="par_idN10EC2" xml-lang="en-US"
level="2">Selection<comment>UFI: udk.features "New property and help ID for
property browser in Basic IDE"</comment></paragraph>
+<h2 id="par_idN10EC2">Selection<comment>UFI: udk.features "New property and
help ID for property browser in Basic IDE"</comment></h2>
<paragraph role="paragraph" id="par_idN10ED8" xml-lang="en-US"><ahelp
hid=".">Specifies the sequence of the selected items, where "0" corresponds to
the first item. To select more than one item, Multiselection must be
enabled.</ahelp></paragraph>
<paragraph role="paragraph" id="par_idN10EEB" xml-lang="en-US">Click the
<emph>...</emph> button to open the <emph>Selection</emph> dialog.</paragraph>
<paragraph role="paragraph" id="par_idN10F0A" xml-lang="en-US"><ahelp
hid=".">Click the item or items that you want to select. To select more than
one item, ensure that the Multiselection option is selected.</ahelp></paragraph>
</section>
<section id="Section68">
-<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SELECTION_TYPE"
id="bm_id2208929" localize="false"/><paragraph role="heading" id="hd_id5026093"
xml-lang="en-US" level="2">Selection type<comment>see
http://specs.openoffice.org/appwide/dialog_ide/New_Tree_Control_in_IDE.odt</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SELECTION_TYPE"
id="bm_id2208929" localize="false"/><h2 id="hd_id5026093">Selection
type<comment>see
http://specs.openoffice.org/appwide/dialog_ide/New_Tree_Control_in_IDE.odt</comment></h2>
<paragraph role="paragraph" id="par_id1134067" xml-lang="en-US"><ahelp
hid=".">Specifies the selection mode that is enabled for this tree
control.</ahelp></paragraph>
</section>
-<section id="Section16"><paragraph role="heading" id="hd_id3154193"
xml-lang="en-US" level="2">Spin Button</paragraph>
+<section id="Section16"><h2 id="hd_id3154193">Spin Button</h2>
<paragraph role="paragraph" id="par_id3145298" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to add spin buttons to a numerical, currency, date, or
time control to allow increasing and decreasing the input value using arrow
buttons.</ahelp></paragraph>
</section>
<section id="Section15">
-<paragraph role="heading" id="hd_id3156267" xml-lang="en-US"
level="2">State</paragraph>
+<h2 id="hd_id3156267">State</h2>
<paragraph role="paragraph" id="par_id3150928" xml-lang="en-US"><ahelp
hid=".">Select the selection state of the current control.</ahelp></paragraph>
</section>
<section id="Section14">
-<paragraph role="heading" id="hd_id3148396" xml-lang="en-US" level="2">Strict
format</paragraph>
+<h2 id="hd_id3148396">Strict format</h2>
<paragraph role="paragraph" id="par_id3153042" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to only allow valid characters to be entered in a
numerical, currency, date, or time control.</ahelp></paragraph>
</section>
-<section id="Section13"><paragraph role="heading" id="hd_id3149538"
xml-lang="en-US" level="2">Tabstop</paragraph>
+<section id="Section13"><h2 id="hd_id3149538">Tabstop</h2>
<paragraph role="paragraph" id="par_id3148543" xml-lang="en-US"><ahelp
hid=".">Select the focus behavior of the current control when using the
<emph>Tab</emph> key.</ahelp></paragraph>
<table id="tbl_id3148388">
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3148776"
xml-lang="en-US">Default</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3153547" xml-lang="en-US">Only input
controls receive the focus when using the <emph>Tab</emph> key. Controls
without input like caption controls are omitted.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154632"
xml-lang="en-US">No</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3150475" xml-lang="en-US">When using
the tab key focusing skips the control.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3150690"
xml-lang="en-US">Yes</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3159106" xml-lang="en-US">The control
can be selected with the Tab key.</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="Section12">
-<paragraph role="heading" id="hd_id3145152" xml-lang="en-US"
level="2">Thousands Separator</paragraph>
+<h2 id="hd_id3145152">Thousands Separator</h2>
<paragraph role="paragraph" id="par_id3155085" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to display thousands separator characters in numerical and
currency controls.</ahelp></paragraph>
</section>
<section id="Section11">
-<paragraph role="heading" id="hd_id3152816" xml-lang="en-US" level="2">Time
Format</paragraph>
+<h2 id="hd_id3152816">Time Format</h2>
<paragraph role="paragraph" id="par_id3145263" xml-lang="en-US"><ahelp
hid=".">Select the format to be used for time controls.</ahelp></paragraph>
</section>
<section id="Section10">
-<paragraph role="heading" id="hd_id3153920" xml-lang="en-US" level="2">Time
max.</paragraph>
+<h2 id="hd_id3153920">Time max.</h2>
<paragraph role="paragraph" id="par_id3155401" xml-lang="en-US"><ahelp
hid=".">Specify the maximum time value for a time control.</ahelp></paragraph>
</section>
<section id="Section9">
-<paragraph role="heading" id="hd_id3163818" xml-lang="en-US" level="2">Time
min.</paragraph>
+<h2 id="hd_id3163818">Time min.</h2>
<paragraph role="paragraph" id="par_id3156262" xml-lang="en-US"><ahelp
hid=".">Specify the minimum time value for a time control.</ahelp></paragraph>
</section>
<section id="Section8">
-<paragraph role="heading" id="hd_id3148638" xml-lang="en-US"
level="2">Title</paragraph>
+<h2 id="hd_id3148638">Title</h2>
<paragraph role="paragraph" id="par_id3147169" xml-lang="en-US"><ahelp
hid=".">Specify the title of the dialog. Click the border of the dialog to
select the dialog.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153716" xml-lang="en-US">
<emph>Titles</emph> are only used for labeling a dialog and can only contain
one line. Please note that if you work with macros, controls are only called
through their <emph>Name</emph> property.</paragraph>
</section>
<section id="Section7">
-<paragraph role="heading" id="hd_id3152594" xml-lang="en-US"
level="2">Tristate</paragraph>
+<h2 id="hd_id3152594">Tristate</h2>
<paragraph role="paragraph" id="par_id3149825" xml-lang="en-US"><ahelp
hid=".">Select "Yes" to allow a check box to have three states (checked,
unchecked, and grayed out) instead of two (checked and
unchecked).</ahelp></paragraph>
</section>
<section id="Section6">
-<paragraph role="heading" id="hd_id3150614" xml-lang="en-US"
level="2">Value</paragraph>
+<h2 id="hd_id3150614">Value</h2>
<paragraph role="paragraph" id="par_id3154315" xml-lang="en-US"><ahelp
hid=".">Specify the value for the current control.</ahelp></paragraph>
</section>
<section id="Section5">
-<paragraph role="heading" id="hd_id3152480" xml-lang="en-US" level="2">Value
max.</paragraph>
+<h2 id="hd_id3152480">Value max.</h2>
<paragraph role="paragraph" id="par_id3163823" xml-lang="en-US"><ahelp
hid=".">Specify the maximum value for the current control.</ahelp></paragraph>
</section>
<section id="Section4">
-<paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="2">Value
min.</paragraph>
+<h2 id="hd_id3149276">Value min.</h2>
<paragraph role="paragraph" id="par_id3145088" xml-lang="en-US"><ahelp
hid=".">Specify the minimum value for the current control.</ahelp></paragraph>
</section>
<section id="Section2">
-<paragraph role="heading" id="hd_id3149712" xml-lang="en-US" level="2">Visible
size</paragraph>
+<h2 id="hd_id3149712">Visible size</h2>
<paragraph role="paragraph" id="par_id3149445" xml-lang="en-US"><ahelp
hid=".">Specify the length of the slider of a scrollbar
control.</ahelp></paragraph>
</section>
-<section id="Section1"><paragraph role="heading" id="hd_id3152472"
xml-lang="en-US" level="2">Width</paragraph>
+<section id="Section1"><h2 id="hd_id3152472">Width</h2>
<paragraph role="paragraph" id="par_id3157963" xml-lang="en-US"><ahelp
hid=".">Specify the width of the current control or dialog.</ahelp></paragraph>
</section>
</sort></body>
diff --git a/source/text/scalc/01/04060101.xhp
b/source/text/scalc/01/04060101.xhp
index 4d4054d35..0c0e4bd84 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -34,7 +34,7 @@
</bookmark>
<h1 id="hd_id3148946">Database Functions</h1>
- <h3 id="hd_id721616440441374">Overview</h3>
+ <h3 id="hd_id721616440441374">Overview</h3>
<paragraph xml-lang="en-US" id="par_id3145173"
role="paragraph"><variable id="datenbanktext">The twelve functions in the
Database category help you to analyze a simple database that occupies a
rectangular spreadsheet area comprising columns and rows, with the data
organized as one row for each record.</variable> The header cell of each column
displays the name of the column and that name usually reflects the contents of
each cell in that column.</paragraph>
<paragraph role="paragraph" id="par_id631615842419413">The functions
in the Database category take three arguments as follows:</paragraph>
<list type="ordered">
@@ -51,7 +51,7 @@
<paragraph role="paragraph" id="par_id101615842794525">These arguments
are described more fully below.</paragraph>
<paragraph role="paragraph" id="par_id241615842810077">All functions
have the same outline concept of operation. The first logical step is to use
the specified <emph>SearchCriteria</emph> to identify the subset of records in
the <emph>Database</emph> that are to be used during subsequent calculations.
The second step is to extract the data values and perform the calculations
associated with the specific function (average, sum, product, and so on). The
values processed are those in the <emph>DatabaseField</emph> column of the
selected records.</paragraph>
<note id="par_id981615978852310">Calc treats dates and logical values
(TRUE and FALSE) as numeric when calculating with these functions.</note>
-
+
<h3 id="hd_id911615888814785">Database Function Arguments</h3>
<paragraph role="paragraph" id="par_id911615888833104">The following
argument definitions apply for all functions in the Database
category:</paragraph>
<list type="ordered">
@@ -90,19 +90,19 @@
</listitem>
</list>
-
+
<h3 id="hd_id481615892281210">Defining Search Criteria</h3>
- <paragraph role="paragraph" id="par_id691615892329680">The number of
columns occupied by the <emph>SearchCriteria</emph> area need not be the same
as the width of the <emph>Database</emph> area. All headings that appear in the
first row of <emph>SearchCriteria</emph> must be identical to headings in the
first row of <emph>Database</emph>. However, not all headings in
<emph>Database</emph> need appear in the first row of
<emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can
appear multiple times in the first row of
<emph>SearchCriteria</emph>.</paragraph>
- <paragraph role="paragraph" id="par_id541615892358897">Search criteria
are entered into the cells of the second and subsequent rows of the
<emph>SearchCriteria</emph> area, below the row containing headings. Blank
cells within the <emph>SearchCriteria</emph> area are ignored.</paragraph>
+ <paragraph role="paragraph" id="par_id691615892329680">The number of
columns occupied by the <emph>SearchCriteria</emph> area need not be the same
as the width of the <emph>Database</emph> area. All headings that appear in the
first row of <emph>SearchCriteria</emph> must be identical to headings in the
first row of <emph>Database</emph>. However, not all headings in
<emph>Database</emph> need appear in the first row of
<emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can
appear multiple times in the first row of
<emph>SearchCriteria</emph>.</paragraph>
+ <paragraph role="paragraph" id="par_id541615892358897">Search criteria
are entered into the cells of the second and subsequent rows of the
<emph>SearchCriteria</emph> area, below the row containing headings. Blank
cells within the <emph>SearchCriteria</emph> area are ignored.</paragraph>
<paragraph role="paragraph" id="par_id151615892882441">Create criteria
in the cells of the <emph>SearchCriteria</emph> area using the comparison
operators <, <=, =, <>, >=, and >. = is assumed if a cell is
not empty but does not start with a comparison operator.</paragraph>
<paragraph role="paragraph" id="par_id561615893059337">If you write
several criteria in one row, they are connected by AND. If you write several
criteria in different rows, they are connected by OR.</paragraph>
<paragraph role="paragraph" id="par_id401615893095178">Criteria can be
created using wildcards, providing that wildcards have been enabled via the
<menuitem>Enable wildcards in formulas</menuitem> option on the <link
href="text/shared/optionen/01060500.xhp" name="Spreadsheet -
Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link> dialog. When interoperability with Microsoft
Excel is important for your spreadsheet, this option should be
enabled.</paragraph>
- <paragraph role="paragraph" id="par_id921615893158111">Even more
powerful criteria can be created using regular expressions, providing that
regular expressions have been enabled via the <menuitem>Enable regular
expressions in formulas</menuitem> option on the <link
href="text/shared/optionen/01060500.xhp" name="Spreadsheet -
Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link> dialog.</paragraph>
-
+ <paragraph role="paragraph" id="par_id921615893158111">Even more
powerful criteria can be created using regular expressions, providing that
regular expressions have been enabled via the <menuitem>Enable regular
expressions in formulas</menuitem> option on the <link
href="text/shared/optionen/01060500.xhp" name="Spreadsheet -
Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link> dialog.</paragraph>
+
<embed href="text/shared/00/00000001.xhp#regexnumex"/>
-
+
<paragraph role="paragraph" id="par_id881615893236930">Another setting
that affects how the search criteria are handled is the <menuitem>Search
criteria = and <> must apply to whole cells</menuitem> option on the
<link href="text/shared/optionen/01060500.xhp" name="Spreadsheet -
Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link> dialog. This option controls whether the search
criteria you set for the Database functions must match the whole cell exactly.
When interoperability with Microsoft Excel is important for your spreadsheet,
this option should be enabled.</paragraph>
-
+
<h3 id="hd_id3150329">Examples of Database Function Use</h3>
<paragraph xml-lang="en-US" id="par_id3153713" role="paragraph">The
following table provides an example database table that is utilized to
demonstrate how to use the functions in the Database category. The cell range
A1:E10 contains fictitious information about the guests invited to Joe's
birthday party. The following information is given for each guest - name,
school grade, age in years, distance to school in meters, and weight in
kilograms.</paragraph>
@@ -341,9 +341,9 @@
</tablecell>
</tablerow>
</table>
-
+
<paragraph role="paragraph" id="par_id221616245476190">The following
six examples use the database table above, combined with different search
criteria areas.</paragraph>
-
+
<h4 id="hd_id861616245631924">Example 1</h4>
<table id="tab_id191616245640932">
<tablerow>
@@ -419,7 +419,7 @@
</table>
<paragraph role="paragraph" id="par_id451616246535763">As in this
simple example, it is sometimes desirable (but not essential) to place the
search criteria area directly under the database table, with the columns of the
two areas vertically aligned. Blank entries in the search criteria area are
ignored. With the above example database table and this search criteria area,
insert the formula <item type="input">=DCOUNT(A1:E10;;A12:E14)</item> into an
empty cell elsewhere in the sheet to count how many of Joe’s guests travel
further than 600 meters to school. The value 5 is returned (counting Betty,
Daniel, Eva, Harry, and Irene).</paragraph>
- <paragraph role="paragraph" id="par_id731616246561901">Note also that
the formula <item type="input">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly
the same value, demonstrating that it is only necessary for the search criteria
area to contain relevant column headings. </paragraph>
+ <paragraph role="paragraph" id="par_id731616246561901">Note also that
the formula <item type="input">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly
the same value, demonstrating that it is only necessary for the search criteria
area to contain relevant column headings. </paragraph>
<h4 id="hd_id191616246773750">Example 2</h4>
<table id="tab_id861616246804093">
@@ -493,10 +493,10 @@
</tablerow>
</table>
- <paragraph role="paragraph" id="par_id361616251794063">In this example
the search criteria area contains only two headings and these are not
vertically aligned with the corresponding headings in the example database
table. Since there are two conditions in the same row, these are connected by
AND. With the above example database table and this search criteria area,
insert the formula <item type="input">=DCOUNT(A1:E10;;B12:C13)</item> into an
empty cell elsewhere in the sheet to count how many of Joe’s guests are in
grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and
Irene).</paragraph>
-
+ <paragraph role="paragraph" id="par_id361616251794063">In this example
the search criteria area contains only two headings and these are not
vertically aligned with the corresponding headings in the example database
table. Since there are two conditions in the same row, these are connected by
AND. With the above example database table and this search criteria area,
insert the formula <item type="input">=DCOUNT(A1:E10;;B12:C13)</item> into an
empty cell elsewhere in the sheet to count how many of Joe’s guests are in
grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and
Irene).</paragraph>
+
<h4 id="hd_id221616251986854">Example 3</h4>
-
+
<table id="tab_id851616251871487">
<tablerow>
<tablecell>
@@ -567,9 +567,9 @@
</tablerow>
</table>
- <paragraph role="paragraph" id="par_id351616252313215">In this example
the search criteria area contains only one heading. Since there are two
conditions in consecutive rows, these are connected by OR. With the above
example database table and this search criteria area, insert the formula <item
type="input">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in
the sheet to count how many of Joe’s guests are either 9 or 10 years old. The
value 4 is returned (counting Andy, Betty, Charles, and Harry).</paragraph>
+ <paragraph role="paragraph" id="par_id351616252313215">In this example
the search criteria area contains only one heading. Since there are two
conditions in consecutive rows, these are connected by OR. With the above
example database table and this search criteria area, insert the formula <item
type="input">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in
the sheet to count how many of Joe’s guests are either 9 or 10 years old. The
value 4 is returned (counting Andy, Betty, Charles, and Harry).</paragraph>
- <h4 id="hd_id71616252395407">Example 4 </h4>
+ <h4 id="hd_id71616252395407">Example 4 </h4>
<table id="tab_id741616252413665">
<tablerow>
<tablecell>
@@ -641,8 +641,8 @@
</tablerow>
</table>
- <paragraph role="paragraph" id="par_id991616252981928">In this example
the search criteria area contains two occurrences of the same heading. Since
there are two conditions in the same row, these are connected by AND. With the
above example database table and this search criteria area, insert the formula
<item type="input">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere
in the sheet to count how many of Joe’s guests are aged between 8 and 10
(inclusive). The value 6 is returned (counting Andy, Betty, Charles, Eva,
Harry, and Irene). </paragraph>
-
+ <paragraph role="paragraph" id="par_id991616252981928">In this example
the search criteria area contains two occurrences of the same heading. Since
there are two conditions in the same row, these are connected by AND. With the
above example database table and this search criteria area, insert the formula
<item type="input">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere
in the sheet to count how many of Joe’s guests are aged between 8 and 10
(inclusive). The value 6 is returned (counting Andy, Betty, Charles, Eva,
Harry, and Irene). </paragraph>
+
<h4 id="hd_id561616253067881">Example 5</h4>
<table id="tab_id601616253073598">
<tablerow>
@@ -715,7 +715,7 @@
<paragraph role="paragraph" id="par_id91616253394127">This simple
example shows the use of wildcards. For this example to work as intended,
select to enable wildcards at <link href="text/shared/optionen/01060500.xhp"
name="Spreadsheet - Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link>. With the above example database table and this
search criteria area, insert the formula <item
type="input">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in
the sheet to count how many of Joe’s guests have names that begin with the
letter “F”. The value 1 is returned (counting Frank).</paragraph>
-
+
<h4 id="hd_id121616253593255">Example 6</h4>
<table id="tab_id441616253599063">
<tablerow>
@@ -787,12 +787,12 @@
</table>
<paragraph role="paragraph" id="par_id631616253692350">This simple
example shows the use of regular expressions. For this example to work as
intended, select to enable regular expressions at <link
href="text/shared/optionen/01060500.xhp" name="Spreadsheet -
Calculate"><switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc
- Calculate</menuitem></link>. With the above example database table and this
search criteria area, insert the formula <item
type="input">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in
the sheet to count how many of Joe’s guests have names that begin with the
letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and
Charles).</paragraph>
-
- <sort order="asc">
+
+ <sort order="asc" descendant="h2">
<section id="Section1">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150882">
- <bookmark_value>DCOUNT function</bookmark_value>
- <bookmark_value>counting rows;with numeric values</bookmark_value>
+<bookmark_value>DCOUNT function</bookmark_value>
+<bookmark_value>counting rows;with numeric values</bookmark_value>
</bookmark><comment>mw added "counting rows;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL" id="bm_id3152926"
localize="false"/>
<h2 id="hd_id3150882">DCOUNT</h2>
@@ -800,82 +800,82 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153218"
role="code">DCOUNT(Database; [DatabaseField]; SearchCriteria)</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153623"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">600" (this search criterion will match
records in the database table that have a value greater than 600 in the
Distance column).</paragraph>
<paragraph role="paragraph" id="par_id441616368480646">Insert
the formula <input>=DCOUNT(A1:E10;; A12:E13)</input> into an empty cell
elsewhere in the sheet to calculate how many of Joe’s party guests travel
further than 600 meters to school. The value 5 is returned.</paragraph>
- <paragraph role="paragraph" id="par_id361616368488119">The
same result is obtained if you use the formula <input>=DCOUNT(A1:E10;
"Distance"; A12:E13)</input>, because all entries in the Distance column are
numeric. However, if you use the formula <input>=DCOUNT(A1:E10; "Name";
A12:E13)</input>, the value 0 is returned because all entries in the Name
column are non-numeric.</paragraph>
+ <paragraph role="paragraph" id="par_id361616368488119">The
same result is obtained if you use the formula <input>=DCOUNT(A1:E10;
"Distance"; A12:E13)</input>, because all entries in the Distance column are
numeric. However, if you use the formula <input>=DCOUNT(A1:E10; "Name";
A12:E13)</input>, the value 0 is returned because all entries in the Name
column are non-numeric.</paragraph>
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="index" id="bm_id3156123">
- <bookmark_value>DCOUNTA function</bookmark_value>
- <bookmark_value>records;counting in Calc databases</bookmark_value>
- <bookmark_value>counting rows;with numeric or alphanumeric
values</bookmark_value>
+<bookmark_value>DCOUNTA function</bookmark_value>
+<bookmark_value>records;counting in Calc databases</bookmark_value>
+<bookmark_value>counting rows;with numeric or alphanumeric
values</bookmark_value>
</bookmark><comment>mw added "records;" and "counting rows;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL2"
id="bm_id3154055" localize="false"/>
<h2 id="hd_id3156123">DCOUNTA</h2>
<paragraph xml-lang="en-US" id="par_id3156110"
role="paragraph"><ahelp hid="HID_FUNC_DBANZAHL2">DCOUNTA counts the number of
cells (fields) of the specified column that are not blank, for all rows
(database records) that match the specified search criteria.</ahelp> Blank
cells of the specified column are not counted. However, if no column is
specified, DCOUNTA returns the count of all records that match the specified
search criteria irrespective of their contents.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146893"
role="code">DCOUNTA(Database; [DatabaseField]; SearchCriteria)</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153982"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">600" (this search criterion will match
records in the database table that have a value greater than 600 in the
Distance column).</paragraph>
<paragraph role="paragraph" id="par_id61616368616093">Insert
the formula <input>=DCOUNTA(A1:E10;; A12:E13)</input> into an empty cell
elsewhere in the sheet to calculate how many of Joe’s party guests travel
further than 600 meters to school. The value 5 is returned.</paragraph>
- <paragraph role="paragraph" id="par_id841616368623207">The
same result is obtained if you use the formula <input>=DCOUNTA(A1:E10;
"Distance"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; "Name";
A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA
counts both numeric and alphanumeric values in the column indicated by the
<emph>DatabaseField</emph> argument.</paragraph>
+ <paragraph role="paragraph" id="par_id841616368623207">The
same result is obtained if you use the formula <input>=DCOUNTA(A1:E10;
"Distance"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; "Name";
A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA
counts both numeric and alphanumeric values in the column indicated by the
<emph>DatabaseField</emph> argument.</paragraph>
</section>
-
+
<section id="Section3">
<bookmark xml-lang="en-US" branch="index" id="bm_id3147256">
- <bookmark_value>DGET function</bookmark_value>
- <bookmark_value>cell contents;searching in Calc databases</bookmark_value>
- <bookmark_value>searching;cell contents in Calc databases</bookmark_value>
+<bookmark_value>DGET function</bookmark_value>
+<bookmark_value>cell contents;searching in Calc databases</bookmark_value>
+<bookmark_value>searching;cell contents in Calc databases</bookmark_value>
</bookmark><comment>mw added "cell contents;" and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBAUSZUG" id="bm_id3149198"
localize="false"/>
<h2 id="hd_id3147256">DGET</h2>
<paragraph xml-lang="en-US" id="par_id3152801"
role="paragraph"><ahelp hid="HID_FUNC_DBAUSZUG">DGET returns the contents of
the cell (field) of the specified column, for the single row (database record)
that matches the specified search criteria.</ahelp></paragraph>
- <paragraph role="paragraph" id="par_id171616180137385">Calc
reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE!
error (wrong data type) if no matches are found. A #VALUE! error is also
reported if a single match is found but the relevant cell is empty.</paragraph>
-
+ <paragraph role="paragraph" id="par_id171616180137385">Calc
reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE!
error (wrong data type) if no matches are found. A #VALUE! error is also
reported if a single match is found but the relevant cell is empty.</paragraph>
+
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154696"
role="code">DGET(Database; DatabaseField; SearchCriteria)</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3155388"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell C13 which should contain "11" (this search criterion will match
records in the database table that have a value of 11 in the Age
column).</paragraph>
<paragraph xml-lang="en-US" id="par_id3153096"
role="paragraph">Insert the formula <input>=DGET(A1:E10; "Name";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the name of
Joe’s party guest who is age 11. The name Daniel is returned.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150524"
role="paragraph">If you change the value in cell C13 to “10”, then the formula
<input>=DGET(A1:E10; "Name"; A12:E13)</input> returns an invalid argument error
(Err:502). The reflects that multiple records match the specified criterion
(both Betty and Charles are age 10).</paragraph>
</section>
-
+
<section id="Section4">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149766">
- <bookmark_value>DMAX function</bookmark_value>
- <bookmark_value>maximum values in Calc databases</bookmark_value>
- <bookmark_value>searching;maximum values in columns</bookmark_value>
+<bookmark_value>DMAX function</bookmark_value>
+<bookmark_value>maximum values in Calc databases</bookmark_value>
+<bookmark_value>searching;maximum values in columns</bookmark_value>
</bookmark><comment>mw added "maximum..." and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMAX" id="bm_id3158401"
localize="false"/>
<h2 id="hd_id3149766">DMAX</h2>
<paragraph xml-lang="en-US" id="par_id3154903"
role="paragraph"><ahelp hid="HID_FUNC_DBMAX">DMAX calculates the maximum value
across the cells (fields) of the specified column that contain numeric values,
for all rows (database records) that match the specified search
criteria.</ahelp> Blank cells or cells containing non-numeric characters are
not included.</paragraph>
<paragraph role="paragraph" id="par_id51616180409281">Returns
0 if no matches are found, or if there are no non-zero numeric values in the
cells of the specified column for the matching records.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3159157"
role="code">DMAX(Database; DatabaseField; SearchCriteria)</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148442"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3148804"
role="paragraph">Insert the formula <input>=DMAX(A1:E10; "Distance";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum
distance in meters that any of Joe’s party guests travel to school. The value
1200 is returned.</paragraph>
</section>
-
+
<section id="Section5">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159141">
- <bookmark_value>DMIN function</bookmark_value>
- <bookmark_value>minimum values in Calc databases</bookmark_value>
- <bookmark_value>searching;minimum values in columns</bookmark_value>
+<bookmark_value>DMIN function</bookmark_value>
+<bookmark_value>minimum values in Calc databases</bookmark_value>
+<bookmark_value>searching;minimum values in columns</bookmark_value>
</bookmark><comment>mw added "minimum..." and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMIN" id="bm_id3159152"
localize="false"/>
<h2 id="hd_id3159141">DMIN</h2>
<paragraph xml-lang="en-US" id="par_id3154261"
role="paragraph"><ahelp hid="HID_FUNC_DBMIN">DMIN calculates the minimum value
across the cells (fields) of the specified column that contain numeric values,
for all rows (database records) that match the specified search
criteria.</ahelp> Blank cells or cells containing non-numeric characters are
not included.</paragraph>
<paragraph role="paragraph" id="par_id901616180605426">Returns
0 if no matches are found, or if there are no non-zero numeric values in the
cells of the specified column for the matching records.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3148479"
role="code">DMIN(Database; DatabaseField; SearchCriteria)</paragraph>
@@ -883,30 +883,30 @@
<paragraph xml-lang="en-US" id="par_id3148925"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3149161"
role="paragraph">Insert the formula <input>=DMIN(A1:E10; "Distance";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum
distance in meters that any of Joe’s party guests travel to school. The value
150 is returned.</paragraph>
</section>
-
+
<section id="Section6">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154274">
- <bookmark_value>DAVERAGE function</bookmark_value>
- <bookmark_value>averages; in Calc databases</bookmark_value>
- <bookmark_value>calculating;averages in Calc databases</bookmark_value>
+<bookmark_value>DAVERAGE function</bookmark_value>
+<bookmark_value>averages; in Calc databases</bookmark_value>
+<bookmark_value>calculating;averages in Calc databases</bookmark_value>
</bookmark><comment>mw added "averages;..." and "calculating;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMITTELWERT"
id="bm_id3166435" localize="false"/>
<h2 id="hd_id3154274">DAVERAGE</h2>
<paragraph xml-lang="en-US" id="par_id3166453"
role="paragraph"><ahelp hid="HID_FUNC_DBMITTELWERT">DAVERAGE calculates the
average of the numeric values in the cells (fields) of the specified column,
for all rows (database records) that match the specified search
criteria.</ahelp> Non-numeric values in those cells are ignored.</paragraph>
<paragraph role="paragraph" id="par_id31615978739452">Returns
a #DIV/0! error if no records match the specified search criteria, or if there
are no numeric values in the cells of the specified column for the matching
records.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150710"
role="code">DAVERAGE(Database; DatabaseField; SearchCriteria)</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149104"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
- <paragraph role="paragraph" id="par_id201616368312277">Insert
the formula <input>=DAVERAGE(A1:E10; "Distance"; A12:E13)</input> into an empty
cell elsewhere in the sheet to calculate the average distance in meters
travelled to school by Joe’s party guests. The value 666.67 is
returned.</paragraph>
+ <paragraph role="paragraph" id="par_id201616368312277">Insert
the formula <input>=DAVERAGE(A1:E10; "Distance"; A12:E13)</input> into an empty
cell elsewhere in the sheet to calculate the average distance in meters
travelled to school by Joe’s party guests. The value 666.67 is
returned.</paragraph>
</section>
-
+
<section id="Section7">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159269">
- <bookmark_value>DPRODUCT function</bookmark_value>
- <bookmark_value>multiplying;cell contents in Calc
databases</bookmark_value>
+<bookmark_value>DPRODUCT function</bookmark_value>
+<bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>
</bookmark><comment>mw added "multiplying..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBPRODUKT"
id="bm_id3159281" localize="false"/>
<h2 id="hd_id3159269">DPRODUCT</h2>
@@ -918,13 +918,13 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148986"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell C13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
- <paragraph role="paragraph" id="par_id91616368981807">Insert
the formula <input>=DPRODUCT(A1:E10; "Age"; A12:E13)</input> into an empty cell
elsewhere in the sheet to calculate the product of the ages in years of Joe’s
party guests. The value 279417600 is returned.</paragraph>
+ <paragraph role="paragraph" id="par_id91616368981807">Insert
the formula <input>=DPRODUCT(A1:E10; "Age"; A12:E13)</input> into an empty cell
elsewhere in the sheet to calculate the product of the ages in years of Joe’s
party guests. The value 279417600 is returned.</paragraph>
</section>
-
+
<section id="Section8">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148462">
- <bookmark_value>DSTDEV function</bookmark_value>
- <bookmark_value>standard deviations in databases;based on a
sample</bookmark_value>
+<bookmark_value>DSTDEV function</bookmark_value>
+<bookmark_value>standard deviations in databases;based on a
sample</bookmark_value>
</bookmark><comment>mw added "standard deviations...;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABW" id="bm_id3145370"
localize="false"/>
<h2 id="hd_id3148462">DSTDEV</h2>
@@ -939,11 +939,11 @@
<paragraph xml-lang="en-US" id="par_id3149934"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:D13 are blank and that
cell E13 contains ">0" (this search criterion is intended to match all records
in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3150630"
role="paragraph">Insert the formula <input>=DSTDEV(A1:E10; "Weight";
A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the
sample standard deviation of the weights in kg of Joe’s party guests. The value
5.5 is returned.</paragraph>
</section>
-
+
<section id="Section9">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150429">
- <bookmark_value>DSTDEVP function</bookmark_value>
- <bookmark_value>standard deviations in databases;based on
populations</bookmark_value>
+<bookmark_value>DSTDEVP function</bookmark_value>
+<bookmark_value>standard deviations in databases;based on
populations</bookmark_value>
</bookmark><comment>mw added "standard deviations...;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABWN"
id="bm_id3149523" localize="false"/>
<h2 id="hd_id3150429">DSTDEVP</h2>
@@ -957,12 +957,12 @@
<paragraph xml-lang="en-US" id="par_id3155431"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:D13 are blank and that
cell E13 contains ">0" (this search criterion is intended to match all records
in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3148411"
role="paragraph">Insert the formula <input>=DSTDEVP(A1:E10; "Weight";
A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the
population standard deviation of the weights in kg of Joe’s party guests. The
value 5.18545 is returned.</paragraph>
</section>
-
+
<section id="Section10">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154794">
- <bookmark_value>DSUM function</bookmark_value>
- <bookmark_value>calculating;sums in Calc databases</bookmark_value>
- <bookmark_value>sums;cells in Calc databases</bookmark_value>
+<bookmark_value>DSUM function</bookmark_value>
+<bookmark_value>calculating;sums in Calc databases</bookmark_value>
+<bookmark_value>sums;cells in Calc databases</bookmark_value>
</bookmark><comment>mw added "calculating;" and "sums;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSUMME" id="bm_id3148687"
localize="false"/>
<h2 id="hd_id3154794">DSUM</h2>
@@ -976,11 +976,11 @@
<paragraph xml-lang="en-US" id="par_id3152766"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3151312"
role="paragraph">Insert the formula <input>=DSUM(A1:E10; "Distance";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the total
distance in meters that all of Joe’s party guests travel to school. The value
6000 is returned.</paragraph>
</section>
-
+
<section id="Section11">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155614">
- <bookmark_value>DVAR function</bookmark_value>
- <bookmark_value>variances;based on samples</bookmark_value>
+<bookmark_value>DVAR function</bookmark_value>
+<bookmark_value>variances;based on samples</bookmark_value>
</bookmark><comment>mw added "variances;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZ"
id="bm_id3159391" localize="false"/>
<h2 id="hd_id3155614">DVAR</h2>
@@ -995,11 +995,11 @@
<paragraph xml-lang="en-US" id="par_id3153701"
role="paragraph">The example database table giving information about the guests
invited to Joe’s birthday party (described above) should occupy cells A1:E10.
The content of cells A12:E12 should be identical to the header labels for the
database table in cells A1:E1. Make sure that cells A13:E13 are blank, except
for cell D13 which should contain ">0" (this search criterion is intended to
match all records in the database table).</paragraph>
<paragraph xml-lang="en-US" id="par_id3153676"
role="paragraph">Insert the formula <input>=DVAR(A1:E10; "Distance";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample
variance of the distances in meters that Joe’s party guests travel to school.
The value 193125 is returned.</paragraph>
</section>
-
+
<section id="Section12">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153880">
- <bookmark_value>DVARP function</bookmark_value>
- <bookmark_value>variances;based on populations</bookmark_value>
+<bookmark_value>DVARP function</bookmark_value>
+<bookmark_value>variances;based on populations</bookmark_value>
</bookmark><comment>mw added "variances;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZEN"
id="bm_id3153891" localize="false"/>
<h2 id="hd_id3153880">DVARP</h2>
@@ -1014,7 +1014,7 @@
<paragraph xml-lang="en-US" id="par_id3147322"
role="paragraph">Insert the formula <input>=DVARP(A1:E10; "Distance";
A12:E13)</input> into an empty cell elsewhere in the sheet to find the
population variance of the distances in meters that Joe’s party guests travel
to school. The value 171666.67 is returned.</paragraph>
</section>
</sort>
-
+
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
diff --git a/source/text/scalc/01/04060103.xhp
b/source/text/scalc/01/04060103.xhp
index 92438920f..1b14bdc26 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -33,7 +33,7 @@
<h1 id="hd_id3143284">Financial Functions Part One</h1>
<paragraph xml-lang="en-US" id="par_id3149095"
role="paragraph"><variable id="finanztext">This category contains the
mathematical finance functions of <item type="productname">%PRODUCTNAME</item>
Calc.
</variable></paragraph>
-<sort order="asc">
+<sort order="asc" descendant="h2">
<section id="amordegrc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153366"><bookmark_value>AMORDEGRC function</bookmark_value>
<bookmark_value>depreciations;degressive
amortizations</bookmark_value>
diff --git a/source/text/scalc/01/04060105.xhp
b/source/text/scalc/01/04060105.xhp
index 8351a7a8b..24f8d9729 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -52,7 +52,7 @@
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#logical"/>
</section>
-<sort order="asc">
+<sort order="asc" descendant="h2">
<section id="Section10">
<embed href="text/scalc/01/04060104.xhp#isna"/>
diff --git a/source/text/scalc/main0200.xhp b/source/text/scalc/main0200.xhp
index a72af0ea9..33d72cc7b 100644
--- a/source/text/scalc/main0200.xhp
+++ b/source/text/scalc/main0200.xhp
@@ -36,7 +36,6 @@
<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US">This submenu
lists the toolbars that are available in spreadsheets.<embedvar
href="text/shared/00/00000007.xhp#symbolleistenneu"/>
</paragraph>
</section>
-<sort order="asc">
<section id="Section1">
<embed href="text/shared/main0201.xhp#standardbar"/>
</section>
@@ -73,6 +72,5 @@
<section id="Section10">
<embed href="text/swriter/classificationbar.xhp#toolbar"/>
</section>
-</sort>
</body>
</helpdocument>
diff --git a/source/text/sdraw/main0200.xhp b/source/text/sdraw/main0200.xhp
index 3af4d7713..abc3f8124 100644
--- a/source/text/sdraw/main0200.xhp
+++ b/source/text/sdraw/main0200.xhp
@@ -30,7 +30,7 @@
<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US">This section
provides an overview of the toolbars available in $[officename]
Draw.</paragraph>
</section>
<embed href="text/shared/00/00000007.xhp#symbolleistenneu"/>
-<sort order="asc">
+
<section id="Section1">
<embed href="text/shared/main0201.xhp#standardbar"/>
</section>
@@ -70,6 +70,5 @@
<section id="Section12">
<embed href="text/simpress/02/10110000.xhp#insert"/>
</section>
-</sort>
</body>
</helpdocument>
diff --git a/source/text/shared/00/00000002.xhp
b/source/text/shared/00/00000002.xhp
index 351ebaaba..c1d0cc3fa 100644
--- a/source/text/shared/00/00000002.xhp
+++ b/source/text/shared/00/00000002.xhp
@@ -39,7 +39,7 @@
<h1 id="hd_id3150702" xml-lang="en-US"><link
href="text/shared/00/00000002.xhp" name="Glossary of Internet Terms">Glossary
of Internet Terms</link></h1>
<paragraph id="par_id3155577" role="paragraph" xml-lang="en-US">If you are a
newcomer to the Internet, you will be confronted with unfamiliar terms:
browser, bookmark, email, homepage, search engine, and many others. To make
your first steps easier, this glossary explains some of the more important
terminology you may find in the Internet, intranet, mail and news.</paragraph>
</section>
-<sort>
+<sort order="asc" descendant="h2">
<section id="cmis">
diff --git a/source/text/shared/00/00000005.xhp
b/source/text/shared/00/00000005.xhp
index d21098403..a98c58632 100644
--- a/source/text/shared/00/00000005.xhp
+++ b/source/text/shared/00/00000005.xhp
@@ -36,7 +36,7 @@
</section>
<paragraph xml-lang="en-US" id="par_id3154873" role="paragraph">Use the
glossary to look up unfamiliar terms found in any $[officename]
application.</paragraph>
-<sort order="asc">
+<sort order="asc" descendant="h2">
<section id="ascii">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3156192"><bookmark_value>ASCII; definition</bookmark_value>
diff --git a/source/text/shared/01/02100200.xhp
b/source/text/shared/01/02100200.xhp
index 096c905c0..f590e61a8 100644
--- a/source/text/shared/01/02100200.xhp
+++ b/source/text/shared/01/02100200.xhp
@@ -32,7 +32,8 @@
<h2 id="hd_id3150944" xml-lang="en-US">Options</h2>
<paragraph role="paragraph" id="par_id3151384" xml-lang="en-US">Select the
attributes that you want to search for.</paragraph>
-<sort order="asc"><section id="Section1">
+<sort order="asc" descendant="h3">
+ <section id="Section1">
<h3 id="hd_id3149245" xml-lang="en-US">Keep with Next Paragraph</h3>
<paragraph role="paragraph" id="par_id3154760" xml-lang="en-US">Finds the
<emph>Keep With Next Paragraph</emph> attribute.</paragraph>
</section>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
