source/text/shared/guide/copytable2application.xhp   |   27 --
 source/text/shared/guide/copytext2application.xhp    |   43 +--
 source/text/shared/guide/ctl.xhp                     |   42 +--
 source/text/shared/guide/data_dbase2office.xhp       |   49 +--
 source/text/shared/guide/data_report.xhp             |   47 +--
 source/text/shared/guide/data_reports.xhp            |   99 +++----
 source/text/shared/guide/data_search.xhp             |   29 --
 source/text/shared/guide/data_search2.xhp            |  102 +++++--
 source/text/shared/guide/data_tabledefine.xhp        |   39 +-
 source/text/shared/guide/dragdrop.xhp                |   72 ++---
 source/text/shared/guide/dragdrop_beamer.xhp         |   46 +--
 source/text/shared/guide/dragdrop_fromgallery.xhp    |   22 -
 source/text/shared/guide/dragdrop_gallery.xhp        |   39 +-
 source/text/shared/guide/dragdrop_graphic.xhp        |   31 +-
 source/text/shared/guide/dragdrop_table.xhp          |   34 +-
 source/text/shared/guide/email.xhp                   |   27 --
 source/text/shared/guide/export_ms.xhp               |   35 +-
 source/text/shared/guide/fax.xhp                     |   43 +--
 source/text/shared/guide/filternavigator.xhp         |   29 +-
 source/text/shared/guide/flat_icons.xhp              |   27 --
 source/text/shared/guide/hyperlink_rel_abs.xhp       |   39 +-
 source/text/shared/guide/insert_bitmap.xhp           |   57 ++--
 source/text/shared/guide/insert_specialchar.xhp      |   39 +-
 source/text/shared/guide/keyboard.xhp                |  256 +++++++++----------
 source/text/shared/guide/labels.xhp                  |   45 +--
 source/text/shared/guide/language_select.xhp         |  110 ++++----
 source/text/shared/guide/line_intext.xhp             |  217 +++++++---------
 source/text/shared/guide/measurement_units.xhp       |   32 +-
 source/text/shared/guide/ms_user.xhp                 |   64 ++--
 source/text/shared/guide/navigator_setcursor.xhp     |   25 -
 source/text/shared/guide/navpane_on.xhp              |   34 +-
 source/text/shared/guide/pageformat_max.xhp          |   37 +-
 source/text/shared/guide/print_blackwhite.xhp        |   52 ++-
 source/text/shared/guide/round_corner.xhp            |   31 +-
 source/text/shared/guide/space_hyphen.xhp            |   28 +-
 source/text/shared/guide/text_color.xhp              |   35 +-
 source/text/shared/guide/textmode_change.xhp         |   10 
 source/text/shared/guide/version_number.xhp          |    6 
 source/text/shared/guide/viewing_file_properties.xhp |   31 +-
 source/text/shared/guide/workfolder.xhp              |   32 +-
 40 files changed, 1008 insertions(+), 1054 deletions(-)

New commits:
commit 68257fa557206cc11dfcad9fdb037eaceb131217
Author:     Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Mar 27 12:50:14 2023 -0300
Commit:     Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Mar 27 15:58:49 2023 +0000

    tdf#154364 (final) refactor "related topics" for share/guide
    
    + refactor
    + some changes in content display
    + few icon updates
    
    Change-Id: I1cc1823313d96667827a590b48eb4bcbe5419ba5
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/149632
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>

diff --git a/source/text/shared/guide/copytable2application.xhp 
b/source/text/shared/guide/copytable2application.xhp
index aedd63e863..e6c287ca2c 100644
--- a/source/text/shared/guide/copytable2application.xhp
+++ b/source/text/shared/guide/copytable2application.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidecopytable2applicationxml" indexer="include" 
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Inserting Data From Spreadsheets</title>
+<title id="tit">Inserting Data From Spreadsheets</title>
 <filename>/text/shared/guide/copytable2application.xhp</filename>
 </topic>
 <history>
@@ -30,38 +27,40 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3154186"><bookmark_value>charts;copying with link to source cell 
range</bookmark_value>
+<bookmark branch="index" id="bm_id3154186"><bookmark_value>charts;copying with 
link to source cell range</bookmark_value>
 <bookmark_value>inserting; cell ranges from spreadsheets</bookmark_value>
 <bookmark_value>pasting;cell ranges from spreadsheets</bookmark_value>
 <bookmark_value>presentations;inserting spreadsheet cells</bookmark_value>
 <bookmark_value>text documents;inserting spreadsheet cells</bookmark_value>
 <bookmark_value>tables in spreadsheets;copying data to other 
applications</bookmark_value>
 </bookmark><comment>mw deleted "tables;" and added "charts;" and "tables in 
spreadsheets;"</comment>
-<paragraph role="heading" id="hd_id3154186" xml-lang="en-US" 
level="1"><variable id="copytable2application"><link 
href="text/shared/guide/copytable2application.xhp">Inserting Data From 
Spreadsheets</link>
-</variable></paragraph>
+<h1 id="hd_id3154186"><variable id="copytable2application"><link 
href="text/shared/guide/copytable2application.xhp">Inserting Data From 
Spreadsheets</link>
+</variable></h1>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3147088" xml-lang="en-US">Use the 
clipboard to copy the contents of a single cell. You can also copy a formula 
from a cell into the clipboard (for example, from the input line of the formula 
bar) so that the formula can be inserted into a text.</paragraph>
+<paragraph role="listitem" id="par_id3147088">Use the clipboard to copy the 
contents of a single cell. You can also copy a formula from a cell into the 
clipboard (for example, from the input line of the formula bar) so that the 
formula can be inserted into a text.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3145345" xml-lang="en-US">To copy a cell 
range into a text document, select the cell range in the sheet and then use 
either the clipboard or drag-and-drop to insert the cells into the text 
document. You will then find an OLE object in the text document, which you can 
edit further.</paragraph>
+<paragraph role="listitem" id="par_id3145345">To copy a cell range into a text 
document, select the cell range in the sheet and then use either the clipboard 
or drag-and-drop to insert the cells into the text document. You will then find 
an OLE object in the text document, which you can edit further.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3146957" xml-lang="en-US">If you drag 
cells to the normal view of a presentation document, the cells will be inserted 
there as an OLE object. If you drag cells into the outline view, each cell will 
form a line of the outline view.</paragraph>
+<paragraph role="listitem" id="par_id3146957">If you drag cells to the normal 
view of a presentation document, the cells will be inserted there as an OLE 
object. If you drag cells into the outline view, each cell will form a line of 
the outline view.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3148538" xml-lang="en-US">When you copy a 
cell range from $[officename] Calc to the clipboard, the drawing objects, OLE 
objects and charts within this range are also copied.</paragraph>
+<paragraph role="listitem" id="par_id3148538">When you copy a cell range from 
$[officename] Calc to the clipboard, the drawing objects, OLE objects and 
charts within this range are also copied.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3153031" xml-lang="en-US">If you insert a 
cell range with an enclosed chart, the chart will keep its link to the source 
cell range only if you copied the chart and the source cell range 
together.</paragraph>
+<paragraph role="listitem" id="par_id3153031">If you insert a cell range with 
an enclosed chart, the chart will keep its link to the source cell range only 
if you copied the chart and the source cell range together.</paragraph>
 </listitem>
 </list>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<switch select="appl">
+
+<section id="relatedtopics">
+    <switch select="appl">
 <case select="WRITER"><embed 
href="text/swriter/guide/table_insert.xhp#table_insert"/>
 </case>
 </switch>
 <embed href="text/shared/guide/copytext2application.xhp#copytext2application"/>
 <embed href="text/shared/guide/copy_drawfunctions.xhp#copy_drawfunctions"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/copytext2application.xhp 
b/source/text/shared/guide/copytext2application.xhp
index 334bdbf532..898fb5b465 100644
--- a/source/text/shared/guide/copytext2application.xhp
+++ b/source/text/shared/guide/copytext2application.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-       
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidecopytext2applicationxml" indexer="include" 
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Inserting Data From Text Documents</title>
+<title id="tit">Inserting Data From Text Documents</title>
 <filename>/text/shared/guide/copytext2application.xhp</filename>
 </topic>
 <history>
@@ -30,7 +27,7 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3152924"><bookmark_value>sending; AutoAbstract function in 
presentations</bookmark_value>
+<bookmark branch="index" id="bm_id3152924"><bookmark_value>sending; 
AutoAbstract function in presentations</bookmark_value>
 <bookmark_value>AutoAbstract function for sending text to 
presentations</bookmark_value>
 <bookmark_value>outlines; sending to presentations</bookmark_value>
 <bookmark_value>text; copying by drag and drop</bookmark_value>
@@ -39,48 +36,48 @@
 <bookmark_value>copying;data from text documents</bookmark_value>
 <bookmark_value>pasting;data from text documents</bookmark_value>
 </bookmark><comment>mw added "pasting; and changed "drag and drop;""</comment>
-<paragraph role="heading" id="hd_id3152924" xml-lang="en-US" 
level="1"><variable id="copytext2application"><link 
href="text/shared/guide/copytext2application.xhp">Inserting Data From Text 
Documents</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3156426" xml-lang="en-US">You can insert 
text into other document types, such as spreadsheets and presentations. Note 
that there is a difference between whether the text is inserted into a frame, a 
spreadsheet cell, or into the outline view of a presentation.</paragraph>
+<h1 id="hd_id3152924"><variable id="copytext2application"><link 
href="text/shared/guide/copytext2application.xhp">Inserting Data From Text 
Documents</link></variable></h1>
+<paragraph role="paragraph" id="par_id3156426">You can insert text into other 
document types, such as spreadsheets and presentations. Note that there is a 
difference between whether the text is inserted into a frame, a spreadsheet 
cell, or into the outline view of a presentation.</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3147576" xml-lang="en-US">If you copy 
text to the clipboard, you can paste it with or without text attributes. Use 
the shortcut keys <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C
 to copy and <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V
 to paste.</paragraph>
+<paragraph role="listitem" id="par_id3147576">If you copy text to the 
clipboard, you can paste it with or without text attributes. Use the shortcut 
keys <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C
 to copy and <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V
 to paste.</paragraph>
 </listitem>
 </list>
 <table id="tbl_id3166460">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US">
