Fix <embedvar> tags for better l10n (Part 1)

This is Part 1 of the fixes requested by translators concerning the use of the <embedvar>. Change-Id: Iee5ea4289034449c33156d4e20483943eb872ae0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123782 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
author: Rafael Lima <rafael.palma.lima@gmail.com> 2021-10-19 15:52:52 +0200
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2021-10-21 20:00:22 +0200
commit: f025640e2603ee252a21e935c2790627a2e95224 (patch)
tree: aacfef8cdf2f067d7489c3dec5de04e5f2e62468 /source/text/scalc/guide
parent: 993399c7c55d58bf084234713b07ac6ef8442b03 (diff)
3 files changed, 51 insertions, 52 deletions
diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp
index 47ce84594c..e63054fb0c 100644
--- a/source/text/scalc/guide/numbers_text.xhp
+++ b/source/text/scalc/guide/numbers_text.xhp
@@ -19,21 +19,21 @@
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
 
-
 <meta>
-      <topic id="textscalcguidenumbers_textxml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Converting Text to Numbers</title>
-         <filename>/text/scalc/guide/numbers_text.xhp</filename>
-      </topic>
-   </meta>
-   <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>formats; text as numbers</bookmark_value>
-      <bookmark_value>time format conversion</bookmark_value>
-      <bookmark_value>date formats;conversion</bookmark_value>
-      <bookmark_value>converting;text, into numbers</bookmark_value>
-</bookmark><comment>mw changed "converting;" and added two index entries</comment>
-<h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link>
-</variable></h1>
+  <topic id="textscalcguidenumbers_textxml" indexer="include" status="PUBLISH">
+    <title xml-lang="en-US" id="tit">Converting Text to Numbers</title>
+    <filename>/text/scalc/guide/numbers_text.xhp</filename>
+  </topic>
+</meta>
+
+<body>
+  <bookmark xml-lang="en-US" branch="index" id="bm_id3145068">
+    <bookmark_value>formats; text as numbers</bookmark_value>
+    <bookmark_value>time format conversion</bookmark_value>
+    <bookmark_value>date formats;conversion</bookmark_value>
+    <bookmark_value>converting;text, into numbers</bookmark_value>
+  </bookmark>
+  <h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link></variable></h1>
       <section id="text">
          <paragraph xml-lang="en-US" id="par_id0908200901265127" role="paragraph">Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.</paragraph>
          <paragraph xml-lang="en-US" id="par_id0908200901265196" role="paragraph"><emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.</paragraph>
@@ -81,7 +81,7 @@
          <paragraph role="paragraph" id="par_id611567607779380"><literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.</paragraph>
       </section>
      <h2 id="hd_id871567772424915">Changing the default text to number conversion settings</h2>
-      <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <embedvar href="text/shared/optionen/detailedcalculation.xhp#detailed_heading" markup="ignore"/> option.</paragraph>
+     <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <link href="text/shared/optionen/detailedcalculation.xhp" name="detailed_link">Detailed Calculation Settings</link> option.</paragraph>
       <section id="relatedtopics">
         <embed href="text/shared/optionen/detailedcalculation.xhp#detailed_heading"/>
          <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
diff --git a/source/text/scalc/guide/remove_duplicates.xhp b/source/text/scalc/guide/remove_duplicates.xhp
index 360ef28616..812f261539 100644
--- a/source/text/scalc/guide/remove_duplicates.xhp
+++ b/source/text/scalc/guide/remove_duplicates.xhp
@@ -1,6 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -38,7 +37,7 @@
     <paragraph id="par_id631630021463659" role="listitem">Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column.</paragraph>
   </listitem>
   <listitem>
-    <paragraph id="par_id31630021517873" role="listitem">Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <embedvar href="text/shared/02/12090100.xhp#StandardFilter_h1"/> dialog.</paragraph>
+    <paragraph id="par_id31630021517873" role="listitem">Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <link href="text/shared/02/12090100.xhp" name="std_dialog_link"> Standard Filter</link> dialog.</paragraph>
   </listitem>
   <listitem>
     <paragraph id="par_id801630022108301" role="listitem">In <emph>Field Name</emph> make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically.</paragraph>
diff --git a/source/text/scalc/guide/table_cellmerge.xhp b/source/text/scalc/guide/table_cellmerge.xhp
index d5f788f7f2..fe16ebb63f 100644
--- a/source/text/scalc/guide/table_cellmerge.xhp
+++ b/source/text/scalc/guide/table_cellmerge.xhp
@@ -1,6 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,36 +17,35 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
- 
-	
+
 <meta>
