source/text/scalc/01/04060118.xhp | 44 +++++++++++++++++++-------------------
1 file changed, 22 insertions(+), 22 deletions(-)
New commits:
commit 1babc5665e751c926cd049e4784b08b0e2f26f7d
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Thu Feb 4 21:44:22 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Feb 5 16:55:09 2021 +0100
Fix example given in Help description for Calc’s XIRR function.
The data as given for the example does not work because the date in A2
should be 2001-02-01 to give the correct return value.
File affected is 04060118.xhp.
Change-Id: Ib1fd7849557e4b27ca1579940f1a60059a5c2b6f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110370
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060118.xhp
b/source/text/scalc/01/04060118.xhp
index 9b87de938..1f4c8de6e 100644
--- a/source/text/scalc/01/04060118.xhp
+++ b/source/text/scalc/01/04060118.xhp
@@ -179,92 +179,92 @@
<paragraph id="par_id3149708" role="paragraph"
xml-lang="en-US"><emph>Guess</emph> (optional) is a guess that can be input for
the internal rate of return. The default is 10%.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3149273" role="paragraph" xml-lang="en-US">Calculation of
the internal rate of return for the following five payments:</paragraph>
+<paragraph id="par_id3149273" role="paragraph" xml-lang="en-US">Calculation of
the internal rate of return for the following five payments (dates are in ISO
8601 format):</paragraph>
<table id="tbl_id3152970">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id3155838" role="paragraph"
xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id3155838" role="tablehead" xml-lang="en-US"
localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152934" role="paragraph"
xml-lang="en-US">B</paragraph>
+ <paragraph id="par_id3152934" role="tablehead" xml-lang="en-US"
localize="false">B</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154638" role="paragraph"
xml-lang="en-US">C</paragraph>
+ <paragraph id="par_id3154638" role="tablehead" xml-lang="en-US"
localize="false">C</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147083" role="paragraph"
xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3147083" role="tablehead" xml-lang="en-US"
localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151187" role="paragraph"
xml-lang="en-US">2001-01-01</paragraph>
+ <paragraph id="par_id3151187" role="paragraph" xml-lang="en-US"
localize="false">2001-01-01</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145212" role="paragraph" xml-lang="en-US">-<item
type="input">10000</item></paragraph>
+ <paragraph id="par_id3145212" role="paragraph" xml-lang="en-US"
localize="false">-10000</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146856" role="paragraph" xml-lang="en-US"><item
type="input">Received</item></paragraph>
+ <paragraph id="par_id3146856" role="paragraph"
xml-lang="en-US">Received</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3153277" role="paragraph"
xml-lang="en-US">2</paragraph>
+ <paragraph id="par_id3153277" role="tablehead" xml-lang="en-US"
localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154052" role="paragraph"
xml-lang="en-US">2001-01-02</paragraph>
+ <paragraph id="par_id3154052" role="paragraph" xml-lang="en-US"
localize="false">2001-02-01</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151297" role="paragraph" xml-lang="en-US"><item
type="input">2000</item></paragraph>
+ <paragraph id="par_id3151297" role="paragraph" xml-lang="en-US"
localize="false">2000</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149985" role="paragraph" xml-lang="en-US"><item
type="input">Deposited</item></paragraph>
+ <paragraph id="par_id3149985" role="paragraph"
xml-lang="en-US">Deposited</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154744" role="paragraph"
xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id3154744" role="tablehead" xml-lang="en-US"
localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153151" role="paragraph"
xml-lang="en-US">2001-03-15</paragraph>
+ <paragraph id="par_id3153151" role="paragraph" xml-lang="en-US"
localize="false">2001-03-15</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145657" role="paragraph"
xml-lang="en-US">2500</paragraph>
+ <paragraph id="par_id3145657" role="paragraph" xml-lang="en-US"
localize="false">2500</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3155101" role="paragraph"
xml-lang="en-US">4</paragraph>
+ <paragraph id="par_id3155101" role="tablehead" xml-lang="en-US"
localize="false">4</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146894" role="paragraph"
xml-lang="en-US">2001-05-12</paragraph>
+ <paragraph id="par_id3146894" role="paragraph" xml-lang="en-US"
localize="false">2001-05-12</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3143231" role="paragraph"
xml-lang="en-US">5000</paragraph>
+ <paragraph id="par_id3143231" role="paragraph" xml-lang="en-US"
localize="false">5000</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3156012" role="paragraph"
xml-lang="en-US">5</paragraph>
+ <paragraph id="par_id3156012" role="tablehead" xml-lang="en-US"
localize="false">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149758" role="paragraph"
xml-lang="en-US">2001-08-10</paragraph>
+ <paragraph id="par_id3149758" role="paragraph" xml-lang="en-US"
localize="false">2001-08-10</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147495" role="paragraph"
xml-lang="en-US">1000</paragraph>
+ <paragraph id="par_id3147495" role="paragraph" xml-lang="en-US"
localize="false">1000</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id3152793" role="paragraph" xml-lang="en-US">=XIRR(B1:B5;
A1:A5; 0.1) returns 0.1828.</paragraph>
+<paragraph id="par_id3152793" role="paragraph"
xml-lang="en-US"><input>=XIRR(B1:B5; A1:A5; 0.1)</input> returns 0.1828 or
18.28%.</paragraph>
</section>
<section id="xnpv">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
