[Libreoffice-commits] help.git: source/text

Steve Fanning (via logerrit) logerrit at kemper.freedesktop.org
Fri Feb 5 15:55:29 UTC 2021


 source/text/scalc/01/04060118.xhp |   44 +++++++++++++++++++-------------------
 1 file changed, 22 insertions(+), 22 deletions(-)

New commits:
commit 1babc5665e751c926cd049e4784b08b0e2f26f7d
Author:     Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Thu Feb 4 21:44:22 2021 +0100
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at 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">


More information about the Libreoffice-commits mailing list