Related tdf#143846 Improve Arabic/Roman help pages

Change-Id: I4be244dba35f137c1b7d356aab658c5e08604e51
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123523
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

4 files changed, 95 insertions, 40 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index f2e840a5a5..0bc4bd0cdb 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -188,6 +188,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/format_graphic \
     helpcontent2/source/text/scalc/01/ful_func \
     helpcontent2/source/text/scalc/01/func_aggregate \
+    helpcontent2/source/text/scalc/01/func_arabic \
     helpcontent2/source/text/scalc/01/func_averageif \
     helpcontent2/source/text/scalc/01/func_averageifs \
     helpcontent2/source/text/scalc/01/func_ceiling \
@@ -247,6 +248,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_rawsubtract \
     helpcontent2/source/text/scalc/01/func_regex \
     helpcontent2/source/text/scalc/01/func_replaceb \
+    helpcontent2/source/text/scalc/01/func_roman \
     helpcontent2/source/text/scalc/01/func_roundsig \
     helpcontent2/source/text/scalc/01/func_second \
     helpcontent2/source/text/scalc/01/func_skewp \
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 7b33f71390..2fe9ef7455 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -65,28 +65,13 @@
 </list>
 
 <paragraph role="paragraph" id="par_id401624454547945">Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature.</paragraph>
-  
-</section>
 
-<sort order="asc" descendant="h2">  
-  
-<section id="arabic">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3149384">
-  <bookmark_value>ARABIC function</bookmark_value>
-</bookmark>
-
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARABISCH" id="bm_id3145359" localize="false"/>
-
-<h2 id="hd_id3149384">ARABIC</h2>
-<paragraph id="par_id3153558" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARABISCH">Calculates the value of a Roman number. The value range must be between 0 and 3999.</ahelp></paragraph>
+</section>
 
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3155523" role="code" xml-lang="en-US">ARABIC("Text")</paragraph>
-<paragraph id="par_id3151193" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text that represents a Roman number.</paragraph>
+<sort order="asc" descendant="h2">
 
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154621" role="paragraph" xml-lang="en-US"> <item type="input">=ARABIC("MXIV")</item> returns 1014</paragraph>
-<paragraph id="par_id3147553" role="paragraph" xml-lang="en-US"> <item type="input">=ARABIC("MMII")</item> returns 2002</paragraph>
+<section id="arabic">
+  <embed href="text/scalc/01/func_arabic.xhp#func_arabic"/>
 </section>
 
 <section id="asc">
@@ -614,27 +599,7 @@
 </section>
 
 <section id="roman">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153534">
