diff options
author | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2021-06-29 08:41:44 -0500 |
---|---|---|
committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2021-06-29 08:41:44 -0500 |
commit | dbd32aead45fef14e81d3b1ca0a1973f1a856607 (patch) | |
tree | 653ab6c1e034017aef814d55ea7a561524c77c10 /source/text/scalc/01/04060110.xhp | |
parent | 24c249c356c67c7471476ec1bb54a68d87b196d2 (diff) |
Minor
Change-Id: I8784fd6f43f5568db739e50a421bfff8184fd5d3
Diffstat (limited to 'source/text/scalc/01/04060110.xhp')
-rw-r--r-- | source/text/scalc/01/04060110.xhp | 4 |
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) & "The Catcher in the Rye" & UNICHAR(34) & " 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> |