-      <topic id="textscalcguidetable_cellmergexml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Merge and Unmerge Cells</title>
-         <filename>/text/scalc/guide/table_cellmerge.xhp</filename>
-      </topic>
-   </meta>
-   <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id501632012952361">
-      <bookmark_value>merge/merging cells</bookmark_value>
-      <bookmark_value>unmerge/unmerging cells</bookmark_value>
-      <bookmark_value>split/splitting cells</bookmark_value>
-</bookmark>
-<section id="merge_unmerge_cells">
-<paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp" name="Merging and Unmerging Cells">Merge and Unmerge Cells</link>
-</variable></paragraph>
-      <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph>
-</section>
-      <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph>
-      <paragraph xml-lang="en-US" id="hd_id235602" role="heading" level="2">Merge Cells</paragraph>
-      <embed href="/text/scalc/01/05060000.xhp#mergecells_warning"/>
-      <section id="howtoget">
+  <topic id="textscalcguidetable_cellmergexml" indexer="include" status="PUBLISH">
+    <title xml-lang="en-US" id="tit">Merge and Unmerge Cells</title>
+    <filename>/text/scalc/guide/table_cellmerge.xhp</filename>
+  </topic>
+</meta>
+<body>
+  <bookmark xml-lang="en-US" branch="index" id="bm_id501632012952361">
+    <bookmark_value>merge/merging cells</bookmark_value>
+    <bookmark_value>unmerge/unmerging cells</bookmark_value>
+    <bookmark_value>split/splitting cells</bookmark_value>
+  </bookmark>
+  <section id="merge_unmerge_cells">
+    <paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp" name="Merging and Unmerging Cells">Merge and Unmerge Cells</link></variable></paragraph>
+    <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph>
+  </section>
+  <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph>
+  <paragraph xml-lang="en-US" id="hd_id235602" role="heading" level="2">Merge Cells</paragraph>
+  <embed href="/text/scalc/01/05060000.xhp#mergecells_warning"/>
+
+  <section id="howtoget">
       <paragraph xml-lang="en-US" id="par_id1272927" role="paragraph">Click and drag to select the cells to be merged then do one of the following:</paragraph>
       <paragraph role="paragraph" id="par_id221632803290526" xml-lang="en-US">In the Formatting toolbar click:</paragraph>
       <embed href="text/swriter/00/00000405.xhp#symerge_cells"/>
       <paragraph role="paragraph" id="par_id3154351" xml-lang="en-US">Or, right click the selection to open the context menu and choose <menuitem>Merge Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead then the cell selection contains merged cells and cannot be merged further.</paragraph>
       <paragraph role="paragraph" id="par_id931632803442925" xml-lang="en-US">Or, in the <emph>Properties</emph> sidebar mark the <emph>Merge Cells</emph> checkbox.</paragraph>
-      <paragraph role="paragraph" id="par_id3154020" xml-lang="en-US">Or, choose <embedvar href="text/scalc/01/05060000.xhp#format_mergecells_menu"/><menuitem>Merge Cells</menuitem></paragraph>
-      <paragraph xml-lang="en-US" id="par_id6424146" role="listitem">Or, choose <embedvar href="text/scalc/01/05060000.xhp#format_mergecells_menu"/><menuitem>Merge and Center Cells</menuitem></paragraph>
+      <paragraph role="paragraph" id="par_id3154020" xml-lang="en-US">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge Cells</menuitem></paragraph>
+      <paragraph xml-lang="en-US" id="par_id6424146" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
       <paragraph xml-lang="en-US" id="par_id961632012538771" role="listitem">The cells will be merged and the content will be centered in the merged cell.</paragraph>
       </section>
       <embed href="text/scalc/01/05060000.xhp#mergenotes"/>
@@ -58,13 +56,15 @@
       <embed href="text/swriter/00/00000405.xhp#sysplit_cells"/>
       <paragraph xml-lang="en-US" id="par_id431632277778130" role="paragraph">Or, right click the selection to open the context menu and choose <menuitem>Unmerge Cells</menuitem>.<br/>If <menuitem>Merge Cells</menuitem> is present instead then the selection does not contain any merged cells.</paragraph>
       <paragraph xml-lang="en-US" id="par_id261632277824041" role="paragraph">Or, in the <emph>Properties</emph> sidebar clear the <emph>Merge Cells</emph> checkbox.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id9493087" role="listitem">Or, choose <embedvar href="text/scalc/01/05060000.xhp#format_mergecells_menu"/><menuitem>Unmerge Cells</menuitem>.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id561632820960500" role="paragraph">Or, toggle <embedvar href="text/scalc/01/05060000.xhp#format_mergecells_menu"/><menuitem>Merge and Center Cells</menuitem></paragraph>
-      </section>
-      <embed href="text/shared/00/00000004.xhp#related"/>
-      <embed href="text/shared/01/05100100.xhp#mergecells"/>
-      <embed href="text/scalc/01/05060000.xhp#togglemergecells"/>
-      <embed href="text/shared/01/05100200.xhp#unmergecells"/>
-      <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/>
-   </body>
-</helpdocument>
-\ No newline at end of file
+      <paragraph xml-lang="en-US" id="par_id9493087" role="listitem">Or, choose <menuitem>Format - Merge and Unmerge Cells - Unmerge Cells</menuitem>.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id561632820960500" role="paragraph">Or, toggle <menuitem>Format - Merge and Unmerge Cells - Merge and Center Cells</menuitem></paragraph>
+  </section>
+
+  <section id="relatedtopics">
+    <embed href="text/shared/01/05100100.xhp#mergecells"/>
+    <embed href="text/scalc/01/05060000.xhp#togglemergecells"/>
+    <embed href="text/shared/01/05100200.xhp#unmergecells"/>
+    <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/>
+  </section>
+  </body>
+</helpdocument>
author	Rafael Lima <rafael.palma.lima@gmail.com>	2021-10-19 15:52:52 +0200
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2021-10-21 20:00:22 +0200
commit	f025640e2603ee252a21e935c2790627a2e95224 (patch)
tree	aacfef8cdf2f067d7489c3dec5de04e5f2e62468 /source/text/scalc/guide
parent	993399c7c55d58bf084234713b07ac6ef8442b03 (diff)