summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorAndrea Gelmini <andrea.gelmini@gelma.net>2017-09-19 10:09:22 +0200
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2018-01-03 04:33:49 +0100
commit7c78c30b297d368b94ab82f761c032b59f225c06 (patch)
treef427f09846a8260c6486df6babf1694234c606b6 /source/text/scalc
parent1228aaeb66e050dfacd1ac57ec785bc2e13997df (diff)
Fix typos
Change-Id: I7ef82f8d2896f3687be1aacfd08b8cf0d0d6e105 Reviewed-on: https://gerrit.libreoffice.org/47273 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/01/04060109.xhp2
-rw-r--r--source/text/scalc/01/04060119.xhp2
2 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index ef8d5bd5eb..95e3d87911 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -50,7 +50,7 @@
<paragraph xml-lang="en-US" id="par_id102720080230153" role="paragraph">In INDIRECT, the parameter is appended as the second parameter.</paragraph>
<paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph">In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. </paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301556" role="paragraph">In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.</paragraph>
- <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph">When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth paramater will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph">When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301650" role="paragraph">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.</paragraph>
<paragraph xml-lang="en-US" id="par_id102720080230162" role="note">Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301756" role="note">The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function.</paragraph>
diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp
index 982ff2fbb7..78b1ecc36a 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.xhp
@@ -543,7 +543,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155799"><bookmark_value>TBILLEQ function</bookmark_value>
<bookmark_value>treasury bills;annual return</bookmark_value>
<bookmark_value>annual return on treasury bills</bookmark_value>
-</bookmark><comment>mw changed "treasury bills;..." and aded one entry</comment>
+</bookmark><comment>mw changed "treasury bills;..." and added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_TBILLEQ" id="bm_id3147380" localize="false"/>
<paragraph role="heading" id="hd_id3155799" xml-lang="en-US" level="2">TBILLEQ</paragraph>
<paragraph role="paragraph" id="par_id3154403" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_TBILLEQ">Calculates the annual return on a treasury bill.</ahelp> A treasury bill is purchased on the settlement date and sold at the full par value on the maturity date, that must fall within the same year. A discount is deducted from the purchase price.</paragraph>