-  <bookmark_value>ROMAN function</bookmark_value>
-</bookmark>
-
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ROEMISCH" id="bm_id3144755" localize="false"/>
-
-<h2 id="hd_id3153534">ROMAN</h2>
-<paragraph id="par_id3151256" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ROEMISCH">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp></paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150593" role="code" xml-lang="en-US">ROMAN(Number [; Mode])</paragraph>
-<paragraph id="par_id3156139" role="paragraph" xml-lang="en-US"> <emph>Number</emph> is the number that is to be converted into a Roman numeral.</paragraph>
-<paragraph id="par_id3153318" role="paragraph" xml-lang="en-US"> <emph>Mode</emph> (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3151371" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN(999)</item> returns CMXCIX</paragraph>
-<paragraph id="par_id3153938" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN(999;0)</item> returns CMXCIX</paragraph>
-<paragraph id="par_id3148412" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN (999;1)</item> returns LMVLIV</paragraph>
-<paragraph id="par_id3155421" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN(999;2)</item> returns XMIX</paragraph>
-<paragraph id="par_id3149235" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN(999;3)</item> returns VMIV</paragraph>
-<paragraph id="par_id3150624" role="paragraph" xml-lang="en-US"> <item type="input">=ROMAN(999;4)</item> returns IM</paragraph>
+  <embed href="text/scalc/01/func_roman.xhp#func_roman"/>
 </section>
 
 <section id="search">
diff --git a/source/text/scalc/01/func_arabic.xhp b/source/text/scalc/01/func_arabic.xhp
new file mode 100644
index 0000000000..b827428e84
--- /dev/null
+++ b/source/text/scalc/01/func_arabic.xhp
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+* This file is part of the LibreOffice project.
+*
+* This Source Code Form is subject to the terms of the Mozilla Public
+* License, v. 2.0. If a copy of the MPL was not distributed with this
+* file, You can obtain one at http://mozilla.org/MPL/2.0/.
+*
+-->
+
+<meta>
+  <topic id="calcfuncarabic" indexer="include" status="PUBLISH">
+    <title id="tit" xml-lang="en-US">ARABIC Function</title>
+    <filename>/text/scalc/01/func_arabic.xhp</filename>
+  </topic>
+</meta>
+<body>
+  <section id="func_arabic">
+    <bookmark id="bm_id61542230672099" xml-lang="en-US" branch="hid/SC_HID_FUNC_ARABISCH" localize="false"/>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id831542233029549">
+      <bookmark_value>ARABIC function</bookmark_value>
+      <bookmark_value>text functions;convert roman numbers</bookmark_value>
+    </bookmark>
+    <h1 id="hd_id881628776094597"><variable id="Arabic_h1"><link href="text/scalc/01/func_arabic.xhp" name="function ARABIC">ARABIC</link></variable></h1>
+    <paragraph id="par_id541542230672101" role="paragraph"><variable id="func_arabic_desc"><ahelp hid=".">Returns the numeric value corresponding to a Roman number expressed as text.</ahelp></variable></paragraph>
+  </section>
+  <note id="par_id151634221012221">The largest Roman number that can be converted is MMMCMXCIX (or one of its simplified versions), which is equivalent to 3999.</note>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+  <paragraph role="paragraph" id="par_id701542231253817"><input>ARABIC(Text)</input></paragraph>
+  <paragraph role="paragraph" id="par_id621542232197446"><emph>Text</emph>: text representing a Roman number.</paragraph>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+  <paragraph role="paragraph" id="par_id451628776707264"><input>=ARABIC("MXIV")</input> returns the numeric value 1014.</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036375"><input>=ARABIC("MMII")</input> returns the numeric value 2002.</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036134"><input>=ARABIC("")</input> returns 0.</paragraph>
+
+  <section id="relatedtopics">
+    <embed href="text/scalc/01/func_roman.xhp#Roman_h1"/>
+    <paragraph role="paragraph" id="par_id81634670394769" localize="false"><embedvar href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+  </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_roman.xhp b/source/text/scalc/01/func_roman.xhp
new file mode 100644
index 0000000000..4600ab3fc6
--- /dev/null
+++ b/source/text/scalc/01/func_roman.xhp
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+* This file is part of the LibreOffice project.
+*
+* This Source Code Form is subject to the terms of the Mozilla Public
+* License, v. 2.0. If a copy of the MPL was not distributed with this
+* file, You can obtain one at http://mozilla.org/MPL/2.0/.
+*
+-->
+
+<meta>
+  <topic id="calcfuncroman" indexer="include" status="PUBLISH">
+    <title id="tit" xml-lang="en-US">ROMAN Function</title>
+    <filename>/text/scalc/01/func_roman.xhp</filename>
+  </topic>
+</meta>
+<body>
+  <section id="func_roman">
+    <bookmark id="bm_id61542230672099" xml-lang="en-US" branch="hid/SC_HID_FUNC_ROEMISCH" localize="false"/>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id831542233029549">
+      <bookmark_value>ROMAN function</bookmark_value>
+      <bookmark_value>text functions;convert to roman numbers</bookmark_value>
+    </bookmark>
+    <h1 id="hd_id881628776094597"><variable id="Roman_h1"><link href="text/scalc/01/func_roman.xhp" name="function ROMAN">ROMAN</link></variable></h1>
+    <paragraph id="par_id541542230672101" role="paragraph"><variable id="func_roman_desc"><ahelp hid=".">Converts a number into a Roman numeral. The value range must be between 0 and 3999. A simplification mode can be specified in the range from 0 to 4.</ahelp></variable></paragraph>
+  </section>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+  <paragraph role="paragraph" id="par_id701542231253817"><input>ROMAN(Number [; Mode])</input></paragraph>
+  <paragraph role="paragraph" id="par_id621542232197446"><emph>Number</emph>: the number that is to be converted into a Roman numeral.</paragraph>
+  <paragraph role="paragraph" id="par_id621542232197337"><emph>Mode</emph>: optional value ranging between 0 to 4 that indicates the degree of simplification to be used in the conversion. The higher the value, the greater is the simplification of the Roman number.</paragraph>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+  <paragraph role="paragraph" id="par_id451628776707264"><input>=ROMAN(999)</input> returns "CMXCIX" (uses simplification mode equal to zero, which is the default).</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036375"><input>=ROMAN(999;0)</input> returns "CMXCIX".</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036134"><input>=ROMAN(999;1)</input> returns "LMVLIV".</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036278"><input>=ROMAN(999;2)</input> returns "XMIX".</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036364"><input>=ROMAN(999;3)</input> returns "VMIV".</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036008"><input>=ROMAN(999;4)</input> returns "IM".</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036019"><input>=ROMAN(0)</input> returns "" (empty text).</paragraph>
+
+  <section id="relatedtopics">
+    <embed href="text/scalc/01/func_arabic.xhp#Arabic_h1"/>
+    <paragraph role="paragraph" id="par_id81634670394769" localize="false"><embedvar href="text/scalc/01/04060110.xhp#head_text"/></paragraph>
+  </section>
+</body>
+</helpdocument>