-<image id="img_id3143270" src="cmd/sc_paste.png" width="5.64mm" 
height="5.64mm"><alt id="alt_id3143270" xml-lang="en-US">Icon</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3152349">
+<image id="img_id3143270" src="cmd/lc_paste.svg" width="1cm" height="1cm"><alt 
id="alt_id3143270">Icon Paste</alt>     </image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3158430" xml-lang="en-US">To select the 
format in which the clipboard contents will be pasted, click the arrow next to 
the <emph>Paste</emph> icon on the Standard bar, or choose <emph>Edit - Paste 
Special</emph>, then select the proper format.</paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3158430">To select the format in which 
the clipboard contents will be pasted, click the arrow next to the 
<emph>Paste</emph> icon on the Standard bar, or choose <emph>Edit - Paste 
Special</emph>, then select the proper format.</paragraph>
 </tablecell>
 </tablerow>
 </table>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3156155" xml-lang="en-US">If a text 
document contains headings formatted with the Heading Paragraph Style, choose 
<emph>File - Send - Outline to Presentation</emph>. A new presentation document 
is created, which contains the headings as an outline.</paragraph>
+<paragraph role="listitem" id="par_id3156155">If a text document contains 
headings formatted with the Heading Paragraph Style, choose <emph>File - Send - 
Outline to Presentation</emph>. A new presentation document is created, which 
contains the headings as an outline.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3145316" xml-lang="en-US">If you want to 
transfer each heading together with its accompanying paragraphs, select the 
<emph>File - Send - AutoAbstract to Presentation</emph> command. You must have 
formatted the headings with a corresponding Paragraph Style to be able to see 
this command.</paragraph>
+<paragraph role="listitem" id="par_id3145316">If you want to transfer each 
heading together with its accompanying paragraphs, select the <emph>File - Send 
- AutoAbstract to Presentation</emph> command. You must have formatted the 
headings with a corresponding Paragraph Style to be able to see this 
command.</paragraph>
 </listitem>
 </list>
 <h2 id="hd_id3156024">Copying Text Using Drag-and-Drop</h2>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3147303" xml-lang="en-US">If you select 
text and drag it into a spreadsheet with drag-and-drop, it will be inserted as 
text into the cell where you release the mouse.</paragraph>
+<paragraph role="listitem" id="par_id3147303">If you select text and drag it 
into a spreadsheet with drag-and-drop, it will be inserted as text into the 
cell where you release the mouse.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3149655" xml-lang="en-US">If you drag 
text to the normal view of a presentation, an OLE object is inserted as a 
$[officename] plug-in.</paragraph>
+<paragraph role="listitem" id="par_id3149655">If you drag text to the normal 
view of a presentation, an OLE object is inserted as a $[officename] 
plug-in.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3150793" xml-lang="en-US">If you drag the 
text to the outline view of a presentation, it will be inserted at the cursor 
location.</paragraph>
+<paragraph role="listitem" id="par_id3150793">If you drag the text to the 
outline view of a presentation, it will be inserted at the cursor 
location.</paragraph>
 </listitem>
 </list>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<embed 
href="text/shared/guide/copytable2application.xhp#copytable2application"/>
-<embed href="text/shared/guide/copy_drawfunctions.xhp#copy_drawfunctions"/>
+
+<section id="relatedtopics">
+       <embed 
href="text/shared/guide/copytable2application.xhp#copytable2application"/>
+       <embed 
href="text/shared/guide/copy_drawfunctions.xhp#copy_drawfunctions"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/ctl.xhp b/source/text/shared/guide/ctl.xhp
index c4aace0702..817b48bbb5 100644
--- a/source/text/shared/guide/ctl.xhp
+++ b/source/text/shared/guide/ctl.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -21,12 +19,12 @@
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidectlxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Languages Using Complex Text Layout</title>
+<title id="tit">Languages Using Complex Text Layout</title>
 <filename>/text/shared/guide/ctl.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3153662"><bookmark_value>CTL;complex text layout 
languages</bookmark_value>
+<bookmark branch="index" id="bm_id3153662"><bookmark_value>CTL;complex text 
layout languages</bookmark_value>
 <bookmark_value>languages;complex text layout</bookmark_value>
 <bookmark_value>text;CTL languages</bookmark_value>
 <bookmark_value>text layout for special languages</bookmark_value>
@@ -38,38 +36,40 @@
 <bookmark_value>Arabic;entering text</bookmark_value>
 <bookmark_value>Thai;entering text</bookmark_value>
 </bookmark><comment>mw made "text layout;" a one level entry</comment>
-<paragraph role="heading" id="hd_id3153662" xml-lang="en-US" 
level="1"><variable id="ctl"><link href="text/shared/guide/ctl.xhp">Languages 
Using Complex Text Layout</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147618" xml-lang="en-US">Currently, 
$[officename] supports Hindi, Thai, Hebrew, and Arabic as <link 
href="text/shared/00/00000005.xhp#ctl">CTL languages</link>.</paragraph>
-<paragraph role="paragraph" id="par_id3155420" xml-lang="en-US">If you select 
the text flow from right to left, embedded Western text still runs from left to 
right. The cursor responds to the arrow keys in that Right Arrow moves it "to 
the text end" and Left Arrow "to the text start".</paragraph>
-<paragraph role="paragraph" id="par_id3145609" xml-lang="en-US">You can change 
the text writing direction directly by pressing one of the following key 
combinations:</paragraph>
+<h1 id="hd_id3153662"><variable id="ctl"><link 
href="text/shared/guide/ctl.xhp">Languages Using Complex Text Layout</link>
+</variable></h1>
+<paragraph role="paragraph" id="par_id3147618">Currently, $[officename] 
supports Hindi, Thai, Hebrew, and Arabic as <link 
href="text/shared/00/00000005.xhp#ctl">CTL languages</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3155420">If you select the text flow 
from right to left, embedded Western text still runs from left to right. The 
cursor responds to the arrow keys in that Right Arrow moves it "to the text 
end" and Left Arrow "to the text start".</paragraph>
+<paragraph role="paragraph" id="par_id3145609">You can change the text writing 
direction directly by pressing one of the following key 
combinations:</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3154758" xml-lang="en-US"><switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+D
 or <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right
 Shift Key - switch to right-to-left text entry</paragraph>
+<paragraph role="listitem" id="par_id3154758"><switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+D
 or <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Right
 Shift Key - switch to right-to-left text entry</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3149047" xml-lang="en-US"><switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+A
 or <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left
 Shift Key - switch to left-to-right text entry</paragraph>
+<paragraph role="listitem" id="par_id3149047"><switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+A
 or <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left
 Shift Key - switch to left-to-right text entry</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3149656" xml-lang="en-US">The 
modifier-only key combinations only work when CTL support is 
enabled.</paragraph>
+<paragraph role="listitem" id="par_id3149656">The modifier-only key 
combinations only work when CTL support is enabled.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US">In multicolumn 
pages, sections or frames that are formatted with text flow from right to left, 
the first column is the right column and the last column is the left 
column.</paragraph>
-<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US">In 
$[officename] Writer text formatted in <emph>Thai language</emph> has the 
following features:</paragraph>
+<paragraph role="paragraph" id="par_id3150541">In multicolumn pages, sections 
or frames that are formatted with text flow from right to left, the first 
column is the right column and the last column is the left column.</paragraph>
+<paragraph role="paragraph" id="par_id3148797">In $[officename] Writer text 
formatted in <emph>Thai language</emph> has the following features:</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3156280" xml-lang="en-US">In paragraphs 
with justified alignment, the characters are stretched to flush the lines at 
the margins. In other languages the spaces between words are 
stretched.</paragraph>
+<paragraph role="listitem" id="par_id3156280">In paragraphs with justified 
alignment, the characters are stretched to flush the lines at the margins. In 
other languages the spaces between words are stretched.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3154909" xml-lang="en-US">Use the Delete 
key to delete a whole composite character. Use the Backspace key to delete the 
last part of the previous composite character.</paragraph>
+<paragraph role="listitem" id="par_id3154909">Use the Delete key to delete a 
whole composite character. Use the Backspace key to delete the last part of the 
previous composite character.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3149809" xml-lang="en-US">Use the Right 
or Left Arrow key to jump to the next or previous whole composite character. To 
position the cursor into a composite character, use <switchinline 
select="sys"><caseinline 
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Arrow
 key.</paragraph>
+<paragraph role="listitem" id="par_id3149809">Use the Right or Left Arrow key 
to jump to the next or previous whole composite character. To position the 
cursor into a composite character, use <switchinline select="sys"><caseinline 
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Arrow
 key.</paragraph>
 </listitem>
 </list>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<embed href="text/shared/guide/language_select.xhp#language_select"/>
-<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US"><switchinline 
select="sys"><caseinline select="MAC">%PRODUCTNAME - 
Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - <link 
href="text/shared/optionen/01140000.xhp">Language Settings - 
Languages</link></paragraph>
-<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US"><switchinline 
select="sys"><caseinline select="MAC">%PRODUCTNAME - 
Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - <link 
href="text/shared/optionen/01150300.xhp">Language Settings - Complex Text 
Layout</link></paragraph>
+
+<section id="relatedtopics">
+    <embed href="text/shared/guide/language_select.xhp#language_select"/>
+    <paragraph role="paragraph" id="par_id3145786"><switchinline 
select="sys"><caseinline select="MAC">%PRODUCTNAME - 
Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - <link 
href="text/shared/optionen/01140000.xhp">Language Settings - 
Languages</link></paragraph>
+    <paragraph role="paragraph" id="par_id3153770"><switchinline 
select="sys"><caseinline select="MAC">%PRODUCTNAME - 
Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - <link 
href="text/shared/optionen/01150300.xhp">Language Settings - Complex Text 
Layout</link></paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/data_dbase2office.xhp 
b/source/text/shared/guide/data_dbase2office.xhp
index 3eb400d789..c2d021a78c 100644
--- a/source/text/shared/guide/data_dbase2office.xhp
+++ b/source/text/shared/guide/data_dbase2office.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,63 +16,63 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-               <helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedata_dbase2officexml" indexer="include" 
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Importing and Exporting Data in Text 
Format</title>
+<title id="tit">Importing and Exporting Data in Text Format</title>
 <filename>/text/shared/guide/data_dbase2office.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3157896"><bookmark_value>databases; text formats</bookmark_value>
+<bookmark branch="index" id="bm_id3157896"><bookmark_value>databases; text 
formats</bookmark_value>
 <bookmark_value>text formats; databases</bookmark_value>
 <bookmark_value>importing; tables in text format</bookmark_value>
 <bookmark_value>exporting; spreadsheets to text format</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="hd_id3154824" xml-lang="en-US" 
