diff options
| author | Eike Rathke <erack@redhat.com> | 2016-06-01 12:59:37 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2016-06-01 11:11:39 +0000 |
| commit | 09063ddab885bd432d09d0d2205511edbf6fe2f9 (patch) | |
| tree | ebf485aaaf9107c62641f187ec10486bd89f11b0 /source | |
| parent | 161bcc4652310d21627af3636d23d696705637f7 (diff) | |
eliminate the mentioning of locale dependent date string in ISLEAPYEAR
Rather use DATE() and "yyyy-mm-dd" ISO examples.
Change-Id: I41c9dc57167f8c70e8674fcd4b4038ab8e835141
(cherry picked from commit 8353d5baa0186d0774a9ddd598677b31bff5922c)
Reviewed-on: https://gerrit.libreoffice.org/25770
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060111.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp index 89de050211..7f6950cd1c 100644 --- a/source/text/scalc/01/04060111.xhp +++ b/source/text/scalc/01/04060111.xhp @@ -49,12 +49,12 @@ <paragraph role="heading" id="hd_id3149566" xml-lang="en-US" level="2" l10n="U" oldref="14">ISLEAPYEAR</paragraph> <paragraph role="paragraph" id="par_id3150297" xml-lang="en-US" l10n="U" oldref="15"><ahelp hid=".">Determines whether a year is a leap year.</ahelp> If yes, the function will return the value 1 (TRUE); if not, it will return 0 (FALSE).</paragraph> <paragraph role="heading" id="hd_id3148487" xml-lang="en-US" level="3" l10n="U" oldref="16">Syntax</paragraph> -<paragraph role="code" id="par_id3150205" xml-lang="en-US" l10n="U" oldref="17">ISLEAPYEAR("Date")</paragraph> +<paragraph role="code" id="par_id3150205" xml-lang="en-US" l10n="U" oldref="17">ISLEAPYEAR(Date)</paragraph> <paragraph role="paragraph" id="par_id3159239" xml-lang="en-US" l10n="U" oldref="18"> -<emph>Date</emph> specifies whether a given date falls within a leap year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME.</paragraph> +<emph>Date</emph> specifies whether a given date falls within a leap year. The Date parameter must be a valid date.</paragraph> <paragraph role="heading" id="hd_id3149817" xml-lang="en-US" level="3" l10n="U" oldref="19">Example</paragraph> <paragraph role="paragraph" id="par_id3150786" xml-lang="en-US" l10n="CHG" oldref="20">=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" l10n="CHG">You may also use =ISLEAPYEAR("1968-02-29") or =ISLEAPYEAR("2/29/68").</paragraph> +<paragraph role="paragraph" id="par_idN107E7" xml-lang="en-US" l10n="CHG">You may also use =ISLEAPYEAR(DATE(1968;2;29)) or =ISLEAPYEAR("1968-02-29") giving the date string in the ISO 8601 notation.</paragraph> <paragraph role="paragraph" id="par_idN107EA" xml-lang="en-US" l10n="CHG">Never use =ISLEAPYEAR(2/29/68), because this would first evaluate 2 divided by 29 divided by 68, and then calculate the ISLEAPYEAR function from this small number as a serial date number.</paragraph> </section> <section id="years"> |