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.bla...@youmail.dk>
AuthorDate: Sat Mar 27 12:26:33 2021 +0100
Commit: Seth Chaiklin <sdc.bla...@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.bla...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