level="1"><variable id="data_dbase2office"><link 
href="text/shared/guide/data_dbase2office.xhp">Importing and Exporting Data in 
Text Format</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US">If you want to 
exchange data with a database that does not have an ODBC link and does not 
allow dBASE import and export, you can use a common text format.</paragraph>
+<h1 id="hd_id3154824"><variable id="data_dbase2office"><link 
href="text/shared/guide/data_dbase2office.xhp">Importing and Exporting Data in 
Text Format</link>
+</variable></h1>
+<paragraph role="paragraph" id="par_id3147088">If you want to exchange data 
with a database that does not have an ODBC link and does not allow dBASE import 
and export, you can use a common text format.</paragraph>
 <h2 id="hd_id3145313">Importing Data into $[officename]</h2>
-<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US">To exchange 
data in a text format use the $[officename] Calc import/export 
filter.</paragraph>
+<paragraph role="paragraph" id="par_id3147275">To exchange data in a text 
format use the $[officename] Calc import/export filter.</paragraph>
 <list type="ordered">
 <listitem>
-<paragraph role="listitem" id="par_id3145382" xml-lang="en-US">Export the 
desired data from the source database in a text format. The CSV text format is 
recommended. This format separates data fields by using delimiters such as 
commas or semi-colons, and separates records by inserting line 
breaks.</paragraph>
+<paragraph role="listitem" id="par_id3145382">Export the desired data from the 
source database in a text format. The CSV text format is recommended. This 
format separates data fields by using delimiters such as commas or semi-colons, 
and separates records by inserting line breaks.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3153821" xml-lang="en-US">Choose 
<emph>File - </emph><link 
href="text/shared/01/01020000.xhp"><emph>Open</emph></link> and click the file 
to import.</paragraph>
+<paragraph role="listitem" id="par_id3153821">Choose <emph>File - </emph><link 
href="text/shared/01/01020000.xhp"><emph>Open</emph></link> and click the file 
to import.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id1977904" xml-lang="en-US">Select "Text 
CSV" from the <emph>File type</emph> combo box. Click 
<emph>Open</emph>.</paragraph>
+<paragraph role="listitem" id="par_id1977904">Select "Text CSV" from the 
<emph>File type</emph> combo box. Click <emph>Open</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3150771" xml-lang="en-US">The <link 
href="text/shared/00/00000208.xhp"><emph>Text Import</emph></link> dialog 
appears. Decide which data to include from the text document.</paragraph>
+<paragraph role="listitem" id="par_id3150771">The <link 
href="text/shared/00/00000208.xhp"><emph>Text Import</emph></link> dialog 
appears. Decide which data to include from the text document.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3150986" xml-lang="en-US">Once the data 
is in a $[officename] Calc spreadsheet, you can edit it as needed. Save the 
data as a $[officename] data source:</paragraph>
+<paragraph role="paragraph" id="par_id3150986">Once the data is in a 
$[officename] Calc spreadsheet, you can edit it as needed. Save the data as a 
$[officename] data source:</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3149762" xml-lang="en-US">Save the 
current $[officename] Calc spreadsheet in dBASE format in the folder of a dBASE 
database. To do this, choose <emph>File - Save As</emph>, then select the 
<emph>File type</emph> "dBASE" and the folder of the dBASE database.</paragraph>
+<paragraph role="listitem" id="par_id3149762">Save the current $[officename] 
Calc spreadsheet in dBASE format in the folder of a dBASE database. To do this, 
choose <emph>File - Save As</emph>, then select the <emph>File type</emph> 
"dBASE" and the folder of the dBASE database.</paragraph>
 </listitem>
 </list>
 <h2 id="hd_id3150400">Exporting in CSV Text Format</h2>
-<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US">You can export 
the current $[officename] spreadsheet in a text format which can be read by 
many other applications.</paragraph>
+<paragraph role="paragraph" id="par_id3154140">You can export the current 
$[officename] spreadsheet in a text format which can be read by many other 
applications.</paragraph>
 <list type="ordered">
 <listitem>
-<paragraph role="listitem" id="par_id3152933" xml-lang="en-US">Choose 
<emph>File - Save as</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3152933">Choose <emph>File - Save 
as</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3154216" xml-lang="en-US">In <emph>File 
type</emph> select the filter "Text CSV". Enter a file name and click 
<emph>Save</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3154216">In <emph>File type</emph> select 
the filter "Text CSV". Enter a file name and click 
<emph>Save</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3154908" xml-lang="en-US">This opens the 
<link href="text/shared/00/00000207.xhp"><emph>Export of text 
files</emph></link> dialog, in which you can select the character set, field 
delimiter and text delimiter. Click <emph>OK</emph>. A warning informs you that 
only the active sheet was saved.</paragraph>
+<paragraph role="listitem" id="par_id3154908">This opens the <link 
href="text/shared/00/00000207.xhp"><emph>Export of text files</emph></link> 
dialog, in which you can select the character set, field delimiter and text 
delimiter. Click <emph>OK</emph>. A warning informs you that only the active 
sheet was saved.</paragraph>
 </listitem>
 </list>
-<embed href="text/shared/00/00000004.xhp#related"/>
+
+<section id="relatedtopics">
 <embed href="text/shared/guide/data_im_export.xhp#data_im_export"/>
 <switch select="appl">
-<case select="CALC"><embed 
href="text/scalc/guide/dbase_files.xhp#dbase_files"/>
-</case>
-</switch></body>
+<case select="CALC"><embed 
href="text/scalc/guide/dbase_files.xhp#dbase_files"/></case>
+</switch>
+</section>
+</body>
 </helpdocument>
diff --git a/source/text/shared/guide/data_report.xhp 
b/source/text/shared/guide/data_report.xhp
index b4a1e69479..f15716a25a 100644
--- a/source/text/shared/guide/data_report.xhp
+++ b/source/text/shared/guide/data_report.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,17 +16,15 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-               <helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedata_reportxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Using and Editing Database Reports </title>
+<title id="tit">Using and Editing Database Reports </title>
 <filename>/text/shared/guide/data_report.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3147834"><bookmark_value>database reports</bookmark_value>
+<bookmark branch="index" id="bm_id3147834"><bookmark_value>database 
reports</bookmark_value>
 <bookmark_value>data sources;reports</bookmark_value>
 <bookmark_value>reports;opening and editing</bookmark_value>
 <bookmark_value>editing;reports</bookmark_value>
@@ -37,41 +32,43 @@
 <bookmark_value>templates;database reports</bookmark_value>
 <bookmark_value>reports;templates</bookmark_value>
 </bookmark>
-<paragraph role="paragraph" id="par_id3147834" xml-lang="en-US" 
localize="false"/>
-<paragraph role="heading" id="hd_id3149178" xml-lang="en-US" 
level="1"><variable id="data_report"><link 
href="text/shared/guide/data_report.xhp">Using and Editing Database 
Reports</link>
-</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147834" localize="false"/>
+<h1 id="hd_id3149178"><variable id="data_report"><link 
href="text/shared/guide/data_report.xhp">Using and Editing Database 
Reports</link>
+</variable></h1>
 <h2 id="hd_id3145609">Using a Report</h2>
-<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US">%PRODUCTNAME 
stores the information about the created reports in the database 
file.</paragraph>
+<paragraph role="paragraph" id="par_id3147265">%PRODUCTNAME stores the 
information about the created reports in the database file.</paragraph>
 <list type="ordered">
 <listitem>
-<paragraph role="listitem" id="par_id3154758" xml-lang="en-US">Choose 
<emph>File - Open</emph> and select the database file.</paragraph>
+<paragraph role="listitem" id="par_id3154758">Choose <emph>File - Open</emph> 
and select the database file.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3151054" xml-lang="en-US">In the database 
file window, click the <emph>Reports</emph> icon.</paragraph>
+<paragraph role="listitem" id="par_id3151054">In the database file window, 
click the <emph>Reports</emph> icon.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3156280" xml-lang="en-US">Double-click 
one of the report names to open the report.</paragraph>
-<paragraph role="note" id="par_idN1077D" xml-lang="en-US">These links are 
added automatically when you create a new report by the Report Wizard or in the 
Report Builder window.</paragraph>
+<paragraph role="listitem" id="par_id3156280">Double-click one of the report 
names to open the report.</paragraph>
+<note id="par_idN1077D">These links are added automatically when you create a 
new report by the Report Wizard or in the Report Builder window.</note>
 </listitem>
 </list>
 <h2 id="hd_id1695608">Editing a Report Created in the Report Builder 
Window</h2>
 <list type="unordered">
 <listitem>
-<paragraph role="paragraph" id="par_id7510910" xml-lang="en-US">Right-click 
the name of a report in the database file window, then choose Edit.</paragraph>
+<paragraph role="paragraph" id="par_id7510910">Right-click the name of a 
report in the database file window, then choose Edit.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id8138065" xml-lang="en-US">The Report 
Builder window opens with the report's information loaded. </paragraph>
-<paragraph role="paragraph" id="par_id5086825" xml-lang="en-US">Use the 
toolbars and menu commands and drag-and-drop to edit the report as stated in 
the <link href="text/sdatabase/rep_main.xhp">Report Builder</link> 
guide.</paragraph>
-<paragraph role="paragraph" id="par_id4747154" xml-lang="en-US">Execute the 
report to see the resulting report document.</paragraph>
+<paragraph role="paragraph" id="par_id8138065">The Report Builder window opens 
with the report's information loaded. </paragraph>
+<paragraph role="paragraph" id="par_id5086825">Use the toolbars and menu 
commands and drag-and-drop to edit the report as stated in the <link 
href="text/sdatabase/rep_main.xhp">Report Builder</link> guide.</paragraph>
+<paragraph role="paragraph" id="par_id4747154">Execute the report to see the 
resulting report document.</paragraph>
 <h2 id="hd_id3153104">Editing a Report Created by the Report Wizard</h2>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3125863" xml-lang="en-US">On the <link 
