diff options
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060111.xhp | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/ful_func.xhp | 4 | ||||
| -rw-r--r-- | source/text/shared/01/05020301.xhp | 2 | ||||
| -rw-r--r-- | source/text/shared/optionen/01060500.xhp | 1 |
4 files changed, 7 insertions, 1 deletions
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> |