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

[Rafael Lima (via logerrit)]

 source/text/scalc/01/04060103.xhp |    4 ++++
 1 file changed, 4 insertions(+)

New commits:
commit 91287a050719f9c151327cc629cd4630cf61e804
Author:     Rafael Lima <rafael.palma.lima at gmail.com>
AuthorDate: Wed Mar 24 21:03:22 2021 +0100
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Wed Mar 24 23:45:50 2021 +0100

    tdf#102365 Add note to AMORDEGRC and AMORLINC about MS incompatibility with Basis 2
    
    Change-Id: I58d8ef63c570e637ad1cea832848f4d438025e5d
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112969
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp
index bfc194e17..2ba1ed5d3 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -62,6 +62,9 @@
          <paragraph xml-lang="en-US" id="par_id421612299085248" role="paragraph">An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming degressive depreciation, what is the amount of depreciation in the fourth depreciation period?</paragraph>
          <paragraph xml-lang="en-US" id="par_id901612299089478" role="paragraph">
             <input>=AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units.</paragraph>
+         <section id="Basis2Excel">
+             <note id="par_id851616615176815">Beware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel.</note>
+         </section>
       </section>
       <section id="amorlinc">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153765"><bookmark_value>AMORLINC function</bookmark_value>
@@ -89,6 +92,7 @@
          <paragraph xml-lang="en-US" id="par_id641612299092454" role="paragraph">An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming linear depreciation, what is the amount of depreciation in the fourth depreciation period?</paragraph>
          <paragraph xml-lang="en-US" id="par_id391612299096511" role="paragraph">
             <input>=AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 200 currency units.</paragraph>
+         <embed href="text/scalc/01/04060103.xhp#Basis2Excel"/>
       </section>
       <section id="accrint">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145257"><bookmark_value>ACCRINT function</bookmark_value>