04060110.xhp (02dbb15c) 04060110.xhp (6f9008d8)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 54 unchanged lines hidden (view full) ---

63 <item type="input">=ARABIC("MMII")</item> returns 2002</paragraph>
64 </section>
65 <section id="asc">
66<bookmark xml-lang="en-US" branch="index" id="bm_id8796349"><bookmark_value>ASC function</bookmark_value>
67</bookmark><comment>i79585</comment>
68<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" id="bm_id3187353" localize="false"/>
69<paragraph xml-lang="en-US" id="hd_id7723929" role="heading" level="2" l10n="NEW">ASC</paragraph>
70 <paragraph xml-lang="en-US" id="par_id8455153" role="paragraph" l10n="NEW"><ahelp hid=".">The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 54 unchanged lines hidden (view full) ---

63 <item type="input">=ARABIC("MMII")</item> returns 2002</paragraph>
64 </section>
65 <section id="asc">
66<bookmark xml-lang="en-US" branch="index" id="bm_id8796349"><bookmark_value>ASC function</bookmark_value>
67</bookmark><comment>i79585</comment>
68<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" id="bm_id3187353" localize="false"/>
69<paragraph xml-lang="en-US" id="hd_id7723929" role="heading" level="2" l10n="NEW">ASC</paragraph>
70 <paragraph xml-lang="en-US" id="par_id8455153" role="paragraph" l10n="NEW"><ahelp hid=".">The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
71 <paragraph xml-lang="en-US" id="par_id9912411" role="paragraph" l10n="NEW">See <link href="http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions">http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
71 <paragraph xml-lang="en-US" id="par_id9912411" role="paragraph" l10n="NEW">See <link href="https://wiki.openoffice.org/wiki/Calc/Features/JIS_and_ASC_functions">JIS and ASC Spreadsheet Functions</link> for a conversion table.</paragraph>
72 <paragraph xml-lang="en-US" id="hd_id9204992" role="heading" level="3" l10n="NEW">Syntax</paragraph>
73 <paragraph xml-lang="en-US" id="par_id1993774" role="code" l10n="NEW">ASC("Text")</paragraph>
74 <paragraph xml-lang="en-US" id="par_id2949919" role="paragraph" l10n="NEW">
75 <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
76 <paragraph xml-lang="en-US" id="par_id2355113" role="paragraph" l10n="NEW">See also JIS function.</paragraph>
77 </section>
78 <section id="bahttext">
79<bookmark xml-lang="en-US" branch="index" id="bm_id9323709"><bookmark_value>BAHTTEXT function</bookmark_value>

--- 215 unchanged lines hidden (view full) ---

295 <item type="input">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text string.</paragraph>
296 </section>
297 <section id="jis">
298<bookmark xml-lang="en-US" branch="index" id="bm_id7319864"><bookmark_value>JIS function</bookmark_value>
299</bookmark>
300<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" id="bm_id3818475" localize="false"/>
301<paragraph xml-lang="en-US" id="hd_id3666188" role="heading" level="2" l10n="NEW">JIS</paragraph>
302 <paragraph xml-lang="en-US" id="par_id964384" role="paragraph" l10n="NEW"><ahelp hid=".">The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
72 <paragraph xml-lang="en-US" id="hd_id9204992" role="heading" level="3" l10n="NEW">Syntax</paragraph>
73 <paragraph xml-lang="en-US" id="par_id1993774" role="code" l10n="NEW">ASC("Text")</paragraph>
74 <paragraph xml-lang="en-US" id="par_id2949919" role="paragraph" l10n="NEW">
75 <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
76 <paragraph xml-lang="en-US" id="par_id2355113" role="paragraph" l10n="NEW">See also JIS function.</paragraph>
77 </section>
78 <section id="bahttext">
79<bookmark xml-lang="en-US" branch="index" id="bm_id9323709"><bookmark_value>BAHTTEXT function</bookmark_value>

--- 215 unchanged lines hidden (view full) ---

295 <item type="input">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text string.</paragraph>
296 </section>
297 <section id="jis">
298<bookmark xml-lang="en-US" branch="index" id="bm_id7319864"><bookmark_value>JIS function</bookmark_value>
299</bookmark>
300<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" id="bm_id3818475" localize="false"/>
301<paragraph xml-lang="en-US" id="hd_id3666188" role="heading" level="2" l10n="NEW">JIS</paragraph>
302 <paragraph xml-lang="en-US" id="par_id964384" role="paragraph" l10n="NEW"><ahelp hid=".">The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
303 <paragraph xml-lang="en-US" id="par_id1551561" role="paragraph" l10n="NEW">See <link href="http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions">http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
303 <paragraph xml-lang="en-US" id="par_id1551561" role="paragraph" l10n="NEW">See <link href="https://wiki.openoffice.org/wiki/Calc/Features/JIS_and_ASC_functions">JIS and ASC Spreadsheet Functions</link> for a conversion table.</paragraph>
304 <paragraph xml-lang="en-US" id="hd_id2212897" role="heading" level="3" l10n="NEW">Syntax</paragraph>
305 <paragraph xml-lang="en-US" id="par_id2504654" role="code" l10n="NEW">JIS("Text")</paragraph>
306 <paragraph xml-lang="en-US" id="par_id5292519" role="paragraph" l10n="NEW">
307 <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
308 <paragraph xml-lang="en-US" id="par_id3984496" role="paragraph" l10n="NEW">See also ASC function.</paragraph>
309 </section>
310 <section id="left">
311<bookmark xml-lang="en-US" branch="index" id="bm_id3147083"><bookmark_value>LEFT function</bookmark_value>

--- 347 unchanged lines hidden ---
304 <paragraph xml-lang="en-US" id="hd_id2212897" role="heading" level="3" l10n="NEW">Syntax</paragraph>
305 <paragraph xml-lang="en-US" id="par_id2504654" role="code" l10n="NEW">JIS("Text")</paragraph>
306 <paragraph xml-lang="en-US" id="par_id5292519" role="paragraph" l10n="NEW">
307 <emph>Text</emph> is the text that contains characters to be converted.</paragraph>
308 <paragraph xml-lang="en-US" id="par_id3984496" role="paragraph" l10n="NEW">See also ASC function.</paragraph>
309 </section>
310 <section id="left">
311<bookmark xml-lang="en-US" branch="index" id="bm_id3147083"><bookmark_value>LEFT function</bookmark_value>

--- 347 unchanged lines hidden ---