source/text/scalc/01/04060111.xhp | 1 +
source/text/scalc/01/ful_func.xhp | 4 ++++
source/text/shared/01/05020301.xhp | 2 +-
source/text/shared/optionen/01060500.xhp | 1 +
4 files changed, 7 insertions(+), 1 deletion(-)
New commits:
commit 18bf37d1dadbdd5631b8c3a60d3385038513f3df
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue May 2 16:41:28 2023 -0300
Commit: Mike Kaganski <mike.kagan...@collabora.com>
CommitDate: Wed May 3 06:48:53 2023 +0200
tdf#155100 LibreOffice treats 1900 as a common year, not leap
Change-Id: Id8ab89baa623f04a49a307856ea063a2301a2ce3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151302
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
diff --git a/source/text/scalc/01/04060111.xhp
b/source/text/scalc/01/04060111.xhp
index 89b70e5710..5c5e8b5b75 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -51,6 +51,7 @@
<paragraph role="code" id="par_id3150205"
xml-lang="en-US">ISLEAPYEAR(Date)</paragraph>
<paragraph role="paragraph" id="par_id3159239" xml-lang="en-US">
<emph>Date</emph> specifies whether a given date falls within a leap year. The
Date parameter must be a valid date.</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#warnexcelbadleapyear"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150786"
xml-lang="en-US">=ISLEAPYEAR(A1) returns 1, if A1 contains 1968-02-29, the
valid date 29th of February 1968 in your locale setting.</paragraph>
<paragraph role="paragraph" id="par_idN107E7" xml-lang="en-US">You may also
use =ISLEAPYEAR(DATE(1968;2;29)) or =ISLEAPYEAR("1968-02-29") giving the date
string in the ISO 8601 notation.</paragraph>
diff --git a/source/text/scalc/01/ful_func.xhp
b/source/text/scalc/01/ful_func.xhp
index 1d37e191e6..116d16a2cb 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -14,6 +14,10 @@
</topic>
</meta>
<body>
+ <comment>Ms Excel considers 1900 as leap year</comment>
+ <section id="warnexcelbadleapyear">
+ <warning id="par_id631683055048736">Microsoft Excel <link
href="https://learn.microsoft.com/en-US/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year";>wrongly
assumes year 1900 as leap year</link> and consider the inexistent day of
1900-02-29 as valid in date calculations. Dates prior to 1900-03-01 are
therefore different in Excel and Calc.</warning>
+ </section>
<comment> Title in descriptions of functions </comment>
<section id="func_head_syntax">
<h2 id="hd_id126511265112651">Syntax</h2>
diff --git a/source/text/shared/01/05020301.xhp
b/source/text/shared/01/05020301.xhp
index d5e862b46d..9c09a4b41f 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -286,7 +286,7 @@
<embed href="text/shared/01/05020300.xhp#currencytext"/>
<h2 id="hd_id3157309">Date and Time Formats</h2>
-
+<embed href="text/scalc/01/ful_func.xhp#warnexcelbadleapyear"/>
<h3 id="hd_id3153740">Date Formats</h3>
<paragraph id="par_id3152791" role="paragraph">To display days, months and
years, use the following number format codes. </paragraph>
<warning id="par_id610980">Not all format codes give meaningful results for
all languages.</warning>
diff --git a/source/text/shared/optionen/01060500.xhp
b/source/text/shared/optionen/01060500.xhp
index 14cd996817..9e3b7724fd 100644
--- a/source/text/shared/optionen/01060500.xhp
+++ b/source/text/shared/optionen/01060500.xhp
@@ -126,6 +126,7 @@
<paragraph id="par_id3153139" role="paragraph"><ahelp
hid="modules/scalc/ui/optcalculatepage/minchange">Specifies the difference
between two consecutive iteration step results. If the result of the iteration
is lower than the minimum change value, then the iteration will
stop.</ahelp></paragraph>
<h2 id="hd_id3147125">Date</h2>
<paragraph id="par_id3155416" role="paragraph">Select the start date for
the internal conversion from days to numbers.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#warnexcelbadleapyear"/>
<bookmark branch="hid/modules/scalc/ui/optcalculatepage/datestd"
id="bm_id3153159" localize="false"/>
<h3 id="hd_id3147396">12/30/1899 (default)</h3>
<paragraph id="par_id3145646" role="paragraph"><ahelp
hid="modules/scalc/ui/optcalculatepage/datestd">Sets 12/30/1899 as day
zero.</ahelp></paragraph>
