This is an automated email from the ASF dual-hosted git repository.
mseidel pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/trunk by this push:
new 55e6cc2a7c Remove 'oldref' entries (work in progress)
55e6cc2a7c is described below
commit 55e6cc2a7c3c23278ae699411e4c74c52e6aec1d
Author: mseidel <msei...@apache.org>
AuthorDate: Sat Feb 3 13:05:01 2024 +0100
Remove 'oldref' entries (work in progress)
---
.../source/text/sbasic/shared/03090408.xhp | 22 +--
.../helpcontent2/source/text/scalc/01/02170000.xhp | 14 +-
.../helpcontent2/source/text/scalc/01/03090000.xhp | 8 +-
.../helpcontent2/source/text/scalc/01/06030700.xhp | 6 +-
.../helpcontent2/source/text/scalc/01/12040000.xhp | 12 +-
.../helpcontent2/source/text/scalc/01/12050000.xhp | 10 +-
.../source/text/scalc/guide/super_subscript.xhp | 14 +-
.../source/text/scalc/guide/text_rotate.xhp | 14 +-
.../source/text/shared/01/03150100.xhp | 20 +-
main/helpcontent2/source/text/shared/01/guides.xhp | 2 +-
.../source/text/shared/02/01170102.xhp | 202 ++++++++++-----------
.../source/text/shared/02/01170801.xhp | 12 +-
.../source/text/shared/autopi/01020400.xhp | 6 +-
.../text/shared/explorer/database/05000000.xhp | 12 +-
.../source/text/shared/guide/data_search.xhp | 6 +-
.../source/text/simpress/02/04070000.xhp | 11 +-
.../source/text/simpress/02/11070000.xhp | 8 +-
.../source/text/simpress/02/11080000.xhp | 8 +-
.../helpcontent2/source/text/simpress/main0103.xhp | 6 +-
.../helpcontent2/source/text/simpress/main0114.xhp | 10 +-
.../source/text/swriter/01/05100400.xhp | 8 +-
.../source/text/swriter/02/18120000.xhp | 6 +-
.../text/swriter/guide/insert_graphic_dialog.xhp | 10 +-
.../source/text/swriter/guide/navigator.xhp | 10 +-
main/helpcontent2/source/text/swriter/main0210.xhp | 4 +-
25 files changed, 211 insertions(+), 230 deletions(-)
diff --git a/main/helpcontent2/source/text/sbasic/shared/03090408.xhp
b/main/helpcontent2/source/text/sbasic/shared/03090408.xhp
index db6ac0127d..0ef8ccb6d0 100644
--- a/main/helpcontent2/source/text/sbasic/shared/03090408.xhp
+++ b/main/helpcontent2/source/text/sbasic/shared/03090408.xhp
@@ -33,17 +33,17 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153311">
<bookmark_value>Stop statement</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/sbasic/shared/03090408.xhp" name="Stop
Statement [Runtime]">Stop Statement [Runtime]</link></paragraph>
-<paragraph role="paragraph" id="par_id3154142" xml-lang="en-US" l10n="U"
oldref="2">Stops the execution of the Basic program.</paragraph>
+<paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"
l10n="U"><link href="text/sbasic/shared/03090408.xhp" name="Stop Statement
[Runtime]">Stop Statement [Runtime]</link></paragraph>
+<paragraph role="paragraph" id="par_id3154142" xml-lang="en-US" l10n="U">Stops
the execution of the Basic program.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3153126" xml-lang="en-US" level="2"
l10n="U" oldref="3">Syntax:</paragraph>
-<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US" l10n="U"
oldref="4">Stop</paragraph>
-<paragraph role="heading" id="hd_id3156344" xml-lang="en-US" level="2"
l10n="U" oldref="5">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3148552" xml-lang="en-US" l10n="U"
oldref="6">Sub ExampleStop</paragraph>
-<paragraph role="paragraph" id="par_id3153897" xml-lang="en-US" l10n="U"
oldref="7">Dim iVar As Single</paragraph>
-<paragraph role="paragraph" id="par_id3153380" xml-lang="en-US" l10n="U"
oldref="8">iVar = 36</paragraph>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U"
oldref="9">Stop</paragraph>
-<paragraph role="paragraph" id="par_id3148799" xml-lang="en-US" l10n="U"
oldref="10">Msgbox Sqr(iVar)</paragraph>
-<paragraph role="paragraph" id="par_id3151043" xml-lang="en-US" l10n="U"
oldref="11">end sub</paragraph>
+<paragraph role="heading" id="hd_id3153126" xml-lang="en-US" level="2"
l10n="U">Syntax:</paragraph>
+<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US"
l10n="U">Stop</paragraph>
+<paragraph role="heading" id="hd_id3156344" xml-lang="en-US" level="2"
l10n="U">Example:</paragraph>
+<paragraph role="paragraph" id="par_id3148552" xml-lang="en-US" l10n="U">Sub
ExampleStop</paragraph>
+<paragraph role="paragraph" id="par_id3153897" xml-lang="en-US" l10n="U">Dim
iVar As Single</paragraph>
+<paragraph role="paragraph" id="par_id3153380" xml-lang="en-US" l10n="U">iVar
= 36</paragraph>
+<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"
l10n="U">Stop</paragraph>
+<paragraph role="paragraph" id="par_id3148799" xml-lang="en-US"
l10n="U">Msgbox Sqr(iVar)</paragraph>
+<paragraph role="paragraph" id="par_id3151043" xml-lang="en-US" l10n="U">end
sub</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/02170000.xhp
b/main/helpcontent2/source/text/scalc/01/02170000.xhp
index 9f16a24a45..85a488a89c 100644
--- a/main/helpcontent2/source/text/scalc/01/02170000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/02170000.xhp
@@ -36,16 +36,16 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id7030283"
localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id3150769"
localize="false"/>
-<paragraph role="heading" id="hd_id3156424" xml-lang="en-US" level="1"
l10n="U" oldref="1">Delete Sheet</paragraph>
-<paragraph role="paragraph" id="par_id3153193" xml-lang="en-US" l10n="U"
oldref="2"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes
the current sheet after query confirmation.</ahelp>
+<paragraph role="heading" id="hd_id3156424" xml-lang="en-US" level="1"
l10n="U">Delete Sheet</paragraph>
+<paragraph role="paragraph" id="par_id3153193" xml-lang="en-US"
l10n="U"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes
the current sheet after query confirmation.</ahelp>
</variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000402.xhp#btaloes"/>
</section>
-<paragraph role="note" id="par_id3145801" xml-lang="en-US" l10n="CHG"
oldref="7">You cannot delete a sheet while <emph>Edit - Changes - Record</emph>
is activated.</paragraph>
-<paragraph role="heading" id="hd_id3147124" xml-lang="en-US" level="2"
l10n="U" oldref="3">Yes</paragraph>
-<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US" l10n="U"
oldref="4">Deletes the current sheet.</paragraph>
-<paragraph role="heading" id="hd_id3149412" xml-lang="en-US" level="2"
l10n="U" oldref="5">No</paragraph>
-<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" l10n="U"
oldref="6">Cancels the dialog. No delete is performed.</paragraph>
+<paragraph role="note" id="par_id3145801" xml-lang="en-US" l10n="CHG">You
cannot delete a sheet while <emph>Edit - Changes - Record</emph> is
activated.</paragraph>
+<paragraph role="heading" id="hd_id3147124" xml-lang="en-US" level="2"
l10n="U">Yes</paragraph>
+<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US"
l10n="U">Deletes the current sheet.</paragraph>
+<paragraph role="heading" id="hd_id3149412" xml-lang="en-US" level="2"
l10n="U">No</paragraph>
+<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US"
l10n="U">Cancels the dialog. No delete is performed.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/03090000.xhp
b/main/helpcontent2/source/text/scalc/01/03090000.xhp
index 2d1dfbb723..3e9c245625 100644
--- a/main/helpcontent2/source/text/scalc/01/03090000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/03090000.xhp
@@ -36,13 +36,13 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:InputLineVisible" id="bm_id268003"
localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:InputLineVisible"
id="bm_id3148663" localize="false"/>
-<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/scalc/01/03090000.xhp" name="Formula
Bar">Formula Bar</link></paragraph>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U"
oldref="2"><ahelp hid=".uno:InputLineVisible">Shows or hides the Formula Bar,
which is used for entering and editing formulas.</ahelp> The Formula Bar is the
most important tool when working with spreadsheets.</paragraph>
+<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1"
l10n="U"><link href="text/scalc/01/03090000.xhp" name="Formula Bar">Formula
Bar</link></paragraph>
+<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US"
l10n="U"><ahelp hid=".uno:InputLineVisible">Shows or hides the Formula Bar,
which is used for entering and editing formulas.</ahelp> The Formula Bar is the
most important tool when working with spreadsheets.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US" l10n="U"
oldref="4">To hide the Formula Bar, unmark the menu item.</paragraph>
+<paragraph role="paragraph" id="par_id3154686" xml-lang="en-US" l10n="U">To
hide the Formula Bar, unmark the menu item.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000403.xhp#rechenleiste"/>
</section>
-<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US" l10n="U"
oldref="3">If the Formula Bar is hidden, you can still edit cells by activating
the edit mode with F2. After editing cells, accept the changes by pressing
Enter, or discard entries by pressing Esc. Esc is also used to exit the edit
mode.</paragraph>
+<paragraph role="paragraph" id="par_id3145787" xml-lang="en-US" l10n="U">If
the Formula Bar is hidden, you can still edit cells by activating the edit mode
with F2. After editing cells, accept the changes by pressing Enter, or discard
entries by pressing Esc. Esc is also used to exit the edit mode.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/06030700.xhp
b/main/helpcontent2/source/text/scalc/01/06030700.xhp
index 67857c7c48..ca41d021a1 100644
--- a/main/helpcontent2/source/text/scalc/01/06030700.xhp
+++ b/main/helpcontent2/source/text/scalc/01/06030700.xhp
@@ -36,12 +36,12 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode"
id="bm_id5785183" localize="false"/><!-- HID added by script -->
<bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode"
id="bm_id3148491" localize="false"/>
-<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/scalc/01/06030700.xhp" name="Fill
Mode">Fill Mode</link></paragraph>
-<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US" l10n="U"
oldref="2"><ahelp hid=".uno:AuditingFillMode">Activates the Fill Mode in the
Detective. The mouse pointer changes to a special symbol, and you can click any
cell to see a trace to the precedent cell.</ahelp> To exit this mode, press
Escape or click the <emph>End Fill Mode</emph> command in the context
menu.</paragraph>
+<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"
l10n="U"><link href="text/scalc/01/06030700.xhp" name="Fill Mode">Fill
Mode</link></paragraph>
+<paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"
l10n="U"><ahelp hid=".uno:AuditingFillMode">Activates the Fill Mode in the
Detective. The mouse pointer changes to a special symbol, and you can click any
cell to see a trace to the precedent cell.</ahelp> To exit this mode, press
Escape or click the <emph>End Fill Mode</emph> command in the context
menu.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#fuellmodus"/>
</section>
-<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US" l10n="U"
oldref="3">The <emph>Fill Mode</emph> function is identical to the <link
href="text/scalc/01/06030100.xhp" name="Trace Precedent">Trace Precedent</link>
command if you call this mode for the first time. Use the context menu to
select further options for the Fill Mode and to exit this mode.</paragraph>
+<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US" l10n="U">The
<emph>Fill Mode</emph> function is identical to the <link
href="text/scalc/01/06030100.xhp" name="Trace Precedent">Trace Precedent</link>
command if you call this mode for the first time. Use the context menu to
select further options for the Fill Mode and to exit this mode.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/12040000.xhp
b/main/helpcontent2/source/text/scalc/01/12040000.xhp
index 24a93aeb04..ca6935f6e8 100644
--- a/main/helpcontent2/source/text/scalc/01/12040000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12040000.xhp
@@ -31,18 +31,18 @@
<body>
<section id="filter">
<bookmark xml-lang="en-US" branch="hid/.uno:FilterMenu"
id="bm_id102920080228246" localize="false"/>
-<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/scalc/01/12040000.xhp"
name="Filter">Filter</link></paragraph>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US" l10n="U"
oldref="2"><ahelp hid=".">Shows commands to filter your
data.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="1"
l10n="U"><link href="text/scalc/01/12040000.xhp"
name="Filter">Filter</link></paragraph>
+<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"
l10n="U"><ahelp hid=".">Shows commands to filter your data.</ahelp></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US" l10n="U"
oldref="7">$[officename] automatically recognizes predefined database
ranges.</paragraph>
+<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US"
l10n="U">$[officename] automatically recognizes predefined database
ranges.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnftr"/>
</section>
-<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US" l10n="U"
oldref="3">The following filtering options are available:</paragraph>
+<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US" l10n="U">The
following filtering options are available:</paragraph>
<embed href="text/scalc/01/12040100.xhp#autofilter"/>
-<paragraph role="heading" id="hd_id3153728" xml-lang="en-US" level="2"
l10n="CHG" oldref="4"><link href="text/shared/02/12090000.xhp" name="Standard
filter">Standard filter</link></paragraph>
+<paragraph role="heading" id="hd_id3153728" xml-lang="en-US" level="2"
l10n="CHG"><link href="text/shared/02/12090000.xhp" name="Standard
filter">Standard filter</link></paragraph>
<embed href="text/shared/02/12090000.xhp#standardfilter"/>
-<paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="2"
l10n="U" oldref="5"><link href="text/scalc/01/12040300.xhp" name="Advanced
filter">Advanced filter</link></paragraph>
+<paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="2"
l10n="U"><link href="text/scalc/01/12040300.xhp" name="Advanced
filter">Advanced filter</link></paragraph>
<embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
<embed href="text/scalc/01/12040400.xhp#filterentfernen"/>
<embed href="text/scalc/01/12040500.xhp#autofilterausblenden"/>
diff --git a/main/helpcontent2/source/text/scalc/01/12050000.xhp
b/main/helpcontent2/source/text/scalc/01/12050000.xhp
index 0fb352bcaa..d7f655ccba 100644
--- a/main/helpcontent2/source/text/scalc/01/12050000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12050000.xhp
@@ -31,16 +31,16 @@
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:DataSubTotals" id="bm_id1614637"
localize="false"/><!-- HID added by script -->
<bookmark branch="hid/.uno:DataSubTotals" xml-lang="en-US" id="bm_id3154515"/>
-<paragraph role="heading" level="1" id="hd_id3153822" l10n="U"
xml-lang="en-US" oldref="1">Subtotals</paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3145119" xml-lang="en-US"
oldref="2"><variable id="teilergebnisse"><ahelp hid=".uno:DataSubTotals"
visibility="visible">Calculates subtotals for the columns that you
select.</ahelp></variable> $[officename] uses the SUM function to automatically
calculate the subtotal and grand total values in a labeled range. You can also
use other functions to perform the calculation. $[officename] automatically
recognizes a defined database area when you [...]
+<paragraph role="heading" level="1" id="hd_id3153822" l10n="U"
xml-lang="en-US">Subtotals</paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3145119"
xml-lang="en-US"><variable id="teilergebnisse"><ahelp hid=".uno:DataSubTotals"
visibility="visible">Calculates subtotals for the columns that you
select.</ahelp></variable> $[officename] uses the SUM function to automatically
calculate the subtotal and grand total values in a labeled range. You can also
use other functions to perform the calculation. $[officename] automatically
recognizes a defined database area when you place the c [...]
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dntegs"/>
</section>
-<paragraph role="paragraph" id="par_id3153896" l10n="U" xml-lang="en-US"
oldref="3">For example, you can generate a sales summary for a certain postal
code based on data from a client database.</paragraph>
+<paragraph role="paragraph" id="par_id3153896" l10n="U" xml-lang="en-US">For
example, you can generate a sales summary for a certain postal code based on
data from a client database.</paragraph>
<embed href="text/scalc/01/12050100.xhp#gruppe"/>
<embed href="text/scalc/01/12050200.xhp#optionen"/>
<embed href="text/shared/00/00000001.xhp#zurueck"/>
-<paragraph role="heading" level="2" id="hd_id3163708" l10n="U"
xml-lang="en-US" oldref="4">Delete</paragraph>
-<paragraph role="paragraph" id="par_id3154125" l10n="U" xml-lang="en-US"
oldref="5">Deletes the subtotal rows in the selected area.</paragraph>
+<paragraph role="heading" level="2" id="hd_id3163708" l10n="U"
xml-lang="en-US">Delete</paragraph>
+<paragraph role="paragraph" id="par_id3154125" l10n="U"
xml-lang="en-US">Deletes the subtotal rows in the selected area.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/guide/super_subscript.xhp
b/main/helpcontent2/source/text/scalc/guide/super_subscript.xhp
index f8621f79e7..ab0c2542fe 100644
--- a/main/helpcontent2/source/text/scalc/guide/super_subscript.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/super_subscript.xhp
@@ -35,25 +35,25 @@
<bookmark_value>cells; text super/sub</bookmark_value>
<bookmark_value>characters;superscript/subscript</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3151112" xml-lang="en-US" level="1"
l10n="U" oldref="1"><variable id="super_subscript"><link
href="text/scalc/guide/super_subscript.xhp" name="Text Superscript /
Subscript">Text Superscript / Subscript</link>
+<paragraph role="heading" id="hd_id3151112" xml-lang="en-US" level="1"
l10n="U"><variable id="super_subscript"><link
href="text/scalc/guide/super_subscript.xhp" name="Text Superscript /
Subscript">Text Superscript / Subscript</link>
</variable></paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3154684" xml-lang="en-US" l10n="U"
oldref="2">In the cell, select the character that you want to put in
superscript or subscript.</paragraph>
-<paragraph role="listitem" id="par_id3150439" xml-lang="en-US" l10n="U"
oldref="3">If, for example, you want to write H20 with a subscript 2, select
the 2 in the cell (not in the input line).</paragraph>
+<paragraph role="listitem" id="par_id3154684" xml-lang="en-US" l10n="U">In the
cell, select the character that you want to put in superscript or
subscript.</paragraph>
+<paragraph role="listitem" id="par_id3150439" xml-lang="en-US" l10n="U">If,
for example, you want to write H20 with a subscript 2, select the 2 in the cell
(not in the input line).</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3149260" xml-lang="en-US" l10n="U"
oldref="4">Open the context menu for the selected character and choose
<emph>Character</emph>. You will see the <emph>Character</emph>
dialog.</paragraph>
+<paragraph role="listitem" id="par_id3149260" xml-lang="en-US" l10n="U">Open
the context menu for the selected character and choose <emph>Character</emph>.
You will see the <emph>Character</emph> dialog.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3153142" xml-lang="en-US" l10n="U"
oldref="5">Click the <emph>Font Position</emph> tab.</paragraph>
+<paragraph role="listitem" id="par_id3153142" xml-lang="en-US" l10n="U">Click
the <emph>Font Position</emph> tab.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3153954" xml-lang="en-US" l10n="U"
oldref="6">Select the <emph>Subscript</emph> option and click OK.</paragraph>
+<paragraph role="listitem" id="par_id3153954" xml-lang="en-US" l10n="U">Select
the <emph>Subscript</emph> option and click OK.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US" l10n="U"
oldref="7"><link href="text/shared/01/05020500.xhp" name="Context menu -
Character - Font Position">Context menu - Character - Font
Position</link></paragraph>
+<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US" l10n="U"><link
href="text/shared/01/05020500.xhp" name="Context menu - Character - Font
Position">Context menu - Character - Font Position</link></paragraph>
<embed href="text/swriter/guide/subscript.xhp#subscript"/>
</section>
</body>
diff --git a/main/helpcontent2/source/text/scalc/guide/text_rotate.xhp
b/main/helpcontent2/source/text/scalc/guide/text_rotate.xhp
index f07052538c..8a795740a1 100644
--- a/main/helpcontent2/source/text/scalc/guide/text_rotate.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/text_rotate.xhp
@@ -34,25 +34,25 @@
<bookmark_value>rotating; text in cells</bookmark_value>
<bookmark_value>text in cells; writing vertically</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3151112" role="heading" level="1"
l10n="U" oldref="1"><variable id="text_rotate"><link
href="text/scalc/guide/text_rotate.xhp" name="Rotating Text">Rotating
Text</link>
+<paragraph xml-lang="en-US" id="hd_id3151112" role="heading" level="1"
l10n="U"><variable id="text_rotate"><link
href="text/scalc/guide/text_rotate.xhp" name="Rotating Text">Rotating
Text</link>
</variable></paragraph>
<list type="ordered">
<listitem>
-<paragraph xml-lang="en-US" id="par_id3145171" role="listitem" l10n="U"
oldref="2">Select the cells whose text you want to rotate.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145171" role="listitem" l10n="U">Select
the cells whose text you want to rotate.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3155133" role="listitem" l10n="U"
oldref="3">Choose <emph>Format - Cells</emph>. You will see the <emph>Format
Cells</emph> dialog.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155133" role="listitem" l10n="U">Choose
<emph>Format - Cells</emph>. You will see the <emph>Format Cells</emph>
dialog.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3155854" role="listitem" l10n="U"
oldref="4">Click the <emph>Alignment</emph> tab.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155854" role="listitem" l10n="U">Click
the <emph>Alignment</emph> tab.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="CHG"
oldref="5">In the <emph>Text orientation</emph> area use the mouse to select in
the preview wheel the direction in which the text is to be rotated. Click
<emph>OK</emph>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="CHG">In
the <emph>Text orientation</emph> area use the mouse to select in the preview
wheel the direction in which the text is to be rotated. Click
<emph>OK</emph>.</paragraph>
</listitem>
</list><comment>removed a wrong para, i104207</comment>
<section id="relatedtopics">
-<paragraph xml-lang="en-US" id="par_id3148456" role="paragraph" l10n="U"
oldref="7"><link href="text/scalc/01/05020000.xhp" name="Format - Cells">Format
- Cells</link></paragraph>
-<paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U"
oldref="8"><link href="text/shared/01/05340300.xhp" name="Format - Cells -
Alignment">Format - Cells - Alignment</link></paragraph>
+<paragraph xml-lang="en-US" id="par_id3148456" role="paragraph" l10n="U"><link
href="text/scalc/01/05020000.xhp" name="Format - Cells">Format -
Cells</link></paragraph>
+<paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U"><link
href="text/shared/01/05340300.xhp" name="Format - Cells - Alignment">Format -
Cells - Alignment</link></paragraph>
</section>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/shared/01/03150100.xhp
b/main/helpcontent2/source/text/shared/01/03150100.xhp
index 481779eb00..87b2a90ede 100644
--- a/main/helpcontent2/source/text/shared/01/03150100.xhp
+++ b/main/helpcontent2/source/text/shared/01/03150100.xhp
@@ -30,18 +30,18 @@
</meta>
<body>
<!-- removed HID SFX2:MODALDIALOG:DLG_SFX_QUERYDELETE -->
-<paragraph role="heading" level="1" id="hd_id3150278" l10n="U"
xml-lang="en-US" oldref="1">Confirm Delete</paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3148668" xml-lang="en-US"
oldref="2"><ahelp hid="SFX2:MODALDIALOG:DLG_SFX_QUERYDELETE"
visibility="visible">Confirms or cancels the deletion.</ahelp></paragraph>
+<paragraph role="heading" level="1" id="hd_id3150278" l10n="U"
xml-lang="en-US">Confirm Delete</paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3148668"
xml-lang="en-US"><ahelp hid="SFX2:MODALDIALOG:DLG_SFX_QUERYDELETE"
visibility="visible">Confirms or cancels the deletion.</ahelp></paragraph>
<!-- removed HID SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_YES -->
-<paragraph role="heading" level="2" id="hd_id3152821" l10n="U"
xml-lang="en-US" oldref="3">Delete</paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3150040" xml-lang="en-US"
oldref="4"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_YES"
visibility="visible">Performs the deletion in the current
file.</ahelp></paragraph>
+<paragraph role="heading" level="2" id="hd_id3152821" l10n="U"
xml-lang="en-US">Delete</paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3150040"
xml-lang="en-US"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_YES"
visibility="visible">Performs the deletion in the current
file.</ahelp></paragraph>
<!-- removed HID SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_ALL -->
-<paragraph role="heading" level="2" id="hd_id3149999" l10n="U"
xml-lang="en-US" oldref="5">Delete All</paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3155616" xml-lang="en-US"
oldref="6"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_ALL"
visibility="visible">Performs the deletion in all selected
files.</ahelp></paragraph>
+<paragraph role="heading" level="2" id="hd_id3149999" l10n="U"
xml-lang="en-US">Delete All</paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3155616"
xml-lang="en-US"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_ALL"
visibility="visible">Performs the deletion in all selected
files.</ahelp></paragraph>
<!-- removed HID SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_NO -->
-<paragraph role="heading" level="2" id="hd_id3157991" l10n="U"
xml-lang="en-US" oldref="7">Do Not Delete</paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3147043" xml-lang="en-US"
oldref="8"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_NO"
visibility="visible">Rejects the deletion for the current
file.</ahelp></paragraph>
-<paragraph role="heading" level="2" id="hd_id3149346" l10n="U"
xml-lang="en-US" oldref="9">Cancel</paragraph>
-<paragraph role="paragraph" id="par_id3148620" l10n="U" xml-lang="en-US"
oldref="10">Cancels the deletion in the current file and any other selected
files.</paragraph>
+<paragraph role="heading" level="2" id="hd_id3157991" l10n="U"
xml-lang="en-US">Do Not Delete</paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3147043"
xml-lang="en-US"><ahelp hid="SFX2:PUSHBUTTON:DLG_SFX_QUERYDELETE:BTN_NO"
visibility="visible">Rejects the deletion for the current
file.</ahelp></paragraph>
+<paragraph role="heading" level="2" id="hd_id3149346" l10n="U"
xml-lang="en-US">Cancel</paragraph>
+<paragraph role="paragraph" id="par_id3148620" l10n="U"
xml-lang="en-US">Cancels the deletion in the current file and any other
selected files.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/shared/01/guides.xhp
b/main/helpcontent2/source/text/shared/01/guides.xhp
index 7cf0a602a5..522ff1f3d2 100644
--- a/main/helpcontent2/source/text/shared/01/guides.xhp
+++ b/main/helpcontent2/source/text/shared/01/guides.xhp
@@ -35,7 +35,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:SnapLinesMenu" id="bm_id2510147"
localize="false"/>
<paragraph role="heading" id="par_idN10562" xml-lang="en-US" level="1"
l10n="NEW"><link href="text/shared/01/guides.xhp">Guides</link></paragraph>
-<paragraph role="paragraph" id="par_id3146313" xml-lang="en-US" l10n="CHG"
oldref="7"><ahelp hid=".">Specifies the display options for
guides.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3146313" xml-lang="en-US"
l10n="CHG"><ahelp hid=".">Specifies the display options for
guides.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000403.xhp#guides"/>
diff --git a/main/helpcontent2/source/text/shared/02/01170102.xhp
b/main/helpcontent2/source/text/shared/02/01170102.xhp
index 78e7c36929..dd67a602b2 100644
--- a/main/helpcontent2/source/text/shared/02/01170102.xhp
+++ b/main/helpcontent2/source/text/shared/02/01170102.xhp
@@ -39,14 +39,14 @@
<bookmark_value>links;between cells and controls</bookmark_value>
<bookmark_value>controls;assigning data sources</bookmark_value>
</bookmark><comment>MW made "cells..." a two level entry, changed "linked
cells;" to "links;" and "list contents" to "lists;"</comment>
-<paragraph role="heading" id="hd_id3155413" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/02/01170102.xhp"
name="Data">Data</link></paragraph>
-<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US" l10n="U"
oldref="2">The <emph>Data</emph> tab page allows you to assign a data source to
the selected control.</paragraph>
+<paragraph role="heading" id="hd_id3155413" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/02/01170102.xhp"
name="Data">Data</link></paragraph>
+<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US" l10n="U">The
<emph>Data</emph> tab page allows you to assign a data source to the selected
control.</paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00040501.xhp#controleigenschaftendaten"/>
</section>
-<paragraph role="note" id="par_id3148773" xml-lang="en-US" l10n="U"
oldref="64">For forms with database links, the associated database is defined
in the <link href="text/shared/02/01170200.xhp" name="Form Properties">Form
Properties</link>. You will find the functions for this on the <link
href="text/shared/02/01170203.xhp" name="Data"><emph>Data</emph></link> tab
page.</paragraph>
-<paragraph role="paragraph" id="par_id3149377" xml-lang="en-US" l10n="U"
oldref="65">The possible settings of the <emph>Data</emph> tab page of a
control depend on the respective control. You will only see the options that
are available for the current control and context. The following fields are
available:</paragraph>
+<paragraph role="note" id="par_id3148773" xml-lang="en-US" l10n="U">For forms
with database links, the associated database is defined in the <link
href="text/shared/02/01170200.xhp" name="Form Properties">Form
Properties</link>. You will find the functions for this on the <link
href="text/shared/02/01170203.xhp" name="Data"><emph>Data</emph></link> tab
page.</paragraph>
+<paragraph role="paragraph" id="par_id3149377" xml-lang="en-US" l10n="U">The
possible settings of the <emph>Data</emph> tab page of a control depend on the
respective control. You will only see the options that are available for the
current control and context. The following fields are available:</paragraph>
<sort order="asc">
<section id="Section10">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_UNCHECKEDREFVALUE"
id="bm_id7939695" localize="false"/>
@@ -55,233 +55,215 @@
</section>
<section id="Section23">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REFVALUE"
id="bm_id3147327" localize="false"/>
-<paragraph role="heading" id="hd_id3159121" xml-lang="en-US" level="2"
l10n="CHG" oldref="71">Reference value (on)<comment>UFI: moved section from
01170101, changed name</comment></paragraph>
-<paragraph role="paragraph" id="par_id3163812" xml-lang="en-US" l10n="U"
oldref="141"><ahelp hid="HID_PROP_REFVALUE" visibility="hidden">You can enter a
reference value for the web form, which will be remitted to a server when
sending the form. With database forms, the value entered is written in the
database field, assigned to the control field.</ahelp> You can assign a
reference value to option buttons and check boxes. The reference value will be
remitted to a server when sending the w [...]
-<paragraph role="paragraph" id="par_id3150225" xml-lang="en-US" l10n="U"
oldref="204">
-<emph>Reference values for web forms</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3147611" xml-lang="en-US" l10n="U"
oldref="205">Reference values are useful if you design a web form and the
information on the status of the control is to be transmitted to a server. If
the control is clicked by the user, the corresponding reference value is sent
to the server.</paragraph>
-<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US" l10n="U"
oldref="194">For example, if you have two control fields for the options
"feminine" and "masculine", and assign a reference value of 1 to the field
"feminine" and the value 2 to the "masculine" field, the value 1 is transmitted
to the server if a user clicks the "feminine" field and value 2 is sent if the
"masculine" field is clicked.</paragraph>
-<paragraph role="paragraph" id="par_id3150260" xml-lang="en-US" l10n="U"
oldref="206">
-<emph>Reference values for database forms</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3150654" xml-lang="en-US" l10n="U"
oldref="207">For database forms, you can also characterize the status of an
option or a check box by a reference value, storing it in the database. If you
have a set of three options, for example "in progress", "completed", and
"resubmission", with the respective reference values, "ToDo", "OK", and "RS",
these reference values appear in the database if the respective option is
clicked.</paragraph>
+<paragraph role="heading" id="hd_id3159121" xml-lang="en-US" level="2"
l10n="CHG">Reference value (on)<comment>UFI: moved section from 01170101,
changed name</comment></paragraph>
+<paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"
l10n="U"><ahelp hid="HID_PROP_REFVALUE" visibility="hidden">You can enter a
reference value for the web form, which will be remitted to a server when
sending the form. With database forms, the value entered is written in the
database field, assigned to the control field.</ahelp> You can assign a
reference value to option buttons and check boxes. The reference value will be
remitted to a server when sending the web form. With [...]
+<paragraph role="paragraph" id="par_id3150225" xml-lang="en-US"
l10n="U"><emph>Reference values for web forms</emph></paragraph>
+<paragraph role="paragraph" id="par_id3147611" xml-lang="en-US"
l10n="U">Reference values are useful if you design a web form and the
information on the status of the control is to be transmitted to a server. If
the control is clicked by the user, the corresponding reference value is sent
to the server.</paragraph>
+<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US" l10n="U">For
example, if you have two control fields for the options "feminine" and
"masculine", and assign a reference value of 1 to the field "feminine" and the
value 2 to the "masculine" field, the value 1 is transmitted to the server if a
user clicks the "feminine" field and value 2 is sent if the "masculine" field
is clicked.</paragraph>
+<paragraph role="paragraph" id="par_id3150260" xml-lang="en-US"
l10n="U"><emph>Reference values for database forms</emph></paragraph>
+<paragraph role="paragraph" id="par_id3150654" xml-lang="en-US" l10n="U">For
database forms, you can also characterize the status of an option or a check
box by a reference value, storing it in the database. If you have a set of
three options, for example "in progress", "completed", and "resubmission", with
the respective reference values, "ToDo", "OK", and "RS", these reference values
appear in the database if the respective option is clicked.</paragraph>
</section>
<section id="Section1">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CONTROLSOURCE"
id="bm_id3157976" localize="false"/>
-<paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2"
l10n="U" oldref="5">Data field</paragraph>
-<paragraph role="paragraph" id="par_id3155852" xml-lang="en-US" l10n="U"
oldref="6"><ahelp hid="HID_PROP_CONTROLSOURCE" visibility="hidden">Specifies
the field of the data source table to which the control refers.</ahelp> With
database forms, you can link controls with the data fields.</paragraph>
-<paragraph role="paragraph" id="par_id3153224" xml-lang="en-US" l10n="U"
oldref="75">You have several possibilities:</paragraph>
+<paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2"
l10n="U">Data field</paragraph>
+<paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"
l10n="U"><ahelp hid="HID_PROP_CONTROLSOURCE" visibility="hidden">Specifies the
field of the data source table to which the control refers.</ahelp> With
database forms, you can link controls with the data fields.</paragraph>
+<paragraph role="paragraph" id="par_id3153224" xml-lang="en-US" l10n="U">You
have several possibilities:</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3159110" xml-lang="en-US" l10n="U"
oldref="66">First case: There is only one table in the form.</paragraph>
-<paragraph role="listitem" id="par_id3156356" xml-lang="en-US" l10n="U"
oldref="67">Under <emph>Data field</emph>, specify the field of the data source
table whose contents you want to be displayed.</paragraph>
+<paragraph role="listitem" id="par_id3159110" xml-lang="en-US" l10n="U">First
case: There is only one table in the form.</paragraph>
+<paragraph role="listitem" id="par_id3156356" xml-lang="en-US" l10n="U">Under
<emph>Data field</emph>, specify the field of the data source table whose
contents you want to be displayed.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3146898" xml-lang="en-US" l10n="U"
oldref="76">Second case: The control belongs to a subform that is created by an
SQL query.</paragraph>
-<paragraph role="listitem" id="par_id3154273" xml-lang="en-US" l10n="U"
oldref="77">Under <emph>Data field</emph>, specify the field of the SQL
statement whose contents you want to be displayed.</paragraph>
+<paragraph role="listitem" id="par_id3146898" xml-lang="en-US" l10n="U">Second
case: The control belongs to a subform that is created by an SQL
query.</paragraph>
+<paragraph role="listitem" id="par_id3154273" xml-lang="en-US" l10n="U">Under
<emph>Data field</emph>, specify the field of the SQL statement whose contents
you want to be displayed.</paragraph>
</listitem>
</list>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3153949" xml-lang="en-US" l10n="U"
oldref="78">Third case: <link href="text/shared/02/01170900.xhp" name="Combo
Boxes">Combo Boxes</link></paragraph>
-<paragraph role="listitem" id="par_id3147494" xml-lang="en-US" l10n="U"
oldref="79">For combo boxes, the field of the data source table in which the
values entered or selected by the user should be stored is specified under
<emph>Data field</emph>. The values displayed in the list of the combo box are
based on an SQL statement, which is entered under <emph>List
content</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3153949" xml-lang="en-US" l10n="U">Third
case: <link href="text/shared/02/01170900.xhp" name="Combo Boxes">Combo
Boxes</link></paragraph>
+<paragraph role="listitem" id="par_id3147494" xml-lang="en-US" l10n="U">For
combo boxes, the field of the data source table in which the values entered or
selected by the user should be stored is specified under <emph>Data
field</emph>. The values displayed in the list of the combo box are based on an
SQL statement, which is entered under <emph>List content</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3145167" xml-lang="en-US" l10n="U"
oldref="68">Fourth case: <link href="text/shared/02/01170900.xhp" name="List
Boxes">List Boxes</link></paragraph>
-<paragraph role="listitem" id="par_id3153764" xml-lang="en-US" l10n="U"
oldref="91">The data source table does not contain the data to be displayed,
but rather a table linked to the data source table through a common data
field.</paragraph>
-<paragraph role="listitem" id="par_id3149021" xml-lang="en-US" l10n="U"
oldref="69">If you want a list box to display data from a table that is linked
to the current data source table, under <emph>Data field</emph> specify the
field of the data source table to which the content of the list box refers. Or
you can specify the database field that controls the display of the data in the
form. This data field provides the link to the other table if both tables can
be linked through a common d [...]
+<paragraph role="listitem" id="par_id3145167" xml-lang="en-US" l10n="U">Fourth
case: <link href="text/shared/02/01170900.xhp" name="List Boxes">List
Boxes</link></paragraph>
+<paragraph role="listitem" id="par_id3153764" xml-lang="en-US" l10n="U">The
data source table does not contain the data to be displayed, but rather a table
linked to the data source table through a common data field.</paragraph>
+<paragraph role="listitem" id="par_id3149021" xml-lang="en-US" l10n="U">If you
want a list box to display data from a table that is linked to the current data
source table, under <emph>Data field</emph> specify the field of the data
source table to which the content of the list box refers. Or you can specify
the database field that controls the display of the data in the form. This data
field provides the link to the other table if both tables can be linked through
a common data field. I [...]
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3153924" xml-lang="en-US" l10n="U"
oldref="80">List boxes work with references. They can either be implemented
with linked tables by SQL statements (fourth case) or through value
lists:</paragraph>
-<paragraph role="paragraph" id="par_id3145641" xml-lang="en-US" l10n="U"
oldref="58">
-<emph>References through linked tables (SQL statements)</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3147341" xml-lang="en-US" l10n="U"
oldref="59">If you want a list box to display data from a database table that
is linked by a common data field to the table on which the form is based, the
link field of the form table is specified under <emph>Data
field</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3155174" xml-lang="en-US" l10n="U"
oldref="60">The link is created with an SQL Select, which, if you selected
"SQL" or "Native SQL", is specified under <emph>Type of list contents</emph> in
the field <emph>List content</emph>. As an example, a table "Orders" is linked
to the current form control, and in the database a table "Customers" is linked
to the "Orders" table. You can use an SQL statement as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3148537" xml-lang="en-US" l10n="U"
oldref="70">SELECT CustomerName, CustomerNo FROM Customers,</paragraph>
-<paragraph role="paragraph" id="par_id3154967" xml-lang="en-US" l10n="U"
oldref="71">where "CustomerName" is the data field from the linked table
"Customers", and "CustomerNo" is the field of the table "Customers" that is
linked to a field of the form table "Orders" specified under <emph>Data
field</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3163808" xml-lang="en-US" l10n="U"
oldref="55">
-<emph>References Using Value Lists</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3145295" xml-lang="en-US" l10n="U"
oldref="56">For list boxes, you can use value lists. Value lists are lists that
define reference values. In this way, the control in the form does not directly
display the content of a database field, but rather values assigned in the
value list.</paragraph>
-<paragraph role="paragraph" id="par_id3151186" xml-lang="en-US" l10n="U"
oldref="57">If you work with reference values of a value list, the contents of
the data field that you specified under <emph>Data Field</emph> in the form are
not visible, but rather the assigned values. If you chose "Valuelist" on the
<emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a
reference value to the visible list entries in the form under <emph>List
entries</emph> (entered in the < [...]
+<paragraph role="paragraph" id="par_id3153924" xml-lang="en-US" l10n="U">List
boxes work with references. They can either be implemented with linked tables
by SQL statements (fourth case) or through value lists:</paragraph>
+<paragraph role="paragraph" id="par_id3145641" xml-lang="en-US"
l10n="U"><emph>References through linked tables (SQL
statements)</emph></paragraph>
+<paragraph role="paragraph" id="par_id3147341" xml-lang="en-US" l10n="U">If
you want a list box to display data from a database table that is linked by a
common data field to the table on which the form is based, the link field of
the form table is specified under <emph>Data field</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3155174" xml-lang="en-US" l10n="U">The
link is created with an SQL Select, which, if you selected "SQL" or "Native
SQL", is specified under <emph>Type of list contents</emph> in the field
<emph>List content</emph>. As an example, a table "Orders" is linked to the
current form control, and in the database a table "Customers" is linked to the
"Orders" table. You can use an SQL statement as follows:</paragraph>
+<paragraph role="paragraph" id="par_id3148537" xml-lang="en-US"
l10n="U">SELECT CustomerName, CustomerNo FROM Customers,</paragraph>
+<paragraph role="paragraph" id="par_id3154967" xml-lang="en-US" l10n="U">where
"CustomerName" is the data field from the linked table "Customers", and
"CustomerNo" is the field of the table "Customers" that is linked to a field of
the form table "Orders" specified under <emph>Data field</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3163808" xml-lang="en-US"
l10n="U"><emph>References Using Value Lists</emph></paragraph>
+<paragraph role="paragraph" id="par_id3145295" xml-lang="en-US" l10n="U">For
list boxes, you can use value lists. Value lists are lists that define
reference values. In this way, the control in the form does not directly
display the content of a database field, but rather values assigned in the
value list.</paragraph>
+<paragraph role="paragraph" id="par_id3151186" xml-lang="en-US" l10n="U">If
you work with reference values of a value list, the contents of the data field
that you specified under <emph>Data Field</emph> in the form are not visible,
but rather the assigned values. If you chose "Valuelist" on the
<emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a
reference value to the visible list entries in the form under <emph>List
entries</emph> (entered in the <link href="t [...]
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN"
id="bm_id3150297" localize="false"/>
-<paragraph role="heading" id="hd_id3154664" xml-lang="en-US" level="2"
l10n="U" oldref="3">Bound field</paragraph>
-<paragraph role="paragraph" id="par_id3148475" xml-lang="en-US" l10n="CHG"
oldref="4"><ahelp hid="HID_PROP_BOUNDCOLUMN" visibility="hidden">Use an index
to specify the table field or table SQL query to link to the field that is
provided under <emph>Data field</emph>. Valid values for this property are 1,
2, 3, and so on.</ahelp><comment>UFI: issue #i32749#</comment></paragraph>
+<paragraph role="heading" id="hd_id3154664" xml-lang="en-US" level="2"
l10n="U">Bound field</paragraph>
+<paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"
l10n="CHG"><ahelp hid="HID_PROP_BOUNDCOLUMN" visibility="hidden">Use an index
to specify the table field or table SQL query to link to the field that is
provided under <emph>Data field</emph>. Valid values for this property are 1,
2, 3, and so on.</ahelp><comment>UFI: issue #i32749#</comment></paragraph>
<paragraph role="note" id="par_idN10AD2" xml-lang="en-US" l10n="NEW">If you
delete the contents of the <emph>Bound field</emph> cell in the property
browser, the first field of the result set is used to display and to exchange
data.<comment>UFI: issue #i32749#</comment></paragraph>
-<paragraph role="paragraph" id="par_id3154588" xml-lang="en-US" l10n="U"
oldref="72">This property for list boxes defines which data field of a linked
table is displayed in the form.</paragraph>
-<paragraph role="paragraph" id="par_id3151213" xml-lang="en-US" l10n="CHG"
oldref="38">If a list box in the form is to display contents of a table linked
to the form table, then define in the <emph>Type of list contents</emph> field
if the display is determined by an SQL command or the (linked) table is
accessed. With the <emph>Bound field</emph> property, you use an index to
specify to which data field of the query or of the table the list field is
linked.</paragraph>
-<paragraph role="note" id="par_id3148427" xml-lang="en-US" l10n="U"
oldref="73">The property <emph>Bound field</emph> is only for forms that are
used to access more than one table. If the form is based on only one table, the
field to be displayed in the form is specified directly under <emph>Data
field</emph>. However, if you want the list box to display data from a table
that is linked to the current table over a common data field, the linked data
field is defined by the property <emph> [...]
-<paragraph role="paragraph" id="par_id3150365" xml-lang="en-US" l10n="U"
oldref="39">If you selected "SQL" under <emph>Type of list contents</emph>, the
SQL command determines the index to be specified. Example: If you specify an
SQL command such as "SELECT Field1, Field2 FROM tablename" under <emph>List
content</emph>, refer to the following table:</paragraph>
+<paragraph role="paragraph" id="par_id3154588" xml-lang="en-US" l10n="U">This
property for list boxes defines which data field of a linked table is displayed
in the form.</paragraph>
+<paragraph role="paragraph" id="par_id3151213" xml-lang="en-US" l10n="CHG">If
a list box in the form is to display contents of a table linked to the form
table, then define in the <emph>Type of list contents</emph> field if the
display is determined by an SQL command or the (linked) table is accessed. With
the <emph>Bound field</emph> property, you use an index to specify to which
data field of the query or of the table the list field is linked.</paragraph>
+<paragraph role="note" id="par_id3148427" xml-lang="en-US" l10n="U">The
property <emph>Bound field</emph> is only for forms that are used to access
more than one table. If the form is based on only one table, the field to be
displayed in the form is specified directly under <emph>Data field</emph>.
However, if you want the list box to display data from a table that is linked
to the current table over a common data field, the linked data field is defined
by the property <emph>Bound field< [...]
+<paragraph role="paragraph" id="par_id3150365" xml-lang="en-US" l10n="U">If
you selected "SQL" under <emph>Type of list contents</emph>, the SQL command
determines the index to be specified. Example: If you specify an SQL command
such as "SELECT Field1, Field2 FROM tablename" under <emph>List content</emph>,
refer to the following table:</paragraph>
<table id="tbl_id3151070">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3154716" xml-lang="en-US" l10n="U"
oldref="40">Bound field</paragraph>
+<paragraph role="tablehead" id="par_id3154716" xml-lang="en-US" l10n="U">Bound
field</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3150666" xml-lang="en-US" l10n="U"
oldref="41">Link</paragraph>
+<paragraph role="tablehead" id="par_id3150666" xml-lang="en-US"
l10n="U">Link</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3154206" xml-lang="en-US" l10n="CHG"
oldref="42">{empty}<comment>FS told me this</comment></paragraph>
+<paragraph role="code" id="par_id3154206" xml-lang="en-US"
l10n="CHG">{empty}<comment>FS told me this</comment></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3145257" xml-lang="en-US" l10n="U"
oldref="43">The database field "Field1" is linked to the field specified under
<emph>Data field</emph>.</paragraph>
+<paragraph role="tablecontent" id="par_id3145257" xml-lang="en-US"
l10n="U">The database field "Field1" is linked to the field specified under
<emph>Data field</emph>.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3150887" xml-lang="en-US" l10n="U"
oldref="44">1</paragraph>
+<paragraph role="code" id="par_id3150887" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3156064" xml-lang="en-US" l10n="U"
oldref="45">The database field "Field2" is linked to the field specified under
<emph>Data field</emph>.</paragraph>
+<paragraph role="tablecontent" id="par_id3156064" xml-lang="en-US"
l10n="U">The database field "Field2" is linked to the field specified under
<emph>Data field</emph>.</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3154134" xml-lang="en-US" l10n="U"
oldref="46">If you selected "Table" under <emph>Type of list contents</emph>,
the table structure defines the index to be specified. Example: If a database
table is selected under <emph>List content</emph>, refer to the following
table:</paragraph>
+<paragraph role="paragraph" id="par_id3154134" xml-lang="en-US" l10n="U">If
you selected "Table" under <emph>Type of list contents</emph>, the table
structure defines the index to be specified. Example: If a database table is
selected under <emph>List content</emph>, refer to the following
table:</paragraph>
<table id="tbl_id3150426">
<tablerow>
<tablecell>
-<paragraph role="tablehead" id="par_id3155379" xml-lang="en-US" l10n="U"
oldref="47">Bound field</paragraph>
+<paragraph role="tablehead" id="par_id3155379" xml-lang="en-US" l10n="U">Bound
field</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablehead" id="par_id3155529" xml-lang="en-US" l10n="U"
oldref="48">Link</paragraph>
+<paragraph role="tablehead" id="par_id3155529" xml-lang="en-US"
l10n="U">Link</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3155373" xml-lang="en-US" l10n="CHG"
oldref="49">{empty}<comment>FS told me this</comment></paragraph>
+<paragraph role="code" id="par_id3155373" xml-lang="en-US"
l10n="CHG">{empty}<comment>FS told me this</comment></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154260" xml-lang="en-US" l10n="U"
oldref="50">The 1st column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
+<paragraph role="tablecontent" id="par_id3154260" xml-lang="en-US"
l10n="U">The 1st column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3156448" xml-lang="en-US" l10n="U"
oldref="51">1</paragraph>
+<paragraph role="code" id="par_id3156448" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3154486" xml-lang="en-US" l10n="U"
oldref="52">The 2nd column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
+<paragraph role="tablecontent" id="par_id3154486" xml-lang="en-US"
l10n="U">The 2nd column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3149949" xml-lang="en-US" l10n="U"
oldref="53">2</paragraph>
+<paragraph role="code" id="par_id3149949" xml-lang="en-US"
l10n="U">2</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id3146767" xml-lang="en-US" l10n="U"
oldref="54">The 3rd column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
+<paragraph role="tablecontent" id="par_id3146767" xml-lang="en-US"
l10n="U">The 3rd column of the table is linked to the field specified under
<emph>Data field</emph>.</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="Section3">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE"
id="bm_id3153316" localize="false"/>
-<paragraph role="heading" id="hd_id3149772" xml-lang="en-US" level="2"
l10n="U" oldref="9">Type of list contents</paragraph>
-<paragraph role="paragraph" id="par_id3154419" xml-lang="en-US" l10n="U"
oldref="10"><ahelp hid="HID_PROP_LISTSOURCETYPE" visibility="hidden">Determines
the data to fill the lists in list and combo boxes.</ahelp>Determines the data
to fill the lists in list and combo boxes.</paragraph>
-<paragraph role="paragraph" id="par_id3153326" xml-lang="en-US" l10n="U"
oldref="13">With the "Valuelist" option, all entries entered in the <emph>List
entries</emph> field of the <link href="text/shared/02/01170101.xhp"
name="General"><emph>General</emph></link> tab appear in the control. For
database forms, you can use reference values (see the <link
href="text/shared/02/01170102.xhp" name=" References Using Value
Lists"><emph>References Using Value Lists</emph></link> section).</paragraph>
-<paragraph role="paragraph" id="par_id3153067" xml-lang="en-US" l10n="U"
oldref="14">If the content of the control is read from a database, you can
determine the type of the data source with the other options. For example, you
can choose between tables and queries.</paragraph>
+<paragraph role="heading" id="hd_id3149772" xml-lang="en-US" level="2"
l10n="U">Type of list contents</paragraph>
+<paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"
l10n="U"><ahelp hid="HID_PROP_LISTSOURCETYPE" visibility="hidden">Determines
the data to fill the lists in list and combo boxes.</ahelp>Determines the data
to fill the lists in list and combo boxes.</paragraph>
+<paragraph role="paragraph" id="par_id3153326" xml-lang="en-US" l10n="U">With
the "Valuelist" option, all entries entered in the <emph>List entries</emph>
field of the <link href="text/shared/02/01170101.xhp"
name="General"><emph>General</emph></link> tab appear in the control. For
database forms, you can use reference values (see the <link
href="text/shared/02/01170102.xhp" name=" References Using Value
Lists"><emph>References Using Value Lists</emph></link> section).</paragraph>
+<paragraph role="paragraph" id="par_id3153067" xml-lang="en-US" l10n="U">If
the content of the control is read from a database, you can determine the type
of the data source with the other options. For example, you can choose between
tables and queries.</paragraph>
</section>
<section id="Section4">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCE"
id="bm_id3148839" localize="false"/>
-<paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2"
l10n="U" oldref="7">List content</paragraph>
-<paragraph role="paragraph" id="par_id3159171" xml-lang="en-US" l10n="U"
oldref="8"><ahelp hid="HID_PROP_LISTSOURCE">With database forms, specifies the
data source for the list content of the form-element. This field can be used to
define a value list for documents without a database
connection.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3168456" xml-lang="en-US" l10n="U"
oldref="15">In the case of database forms, the data source determines the
entries of the list or combo box. Depending on the selected type, you have a
choice between different data sources under <emph>List content</emph>, provided
that these objects exist in your database. All available database objects of
the type selected under <emph>Type of list contents</emph> are offered here. If
you have selected the "Value Li [...]
-<paragraph role="paragraph" id="par_id3155870" xml-lang="en-US" l10n="U"
oldref="81">Examples of SQL statements:</paragraph>
-<paragraph role="paragraph" id="par_id3144504" xml-lang="en-US" l10n="U"
oldref="82">For list boxes, an SQL statement may have the following
form:</paragraph>
-<paragraph role="code" id="par_id3156188" xml-lang="en-US" l10n="U"
oldref="83">SELECT field1, field2 FROM table,</paragraph>
-<paragraph role="paragraph" id="par_id3155266" xml-lang="en-US" l10n="U"
oldref="84">Here "table" is the table whose data is displayed in the list of
the control (list table). "field1" is the data field that defines the visible
entries in the form; its content is displayed in the list box. "field2" is the
field of the list table that is linked to the form table (value table) through
the field specified under <emph>Data field</emph> if <emph>Bound field</emph> =
1 was selected.</paragraph>
-<paragraph role="paragraph" id="par_id3145074" xml-lang="en-US" l10n="U"
oldref="85">For combo boxes, an SQL statement may take the following
form:</paragraph>
-<paragraph role="code" id="par_id3150991" xml-lang="en-US" l10n="U"
oldref="86">SELECT DISTINCT field FROM table,</paragraph>
-<paragraph role="paragraph" id="par_id3154344" xml-lang="en-US" l10n="U"
oldref="87">Here "field" is a data field from the list table "table" whose
content is displayed in the list of the combo box.</paragraph>
-<paragraph role="paragraph" id="par_id3149328" xml-lang="en-US" l10n="U"
oldref="74">
-<emph>Value lists for HTML documents</emph>
-</paragraph>
-<paragraph role="paragraph" id="par_id3156034" xml-lang="en-US" l10n="U"
oldref="16">For HTML forms, you can enter a value list under <emph>List
content</emph>. Select the option "Valuelist" under <emph>Type of list
contents</emph>. The values entered here will not be visible in the form, and
are used to assign values to the visible entries. The entries made under
<emph>List content</emph> correspond to the HTML tag <OPTION
VALUE=...>.</paragraph>
-<paragraph role="paragraph" id="par_id3154855" xml-lang="en-US" l10n="U"
oldref="17">In the data transfer of a selected entry from a list box or a combo
box, both the list of the values displayed in the form, which was entered on
the <link href="text/shared/02/01170101.xhp"
name="General"><emph>General</emph></link> tab under <emph>List entries</emph>,
and the value list entered on the <emph>Data</emph> tab under <emph>List
content</emph>, are taken into consideration: If a (non-empty) t [...]
-<paragraph role="paragraph" id="par_id3163377" xml-lang="en-US" l10n="U"
oldref="18">If the value list is to contain an empty string, enter the value
"$$$empty$$$" under <emph>List content</emph> at the corresponding position
(note uppercase/lowercase). $[officename] interprets this input as an empty
string and assigns it to the respective list entry.</paragraph>
-<paragraph role="paragraph" id="par_id3156309" xml-lang="en-US" l10n="U"
oldref="19">The following table shows the connections between HTML, JavaScript,
and the $[officename] field <emph>List content</emph> using an example list box
named "ListBox1". In this case, "Item" designates a list entry visible in the
form:</paragraph>
+<paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2"
l10n="U">List content</paragraph>
+<paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"
l10n="U"><ahelp hid="HID_PROP_LISTSOURCE">With database forms, specifies the
data source for the list content of the form-element. This field can be used to
define a value list for documents without a database
connection.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3168456" xml-lang="en-US" l10n="U">In
the case of database forms, the data source determines the entries of the list
or combo box. Depending on the selected type, you have a choice between
different data sources under <emph>List content</emph>, provided that these
objects exist in your database. All available database objects of the type
selected under <emph>Type of list contents</emph> are offered here. If you have
selected the "Value List" option a [...]
+<paragraph role="paragraph" id="par_id3155870" xml-lang="en-US"
l10n="U">Examples of SQL statements:</paragraph>
+<paragraph role="paragraph" id="par_id3144504" xml-lang="en-US" l10n="U">For
list boxes, an SQL statement may have the following form:</paragraph>
+<paragraph role="code" id="par_id3156188" xml-lang="en-US" l10n="U">SELECT
field1, field2 FROM table,</paragraph>
+<paragraph role="paragraph" id="par_id3155266" xml-lang="en-US" l10n="U">Here
"table" is the table whose data is displayed in the list of the control (list
table). "field1" is the data field that defines the visible entries in the
form; its content is displayed in the list box. "field2" is the field of the
list table that is linked to the form table (value table) through the field
specified under <emph>Data field</emph> if <emph>Bound field</emph> = 1 was
selected.</paragraph>
+<paragraph role="paragraph" id="par_id3145074" xml-lang="en-US" l10n="U">For
combo boxes, an SQL statement may take the following form:</paragraph>
+<paragraph role="code" id="par_id3150991" xml-lang="en-US" l10n="U">SELECT
DISTINCT field FROM table,</paragraph>
+<paragraph role="paragraph" id="par_id3154344" xml-lang="en-US" l10n="U">Here
"field" is a data field from the list table "table" whose content is displayed
in the list of the combo box.</paragraph>
+<paragraph role="paragraph" id="par_id3149328" xml-lang="en-US"
l10n="U"><emph>Value lists for HTML documents</emph></paragraph>
+<paragraph role="paragraph" id="par_id3156034" xml-lang="en-US" l10n="U">For
HTML forms, you can enter a value list under <emph>List content</emph>. Select
the option "Valuelist" under <emph>Type of list contents</emph>. The values
entered here will not be visible in the form, and are used to assign values to
the visible entries. The entries made under <emph>List content</emph>
correspond to the HTML tag <OPTION VALUE=...>.</paragraph>
+<paragraph role="paragraph" id="par_id3154855" xml-lang="en-US" l10n="U">In
the data transfer of a selected entry from a list box or a combo box, both the
list of the values displayed in the form, which was entered on the <link
href="text/shared/02/01170101.xhp" name="General"><emph>General</emph></link>
tab under <emph>List entries</emph>, and the value list entered on the
<emph>Data</emph> tab under <emph>List content</emph>, are taken into
consideration: If a (non-empty) text is at th [...]
+<paragraph role="paragraph" id="par_id3163377" xml-lang="en-US" l10n="U">If
the value list is to contain an empty string, enter the value "$$$empty$$$"
under <emph>List content</emph> at the corresponding position (note
uppercase/lowercase). $[officename] interprets this input as an empty string
and assigns it to the respective list entry.</paragraph>
+<paragraph role="paragraph" id="par_id3156309" xml-lang="en-US" l10n="U">The
following table shows the connections between HTML, JavaScript, and the
$[officename] field <emph>List content</emph> using an example list box named
"ListBox1". In this case, "Item" designates a list entry visible in the
form:</paragraph>
<table id="tbl_id3145656">
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3159204" xml-lang="en-US" l10n="U"
oldref="20">
-<emph>HTML Tag</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159204" xml-lang="en-US"
l10n="U"><emph>HTML Tag</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152539" xml-lang="en-US" l10n="U"
oldref="21">
-<emph>JavaScript</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152539" xml-lang="en-US"
l10n="U"><emph>JavaScript</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158404" xml-lang="en-US" l10n="U"
oldref="22">
-<emph>Entry in value list of the control (List content)</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158404" xml-lang="en-US"
l10n="U"><emph>Entry in value list of the control (List
content)</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US" l10n="U"
oldref="23">
-<emph>Transmitted data</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US"
l10n="U"><emph>Transmitted data</emph></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3154668" xml-lang="en-US" l10n="U"
oldref="24"><OPTION>Item</paragraph>
+<paragraph role="code" id="par_id3154668" xml-lang="en-US"
l10n="U"><OPTION>Item</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154269" xml-lang="en-US" l10n="U"
oldref="25">Not possible</paragraph>
+<paragraph role="paragraph" id="par_id3154269" xml-lang="en-US" l10n="U">Not
possible</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153109" xml-lang="en-US" l10n="U"
oldref="26">""</paragraph>
+<paragraph role="paragraph" id="par_id3153109" xml-lang="en-US"
l10n="U">""</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154596" xml-lang="en-US" l10n="U"
oldref="27">the visible list entry ("ListBox1=Item")</paragraph>
+<paragraph role="paragraph" id="par_id3154596" xml-lang="en-US" l10n="U">The
visible list entry ("ListBox1=Item")</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3146892" xml-lang="en-US" l10n="U"
oldref="28"><OPTION VALUE="Value">Item</paragraph>
+<paragraph role="code" id="par_id3146892" xml-lang="en-US" l10n="U"><OPTION
VALUE="Value">Item</paragraph>
</tablecell>
<tablecell>
-<paragraph role="code" id="par_id3154604" xml-lang="en-US" l10n="U"
oldref="29">ListBox1.options[0].value="Value"</paragraph>
+<paragraph role="code" id="par_id3154604" xml-lang="en-US"
l10n="U">ListBox1.options[0].value="Value"</paragraph>
</tablecell>
<tablecell>
-<paragraph role="code" id="par_id3153689" xml-lang="en-US" l10n="U"
oldref="30">"Value"</paragraph>
+<paragraph role="code" id="par_id3153689" xml-lang="en-US"
l10n="U">"Value"</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159226" xml-lang="en-US" l10n="U"
oldref="31">The value assigned to the list entry ("ListBox1=Value")</paragraph>
+<paragraph role="paragraph" id="par_id3159226" xml-lang="en-US" l10n="U">The
value assigned to the list entry ("ListBox1=Value")</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="code" id="par_id3155944" xml-lang="en-US" l10n="U"
oldref="32"><OPTION VALUE="">Item</paragraph>
+<paragraph role="code" id="par_id3155944" xml-lang="en-US" l10n="U"><OPTION
VALUE="">Item</paragraph>
</tablecell>
<tablecell>
-<paragraph role="code" id="par_id3155147" xml-lang="en-US" l10n="U"
oldref="33">ListBox1.options[0].value=""</paragraph>
+<paragraph role="code" id="par_id3155147" xml-lang="en-US"
l10n="U">ListBox1.options[0].value=""</paragraph>
</tablecell>
<tablecell>
-<paragraph role="code" id="par_id3154763" xml-lang="en-US" l10n="U"
oldref="34">"$$$empty$$$"</paragraph>
+<paragraph role="code" id="par_id3154763" xml-lang="en-US"
l10n="U">"$$$empty$$$"</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" l10n="U"
oldref="35">An empty string ("ListBox1=")</paragraph>
+<paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" l10n="U">An
empty string ("ListBox1=")</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<section id="Section5">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EMPTY_IS_NULL"
id="bm_id3150628" localize="false"/>
-<paragraph role="heading" id="hd_id3148901" xml-lang="en-US" level="2"
l10n="U" oldref="11">Empty string is NULL</paragraph>
-<paragraph role="paragraph" id="par_id3145357" xml-lang="en-US" l10n="CHG"
oldref="12"><ahelp hid="HID_PROP_EMPTY_IS_NULL">Defines how an empty string
input should be handled. If set to Yes, an input string of length zero will be
treated as a value NULL. If set to No, any input will be treated as-is without
any conversion.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3148901" xml-lang="en-US" level="2"
l10n="U">Empty string is NULL</paragraph>
+<paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"
l10n="CHG"><ahelp hid="HID_PROP_EMPTY_IS_NULL">Defines how an empty string
input should be handled. If set to Yes, an input string of length zero will be
treated as a value NULL. If set to No, any input will be treated as-is without
any conversion.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id0820200812403467" xml-lang="en-US"
l10n="NEW">An empty string is a string of length zero (""). Normally, a value
NULL is not the same as an empty string. In general, a term NULL is used to
denote an undefined value, an unknown value, or "no value has been entered
yet."</paragraph>
<paragraph role="paragraph" id="par_id0820200812403455" xml-lang="en-US"
l10n="NEW">Database systems vary and they might handle a value NULL
differently. Refer to documentations of the database that you are
using.</paragraph>
</section>
<section id="Section6">
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTERPROPOSAL"
id="bm_id3149393" localize="false"/>
-<paragraph role="heading" id="hd_id3161653" xml-lang="en-US" level="2"
l10n="U" oldref="88">Filter proposal</paragraph>
-<paragraph role="paragraph" id="par_id3151221" xml-lang="en-US" l10n="U"
oldref="89"><variable id="filtervorschlag"><ahelp
hid="HID_PROP_FILTERPROPOSAL">While designing your form, you can set the
"Filter proposal" property for each text box in the <emph>Data</emph> tab of
the corresponding <emph>Properties</emph> dialog. In subsequent searches in the
filter mode, you can select from all information contained in these
fields.</ahelp> The field content can then be selected using the AutoCo [...]
+<paragraph role="heading" id="hd_id3161653" xml-lang="en-US" level="2"
l10n="U">Filter proposal</paragraph>
+<paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"
l10n="U"><variable id="filtervorschlag"><ahelp
hid="HID_PROP_FILTERPROPOSAL">While designing your form, you can set the
"Filter proposal" property for each text box in the <emph>Data</emph> tab of
the corresponding <emph>Properties</emph> dialog. In subsequent searches in the
filter mode, you can select from all information contained in these
fields.</ahelp> The field content can then be selected using the AutoComplete
funct [...]
</variable></paragraph>
</section>
<section id="Section9">
diff --git a/main/helpcontent2/source/text/shared/02/01170801.xhp
b/main/helpcontent2/source/text/shared/02/01170801.xhp
index a614b898c7..b1926b93ca 100644
--- a/main/helpcontent2/source/text/shared/02/01170801.xhp
+++ b/main/helpcontent2/source/text/shared/02/01170801.xhp
@@ -30,17 +30,17 @@
</meta>
<body>
<section id="seite1">
-<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1"
l10n="U" oldref="3"><link href="text/shared/02/01170801.xhp" name="Table
Element / List Box / Combo Box Wizard: Data">Table Element / List Box / Combo
Box Wizard: Data</link></paragraph>
-<paragraph role="paragraph" id="par_id3150476" xml-lang="en-US" l10n="U"
oldref="4">Select the data source and table to which the form field
corresponds. If you insert the form field in a document that is already linked
to a data source, this page becomes invisible.</paragraph>
+<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/02/01170801.xhp" name="Table Element / List
Box / Combo Box Wizard: Data">Table Element / List Box / Combo Box Wizard:
Data</link></paragraph>
+<paragraph role="paragraph" id="par_id3150476" xml-lang="en-US"
l10n="U">Select the data source and table to which the form field corresponds.
If you insert the form field in a document that is already linked to a data
source, this page becomes invisible.</paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00040501.xhp#aupitab1"/>
</section>
<!-- removed HID DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_DATASOURCE -->
-<paragraph role="heading" id="hd_id3153894" xml-lang="en-US" level="2"
l10n="U" oldref="5">Data source</paragraph>
-<paragraph role="paragraph" id="par_id3153114" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_DATASOURCE">Specifies the data
source that contains the desired table.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3153894" xml-lang="en-US" level="2"
l10n="U">Data source</paragraph>
+<paragraph role="paragraph" id="par_id3153114" xml-lang="en-US"
l10n="U"><ahelp
hid="DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_DATASOURCE">Specifies the data
source that contains the desired table.</ahelp></paragraph>
<!-- removed HID DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_TABLE -->
-<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="2"
l10n="U" oldref="7">Table</paragraph>
-<paragraph role="paragraph" id="par_id3150774" xml-lang="en-US" l10n="U"
oldref="8"><ahelp hid="DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_TABLE">Specifies
the desired table.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="2"
l10n="U">Table</paragraph>
+<paragraph role="paragraph" id="par_id3150774" xml-lang="en-US"
l10n="U"><ahelp hid="DBP_LISTBOX_RID_PAGE_TABLESELECTION_LB_TABLE">Specifies
the desired table.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/shared/autopi/01020400.xhp
b/main/helpcontent2/source/text/shared/autopi/01020400.xhp
index 48b7827b9e..0018fa3aaa 100644
--- a/main/helpcontent2/source/text/shared/autopi/01020400.xhp
+++ b/main/helpcontent2/source/text/shared/autopi/01020400.xhp
@@ -32,8 +32,8 @@
<body>
<section id="seite4">
<bookmark xml-lang="en-US" branch="hid/SW_HID_FAX_PAGE4" id="bm_id3152425"
localize="false"/>
-<paragraph role="heading" id="hd_id3147143" xml-lang="en-US" level="1"
l10n="CHG" oldref="1"><link href="text/shared/autopi/01020400.xhp" name="Fax
Wizard - Footer">Fax Wizard - Footer</link></paragraph>
-<paragraph role="paragraph" id="par_id3155805" xml-lang="en-US" l10n="CHG"
oldref="2"><ahelp hid="HID_FAX_PAGE4">Specifies the footer
data.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3147143" xml-lang="en-US" level="1"
l10n="CHG"><link href="text/shared/autopi/01020400.xhp" name="Fax Wizard -
Footer">Fax Wizard - Footer</link></paragraph>
+<paragraph role="paragraph" id="par_id3155805" xml-lang="en-US"
l10n="CHG"><ahelp hid="HID_FAX_PAGE4">Specifies the footer
data.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000401.xhp#autopilotfax4"/>
@@ -47,6 +47,6 @@
<!-- removed HID 41160 -->
<paragraph role="heading" id="par_idN105E4" xml-lang="en-US" level="3"
l10n="NEW">Include page number</paragraph>
<paragraph role="paragraph" id="par_idN105E7" xml-lang="en-US"
l10n="NEW"><ahelp hid=".">Prints a page number in the footer
area.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3152812" xml-lang="en-US" l10n="CHG"
oldref="19"><link href="text/shared/autopi/01020500.xhp" name="Go to Fax Wizard
- Name and location">Go to Fax Wizard - Name and location</link></paragraph>
+<paragraph role="paragraph" id="par_id3152812" xml-lang="en-US"
l10n="CHG"><link href="text/shared/autopi/01020500.xhp" name="Go to Fax Wizard
- Name and location">Go to Fax Wizard - Name and location</link></paragraph>
</body>
</helpdocument>
diff --git
a/main/helpcontent2/source/text/shared/explorer/database/05000000.xhp
b/main/helpcontent2/source/text/shared/explorer/database/05000000.xhp
index 899814fdb9..1e65094a4d 100644
--- a/main/helpcontent2/source/text/shared/explorer/database/05000000.xhp
+++ b/main/helpcontent2/source/text/shared/explorer/database/05000000.xhp
@@ -30,15 +30,15 @@
</meta>
<body>
<section id="tabellen">
-<paragraph role="heading" id="hd_id3148520" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/explorer/database/05000000.xhp"
name="Tables">Tables</link></paragraph>
-<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US" l10n="U"
oldref="2">Data sources tables allow you see your data line by line. You can
make new entries and deletions.</paragraph>
+<paragraph role="heading" id="hd_id3148520" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/explorer/database/05000000.xhp"
name="Tables">Tables</link></paragraph>
+<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US" l10n="U">Data
sources tables allow you see your data line by line. You can make new entries
and deletions.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US" l10n="U"
oldref="43">In the $[officename] Help, you will find further information on the
following subjects:</paragraph>
-<paragraph role="heading" id="hd_id3152425" xml-lang="en-US" level="2"
l10n="U" oldref="54"><link href="text/shared/explorer/database/05010000.xhp"
name="Create new or edit table design">Create new or edit table
design</link></paragraph>
+<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US" l10n="U">In
the $[officename] Help, you will find further information on the following
subjects:</paragraph>
+<paragraph role="heading" id="hd_id3152425" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/explorer/database/05010000.xhp" name="Create
new or edit table design">Create new or edit table design</link></paragraph>
<embed href="text/shared/01/05340400.xhp#umgang"/>
<embed href="text/shared/02/12100200.xhp#datensatzsuche"/>
-<paragraph role="heading" id="hd_id3149095" xml-lang="en-US" level="2"
l10n="U" oldref="53"><link href="text/shared/main0212.xhp" name="Sort and
Filter Data">Sort and Filter Data</link></paragraph>
-<paragraph role="heading" id="hd_id3154288" xml-lang="en-US" level="2"
l10n="U" oldref="40"><link href="text/shared/explorer/database/05020000.xhp"
name="Relations, Primary and External Key">Relations, Primary and External
Key</link></paragraph>
+<paragraph role="heading" id="hd_id3149095" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/main0212.xhp" name="Sort and Filter Data">Sort
and Filter Data</link></paragraph>
+<paragraph role="heading" id="hd_id3154288" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/explorer/database/05020000.xhp"
name="Relations, Primary and External Key">Relations, Primary and External
Key</link></paragraph>
<embed href="text/shared/explorer/database/05000001.xhp#kontext"/>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/shared/guide/data_search.xhp
b/main/helpcontent2/source/text/shared/guide/data_search.xhp
index 2376f51c9d..d091494274 100644
--- a/main/helpcontent2/source/text/shared/guide/data_search.xhp
+++ b/main/helpcontent2/source/text/shared/guide/data_search.xhp
@@ -34,7 +34,7 @@
<bookmark_value>forms;finding records</bookmark_value>
<bookmark_value>searching;tables and forms</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3154186" xml-lang="en-US" level="1"
l10n="U" oldref="64"><variable id="data_search"><link
href="text/shared/guide/data_search.xhp" name="Searching Tables and Form
Documents">Searching Tables and Form Documents</link>
+<paragraph role="heading" id="hd_id3154186" xml-lang="en-US" level="1"
l10n="U"><variable id="data_search"><link
href="text/shared/guide/data_search.xhp" name="Searching Tables and Form
Documents">Searching Tables and Form Documents</link>
</variable></paragraph>
<table id="tbl_id3149346">
<tablerow>
@@ -44,11 +44,11 @@
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149178" xml-lang="en-US" l10n="CHG"
oldref="65">In spreadsheets and documents in which form controls are used, you
can click the <emph>Find Record</emph> icon on the form bar to open a dialog to
find any text and values.</paragraph>
+<paragraph role="paragraph" id="par_id3149178" xml-lang="en-US" l10n="CHG">In
spreadsheets and documents in which form controls are used, you can click the
<emph>Find Record</emph> icon on the form bar to open a dialog to find any text
and values.</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US" l10n="U"
oldref="66">You can search in one or in all data fields. You can select whether
the text must be at the beginning, end or any location of the data field. You
also can use the ? and * wildcards, as in the <emph>Find & Replace</emph>
dialog. You can find additional information about the database search function
in the <link href="text/shared/02/12100200.xhp" name="$[officename]
Help">$[officename] Help</link>.</pa [...]
+<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US" l10n="U">You
can search in one or in all data fields. You can select whether the text must
be at the beginning, end or any location of the data field. You also can use
the ? and * wildcards, as in the <emph>Find & Replace</emph> dialog. You
can find additional information about the database search function in the <link
href="text/shared/02/12100200.xhp" name="$[officename] Help">$[officename]
Help</link>.</paragraph>
<embed href="text/shared/00/00000004.xhp#related"/>
<embed href="text/shared/guide/data_search2.xhp#data_search2"/>
</body>
diff --git a/main/helpcontent2/source/text/simpress/02/04070000.xhp
b/main/helpcontent2/source/text/simpress/02/04070000.xhp
index 9b0a749619..b35a18d5ed 100644
--- a/main/helpcontent2/source/text/simpress/02/04070000.xhp
+++ b/main/helpcontent2/source/text/simpress/02/04070000.xhp
@@ -32,25 +32,24 @@
<section id="mitzeitnahme">
<bookmark xml-lang="en-US" branch="hid/.uno:RehearseTimings" id="bm_id194363"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:RehearseTimings" id="bm_id3154321"
localize="false"/>
-<paragraph role="heading" id="hd_id3150010" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/simpress/02/04070000.xhp" name="Rehearse
Timings">Rehearse Timings</link></paragraph>
-<paragraph role="paragraph" id="par_id3154491" xml-lang="en-US" l10n="U"
oldref="2"><ahelp hid=".uno:RehearseTimings">Starts a slide show with a timer
in the lower left corner.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150010" xml-lang="en-US" level="1"
l10n="U"><link href="text/simpress/02/04070000.xhp" name="Rehearse
Timings">Rehearse Timings</link></paragraph>
+<paragraph role="paragraph" id="par_id3154491" xml-lang="en-US"
l10n="U"><ahelp hid=".uno:RehearseTimings">Starts a slide show with a timer in
the lower left corner.</ahelp></paragraph>
</section>
<section id="symitzeitnahme">
<table id="tbl_id3155064">
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" l10n="E">
-<image id="img_id3155962" src="res/commandimagelist/sc_rehearsetimings.png"
width="0.222inch" height="0.222inch"><alt id="alt_id3155962"
xml-lang="en-US">Icon</alt>
-</image></paragraph>
+<image id="img_id3155962" src="res/commandimagelist/sc_rehearsetimings.png"
width="0.222inch" height="0.222inch"><alt id="alt_id3155962"
xml-lang="en-US">Icon</alt></image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150298" xml-lang="en-US" l10n="U"
oldref="3">Rehearse Timings</paragraph>
+<paragraph role="paragraph" id="par_id3150298" xml-lang="en-US"
l10n="U">Rehearse Timings</paragraph>
</tablecell>
</tablerow>
</table>
</section>
<embed href="text/shared/00/00000004.xhp#related"/>
<embed href="text/simpress/guide/rehearse_timings.xhp#rehearse_timings"/>
-<paragraph role="paragraph" id="par_id3152994" xml-lang="en-US" l10n="U"
oldref="6"><link href="text/simpress/01/06080000.xhp" name="Slide Show
Settings">Slide Show Settings</link></paragraph>
+<paragraph role="paragraph" id="par_id3152994" xml-lang="en-US" l10n="U"><link
href="text/simpress/01/06080000.xhp" name="Slide Show Settings">Slide Show
Settings</link></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/simpress/02/11070000.xhp
b/main/helpcontent2/source/text/simpress/02/11070000.xhp
index 99e16dc5d8..25497f8ab1 100644
--- a/main/helpcontent2/source/text/simpress/02/11070000.xhp
+++ b/main/helpcontent2/source/text/simpress/02/11070000.xhp
@@ -36,17 +36,17 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:OutlineExpandAll"
id="bm_id3708411" localize="false"/><!-- HID added by script -->
<bookmark branch="hid/.uno:OutlineExpandAll" xml-lang="en-US"
id="bm_id3146121"/>
-<paragraph l10n="U" role="heading" level="1" id="hd_id3153728" oldref="1"
xml-lang="en-US"><link href="text/simpress/02/11070000.xhp" name="All
Levels">All Levels</link></paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3154492" xml-lang="en-US"
oldref="2"><ahelp visibility="visible" hid=".uno:OutlineExpandAll">Displays the
hidden headings of the slides in the current slide show. To hide all of the
headings in the current slide show, except for the slide titles, click the
<link href="text/simpress/02/11060000.xhp" name="First Level"><emph>First
Level</emph></link> icon.</ahelp></paragraph>
+<paragraph l10n="U" role="heading" level="1" id="hd_id3153728"
xml-lang="en-US"><link href="text/simpress/02/11070000.xhp" name="All
Levels">All Levels</link></paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3154492"
xml-lang="en-US"><ahelp visibility="visible"
hid=".uno:OutlineExpandAll">Displays the hidden headings of the slides in the
current slide show. To hide all of the headings in the current slide show,
except for the slide titles, click the <link
href="text/simpress/02/11060000.xhp" name="First Level"><emph>First
Level</emph></link> icon.</ahelp></paragraph>
</section>
<section id="syalleebenen">
<table id="tbl_id3149018">
<tablerow>
<tablecell>
-<paragraph l10n="E" role="paragraph" id="par_id3155333" xml-lang="en-US"
oldref=""><image src="res/commandimagelist/sc_outlineexpandall.png"
id="img_id3154705"><alt xml-lang="en-US"
id="alt_id3154705">Icon</alt></image></paragraph>
+<paragraph l10n="E" role="paragraph" id="par_id3155333"
xml-lang="en-US"><image src="res/commandimagelist/sc_outlineexpandall.png"
id="img_id3154705"><alt xml-lang="en-US"
id="alt_id3154705">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3166424" l10n="U" xml-lang="en-US"
oldref="3">All Levels</paragraph>
+<paragraph role="paragraph" id="par_id3166424" l10n="U" xml-lang="en-US">All
Levels</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/main/helpcontent2/source/text/simpress/02/11080000.xhp
b/main/helpcontent2/source/text/simpress/02/11080000.xhp
index 00c9061f96..387dea0296 100644
--- a/main/helpcontent2/source/text/simpress/02/11080000.xhp
+++ b/main/helpcontent2/source/text/simpress/02/11080000.xhp
@@ -36,17 +36,17 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:OutlineCollapse" id="bm_id3444362"
localize="false"/><!-- HID added by script -->
<bookmark branch="hid/.uno:OutlineCollapse" xml-lang="en-US"
id="bm_id3154014"/>
-<paragraph l10n="U" role="heading" level="1" id="hd_id3146119" oldref="1"
xml-lang="en-US"><link href="text/simpress/02/11080000.xhp" name="Hide
Subpoints">Hide Subpoints</link></paragraph>
-<paragraph l10n="U" role="paragraph" id="par_id3154490" xml-lang="en-US"
oldref="2"><ahelp visibility="visible" hid=".uno:OutlineCollapse">Hides the
subheadings of a selected heading. Hidden subheadings are indicated by a black
line in front of a heading. To show the lower level headings, click the <link
href="text/simpress/02/11090000.xhp" name="Show Subpoints"><emph>Show
Subpoints</emph></link> icon.</ahelp></paragraph>
+<paragraph l10n="U" role="heading" level="1" id="hd_id3146119"
xml-lang="en-US"><link href="text/simpress/02/11080000.xhp" name="Hide
Subpoints">Hide Subpoints</link></paragraph>
+<paragraph l10n="U" role="paragraph" id="par_id3154490"
xml-lang="en-US"><ahelp visibility="visible" hid=".uno:OutlineCollapse">Hides
the subheadings of a selected heading. Hidden subheadings are indicated by a
black line in front of a heading. To show the lower level headings, click the
<link href="text/simpress/02/11090000.xhp" name="Show Subpoints"><emph>Show
Subpoints</emph></link> icon.</ahelp></paragraph>
</section>
<section id="syunterversteck">
<table id="tbl_id3153714">
<tablerow>
<tablecell>
-<paragraph l10n="E" role="paragraph" id="par_id3155961" xml-lang="en-US"
oldref=""><image src="res/commandimagelist/sc_outlinecollapse.png"
id="img_id3149256"><alt xml-lang="en-US"
id="alt_id3149256">Icon</alt></image></paragraph>
+<paragraph l10n="E" role="paragraph" id="par_id3155961"
xml-lang="en-US"><image src="res/commandimagelist/sc_outlinecollapse.png"
id="img_id3149256"><alt xml-lang="en-US"
id="alt_id3149256">Icon</alt></image></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3148489" l10n="U" xml-lang="en-US"
oldref="3">Hide Subpoints</paragraph>
+<paragraph role="paragraph" id="par_id3148489" l10n="U" xml-lang="en-US">Hide
Subpoints</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/main/helpcontent2/source/text/simpress/main0103.xhp
b/main/helpcontent2/source/text/simpress/main0103.xhp
index 0ae9275bb9..7228aeae06 100644
--- a/main/helpcontent2/source/text/simpress/main0103.xhp
+++ b/main/helpcontent2/source/text/simpress/main0103.xhp
@@ -31,8 +31,8 @@
<body>
<section id="ansicht">
<bookmark xml-lang="en-US" branch="hid/.uno:ViewMenu" id="bm_id2276680"
localize="false"/>
-<paragraph role="heading" id="hd_id3150297" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/simpress/main0103.xhp"
name="View">View</link></paragraph>
-<paragraph role="paragraph" id="par_id3149378" xml-lang="en-US" l10n="CHG"
oldref="2"><ahelp hid=".">This menu contains commands for controlling the
on-screen display of the document.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150297" xml-lang="en-US" level="1"
l10n="U"><link href="text/simpress/main0103.xhp"
name="View">View</link></paragraph>
+<paragraph role="paragraph" id="par_id3149378" xml-lang="en-US"
l10n="CHG"><ahelp hid=".">This menu contains commands for controlling the
on-screen display of the document.</ahelp></paragraph>
</section>
<embed href="text/simpress/01/03080000.xhp#zeichnung"/>
<embed href="text/simpress/01/03090000.xhp#gliederung"/>
@@ -51,7 +51,7 @@
<embed href="text/shared/01/guides.xhp#guides"/>
<embed href="text/simpress/01/02110000.xhp#navigator"/>
<embed href="text/simpress/01/03152000.xhp#headerandfooter"/>
-<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="2"
l10n="U" oldref="3"><link href="text/shared/01/03010000.xhp"
name="Zoom">Zoom</link></paragraph>
+<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/01/03010000.xhp"
name="Zoom">Zoom</link></paragraph>
<embed href="text/shared/01/03010000.xhp#massstabtext"/>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/simpress/main0114.xhp
b/main/helpcontent2/source/text/simpress/main0114.xhp
index 32df840dd3..4c55e58c06 100644
--- a/main/helpcontent2/source/text/simpress/main0114.xhp
+++ b/main/helpcontent2/source/text/simpress/main0114.xhp
@@ -31,20 +31,20 @@
<body>
<section id="praesent">
<bookmark xml-lang="en-US" branch="hid/.uno:SlideShowMenu" id="bm_id1934263"
localize="false"/>
-<paragraph role="heading" id="hd_id3154011" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/simpress/main0114.xhp" name="Slide
Show">Slide Show</link></paragraph>
-<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US" l10n="CHG"
oldref="2"><ahelp hid=".">Contains commands and options for running a
presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3154011" xml-lang="en-US" level="1"
l10n="U"><link href="text/simpress/main0114.xhp" name="Slide Show">Slide
Show</link></paragraph>
+<paragraph role="paragraph" id="par_id3145252" xml-lang="en-US"
l10n="CHG"><ahelp hid=".">Contains commands and options for running a
presentation.</ahelp></paragraph>
</section>
<embed href="text/simpress/01/03130000.xhp#bildpraesent"/>
-<paragraph role="heading" id="hd_id3154510" xml-lang="en-US" level="2"
l10n="U" oldref="3"><link href="text/simpress/01/06080000.xhp" name="Slide Show
Settings">Slide Show Settings</link></paragraph>
+<paragraph role="heading" id="hd_id3154510" xml-lang="en-US" level="2"
l10n="U"><link href="text/simpress/01/06080000.xhp" name="Slide Show
Settings">Slide Show Settings</link></paragraph>
<embed href="text/simpress/01/06080000.xhp#praesent"/>
<embed href="text/simpress/02/04070000.xhp#mitzeitnahme"/>
-<paragraph role="heading" id="hd_id3153486" xml-lang="en-US" level="2"
l10n="U" oldref="5"><link href="text/simpress/01/06070000.xhp"
name="Interaction">Interaction</link></paragraph>
+<paragraph role="heading" id="hd_id3153486" xml-lang="en-US" level="2"
l10n="U"><link href="text/simpress/01/06070000.xhp"
name="Interaction">Interaction</link></paragraph>
<embed href="text/simpress/01/06070000.xhp#interaktiontext"/>
<paragraph role="heading" id="par_idN10611" xml-lang="en-US" level="2"
l10n="NEW"><link href="text/simpress/01/06060000.xhp">Custom
Animation</link></paragraph>
<embed href="text/simpress/01/06060000.xhp#effekttext"/>
<embed href="text/simpress/01/06040000.xhp#diawechsel"/>
<embed href="text/simpress/02/04010000.xhp#diaanzeigen"/>
-<paragraph role="heading" id="hd_id3153711" xml-lang="en-US" level="2"
l10n="U" oldref="4"><link href="text/simpress/01/06100000.xhp" name="Custom
Slide Show">Custom Slide Show</link></paragraph>
+<paragraph role="heading" id="hd_id3153711" xml-lang="en-US" level="2"
l10n="U"><link href="text/simpress/01/06100000.xhp" name="Custom Slide
Show">Custom Slide Show</link></paragraph>
<embed href="text/simpress/01/06100000.xhp#indipraesent"/>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/swriter/01/05100400.xhp
b/main/helpcontent2/source/text/swriter/01/05100400.xhp
index cf24b73133..a073a29a4f 100644
--- a/main/helpcontent2/source/text/swriter/01/05100400.xhp
+++ b/main/helpcontent2/source/text/swriter/01/05100400.xhp
@@ -32,15 +32,15 @@
<section id="aufheben">
<bookmark xml-lang="en-US" branch="hid/.uno:UnsetCellsReadOnly"
id="bm_id3818873" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:UnsetCellsReadOnly"
id="bm_id3147402" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149052" role="heading" level="1"
l10n="U" oldref="1"><link href="text/swriter/01/05100400.xhp"
name="Unprotect">Unprotect</link></paragraph>
-<paragraph xml-lang="en-US" id="par_id3083450" role="paragraph" l10n="CHG"
oldref="2"><ahelp hid=".uno:UnsetCellsReadOnly">Removes the cell protection for
all selected cells in the current table.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3149052" role="heading" level="1"
l10n="U"><link href="text/swriter/01/05100400.xhp"
name="Unprotect">Unprotect</link></paragraph>
+<paragraph xml-lang="en-US" id="par_id3083450" role="paragraph"
l10n="CHG"><ahelp hid=".uno:UnsetCellsReadOnly">Removes the cell protection for
all selected cells in the current table.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/swriter/00/00000405.xhp#schutzaufhz"/>
</section>
-<paragraph xml-lang="en-US" id="par_id3154558" role="paragraph" l10n="U"
oldref="3">To remove the protection from several tables at once, select the
tables, and then press <switchinline select="sys"><caseinline
select="MAC">Command
+<paragraph xml-lang="en-US" id="par_id3154558" role="paragraph" l10n="U">To
remove the protection from several tables at once, select the tables, and then
press <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+T. To
remove the protection from all of the tables in a document, click anywhere in
the document, and then press <switchinline select="sys"><caseinline
select="MAC">Command
</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+T.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150765" role="tip" l10n="U"
oldref="4">You can also remove cell protection from a table in the <link
href="text/swriter/01/02110000.xhp"
name="Navigator">Navigator</link>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150765" role="tip" l10n="U">You can
also remove cell protection from a table in the <link
href="text/swriter/01/02110000.xhp"
name="Navigator">Navigator</link>.</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/swriter/02/18120000.xhp
b/main/helpcontent2/source/text/swriter/02/18120000.xhp
index 12722f0bd3..f8d979b76f 100644
--- a/main/helpcontent2/source/text/swriter/02/18120000.xhp
+++ b/main/helpcontent2/source/text/swriter/02/18120000.xhp
@@ -32,13 +32,13 @@
<section id="grafikenaus">
<bookmark xml-lang="en-US" branch="hid/.uno:Graphic" id="bm_id1021216"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:Graphic" id="bm_id3155625"
localize="false"/>
-<paragraph role="heading" id="hd_id3148568" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/swriter/02/18120000.xhp" name="Graphics
On/Off">Graphics On/Off</link></paragraph>
+<paragraph role="heading" id="hd_id3148568" xml-lang="en-US" level="1"
l10n="U"><link href="text/swriter/02/18120000.xhp" name="Graphics
On/Off">Graphics On/Off</link></paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3147167">
<bookmark_value>graphics;do not show</bookmark_value>
<bookmark_value>images;do not show</bookmark_value>
<bookmark_value>pictures;do not show</bookmark_value>
</bookmark>
-<paragraph role="paragraph" id="par_id3147167" xml-lang="en-US" l10n="CHG"
oldref="3"><ahelp hid=".uno:Graphic">If the <emph>Graphics On/Off</emph> icon
on the <emph>Tools</emph> bar is activated, no graphics are displayed - only
empty frames as placeholders.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147167" xml-lang="en-US"
l10n="CHG"><ahelp hid=".uno:Graphic">If the <emph>Graphics On/Off</emph> icon
on the <emph>Tools</emph> bar is activated, no graphics are displayed - only
empty frames as placeholders.</ahelp></paragraph>
</section>
<section id="sygrafikenaus">
<table id="tbl_id3151180">
@@ -49,7 +49,7 @@
</image></paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154107" xml-lang="en-US" l10n="U"
oldref="2">Graphics On/Off</paragraph>
+<paragraph role="paragraph" id="par_id3154107" xml-lang="en-US"
l10n="U">Graphics On/Off</paragraph>
</tablecell>
</tablerow>
</table>
diff --git
a/main/helpcontent2/source/text/swriter/guide/insert_graphic_dialog.xhp
b/main/helpcontent2/source/text/swriter/guide/insert_graphic_dialog.xhp
index f708de4d18..d89fbb718e 100644
--- a/main/helpcontent2/source/text/swriter/guide/insert_graphic_dialog.xhp
+++ b/main/helpcontent2/source/text/swriter/guide/insert_graphic_dialog.xhp
@@ -34,20 +34,20 @@ status="PUBLISH">
<bookmark_value>pictures; inserting by dialog</bookmark_value>
<bookmark_value>inserting; pictures, by dialog</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3154896" role="heading" level="1"
l10n="U" oldref="1"><variable id="insert_graphic_dialog"><link
href="text/swriter/guide/insert_graphic_dialog.xhp" name="Inserting a Graphic
From a File">Inserting a Graphic From a File</link>
+<paragraph xml-lang="en-US" id="hd_id3154896" role="heading" level="1"
l10n="U"><variable id="insert_graphic_dialog"><link
href="text/swriter/guide/insert_graphic_dialog.xhp" name="Inserting a Graphic
From a File">Inserting a Graphic From a File</link>
</variable></paragraph>
<list type="ordered">
<listitem>
-<paragraph xml-lang="en-US" id="par_id3155914" role="listitem" l10n="U"
oldref="2">Click in the document where you want to insert the
graphic.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155914" role="listitem" l10n="U">Click
in the document where you want to insert the graphic.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3155864" role="listitem" l10n="U"
oldref="3">Choose <link href="text/shared/01/04140000.xhp" name="Insert -
Picture - From File"><emph>Insert - Picture - From
File</emph></link>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155864" role="listitem" l10n="U">Choose
<link href="text/shared/01/04140000.xhp" name="Insert - Picture - From
File"><emph>Insert - Picture - From File</emph></link>.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3156021" role="listitem" l10n="U"
oldref="4">Locate the graphic file that you want to insert, and then click
<emph>Open</emph>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156021" role="listitem" l10n="U">Locate
the graphic file that you want to insert, and then click
<emph>Open</emph>.</paragraph>
</listitem>
</list>
-<paragraph xml-lang="en-US" id="par_id3153396" role="paragraph" l10n="U"
oldref="5">By default, the inserted graphic is centered above the paragraph
that you clicked in.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153396" role="paragraph" l10n="U">By
default, the inserted graphic is centered above the paragraph that you clicked
in.</paragraph>
<embed href="text/shared/00/00000004.xhp#related"/>
<embed href="text/swriter/guide/insert_graphic.xhp#insert_graphic"/>
<embed
href="text/swriter/guide/insert_graphic_gallery.xhp#insert_graphic_gallery"/>
diff --git a/main/helpcontent2/source/text/swriter/guide/navigator.xhp
b/main/helpcontent2/source/text/swriter/guide/navigator.xhp
index 338c9dee67..3f435dca38 100644
--- a/main/helpcontent2/source/text/swriter/guide/navigator.xhp
+++ b/main/helpcontent2/source/text/swriter/guide/navigator.xhp
@@ -40,19 +40,19 @@
<bookmark_value>jumping;to text elements</bookmark_value>
<bookmark_value>overviews;Navigator in text documents</bookmark_value>
</bookmark><comment>MW added "pages;"</comment>
-<paragraph xml-lang="en-US" id="hd_id3154897" role="heading" level="1"
l10n="U" oldref="1"><variable id="navigator"><link
href="text/swriter/guide/navigator.xhp" name="Navigator for Text
Documents">Navigator for Text Documents</link>
+<paragraph xml-lang="en-US" id="hd_id3154897" role="heading" level="1"
l10n="U"><variable id="navigator"><link href="text/swriter/guide/navigator.xhp"
name="Navigator for Text Documents">Navigator for Text Documents</link>
</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3153402" role="paragraph" l10n="U"
oldref="2">The Navigator displays the different parts of your document, such as
headings, tables, frames, objects, or hyperlinks.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153402" role="paragraph" l10n="U">The
Navigator displays the different parts of your document, such as headings,
tables, frames, objects, or hyperlinks.</paragraph>
<list type="ordered">
<listitem>
-<paragraph xml-lang="en-US" id="par_id3154247" role="listitem" l10n="U"
oldref="3">To open the <emph>Navigator</emph>, press F5.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154247" role="listitem" l10n="U">To
open the <emph>Navigator</emph>, press F5.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3155878" role="listitem" l10n="U"
oldref="5">To quickly jump to a location in your document, double-click an item
listed in the <emph>Navigator</emph> window or enter the respective page number
in the spin box.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155878" role="listitem" l10n="U">To
quickly jump to a location in your document, double-click an item listed in the
<emph>Navigator</emph> window or enter the respective page number in the spin
box.</paragraph>
</listitem>
</list>
<embed href="text/shared/00/00000004.xhp#related"/>
<embed href="text/shared/guide/navigator.xhp#navigator"/>
-<paragraph xml-lang="en-US" id="par_id3147108" role="paragraph" l10n="U"
oldref="4"><link href="text/swriter/01/02110000.xhp"
name="Navigator">Navigator</link></paragraph>
+<paragraph xml-lang="en-US" id="par_id3147108" role="paragraph" l10n="U"><link
href="text/swriter/01/02110000.xhp"
name="Navigator">Navigator</link></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/swriter/main0210.xhp
b/main/helpcontent2/source/text/swriter/main0210.xhp
index 566abd1386..2a81adbf2d 100644
--- a/main/helpcontent2/source/text/swriter/main0210.xhp
+++ b/main/helpcontent2/source/text/swriter/main0210.xhp
@@ -32,8 +32,8 @@
<section id="seitenansicht">
<bookmark xml-lang="en-US" branch="hid/HID_PVIEW_TOOLBOX" id="bm_id3154239"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SW_HID_PAGEPREVIEW" id="bm_id3154242"
localize="false"/>
-<paragraph role="heading" id="hd_id3145783" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/swriter/main0210.xhp" name="Page
Preview">Page Preview</link></paragraph>
-<paragraph role="paragraph" id="par_id3154253" xml-lang="en-US" l10n="U"
oldref="2">The <emph>Page Preview</emph> Bar appears when you view the current
document in the page preview mode.</paragraph>
+<paragraph role="heading" id="hd_id3145783" xml-lang="en-US" level="1"
l10n="U"><link href="text/swriter/main0210.xhp" name="Page Preview">Page
Preview</link></paragraph>
+<paragraph role="paragraph" id="par_id3154253" xml-lang="en-US" l10n="U">The
<emph>Page Preview</emph> Bar appears when you view the current document in the
page preview mode.</paragraph>
</section>
<embed href="text/shared/02/10030000.xhp#ersteseite"/>
<embed href="text/shared/02/10030000.xhp#syersteseite"/>