href="text/shared/autopi/01100500.xhp">last dialog page of the Report 
Wizard</link>, you can choose to edit the report template before you use the 
report.</paragraph>
+<paragraph role="listitem" id="par_id3125863">On the <link 
href="text/shared/autopi/01100500.xhp">last dialog page of the Report 
Wizard</link>, you can choose to edit the report template before you use the 
report.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3155431" xml-lang="en-US">You can edit 
the page styles for the first page and the following pages of the report as 
well as the paragraph styles, the number formats, the printed field labels, and 
more.</paragraph>
-<paragraph role="warning" id="par_idN107D7" xml-lang="en-US">Unless you have a 
thorough understanding of the database the report accesses, do not edit the SQL 
statement, database name, the hidden form controls, or the related information 
on the report.</paragraph>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<embed href="text/shared/guide/database_main.xhp#database_main"/>
+<paragraph role="paragraph" id="par_id3155431">You can edit the page styles 
for the first page and the following pages of the report as well as the 
paragraph styles, the number formats, the printed field labels, and 
more.</paragraph>
+<warning id="par_idN107D7">Unless you have a thorough understanding of the 
database the report accesses, do not edit the SQL statement, database name, the 
hidden form controls, or the related information on the report.</warning>
+
+<section id="relatedtopics">
+       <embed href="text/shared/guide/database_main.xhp#database_main"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/data_reports.xhp 
b/source/text/shared/guide/data_reports.xhp
index 4dc4d498d2..0973ddaf9b 100644
--- a/source/text/shared/guide/data_reports.xhp
+++ b/source/text/shared/guide/data_reports.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,118 +16,116 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-               <helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedata_reportsxhp" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Creating Reports </title>
+<title id="tit">Creating Reports </title>
 <filename>/text/shared/guide/data_reports.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3729667"><bookmark_value>databases;creating reports</bookmark_value>
+<bookmark branch="index" id="bm_id3729667"><bookmark_value>databases;creating 
reports</bookmark_value>
 <bookmark_value>reports;creating</bookmark_value>
 <bookmark_value>wizards;reports</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="par_idN105A3" xml-lang="en-US" 
level="1"><variable id="data_reports"><link 
href="text/shared/guide/data_reports.xhp">Creating Reports</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_idN105C1" xml-lang="en-US">A report is a 
Writer text document that can show your data in an organized order and 
formatting. In %PRODUCTNAME Base, you have a choice to create a report either 
manually using drag-and-drop in the Report Builder window, or semi-automatic by 
following a series of dialogs in the Report Wizard. </paragraph>
-<paragraph role="paragraph" id="par_id4094363" xml-lang="en-US">The following 
list gives you some information to decide which method to use for your 
data:</paragraph>
+<h1 id="par_idN105A3"><variable id="data_reports"><link 
href="text/shared/guide/data_reports.xhp">Creating Reports</link>
+</variable></h1>
+<paragraph role="paragraph" id="par_idN105C1">A report is a Writer text 
document that can show your data in an organized order and formatting. In 
%PRODUCTNAME Base, you have a choice to create a report either manually using 
drag-and-drop in the Report Builder window, or semi-automatic by following a 
series of dialogs in the Report Wizard. </paragraph>
+<paragraph role="paragraph" id="par_id4094363">The following list gives you 
some information to decide which method to use for your data:</paragraph>
 <table id="tbl_id1888180">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id8514358" xml-lang="en-US">Report 
Builder</paragraph>
+<tablecell>
+<paragraph role="tablehead" id="par_id8514358">Report Builder</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id9764091" xml-lang="en-US">Report 
Wizard</paragraph>
+<tablecell>
+<paragraph role="tablehead" id="par_id9764091">Report Wizard</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1579638" xml-lang="en-US">Started by 
"Create Report in Design View" command.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id1579638">Started by "Create Report in 
Design View" command.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1886959" xml-lang="en-US">Started by 
"Use Wizard to Create Report" command.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id1886959">Started by "Use Wizard to 
Create Report" command.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id455030" xml-lang="en-US">Full 
flexibility to use report headers and footers, page headers and footers, 
multi-column reports.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id455030">Full flexibility to use 
report headers and footers, page headers and footers, multi-column 
reports.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id8409985" xml-lang="en-US">Uses a 
Writer template to generate a report document.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id8409985">Uses a Writer template to 
generate a report document.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id5931272" xml-lang="en-US">Use 
drag-and-drop to position the record fields or other design elements like 
pictures or lines.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id5931272">Use drag-and-drop to 
position the record fields or other design elements like pictures or 
lines.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id9869075" xml-lang="en-US">Select from 
several given choices to arrange the data records.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id9869075">Select from several given 
choices to arrange the data records.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id8611713" xml-lang="en-US">Generates a 
one-time snapshot of the data. To see an updated report, execute the same 
report again to create a Writer document with the updated data.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id8611713">Generates a one-time 
snapshot of the data. To see an updated report, execute the same report again 
to create a Writer document with the updated data.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2866908" xml-lang="en-US">You can 
choose to generate a one-time snapshot with fixed data, or a "live" report with 
links to the current data at the time when you open the Base file.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id2866908">You can choose to generate a 
one-time snapshot with fixed data, or a "live" report with links to the current 
data at the time when you open the Base file.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4169743" xml-lang="en-US">Saves the 
report as a Writer text document. Stores the information how to create the 
report inside the Base file.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id4169743">Saves the report as a Writer 
text document. Stores the information how to create the report inside the Base 
file.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id408948" xml-lang="en-US">Saves the 
report and the information how to create the report inside the Base 
file.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id408948">Saves the report and the 
information how to create the report inside the Base file.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2891933" xml-lang="en-US">Choose Open 
in the context menu or double-click the report name to create a new report with 
the current data.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id2891933">Choose Open in the context 
menu or double-click the report name to create a new report with the current 
data.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id6142765" xml-lang="en-US">Choose Open 
in the context menu or double-click the report name to either see again the 
static snapshot of the data from first creation time, or to create a new report 
with the current data. This depends on your choice on the last page of the 
wizard.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id6142765">Choose Open in the context 
menu or double-click the report name to either see again the static snapshot of 
the data from first creation time, or to create a new report with the current 
data. This depends on your choice on the last page of the wizard.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1757560" xml-lang="en-US">Choose Edit 
in the context menu of a report name to open the Report Builder window, with 
the report's information loaded.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id1757560">Choose Edit in the context 
menu of a report name to open the Report Builder window, with the report's 
information loaded.</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4649189" xml-lang="en-US">Choose Edit 
in the context menu of a report name to edit the Writer template file that was 
used to create the report.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id4649189">Choose Edit in the context 
menu of a report name to edit the Writer template file that was used to create 
the report.</paragraph>
 </tablecell>
 </tablerow>
 </table>
 <h2 id="hd_id8414258">Creating a New Report Manually In Design View</h2>
 <list type="ordered">
 <listitem>
-<paragraph role="paragraph" id="par_id3119602" xml-lang="en-US">Open the 
database file where you want to create the new report.</paragraph>
+<paragraph role="paragraph" id="par_id3119602">Open the database file where 
you want to create the new report.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id4226508" xml-lang="en-US">In the left 
pane of the database window, click the <emph>Reports</emph> icon.</paragraph>
+<paragraph role="paragraph" id="par_id4226508">In the left pane of the 
database window, click the <emph>Reports</emph> icon.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id5758842" xml-lang="en-US">Click 
<emph>Create Report in Design View</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id5758842">Click <emph>Create Report in 
Design View</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id4870754" xml-lang="en-US">Follow the 
instructions in the <link href="text/sdatabase/rep_main.xhp">Report 
Builder</link> guide.</paragraph>
+<paragraph role="paragraph" id="par_id4870754">Follow the instructions in the 
<link href="text/sdatabase/rep_main.xhp">Report Builder</link> 
guide.</paragraph>
 </listitem>
 </list>
 <h2 id="par_idN105C4">Creating a New Report With the Report Wizard</h2>
 <list type="ordered">
 <listitem>
-<paragraph role="paragraph" id="par_idN105DC" xml-lang="en-US">Open the 
database file where you want to create the new report.</paragraph>
+<paragraph role="paragraph" id="par_idN105DC">Open the database file where you 
want to create the new report.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN105E0" xml-lang="en-US">In the left 
pane of the database window, click the <emph>Reports</emph> icon.</paragraph>
+<paragraph role="paragraph" id="par_idN105E0">In the left pane of the database 
window, click the <emph>Reports</emph> icon.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_idN105E8" xml-lang="en-US">Click <emph>Use 
Wizard to Create Report</emph>.</paragraph>
+<paragraph role="paragraph" id="par_idN105E8">Click <emph>Use Wizard to Create 
Report</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id8032166" xml-lang="en-US">Follow the 
steps of the <link href="text/shared/autopi/01100000.xhp">Report Wizard</link> 
to create the report.</paragraph>
+<paragraph role="paragraph" id="par_id8032166">Follow the steps of the <link 
href="text/shared/autopi/01100000.xhp">Report Wizard</link> to create the 
report.</paragraph>
 </listitem>
 </list>
 <section id="relatedtopics">
diff --git a/source/text/shared/guide/data_search.xhp 
b/source/text/shared/guide/data_search.xhp
index 16e431ce7c..e2911c1e12 100644
--- a/source/text/shared/guide/data_search.xhp
+++ b/source/text/shared/guide/data_search.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-       
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedata_searchxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Searching Tables and Form Documents</title>
+<title id="tit">Searching Tables and Form Documents</title>
 <filename>/text/shared/guide/data_search.xhp</filename>
 </topic>
 <history>
@@ -30,27 +27,27 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id4066896"><bookmark_value>finding;records in form 
documents</bookmark_value>
+<bookmark branch="index" id="bm_id4066896"><bookmark_value>finding;records in 
form documents</bookmark_value>
 <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"><variable id="data_search"><link 
href="text/shared/guide/data_search.xhp">Searching Tables and Form 
Documents</link>
-</variable></paragraph>
+<h1 id="hd_id3154186"><variable id="data_search"><link 
href="text/shared/guide/data_search.xhp">Searching Tables and Form 
Documents</link>
+</variable></h1>
 <table id="tbl_id3149346">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US">
