AllLangHelp_scalc.mk | 2 +
source/text/scalc/01/04060110.xhp | 45 +++-------------------------------
source/text/scalc/01/func_arabic.xhp | 42 +++++++++++++++++++++++++++++++
source/text/scalc/01/func_roman.xhp | 46 +++++++++++++++++++++++++++++++++++
4 files changed, 95 insertions(+), 40 deletions(-)
New commits:
commit c37c5f2131d0fe893d7de8995e7deb73262988aa
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Thu Oct 14 16:36:35 2021 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Oct 21 20:01:05 2021 +0200
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.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index f2e840a5a..0bc4bd0cd 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 7b33f7139..2fe9ef745 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 000000000..b827428e8
--- /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 000000000..4600ab3fc
--- /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>
