tdf#143846 Separate help pages for ASC/JIS text functions

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

4 files changed, 87 insertions, 28 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 617223bfed..9a896f1476 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     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_asc \
     helpcontent2/source/text/scalc/01/func_averageif \
     helpcontent2/source/text/scalc/01/func_averageifs \
     helpcontent2/source/text/scalc/01/func_ceiling \
@@ -230,6 +231,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_imsinh \
     helpcontent2/source/text/scalc/01/func_imtan \
     helpcontent2/source/text/scalc/01/func_isoweeknum \
+    helpcontent2/source/text/scalc/01/func_jis \
     helpcontent2/source/text/scalc/01/func_maxifs \
     helpcontent2/source/text/scalc/01/func_minifs \
     helpcontent2/source/text/scalc/01/func_minute \
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 2fe9ef7455..9ddbcf00a7 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -75,20 +75,7 @@
 </section>
 
 <section id="asc">
-<bookmark xml-lang="en-US" branch="index" id="bm_id8796349">
-  <bookmark_value>ASC function</bookmark_value>
-</bookmark>
-<comment>i79585</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" id="bm_id3187353" localize="false"/>
-
-<h2 id="hd_id7723929">ASC</h2>
-<paragraph id="par_id8455153" role="paragraph" xml-lang="en-US"><ahelp hid=".">The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
-<paragraph id="par_id9912411" role="paragraph" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id1993774" role="code" xml-lang="en-US">ASC("Text")</paragraph>
-<paragraph id="par_id2949919" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
-<paragraph id="par_id2355113" role="paragraph" xml-lang="en-US">See also JIS function.</paragraph>
+  <embed href="text/scalc/01/func_asc.xhp#func_asc"/>
 </section>
 
 <section id="bahttext">
@@ -325,20 +312,7 @@
 </section>
 
 <section id="jis">
-<bookmark xml-lang="en-US" branch="index" id="bm_id7319864">
-  <bookmark_value>JIS function</bookmark_value>
-</bookmark>
-
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" id="bm_id3818475" localize="false"/>
-
-<h2 id="hd_id3666188">JIS</h2>
-<paragraph id="par_id964384" role="paragraph" xml-lang="en-US"><ahelp hid=".">The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
-<paragraph id="par_id1551561" role="paragraph" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id2504654" role="code" xml-lang="en-US">JIS("Text")</paragraph>
-<paragraph id="par_id5292519" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
-<paragraph id="par_id3984496" role="paragraph" xml-lang="en-US">See also ASC function.</paragraph>
+  <embed href="text/scalc/01/func_jis.xhp#func_jis"/>
 </section>
 
 <section id="left">
diff --git a/source/text/scalc/01/func_asc.xhp b/source/text/scalc/01/func_asc.xhp
new file mode 100644
index 0000000000..c828efb665
--- /dev/null
+++ b/source/text/scalc/01/func_asc.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="calcfuncasc" indexer="include" status="PUBLISH">
+    <title id="tit" xml-lang="en-US">ASC Function</title>
+    <filename>/text/scalc/01/func_asc.xhp</filename>
+  </topic>
+</meta>
+<body>
+  <section id="func_asc">
+    <bookmark id="bm_id61542230672099" xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" localize="false"/>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id831542233029549">
+      <bookmark_value>ASC function</bookmark_value>
+      <bookmark_value>text functions;katakana characters</bookmark_value>
+    </bookmark>
+    <h1 id="hd_id881628776094597"><variable id="Asc_h1"><link href="text/scalc/01/func_asc.xhp" name="function ASC">ASC</link></variable></h1>
+    <paragraph id="par_id541542230672101" role="paragraph"><variable id="func_asc_desc"><ahelp hid=".">Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters.</ahelp></variable></paragraph>
+  </section>
+  <note id="par_id151634221012221">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</note>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+  <paragraph role="paragraph" id="par_id701542231253817"><input>ASC(Text)</input></paragraph>
+  <paragraph role="paragraph" id="par_id621542232197446"><emph>Text</emph>: the text string that contains characters to be converted.</paragraph>
+  <note id="par_id481637763523789">Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications.</note>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+  <paragraph role="paragraph" id="par_id451628776707264"><input>=ASC("LibreOffice")</input> returns the string "LibreOffice". No modifications were made because all characters are single-byte characters.</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036375"><input>=ASC("ライト")</input> returns the string "ﾗｲﾄ", which is composed of single-byte characters.</paragraph>
+
+  <section id="relatedtopics">
+    <embed href="text/scalc/01/func_jis.xhp#Jis_h1"/>
+    <embed href="text/scalc/01/04060110.xhp#head_text"/>
+  </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_jis.xhp b/source/text/scalc/01/func_jis.xhp
new file mode 100644
index 0000000000..ef94de403e
--- /dev/null
+++ b/source/text/scalc/01/func_jis.xhp
@@ -0,0 +1,41 @@
+<?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="calcfuncjis" indexer="include" status="PUBLISH">
+    <title id="tit" xml-lang="en-US">JIS Function</title>
+    <filename>/text/scalc/01/func_jis.xhp</filename>
+  </topic>
+</meta>
+<body>
+  <section id="func_jis">
+    <bookmark id="bm_id61542230672099" xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" localize="false"/>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id831542233029549">
+      <bookmark_value>JIS function</bookmark_value>
+    </bookmark>
+    <h1 id="hd_id881628776094597"><variable id="Jis_h1"><link href="text/scalc/01/func_jis.xhp" name="function JIS">JIS</link></variable></h1>
+    <paragraph id="par_id541542230672101" role="paragraph"><variable id="func_jis_desc"><ahelp hid=".">Converts single-byte (half-width) ASCII or katakana characters to double-byte (full-width) characters.</ahelp></variable></paragraph>
+  </section>
+  <note id="par_id151634221012221">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</note>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+  <paragraph role="paragraph" id="par_id701542231253817"><input>JIS(Text)</input></paragraph>
+  <paragraph role="paragraph" id="par_id621542232197446"><emph>Text</emph>: the text string that contains characters to be converted.</paragraph>
+  <note id="par_id481637763523789">Applying the JIS function to a string composed of double-byte characters will return the input string without any modifications.</note>
+  <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+  <paragraph role="paragraph" id="par_id451628776707264"><input>=JIS("LibreOffice")</input> returns the string "ＬｉｂｒｅＯｆｆｉｃｅ". Note that the returned string uses double-byte characters.</paragraph>
+  <paragraph role="paragraph" id="par_id101628778036375"><input>=JIS("ﾗｲﾄ")</input> returns the string "ライト", which is composed of double-byte characters.</paragraph>
+
+  <section id="relatedtopics">
+    <embed href="text/scalc/01/func_asc.xhp#Asc_h1"/>
+    <embed href="text/scalc/01/04060110.xhp#head_text"/>
+  </section>
+</body>
+</helpdocument>