-<image id="img_id3153311" src="cmd/sc_recsearch.png" width="0.222inch" 
height="0.222inch"><alt id="alt_id3153311" xml-lang="en-US">Icon</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3147088"><image id="img_id3153311" 
src="cmd/sc_recsearch.png" width="1cm" height="1cm"><alt 
id="alt_id3153311">Icon Search</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149178" xml-lang="en-US">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>
+<paragraph role="paragraph" id="par_id3149178">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">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 &amp; Replace</emph> dialog. You can find 
additional information about the database search function in the <link 
href="text/shared/02/12100200.xhp">$[officename] Help</link>.</paragraph>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<embed href="text/shared/guide/data_search2.xhp#data_search2"/>
+<paragraph role="paragraph" id="par_id3149811">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 &amp; Replace</emph> dialog. You can find additional information 
about the database search function in the <link 
href="text/shared/02/12100200.xhp">$[officename] Help</link>.</paragraph>
+
+<section id="relatedtopics">
+       <embed href="text/shared/guide/data_search2.xhp#data_search2"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/data_search2.xhp 
b/source/text/shared/guide/data_search2.xhp
index 928fbe6ac5..b42a06d2e4 100644
--- a/source/text/shared/guide/data_search2.xhp
+++ b/source/text/shared/guide/data_search2.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,17 +16,15 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-               <helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedata_search2xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Searching With a Form Filter</title>
+<title id="tit">Searching With a Form Filter</title>
 <filename>/text/shared/guide/data_search2.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id8772545"><bookmark_value>form filters</bookmark_value>
+<bookmark branch="index" id="bm_id8772545"><bookmark_value>form 
filters</bookmark_value>
 <bookmark_value>databases;form filters</bookmark_value>
 <bookmark_value>searching; form filters</bookmark_value>
 <bookmark_value>removing;form filters</bookmark_value>
@@ -37,40 +32,81 @@
 <bookmark_value>data;filtering in forms</bookmark_value>
 <bookmark_value>forms; filtering data</bookmark_value>
 <bookmark_value>data, see also values</bookmark_value>
-</bookmark><comment>MW inserted a cross-reference</comment><paragraph 
role="heading" id="hd_id3156042" xml-lang="en-US" level="1"><variable 
id="data_search2"><link href="text/shared/guide/data_search2.xhp">Searching 
With a Form Filter</link>
-</variable></paragraph>
+</bookmark><comment>MW inserted a cross-reference</comment><h1 
id="hd_id3156042"><variable id="data_search2"><link 
href="text/shared/guide/data_search2.xhp">Searching With a Form Filter</link>
+</variable></h1>
 <list type="ordered">
 <listitem>
-<paragraph role="paragraph" id="par_id3149182" xml-lang="en-US">Open a form 
document that contains database fields.</paragraph>
-<paragraph role="paragraph" id="par_id3159157" xml-lang="en-US">As an example, 
open an empty text document and press <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 + Shift + F4 keys. Open the bibliography database table <emph>biblio</emph> in 
the data source view. While pressing Shift+<switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>,
 drag a few column headers into the document so that the form fields are 
created.</paragraph>
+<paragraph role="paragraph" id="par_id3149182">Open a form document that 
contains database fields.</paragraph>
+<paragraph role="paragraph" id="par_id3159157">As an example, open an empty 
text document and press <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 + Shift + F4 keys. Open the bibliography database table <emph>biblio</emph> in 
the data source view. While pressing Shift+<switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>,
 drag a few column headers into the document so that the form fields are 
created.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3150984" xml-lang="en-US">On the 
<emph>Form Controls</emph> toolbar, click the <emph>Design Mode On/Off</emph> 
icon
-<image id="img_id3147618" src="cmd/sc_switchcontroldesignmode.png" 
width="0.222inch" height="0.222inch"><alt id="alt_id3147618" 
xml-lang="en-US">Icon</alt>
-       </image> to turn off the design mode.</paragraph>
+<paragraph role="paragraph" id="par_id3150984">On the <emph>Form 
Controls</emph> toolbar, click the <emph>Design Mode On/Off</emph> icon to turn 
off the design mode.</paragraph>
+<table id="tab_id741679928774599">
+       <tablerow>
+               <tablecell>
+                       <paragraph id="par_id801679928774600" role="paragraph">
+                               <image src="cmd/lc_switchcontroldesignmode.svg" 
id="img_id541679928774601" width="1cm"  height="1cm"><alt xml-lang="en-US" 
id="alt_id691679928774602">Icon Design Mode</alt></image>
+                       </paragraph>
+               </tablecell>
+               <tablecell>
+                       <paragraph id="par_id651679928774604" role="paragraph" 
xml-lang="en-US">Design Mode On/Off</paragraph>
+               </tablecell>
+       </tablerow>
+</table>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3148672" xml-lang="en-US">On the 
<emph>Form Navigation</emph> toolbar, click the <emph>Form-Based Filters</emph> 
icon
-<image id="img_id3149807" src="cmd/sc_formfilter.png" width="0.222inch" 
height="0.222inch"><alt id="alt_id3149807" xml-lang="en-US">Icon</alt>
-       </image>. The current document is displayed with its form controls as 
an empty edit mask. The <emph>Form Filter </emph>toolbar appears.</paragraph>
+<paragraph role="paragraph" id="par_id3148672">On the <emph>Form 
Navigation</emph> toolbar, click the <emph>Form-Based Filters</emph> icon. The 
current document is displayed with its form controls as an empty edit mask. The 
<emph>Form Filter </emph>toolbar appears.</paragraph>
+       <table id="tab_id711679928863235">
+               <tablerow>
+                       <tablecell>
+                               <paragraph id="par_id361679928863236" 
role="paragraph">
+                                       <image src="cmd/sc_formfilter.png" 
id="img_id931679928863237" width="1cm"  height="1cm"><alt xml-lang="en-US" 
id="alt_id881679928863238">Icon Form Navigator</alt></image>
+                               </paragraph>
+                       </tablecell>
+                       <tablecell>
+                               <paragraph id="par_id861679928863240" 
role="paragraph" xml-lang="en-US">Form Navigator</paragraph>
+                       </tablecell>
+               </tablerow>
+       </table>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US">Enter the 
filter conditions into one or several fields. Note that if you enter filter 
conditions into several fields, all of the entered conditions must match 
(Boolean AND).</paragraph>
+<paragraph role="paragraph" id="par_id3149666">Enter the filter conditions 
into one or several fields. Note that if you enter filter conditions into 
several fields, all of the entered conditions must match (Boolean 
AND).</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3149481" xml-lang="en-US">More 
information about wildcards and operators can be found in <link 
href="text/sdatabase/02010100.xhp">Query Design</link>. </paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormFilterExecute" 
id="bm_id9819688" localize="false"/>
-<paragraph role="paragraph" id="par_id3152462" xml-lang="en-US"><ahelp 
hid=".uno:FormFilterExecute">If you click the <emph>Apply Form-Based 
Filter</emph> icon on the <emph>Form Filter</emph> toolbar, the filter will be 
applied.</ahelp> You see the <emph>Form Navigation</emph> toolbar and can 
browse through the found records.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormFilterExit" id="bm_id2865336" 
localize="false"/>
-<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"><ahelp 
hid=".uno:FormFilterExit">If you click on the <emph>Close</emph> button on the 
<emph>Form Filter</emph> toolbar, the form is displayed without a 
filter.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3150114" xml-lang="en-US">Click the 
<link href="text/shared/02/12120000.xhp"><emph>Apply Filter</emph></link> icon
-<image id="img_id3144764" src="cmd/sc_datafilterstandardfilter.png" 
width="0.222inch" height="0.222inch"><alt id="alt_id3144764" 
xml-lang="en-US">Icon</alt>
-       </image> on the <emph>Form Navigation</emph> toolbar to change to the 
filtered view.</paragraph>
-<paragraph role="paragraph" id="par_id3146898" xml-lang="en-US">The filter 
that has been set can be removed by clicking <link 
href="text/shared/02/12040000.xhp"><emph>Reset Filter/Sort</emph></link> icon
-<image id="img_id3151318" src="cmd/sc_removefiltersort.png" width="0.222inch" 
height="0.222inch"><alt id="alt_id3151318" xml-lang="en-US">Icon</alt>
-       </image>.</paragraph>
-<embed href="text/shared/00/00000004.xhp#related"/>
-<embed href="text/shared/guide/filternavigator.xhp#filternavigator"/>
-<embed href="text/shared/guide/data_search.xhp#data_search"/>
+<paragraph role="paragraph" id="par_id3149481">More information about 
wildcards and operators can be found in <link 
href="text/sdatabase/02010100.xhp">Query Design</link>. </paragraph>
+<bookmark branch="hid/.uno:FormFilterExecute" id="bm_id9819688" 
localize="false"/>
+<paragraph role="paragraph" id="par_id3152462"><ahelp 
hid=".uno:FormFilterExecute">If you click the <emph>Apply Form-Based 
Filter</emph> icon on the <emph>Form Filter</emph> toolbar, the filter will be 
applied.</ahelp> You see the <emph>Form Navigation</emph> toolbar and can 
browse through the found records.</paragraph>
+<bookmark branch="hid/.uno:FormFilterExit" id="bm_id2865336" localize="false"/>
+<paragraph role="paragraph" id="par_id3145273"><ahelp 
hid=".uno:FormFilterExit">If you click on the <emph>Close</emph> button on the 
<emph>Form Filter</emph> toolbar, the form is displayed without a 
filter.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150114">Click the <link 
href="text/shared/02/12120000.xhp"><emph>Apply Filter</emph></link> icon on the 
<emph>Form Navigation</emph> toolbar to change to the filtered view.</paragraph>
+<table id="tab_id381679929261703">
+       <tablerow>
+               <tablecell>
+                       <paragraph id="par_id191679929261704" role="paragraph">
+                               <image 
src="cmd/lc_datafilterstandardfilter.svg" id="img_id111679929261705" 
width="1cm"  height="1cm"><alt xml-lang="en-US" id="alt_id561679929261706">Icon 
Apply Filter</alt></image>
+                       </paragraph>
+               </tablecell>
+               <tablecell>
+                       <paragraph id="par_id901679929261708" role="paragraph" 
xml-lang="en-US">Apply Filter</paragraph>
+               </tablecell>
+       </tablerow>
+</table>
+<paragraph role="paragraph" id="par_id3146898">The filter that has been set 
can be removed by clicking <link href="text/shared/02/12040000.xhp"><emph>Reset 
Filter/Sort</emph></link> icon.</paragraph>
+       <table id="tab_id631679929385834">
+               <tablerow>
+                       <tablecell>
+                               <paragraph id="par_id551679929385836" 
role="paragraph">
+                                       <image 
src="cmd/lc_removefiltersort.svg" id="img_id341679929385837" width="1cm"  
height="1cm"><alt xml-lang="en-US" id="alt_id981679929385838">Icon Reset 
Filter/Sort</alt></image>
+                               </paragraph>
+                       </tablecell>
+                       <tablecell>
+                               <paragraph id="par_id501679929385841" 
role="paragraph" xml-lang="en-US">Reset Filter/Sort</paragraph>
+                       </tablecell>
+               </tablerow>
+       </table>
+<section id="relatedtopics">
+       <embed href="text/shared/guide/filternavigator.xhp#filternavigator"/>
+       <embed href="text/shared/guide/data_search.xhp#data_search"/>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/data_tabledefine.xhp 
b/source/text/shared/guide/data_tabledefine.xhp
index f0b877d7d0..428b796000 100644
--- a/source/text/shared/guide/data_tabledefine.xhp
+++ b/source/text/shared/guide/data_tabledefine.xhp
@@ -22,43 +22,44 @@
 
 <meta>
       <topic id="textsharedguidedata_tabledefinexml" indexer="include" 
