diff options
author | Eike Rathke <erack@redhat.com> | 2016-01-08 11:24:40 +0100 |
---|---|---|
committer | Eike Rathke <erack@redhat.com> | 2016-01-08 12:17:24 +0100 |
commit | 71a3f0e66fb6fb37f73fe3841a36ba00bec5beaa (patch) | |
tree | f6801787a460a164a83127bab14d38a4d4e41718 /source/text/scalc/01/func_weeknumadd.xhp | |
parent | Fix typo in AGGREGATE function help page (diff) | |
download | help-71a3f0e66fb6fb37f73fe3841a36ba00bec5beaa.tar.gz help-71a3f0e66fb6fb37f73fe3841a36ba00bec5beaa.zip |
tdf#85433 help content for WEEKNUM, ISOWEEKNUM, WEEKNUM_EXCEL2003, WEEKNUM_OOO
Change-Id: I92995b4de6fe18d981757f0d273ddce5c11b1559
Diffstat (limited to 'source/text/scalc/01/func_weeknumadd.xhp')
-rw-r--r-- | source/text/scalc/01/func_weeknumadd.xhp | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/source/text/scalc/01/func_weeknumadd.xhp b/source/text/scalc/01/func_weeknumadd.xhp index 4c46437777..de257e6a06 100644 --- a/source/text/scalc/01/func_weeknumadd.xhp +++ b/source/text/scalc/01/func_weeknumadd.xhp @@ -24,26 +24,26 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_weeknumaddxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">WEEKNUM_ADD </title> +<title id="tit" xml-lang="en-US">WEEKNUM_EXCEL2003 </title> <filename>/text/scalc/01/func_weeknumadd.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_ADD function</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_EXCEL2003 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><paragraph role="heading" id="hd_id3166443" xml-lang="en-US" level="2" l10n="U" oldref="222"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_ADD</link> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><paragraph role="heading" id="hd_id3166443" xml-lang="en-US" level="2" l10n="U" oldref="222"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3152945" xml-lang="en-US" l10n="U" oldref="223"><ahelp hid="HID_AAI_FUNC_WEEKNUM">The result indicates the number of the calendar week for a date.</ahelp></paragraph> -<paragraph role="tip" id="par_idN105DD" xml-lang="en-US" l10n="NEW">The WEEKNUM_ADD function is designed to calculate week numbers exactly as Microsoft Excel does. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function, or format your date cells using the WW formatting code, when you need ISO 8601 week numbers.</paragraph> +<paragraph role="tip" id="par_idN105DD" xml-lang="en-US" l10n="NEW">The WEEKNUM_EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function for ODF OpenFormula and Excel 2010 compatibility, or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function when you just need ISO 8601 week numbers. In releases prior to $[officename] 5.1 WEEKNUM_EXCEL2003 was named WEEKNUM_ADD.</paragraph> <paragraph role="heading" id="hd_id3153745" xml-lang="en-US" level="3" l10n="U" oldref="224">Syntax</paragraph> -<paragraph role="code" id="par_id3153685" xml-lang="en-US" l10n="U" oldref="225">WEEKNUM_ADD(Date; ReturnType)</paragraph> +<paragraph role="code" id="par_id3153685" xml-lang="en-US" l10n="U" oldref="225">WEEKNUM_EXCEL2003(Date; ReturnType)</paragraph> <paragraph role="paragraph" id="par_id3159277" xml-lang="en-US" l10n="U" oldref="226"> <emph>Date</emph> is the date within the calendar week.</paragraph> <paragraph role="paragraph" id="par_id3154098" xml-lang="en-US" l10n="U" oldref="227"> <emph>ReturnType</emph> is 1 for week beginning on a Sunday, 2 for week beginning on a Monday.</paragraph> <paragraph role="heading" id="hd_id3152886" xml-lang="en-US" level="3" l10n="U" oldref="228">Example</paragraph> -<paragraph role="paragraph" id="par_id3149973" xml-lang="en-US" l10n="U" oldref="229">In which week number does 12.24.2001 fall?</paragraph> +<paragraph role="paragraph" id="par_id3149973" xml-lang="en-US" l10n="U" oldref="229">In which week number does 12/24/2001 fall?</paragraph> <paragraph role="paragraph" id="par_id3149914" xml-lang="en-US" l10n="U" oldref="230"> -<item type="input">=WEEKNUM_ADD(24.12.2001;1)</item> returns 52.</paragraph> +<item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52.</paragraph> </body> </helpdocument> |