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

Sat Mar 27 14:40:54 UTC 2021

source/text/scalc/01/04060118.xhp         |    2 +-
 source/text/scalc/01/common_func.xhp      |    3 +++
 source/text/scalc/01/func_networkdays.xhp |    1 +
 source/text/scalc/01/func_workday.xhp     |    1 +
 4 files changed, 6 insertions(+), 1 deletion(-)

New commits:
commit 4de9606186a78818a49c1f8d687b30d0e09fda9b
Author:     Seth Chaiklin <sdc.blanco at youmail.dk>
AuthorDate: Sat Mar 27 12:26:33 2021 +0100
Commit:     Seth Chaiklin <sdc.blanco at youmail.dk>
CommitDate: Sat Mar 27 15:40:18 2021 +0100

    tdf#137715 add "note" to DateSequence functions about text in range
    
       + add generic <note> in scalc/01/common_func.xhp about text
         in data ranges, which can be used for all functions that
         can be affected by this problem.
       + embed this note for all relevant DateSequence functions.
    
    Change-Id: If1c245d70f2b4aa464c50e502eed387b1d39f081
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113129
    Tested-by: Jenkins
    Reviewed-by: Seth Chaiklin <sdc.blanco at youmail.dk>

diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp
index 1f4c8de6e..4f00a1500 100644
--- a/source/text/scalc/01/04060118.xhp
+++ b/source/text/scalc/01/04060118.xhp
@@ -177,7 +177,7 @@
 <paragraph id="par_id3149826" role="code" xml-lang="en-US">XIRR(Values; Dates [; Guess])</paragraph>
 <paragraph id="par_id3163821" role="paragraph" xml-lang="en-US"><emph>Values</emph> and <emph>Dates</emph> refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits).</paragraph>
 <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#datenumbersequencenote"/>
 <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 (dates are in ISO 8601 format):</paragraph>
 
diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp
index fd7f60765..8a3f7241a 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -21,5 +21,8 @@
     <section id="sectionexample">
         <h3 id="hd_id281171">Example</h3>
     </section>
+    <section id="datenumbersequencenote">
+        <note id="par_id301616845402409">This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature.</note>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp
index 0883963c0..dc5681d14 100644
--- a/source/text/scalc/01/func_networkdays.xhp
+++ b/source/text/scalc/01/func_networkdays.xhp
@@ -46,6 +46,7 @@
 <paragraph id="par_id160920161749585013" role="paragraph" xml-lang="en-US"><emph>Workdays</emph> is an optional list of number values defining standard work week. This list starts by Sunday, workdays are indicated by zero and non-working days by non-zero value.</paragraph>
 <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/>
 <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
+<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph id="par_id3154661" role="paragraph" xml-lang="en-US">How many workdays fall between 2001-12-15 and 2002-01-15? The start date is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "2001-12-24", "2001-12-25", "2001-12-26", "2001-12-31", "2002-01-01".</paragraph>
 <paragraph id="par_id3147328" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays.</paragraph>
diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp
index 39cabbfde..95b1f9510 100644
--- a/source/text/scalc/01/func_workday.xhp
+++ b/source/text/scalc/01/func_workday.xhp
@@ -40,6 +40,7 @@
 <emph>Holidays</emph> is a list of optional holidays. These are non-working days. Enter a cell range in which the holidays are listed individually.</paragraph>
 <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/>
 <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
+<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph role="paragraph" id="par_id3152782" xml-lang="en-US">What date came 17 workdays after 1 December 2001? Enter the start date "2001-12-01" in C3 and the number of workdays in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "2001-12-24", "2001-12-25", "2001-12-26", "2001-12-31", "2002-01-01".</paragraph>
 <paragraph role="paragraph" id="par_id3146142" xml-lang="en-US"><item type="input">=WORKDAY(C3;D3;F3:J3)</item>  returns 2001-12-28. Format the serial date number as a date, for example in the format YYYY-MM-DD.<comment>UFI: fixed #i30213#</comment></paragraph>