status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Table Design</title>
+         <title id="tit">Table Design</title>
          <filename>/text/shared/guide/data_tabledefine.xhp</filename>
       </topic>
    </meta>
    <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3155448"><bookmark_value>tables in databases; creating in design view 
(manually)</bookmark_value>
+<bookmark branch="index" id="bm_id3155448"><bookmark_value>tables in 
databases; creating in design view (manually)</bookmark_value>
       <bookmark_value>designing; database tables</bookmark_value>
       <bookmark_value>properties;fields in databases</bookmark_value>
       <bookmark_value>fields;database tables</bookmark_value>
       <bookmark_value>AutoValue (Base)</bookmark_value>
       <bookmark_value>primary keys;design view</bookmark_value>
 </bookmark><comment>MW deleted "database tables;" and changed "tables in 
databases;"</comment><comment>UFI added AutoValue and Primary Key entry - 
i48831</comment><comment>MW changed Tables in databases, AutoValue and Primary 
Key entries</comment>
-<paragraph xml-lang="en-US" id="par_id3155448" role="paragraph" 
localize="false"/>
-      <paragraph xml-lang="en-US" id="hd_id3149798" role="heading" 
level="1"><variable id="data_tabledefine"><link 
href="text/shared/guide/data_tabledefine.xhp">Table Design</link>
-</variable></paragraph>
-      <paragraph xml-lang="en-US" id="par_id3155535" role="paragraph">This 
section contains information about how to create a new database table in the 
<link href="text/sdatabase/05010000.xhp">design view</link>.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3154288" role="paragraph">Open the 
database file of the database where you want a new table. Click the 
<emph>Tables</emph> icon. Choose <emph>Create Table in Design View</emph> to 
create a new table.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3146798" role="paragraph">In the 
Design view, you can now create the fields for your table.</paragraph>
+<paragraph id="par_id3155448" role="paragraph" localize="false"/>
+      <h1 id="hd_id3149798"><variable id="data_tabledefine"><link 
href="text/shared/guide/data_tabledefine.xhp">Table 
Design</link></variable></h1>
+      <paragraph id="par_id3155535" role="paragraph">This section contains 
information about how to create a new database table in the <link 
href="text/sdatabase/05010000.xhp">design view</link>.</paragraph>
+      <paragraph id="par_id3154288" role="paragraph">Open the database file of 
the database where you want a new table. Click the <emph>Tables</emph> icon. 
Choose <emph>Create Table in Design View</emph> to create a new 
table.</paragraph>
+      <paragraph id="par_id3146798" role="paragraph">In the Design view, you 
can now create the fields for your table.</paragraph>
       <list type="unordered">
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3153349" 
role="listitem">Enter new fields in rows from top to bottom. Click the 
<emph>Field Name</emph> cell and enter a field name for each data 
field.</paragraph>
+            <paragraph id="par_id3153349" role="listitem">Enter new fields in 
rows from top to bottom. Click the <emph>Field Name</emph> cell and enter a 
field name for each data field.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id1595507" 
role="listitem">Include a "primary key" data field. Base needs a primary key to 
be able to edit the table contents. A primary key has unique contents for each 
data record. For example, insert a numerical field, right-click the first 
column, and choose <emph>Primary Key</emph> from the context menu. Set 
<emph>AutoValue</emph> to "Yes", so Base can automatically increment the value 
for each new record.</paragraph>
+            <paragraph id="par_id1595507" role="listitem">Include a "primary 
key" data field. Base needs a primary key to be able to edit the table 
contents. A primary key has unique contents for each data record. For example, 
insert a numerical field, right-click the first column, and choose 
<emph>Primary Key</emph> from the context menu. Set <emph>AutoValue</emph> to 
"Yes", so Base can automatically increment the value for each new 
record.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3150084" role="listitem">In 
the next cell to the right, define the <emph>Field Type</emph>. When you click 
in the cell, you can select a field type in the combo box.</paragraph>
+            <paragraph id="par_id3150084" role="listitem">In the next cell to 
the right, define the <emph>Field Type</emph>. When you click in the cell, you 
can select a field type in the combo box.</paragraph>
          </listitem>
       </list>
-      <paragraph xml-lang="en-US" id="par_id3154760" role="note">Each field 
can only accept data corresponding to the specified field type. For example, it 
is not possible to enter text in a number field. Memo fields in dBASE III 
format are references to internally-managed text files which can hold up to 64 
kB text.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3149456" role="paragraph">You can 
enter an optional <emph>Description</emph> for each field. The text of the 
description will appear as a tip on the column headings in the table 
view.</paragraph>
+      <note id="par_id3154760">Each field can only accept data corresponding 
to the specified field type. For example, it is not possible to enter text in a 
number field. Memo fields in dBASE III format are references to 
internally-managed text files which can hold up to 64 kB text.</note>
+      <paragraph id="par_id3149456" role="paragraph">You can enter an optional 
<emph>Description</emph> for each field. The text of the description will 
appear as a tip on the column headings in the table view.</paragraph>
       <h2 id="hd_id3153379">Field Properties</h2>
-      <paragraph xml-lang="en-US" id="par_id3148798" role="paragraph">Enter 
properties for each selected data field. Depending on the database type, some 
input facilities may not be available.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3144762" role="paragraph">In the 
<emph>Default value</emph> box, enter the default contents for every new 
record. This contents can be edited later.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3150869" role="paragraph">In the 
<emph>Entry required</emph> box, specify whether or not the field may remain 
empty.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3154908" role="paragraph">For the 
<emph>Length</emph> box, a combo box may be shown that provides the available 
choices.</paragraph>
-      <embed href="text/shared/00/00000004.xhp#related"/>
-      <embed href="text/shared/guide/database_main.xhp#database_main"/>
+      <paragraph id="par_id3148798" role="paragraph">Enter properties for each 
selected data field. Depending on the database type, some input facilities may 
not be available.</paragraph>
+      <paragraph id="par_id3144762" role="paragraph">In the <emph>Default 
value</emph> box, enter the default contents for every new record. This 
contents can be edited later.</paragraph>
+      <paragraph id="par_id3150869" role="paragraph">In the <emph>Entry 
required</emph> box, specify whether or not the field may remain 
empty.</paragraph>
+      <paragraph id="par_id3154908" role="paragraph">For the 
<emph>Length</emph> box, a combo box may be shown that provides the available 
choices.</paragraph>
+
+      <section id="relatedtopics">
+         <embed href="text/shared/guide/database_main.xhp#database_main"/>
+      </section>
    </body>
 </helpdocument>
diff --git a/source/text/shared/guide/dragdrop.xhp 
b/source/text/shared/guide/dragdrop.xhp
index 7075ee9543..a50b01ba75 100644
--- a/source/text/shared/guide/dragdrop.xhp
+++ b/source/text/shared/guide/dragdrop.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-       
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedragdropxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Dragging and Dropping Within a $[officename] 
Document</title>
+<title id="tit">Dragging and Dropping Within a $[officename] Document</title>
 <filename>/text/shared/guide/dragdrop.xhp</filename>
 </topic>
 <history>
@@ -30,73 +27,65 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3154927"><bookmark_value>drag and drop;overview</bookmark_value>
+<bookmark branch="index" id="bm_id3154927"><bookmark_value>drag and 
drop;overview</bookmark_value>
 <bookmark_value>mouse; pointers when using drag and drop</bookmark_value>
 <bookmark_value>links;by drag and drop</bookmark_value>
 <bookmark_value>copying;by drag and drop</bookmark_value>
 </bookmark>
-<paragraph role="paragraph" id="par_id3154927" xml-lang="en-US" 
localize="false"/>
-<paragraph role="heading" id="hd_id3147571" xml-lang="en-US" 
level="1"><variable id="dragdrop"><link 
href="text/shared/guide/dragdrop.xhp">Dragging and Dropping Within a 
$[officename] Document</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147008" xml-lang="en-US">There are many 
options for moving or copying objects using drag-and-drop. Text sections, 
drawing objects, graphics, form controls, hyperlinks, cell ranges, and many 
more can be moved or copied with the mouse.</paragraph>
-<paragraph role="paragraph" id="par_id3155892" xml-lang="en-US">Note that the 
mouse pointer displays a plus sign when copying and an arrow when creating a 
link or hyperlink.</paragraph>
+<paragraph role="paragraph" id="par_id3154927" localize="false"/>
+<h1 id="hd_id3147571"><variable id="dragdrop"><link 
href="text/shared/guide/dragdrop.xhp">Dragging and Dropping Within a 
$[officename] Document</link></variable></h1>
+<paragraph role="paragraph" id="par_id3147008">There are many options for 
moving or copying objects using drag-and-drop. Text sections, drawing objects, 
graphics, form controls, hyperlinks, cell ranges, and many more can be moved or 
copied with the mouse.</paragraph>
+<paragraph role="paragraph" id="par_id3155892">Note that the mouse pointer 
displays a plus sign when copying and an arrow when creating a link or 
hyperlink.</paragraph>
 <table id="tbl_id3147576">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3146798" xml-lang="en-US">Mouse 
