summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060110.xhp
diff options
context:
space:
mode:
authorAdolfo Jayme Barrientos <fitojb@ubuntu.com>2021-06-29 08:41:44 -0500
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2021-06-29 08:41:44 -0500
commitdbd32aead45fef14e81d3b1ca0a1973f1a856607 (patch)
tree653ab6c1e034017aef814d55ea7a561524c77c10 /source/text/scalc/01/04060110.xhp
parent24c249c356c67c7471476ec1bb54a68d87b196d2 (diff)
Minor
Change-Id: I8784fd6f43f5568db739e50a421bfff8184fd5d3
Diffstat (limited to 'source/text/scalc/01/04060110.xhp')
-rw-r--r--source/text/scalc/01/04060110.xhp4
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 4049249c38..aa7109ba85 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -57,14 +57,14 @@
<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>
+ <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>
</listitem>
<listitem>
<paragraph id="par_id21624454513641" role="listitem">You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) &amp; "The Catcher in the Rye" &amp; UNICHAR(34) &amp; " is a famous book by J. D. Salinger."</input> displays the string <literal>"The Catcher in the Rye" is a famous book by J. D. Salinger.</literal></paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id401624454547945">Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools > AutoCorrect Options > Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Untick the <menuitem>Replace</menuitem> toggle button to disable the feature.</paragraph>
+<paragraph role="paragraph" id="par_id401624454547945">Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature.</paragraph>
</section>