diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-04-14 22:45:22 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-04-15 11:15:43 +0200 |
| commit | 1653fc7e7a458eea57fe1547650abc1a76a42c03 (patch) | |
| tree | 487d44c70c6578ad34e0cca01c1d68ec39c67dd5 /source/text | |
| parent | a1a06717d857022304899fa8607af38b4ce57ac3 (diff) | |
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.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/sbasic/shared/01170101.xhp | 226 | ||||
| -rw-r--r-- | source/text/scalc/01/04060101.xhp | 156 | ||||
| -rw-r--r-- | source/text/scalc/01/04060103.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/01/04060105.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/main0200.xhp | 2 | ||||
| -rw-r--r-- | source/text/sdraw/main0200.xhp | 3 | ||||
| -rw-r--r-- | source/text/shared/00/00000002.xhp | 2 | ||||
| -rw-r--r-- | source/text/shared/00/00000005.xhp | 2 | ||||
| -rw-r--r-- | source/text/shared/01/02100200.xhp | 3 |
9 files changed, 196 insertions, 202 deletions
diff --git a/source/text/sbasic/shared/01170101.xhp b/source/text/sbasic/shared/01170101.xhp index eda7765b41..35768089c6 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 4d4054d359..0c0e4bd848 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 92438920f4..1b14bdc26e 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 8351a7a8bc..24f8d9729c 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 a72af0ea9a..33d72cc7b4 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 3af4d77134..abc3f8124c 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 351ebaaba7..c1d0cc3fab 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 d210984038..a98c586324 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 096c905c0d..f590e61a80 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> |