Pointer</paragraph>
+<tablecell>
+<paragraph role="tablehead" id="par_id3146798">Mouse Pointer</paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3147618" 
xml-lang="en-US">Description</paragraph>
+<tablecell>
+<paragraph role="tablehead" id="par_id3147618">Description</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3159177" xml-lang="en-US">
-<image id="img_id3147573" src="media/helpimg/movedata.png" width="8.47mm" 
height="8.47mm"><alt id="alt_id3147573" xml-lang="en-US">Mouse pointer moving 
data</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3159177"><image id="img_id3147573" 
src="media/helpimg/movedata.png" width="8.47mm" height="8.47mm"><alt 
id="alt_id3147573">Mouse pointer moving data</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3154898" 
xml-lang="en-US">Moving</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3154898">Moving</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3154306" xml-lang="en-US">
-<image id="img_id3149233" src="media/helpimg/copydata.png" width="8.47mm" 
height="8.47mm"><alt id="alt_id3149233" xml-lang="en-US">Mouse pointer copying 
data</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3154306"><image id="img_id3149233" 
src="media/helpimg/copydata.png" width="8.47mm" height="8.47mm"><alt 
id="alt_id3149233">Mouse pointer copying data</alt>   </image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153627" 
xml-lang="en-US">Copying</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3153627">Copying</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153896" xml-lang="en-US">
-<image id="img_id3159413" src="media/helpimg/linkdata.png" width="8.47mm" 
height="8.47mm"><alt id="alt_id3159413" xml-lang="en-US">Mouse pointer 
inserting link</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3153896"><image id="img_id3159413" 
src="media/helpimg/linkdata.png" width="8.47mm" height="8.47mm"><alt 
id="alt_id3159413">Mouse pointer inserting link</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3154938" xml-lang="en-US">Creating a 
link</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3154938">Creating a link</paragraph>
 </tablecell>
 </tablerow>
 </table>
 
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US">If you press 
<switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 or Shift+<switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 while releasing the mouse button, you can control whether the object is 
copied, moved, or a link is created.</paragraph>
+<paragraph role="paragraph" id="par_id3154366">If you press <switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 or Shift+<switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 while releasing the mouse button, you can control whether the object is 
copied, moved, or a link is created.</paragraph>
 <table id="tbl_id3150768">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3148672" xml-lang="en-US">
-<image id="img_id3158407" src="sw/res/sc20238.png" width="5.64mm" 
height="5.64mm"><alt id="alt_id3158407" xml-lang="en-US">Icon</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3148672"><image id="img_id3158407" 
src="sw/res/sc20238.png" width="1cm" height="1cm"><alt id="alt_id3158407">Icon 
Drag Mode</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US">If you drag 
objects out of the <link 
href="text/shared/guide/navigator.xhp"><emph>Navigator</emph></link>, you can 
specify in the submenu of the Navigator's <emph>Drag Mode</emph> icon whether 
to copy the object, insert it as a link or insert it as a hyperlink.</paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3156422">If you drag objects out of the 
<link href="text/shared/guide/navigator.xhp"><emph>Navigator</emph></link>, you 
can specify in the submenu of the Navigator's <emph>Drag Mode</emph> icon 
whether to copy the object, insert it as a link or insert it as a 
hyperlink.</paragraph>
 </tablecell>
 </tablerow>
 </table>
 
-<paragraph role="tip" id="par_id3153144" xml-lang="en-US">You can cancel a 
drag-and-drop operation in $[officename] at any time by pressing the Esc key 
before releasing the mouse button.</paragraph>
-<embed href="text/shared/00/00000004.xhp#related"/>
+<tip id="par_id3153144">You can cancel a drag-and-drop operation in 
$[officename] at any time by pressing the Esc key before releasing the mouse 
button.</tip>
+
+<section id="relatedtopics">
 <embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/>
 <embed href="text/shared/guide/dragdrop_table.xhp#dragdrop_table"/>
 <embed href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/>
@@ -109,5 +98,6 @@
 <case select="CALC"><embed 
href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/>
 </case>
 </switch>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/dragdrop_beamer.xhp 
b/source/text/shared/guide/dragdrop_beamer.xhp
index 670ea602d6..6f5de7b5b1 100644
--- a/source/text/shared/guide/dragdrop_beamer.xhp
+++ b/source/text/shared/guide/dragdrop_beamer.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,12 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-       
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedragdrop_beamerxml" indexer="include" 
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Drag-and-Drop With the Data Source 
View</title>
+<title id="tit">Drag-and-Drop With the Data Source View</title>
 <filename>/text/shared/guide/dragdrop_beamer.xhp</filename>
 </topic>
 <history>
@@ -31,40 +27,39 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3145071"><bookmark_value>drag and drop; data source 
view</bookmark_value>
+<bookmark branch="index" id="bm_id3145071"><bookmark_value>drag and drop; data 
source view</bookmark_value>
 <bookmark_value>data source view; drag and drop</bookmark_value>
 <bookmark_value>copying;from data source view</bookmark_value>
 <bookmark_value>pasting;from data source view</bookmark_value>
 </bookmark><comment>mw added "pasting;"</comment>
-<paragraph role="heading" id="hd_id3145071" xml-lang="en-US" 
level="1"><variable id="dragdrop_beamer"><link 
href="text/shared/guide/dragdrop_beamer.xhp">Drag-and-Drop With the Data Source 
View</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3151111" xml-lang="en-US">A fast way of 
copying from a data source into a text or spreadsheet document, or of creating 
forms based on a data source, is by drag-and-drop.</paragraph>
+<h1 id="hd_id3145071"><variable id="dragdrop_beamer"><link 
href="text/shared/guide/dragdrop_beamer.xhp">Drag-and-Drop With the Data Source 
View</link>
+</variable></h1>
+<paragraph role="paragraph" id="par_id3151111">A fast way of copying from a 
data source into a text or spreadsheet document, or of creating forms based on 
a data source, is by drag-and-drop.</paragraph>
 <table id="tbl_id3149578">
 <tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147335" xml-lang="en-US">
-<image id="img_id3155390" src="media/helpimg/copydata.png" width="8.47mm" 
height="8.47mm"><alt id="alt_id3155390" xml-lang="en-US">Mouse pointer copying 
data</alt>
-       </image></paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3147335"><image id="img_id3155390" 
src="media/helpimg/copydata.png" width="8.47mm" height="8.47mm"><alt 
id="alt_id3155390">Mouse pointer copying data</alt></image></paragraph>
 </tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US">Copying with 
Drag-and-Drop</paragraph>
+<tablecell>
+<paragraph role="paragraph" id="par_id3145315">Copying with 
Drag-and-Drop</paragraph>
 </tablecell>
 </tablerow>
 </table>
 
-<paragraph role="paragraph" id="par_id3149233" xml-lang="en-US">If you want to 
reverse a drag-and-drop, position the cursor in your document and choose 
<emph>Edit - Undo</emph>.</paragraph>
-<paragraph role="tip" id="par_id3149656" xml-lang="en-US">It is also possible 
to copy by drag-and-drop from a document into a data source:</paragraph>
-<paragraph role="tip" id="par_id3153379" xml-lang="en-US">A text table or the 
selected range of a spreadsheet can be dragged using drag-and-drop to a table 
container in the data source explorer.</paragraph>
-<paragraph role="tip" id="par_id3151211" xml-lang="en-US">Plain text can be 
copied using drag-and-drop from one document to a data field in the data source 
view.</paragraph>
+<paragraph role="paragraph" id="par_id3149233">If you want to reverse a 
drag-and-drop, position the cursor in your document and choose <emph>Edit - 
Undo</emph>.</paragraph>
+<tip id="par_id3149656">It is also possible to copy by drag-and-drop from a 
document into a data source:</tip>
+<tip id="par_id3153379">A text table or the selected range of a spreadsheet 
can be dragged using drag-and-drop to a table container in the data source 
explorer.</tip>
+<tip id="par_id3151211">Plain text can be copied using drag-and-drop from one 
document to a data field in the data source view.</tip>
 <h3 id="hd_id3145421">Using data in a text document</h3>
-<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US">You can insert 
a database field in a text document by dragging a field name from the column 
header of the data source view into the document. This is especially useful 
when designing form letters. Simply drag the desired fields - home address, 
form of address, and so on - into your document.</paragraph>
-<paragraph role="paragraph" id="par_id3153105" xml-lang="en-US">To insert a 
complete record, select the corresponding header and drag it into the document. 
When you release the mouse button, the <link 
href="text/shared/02/12070000.xhp"><emph>Insert database columns</emph></link> 
dialog appears, in which you can decide whether to use all database fields, and 
whether to copy the data into the document as text, a table or fields. All 
currently selected records will be inserted.</paragraph>
+<paragraph role="paragraph" id="par_id3154685">You can insert a database field 
in a text document by dragging a field name from the column header of the data 
source view into the document. This is especially useful when designing form 
letters. Simply drag the desired fields - home address, form of address, and so 
on - into your document.</paragraph>
+<paragraph role="paragraph" id="par_id3153105">To insert a complete record, 
select the corresponding header and drag it into the document. When you release 
the mouse button, the <link href="text/shared/02/12070000.xhp"><emph>Insert 
database columns</emph></link> dialog appears, in which you can decide whether 
to use all database fields, and whether to copy the data into the document as 
text, a table or fields. All currently selected records will be 
inserted.</paragraph>
 <h3 id="hd_id3147230">Applying data to a table document</h3>
-<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US">You can insert 
one or more records into the current sheet of a spreadsheet by selecting the 
rows in the data source view and dragging and dropping them into the 
spreadsheet. The data is inserted at the place where you release the mouse 
button.</paragraph>
+<paragraph role="paragraph" id="par_id3125864">You can insert one or more 
records into the current sheet of a spreadsheet by selecting the rows in the 
data source view and dragging and dropping them into the spreadsheet. The data 
is inserted at the place where you release the mouse button.</paragraph>
 <h3 id="hd_id3149766">Inserting controls in a text form</h3>
-<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US">When you 
create a text form linked to a database, you can generate controls by 
drag-and-drop from the data source view.</paragraph>
-<paragraph role="paragraph" id="par_id3149562" xml-lang="en-US">When you drag 
a database column into the text document, you insert a field. If you hold down 
Shift+<switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 while dragging, a text field is inserted, grouped with an appropriate label 
field. The text field already contains all the database information that you 
need for the form.</paragraph>
-<embed href="text/shared/00/00000004.xhp#related"/>
+<paragraph role="paragraph" id="par_id3155132">When you create a text form 
linked to a database, you can generate controls by drag-and-drop from the data 
source view.</paragraph>
+<paragraph role="paragraph" id="par_id3149562">When you drag a database column 
into the text document, you insert a field. If you hold down 
Shift+<switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 while dragging, a text field is inserted, grouped with an appropriate label 
field. The text field already contains all the database information that you 
need for the form.</paragraph>
+
+<section id="relatedtopics">
 <embed href="text/shared/guide/dragdrop.xhp#dragdrop"/>
 <embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/>
 <embed href="text/shared/guide/dragdrop_table.xhp#dragdrop_table"/>
