AllLangHelp_scalc.mk | 2 +
source/text/scalc/01/04060110.xhp | 30 +--------------------------
source/text/scalc/01/func_asc.xhp | 42 ++++++++++++++++++++++++++++++++++++++
source/text/scalc/01/func_jis.xhp | 41 +++++++++++++++++++++++++++++++++++++
4 files changed, 87 insertions(+), 28 deletions(-)
New commits:
commit f0f2cba1d40a248f3cc24ecaa60d403586894780
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Wed Nov 24 16:24:40 2021 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 24 23:16:32 2021 +0100
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.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 617223bfe..9a896f147 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 2fe9ef745..9ddbcf00a 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 000000000..c828efb66
--- /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 000000000..ef94de403
--- /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>
