summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060110.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2021-12-31 14:23:17 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2022-01-01 03:26:08 +0100
commit7ad8f2bbd7b786557b8bcd9b275e0c312a921bf8 (patch)
tree04cac653d9634d292e085c1ffa289689cfad5c8b /source/text/scalc/01/04060110.xhp
parent830ed1f1dd5ad301e635f32f4120297fcb104000 (diff)
tdf#94537 COM.MICROSOFT.* namespace information
+ Covered all COM.MICROSOFT namespace of wiki page in the bug report. + refactor of other info such as release number availability. + Muted l10N in a table and drop duplication. Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/01/04060110.xhp')
-rw-r--r--source/text/scalc/01/04060110.xhp17
1 files changed, 9 insertions, 8 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 9ddbcf00a7..c05a24580a 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -46,15 +46,15 @@
<bookmark_value>using double quotation marks in formulas</bookmark_value>
<bookmark_value>formulas; using double quotation marks</bookmark_value>
</bookmark>
-
-<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2>
+
+<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2>
<paragraph role="paragraph" id="par_id891624454058773">To include a text string in a formula, place the text string between two double quotation marks (") and Calc takes the characters in the string without attempting to interpret them. For example, the formula <input>="Hello world!"</input> displays the text string <literal>Hello world!</literal> in the cell, with no surrounding double quotation marks.</paragraph>
<paragraph role="paragraph" id="par_id461624454425320">The more complex formula <input>=CONCATENATE("Life is really simple, "; "but we insist on making it complicated "; "(Confucius).")</input> concatenates three individual strings in double quotation marks, outputting <literal>Life is really simple, but we insist on making it complicated (Confucius).</literal></paragraph>
<paragraph role="paragraph" id="par_id711624454477483">To place a literal double quotation mark within a string inside a formula, two methods can be used:</paragraph>
-
+
<list type="ordered">
<listitem>
<paragraph id="par_id541624454496424" role="listitem">You can "escape" the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. For example, the formula <input>="My name is ""John Doe""."</input> outputs the string <literal>My name is "John Doe".</literal> Another simple example is the formula <input>=UNICODE("""")</input> which returns <literal>34</literal>, the decimal value of the Unicode quotation mark character (U+0022) — here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third.</paragraph>
@@ -82,9 +82,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id9323709">
<bookmark_value>BAHTTEXT function</bookmark_value>
</bookmark>
-
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BAHTTEXT" id="bm_id744346" localize="false"/><comment>i66350</comment>
-
<h2 id="hd_id6695455">BAHTTEXT</h2>
<paragraph id="par_id354014" role="paragraph" xml-lang="en-US">Converts a number to Thai text, including the Thai currency names.</paragraph>
@@ -94,6 +92,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3289284" role="paragraph" xml-lang="en-US"> <item type="input">=BAHTTEXT(12.65)</item> returns a string in Thai characters with the meaning of "Twelve Baht and sixty five Satang".</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.BAHTTEXT</literal></paragraph>
</section>
<section id="base">
@@ -163,10 +164,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3147472" role="code" xml-lang="en-US">CLEAN("Text")</paragraph>
<paragraph id="par_id3150695" role="paragraph" xml-lang="en-US"> <emph>Text</emph> refers to the text from which to remove all non-printable characters.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id581621538151600"><input>=LEN(CLEAN(CHAR(7) &amp; "LibreOffice Calc" &amp; CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the beginning and end of the string argument. CLEAN does not remove spaces.</paragraph>
-
+
</section>
<section id="code">
@@ -527,7 +528,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3148626" role="paragraph" xml-lang="en-US"> <item type="input">=REPT("Good morning";2)</item> returns Good morningGood morning.</paragraph>
-
+
<tip id="par_id381626381556310">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT" name="REPT_Wiki">REPT</link> wiki page for more details about this function.</tip></section>
<section id="right">