@@ -74,5 +69,6 @@
 <case select="WRITER"><embed 
href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/>
 </case>
 </switch>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/shared/guide/dragdrop_fromgallery.xhp 
b/source/text/shared/guide/dragdrop_fromgallery.xhp
index 9eb4d5c7fc..a728af6715 100644
--- a/source/text/shared/guide/dragdrop_fromgallery.xhp
+++ b/source/text/shared/guide/dragdrop_fromgallery.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,12 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-       
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedragdrop_fromgalleryxml" indexer="include" 
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Copying Graphics From the Gallery</title>
+<title id="tit">Copying Graphics From the Gallery</title>
 <filename>/text/shared/guide/dragdrop_fromgallery.xhp</filename>
 </topic>
 <history>
@@ -32,25 +28,25 @@
 </meta>
 <body>
 <section id="dndfromgallery01">
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3145345"><bookmark_value>Gallery;dragging pictures to draw 
objects</bookmark_value>
+<bookmark branch="index" id="bm_id3145345"><bookmark_value>Gallery;dragging 
pictures to draw objects</bookmark_value>
 <bookmark_value>draw objects;dropping Gallery pictures</bookmark_value>
 <bookmark_value>drag and drop;from Gallery to draw objects</bookmark_value>
 </bookmark><comment>mw deleted "Gallery;copying..." and copied "copying;..." 
to Shared guide gallery_insert.xhp.</comment>
-<paragraph role="heading" id="hd_id3145345" xml-lang="en-US" 
level="1"><variable id="dragdrop_fromgallery"><link 
href="text/shared/guide/dragdrop_fromgallery.xhp">Copying Graphics From the 
Gallery</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155535" xml-lang="en-US">If you drag a 
graphic from the Gallery into a text, spreadsheet or presentation document, the 
graphic will be inserted there.</paragraph>
+<h1 id="hd_id3145345"><variable id="dragdrop_fromgallery"><link 
href="text/shared/guide/dragdrop_fromgallery.xhp">Copying Graphics From the 
Gallery</link>
+</variable></h1>
+<paragraph role="paragraph" id="par_id3155535">If you drag a graphic from the 
Gallery into a text, spreadsheet or presentation document, the graphic will be 
inserted there.</paragraph>
 </section>
 <section id="dndfromgallery02">
-<paragraph role="paragraph" id="par_id3149762" xml-lang="en-US">If you release 
the graphic <emph>directly on a draw object</emph>, please note the 
following:</paragraph>
+<paragraph role="paragraph" id="par_id3149762">If you release the graphic 
<emph>directly on a draw object</emph>, please note the following:</paragraph>
 <list type="unordered">
 <listitem>
-<paragraph role="listitem" id="par_id3153825" xml-lang="en-US">If you move the 
graphic (drag it without pressing any key, in which case no additional symbol 
appears next to the mouse pointer), only the attributes are copied from the 
graphic and applied to the draw object on which you release the mouse 
button.</paragraph>
+<paragraph role="listitem" id="par_id3153825">If you move the graphic (drag it 
without pressing any key, in which case no additional symbol appears next to 
the mouse pointer), only the attributes are copied from the graphic and applied 
to the draw object on which you release the mouse button.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3153665" xml-lang="en-US">If you copy the 
graphic (drag it while holding down the <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 key, in which case a plus sign appears next to the mouse pointer), the graphic 
will be inserted as an object.</paragraph>
+<paragraph role="listitem" id="par_id3153665">If you copy the graphic (drag it 
while holding down the <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>
 key, in which case a plus sign appears next to the mouse pointer), the graphic 
will be inserted as an object.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3154514" xml-lang="en-US">If you create a 
hyperlink (drag while holding down Shift and <switchinline 
select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>,
 in which case a linking arrow appears next to the mouse pointer), the drawing 
object is replaced by the graphic from the Gallery, but the position and size 
of the replaced draw object are retained.</paragraph>
+<paragraph role="listitem" id="par_id3154514">If you create a hyperlink (drag 
while holding down Shift and <switchinline select="sys"><caseinline 
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>,
 in which case a linking arrow appears next to the mouse pointer), the drawing 
object is replaced by the graphic from the Gallery, but the position and size 
of the replaced draw object are retained.</paragraph>
 </listitem>
 </list>
 </section>
diff --git a/source/text/shared/guide/dragdrop_gallery.xhp 
b/source/text/shared/guide/dragdrop_gallery.xhp
index 6ddd0fcb9b..1e16725a98 100644
--- a/source/text/shared/guide/dragdrop_gallery.xhp
+++ b/source/text/shared/guide/dragdrop_gallery.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,20 +16,15 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
-               <helpdocument version="1.0">
+<helpdocument version="1.0">
 <meta>
 <topic id="textsharedguidedragdrop_galleryxml" indexer="include" 
status="PUBLISH">
-<title xml-lang="en-US" id="tit">Adding Graphics to the Gallery</title>
+<title id="tit">Adding Graphics to the Gallery</title>
 <filename>/text/shared/guide/dragdrop_gallery.xhp</filename>
 </topic>
 </meta>
 <body>
-  
-  
-  
-<bookmark xml-lang="en-US" branch="index" 
id="bm_id3154927"><bookmark_value>drag and drop;to Gallery</bookmark_value>
+<bookmark branch="index" id="bm_id3154927"><bookmark_value>drag and drop;to 
Gallery</bookmark_value>
 <bookmark_value>copying;to Gallery</bookmark_value>
 <bookmark_value>Gallery; adding pictures</bookmark_value>
 <bookmark_value>pictures;adding to Gallery</bookmark_value>
@@ -40,41 +32,38 @@
 <bookmark_value>pasting;to Gallery</bookmark_value>
 </bookmark>
   <comment>mw changed "adding;" to "inserting;"</comment>
-  <paragraph xml-lang="en-US" id="hd_id3154927" role="heading" 
level="1"><variable id="dragdrop_gallery"><link 
href="text/shared/guide/dragdrop_gallery.xhp">Adding Graphics to the 
Gallery</link> 
-</variable></paragraph>
-  <paragraph xml-lang="en-US" id="par_id3143267" role="paragraph">You can 
place a graphic from a document such as an HTML page in the Gallery by 
drag-and-drop.</paragraph>
+  <h1 id="hd_id3154927"><variable id="dragdrop_gallery"><link 
href="text/shared/guide/dragdrop_gallery.xhp">Adding Graphics to the 
Gallery</link>
+</variable></h1>
+  <paragraph id="par_id3143267" role="paragraph">You can place a graphic from 
a document such as an HTML page in the Gallery by drag-and-drop.</paragraph>
   <list type="ordered">
    <listitem>
-    <paragraph xml-lang="en-US" id="par_id3154823" role="listitem">Display the 
Gallery theme to which you want to add the graphic.</paragraph>
+    <paragraph id="par_id3154823" role="listitem">Display the Gallery theme to 
which you want to add the graphic.</paragraph>
    </listitem>
    <listitem>
-    <paragraph xml-lang="en-US" id="par_id3153748" role="listitem">Position 
the mouse pointer above the graphic, without clicking.</paragraph>
+    <paragraph id="par_id3153748" role="listitem">Position the mouse pointer 
above the graphic, without clicking.</paragraph>
    </listitem>
    <listitem>
-    <paragraph xml-lang="en-US" id="par_id3156346" role="listitem">If the 
mouse pointer changes to a hand symbol, the graphic refers to a hyperlink. In 
this case, click the graphic while pressing the <switchinline 
select="sys"><caseinline 
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
 key to select it without executing the respective link.</paragraph>
-    <paragraph xml-lang="en-US" id="par_id3149578" role="listitem">If the 
mouse pointer does not change to a hand symbol, you can simply click the 
graphic to select it.</paragraph>
+    <paragraph id="par_id3156346" role="listitem">If the mouse pointer changes 
to a hand symbol, the graphic refers to a hyperlink. In this case, click the 
graphic while pressing the <switchinline select="sys"><caseinline 
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
 key to select it without executing the respective link.</paragraph>
+    <paragraph id="par_id3149578" role="listitem">If the mouse pointer does 
not change to a hand symbol, you can simply click the graphic to select 
it.</paragraph>
    </listitem>
    <listitem>
-    <paragraph xml-lang="en-US" id="par_id3145120" role="listitem">Once the 
graphic is selected, release the mouse button. Click again on the graphic 
image, keeping the mouse button pressed for more than two seconds. The graphic 
image is copied to the internal memory.</paragraph>
+    <paragraph id="par_id3145120" role="listitem">Once the graphic is 
selected, release the mouse button. Click again on the graphic image, keeping 
the mouse button pressed for more than two seconds. The graphic image is copied 
to the internal memory.</paragraph>
    </listitem>
    <listitem>
-    <paragraph xml-lang="en-US" id="par_id3150772" role="listitem">Without 
releasing the mouse button, drag the graphic into the Gallery.</paragraph>
+    <paragraph id="par_id3150772" role="listitem">Without releasing the mouse 
button, drag the graphic into the Gallery.</paragraph>
    </listitem>
   </list>
-  <embed href="text/shared/00/00000004.xhp#related"/>
+<section id="relatedtopics">
   <embed href="text/shared/guide/gallery_insert.xhp#gallery_insert"/>
   <embed href="text/shared/guide/dragdrop.xhp#dragdrop"/>
   <embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/>
   <embed href="text/shared/guide/dragdrop_table.xhp#dragdrop_table"/>
   <embed 
href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/>
-  
 <switch select="appl">
-  
 <case select="WRITER">
   <embed href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/>
-  
 </case>
-  
 </switch>
+</section>
  </body>
 </helpdocument>
diff --git a/source/text/shared/guide/dragdrop_graphic.xhp 
b/source/text/shared/guide/dragdrop_graphic.xhp
index f5a344e3a8..0485b00563 100644
--- a/source/text/shared/guide/dragdrop_graphic.xhp
+++ b/source/text/shared/guide/dragdrop_graphic.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,12 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of

... etc. - the rest is truncated

Reply via email to