diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-12-31 14:23:17 -0300 |
---|---|---|
committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2022-01-01 03:26:08 +0100 |
commit | 7ad8f2bbd7b786557b8bcd9b275e0c312a921bf8 (patch) | |
tree | 04cac653d9634d292e085c1ffa289689cfad5c8b /source/text/scalc/01/04060110.xhp | |
parent | 830ed1f1dd5ad301e635f32f4120297fcb104000 (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.xhp | 17 |
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) & "LibreOffice Calc" & 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"> |