diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-05-03 15:24:54 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-05-03 20:29:53 +0200 |
commit | 15ebd0257b457b87f4de43352d9b5d51272b5dba (patch) | |
tree | d61244df0e9decdf8032749021e1964a0165f21c | |
parent | 507bed7d6fe7ea2347648813008074e8fd1e90f8 (diff) |
Include Date add-in functions in Date&Time Help page
Change-Id: Icf4b9bb113b778b059928eb117d88084551ba6ac
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151341
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r-- | source/text/scalc/01/04060102.xhp | 12 | ||||
-rw-r--r-- | source/text/scalc/01/04060111.xhp | 23 |
2 files changed, 25 insertions, 10 deletions
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index 81988d0981..37afdc78ec 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -100,21 +100,26 @@ <h2 id="par_idN1067A">Functions</h2> <section id="datetimefunctions"> - <paragraph role="paragraph" id="par_id31577531529079" localize="false"><embedvar href="text/scalc/01/04060102.xhp#h1" markup="ignore"/></paragraph> +<paragraph role="paragraph" id="par_id31577531529079" localize="false"><embedvar href="text/scalc/01/04060102.xhp#h1" markup="ignore"/></paragraph> <paragraph id="par_id6854457" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_date.xhp#date"/> </paragraph> <paragraph id="par_id6354457" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_datedif.xhp#datedif"/> </paragraph> <paragraph id="par_id3372295" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_datevalue.xhp#datevalue"/> </paragraph> <paragraph id="par_id5375835" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph> -<paragraph id="par_id1208838" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_days.xhp#days"/> </paragraph> +<paragraph id="par_id1208838" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_days.xhp#days"/></paragraph> + <paragraph id="par_id7679982" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/> </paragraph> +<paragraph role="paragraph" id="par_id591683136920655" localize="false"><embedvar href="text/scalc/01/04060111.xhp#DAYSINMONTHh1"/></paragraph> +<paragraph role="paragraph" id="par_id661683136902973" localize="false"><embedvar href="text/scalc/01/04060111.xhp#DAYSINYEARh1"/></paragraph> <paragraph id="par_id1074251" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph> <paragraph id="par_id5684377" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_edate.xhp#edate"/> </paragraph> <paragraph id="par_id1346781" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/> </paragraph> <paragraph id="par_id224005" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/> </paragraph> +<paragraph role="paragraph" id="par_id81683136801600" localize="false"><embedvar href="text/scalc/01/04060111.xhp#ISLEAPYEARh1"/></paragraph> <paragraph id="par_id3886533" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/> </paragraph> <paragraph id="par_id3953062" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_minute.xhp#minute"/> </paragraph> <paragraph id="par_id2579729" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_month.xhp#month"/> </paragraph> +<paragraph role="paragraph" id="par_id311683136864113" localize="false"><embedvar href="text/scalc/01/04060111.xhp#MONTHSh1"/></paragraph> <paragraph id="par_id8951384" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_networkdays.xhp#networkdays"/> </paragraph> <paragraph id="par_id231020162315043955" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> </paragraph> <paragraph id="par_id6501968" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph> @@ -126,10 +131,13 @@ <paragraph id="par_id3886532" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/> </paragraph> <paragraph id="par_id614947" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph> <paragraph id="par_id3886534" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph> +<paragraph role="paragraph" id="par_id191683136968172" localize="false"><embedvar href="text/scalc/01/04060111.xhp#WEEKSh1"/></paragraph> +<paragraph role="paragraph" id="par_id511683136985322" localize="false"><embedvar href="text/scalc/01/04060111.xhp#WEEKSINYEARh1"/></paragraph> <paragraph id="par_idN10683" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph> <paragraph id="par_id231020163315043955" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph> <paragraph id="par_id641193" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_year.xhp#year"/> </paragraph> <paragraph id="par_id5189062" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/> </paragraph> +<paragraph role="paragraph" id="par_id81683136834196" localize="false"><embedvar href="text/scalc/01/04060111.xhp#YEARSh1"/></paragraph> </section> <section id="relatedtopics"> diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp index 1e7710ccf8..cd23eb5420 100644 --- a/source/text/scalc/01/04060111.xhp +++ b/source/text/scalc/01/04060111.xhp @@ -45,7 +45,7 @@ <bookmark branch="index" id="bm_id3149566"><bookmark_value>ISLEAPYEAR function</bookmark_value> <bookmark_value>leap year determination</bookmark_value> </bookmark><comment>mw added one entry</comment> -<h2 id="hd_id3149566">ISLEAPYEAR</h2> +<h2 id="hd_id3149566"><variable id="ISLEAPYEARh1"><link href="text/scalc/01/04060111.xhp#isleapyear">ISLEAPYEAR</link></variable></h2> <paragraph role="paragraph" id="par_id3150297"><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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150205">ISLEAPYEAR(Date)</paragraph> @@ -59,13 +59,14 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311600873986703" localize="false"><literal>ORG.OPENOFFICE.ISLEAPYEAR</literal></paragraph> +<tip id="par_id721677017247207"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISLEAPYEAR">ISLEAPYEAR wiki page</link>.</tip> </section> <section id="years"> <bookmark branch="index" id="bm_id3154656"><bookmark_value>YEARS function</bookmark_value> <bookmark_value>number of years between two dates</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_DAI_FUNC_DIFFYEARS" id="bm_id3150368" localize="false"/> -<h2 id="hd_id3154656">YEARS</h2> +<h2 id="hd_id3154656"><variable id="YEARSh1"><link href="text/scalc/01/04060111.xhp#years">YEARS</link></variable></h2> <paragraph role="paragraph" id="par_id3150886"><ahelp hid="HID_DAI_FUNC_DIFFYEARS">Calculates the difference in years between two dates.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3146114">YEARS(StartDate; EndDate; Type)</paragraph> @@ -78,13 +79,14 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873086703" localize="false"><literal>ORG.OPENOFFICE.YEARS</literal></paragraph> +<tip id="par_id871683137762172"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/YEARS">YEARS wiki page</link>.</tip> </section> <section id="months"> <bookmark branch="index" id="bm_id3152898"><bookmark_value>MONTHS function</bookmark_value> <bookmark_value>number of months between two dates</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_DAI_FUNC_DIFFMONTHS" id="bm_id3148839" localize="false"/> -<h2 id="hd_id3152898">MONTHS</h2> +<h2 id="hd_id3152898"><variable id="MONTHSh1"><link href="text/scalc/01/04060111.xhp#months">MONTHS</link></variable></h2> <paragraph role="paragraph" id="par_id3153066"><ahelp hid="HID_DAI_FUNC_DIFFMONTHS">Calculates the difference in months between two dates.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3146869">MONTHS(StartDate; EndDate; Type)</paragraph> @@ -97,6 +99,7 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id321640873986703" localize="false"><literal>ORG.OPENOFFICE.MONTHS</literal></paragraph> +<tip id="par_id31683137789991"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTHS">MONTHS wiki page</link>.</tip> </section> <section id="rot13"> <bookmark branch="index" id="bm_id3159094"><bookmark_value>ROT13 function</bookmark_value> @@ -121,7 +124,7 @@ <bookmark_value>number of days; in a specific year</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_DAI_FUNC_DAYSINYEAR" id="bm_id3153972" localize="false"/> -<h2 id="hd_id3151300">DAYSINYEAR</h2> +<h2 id="hd_id3151300"><variable id="DAYSINYEARh1"><link href="text/scalc/01/04060111.xhp#daysinyear">DAYSINYEAR</link></variable></h2> <paragraph role="paragraph" id="par_id3143220"><ahelp hid="HID_DAI_FUNC_DAYSINYEAR">Calculates the number of days of the year in which the date entered occurs.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154651">DAYSINYEAR(Date)</paragraph> @@ -132,13 +135,14 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873586703" localize="false"><literal>ORG.OPENOFFICE.DAYSINYEAR</literal></paragraph> +<tip id="par_id651683137822891"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYSINYEAR">DAYSINYEAR wiki page</link>.</tip> </section> <section id="daysinmonth"> <bookmark branch="index" id="bm_id3154737"><bookmark_value>DAYSINMONTH function</bookmark_value> <bookmark_value>number of days;in a specific month of a year</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_DAI_FUNC_DAYSINMONTH" id="bm_id3155593" localize="false"/> -<h2 id="hd_id3154737">DAYSINMONTH</h2> +<h2 id="hd_id3154737"><variable id="DAYSINMONTHh1"><link href="text/scalc/01/04060111.xhp#daysinmonth">DAYSINMONTH</link></variable></h2> <paragraph role="paragraph" id="par_id3149316"><ahelp hid="HID_DAI_FUNC_DAYSINMONTH">Calculates the number of days of the month in which the date entered occurs.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150955">DAYSINMONTH(Date)</paragraph> @@ -149,13 +153,14 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873986700" localize="false"><literal>ORG.OPENOFFICE.DAYSINMONTH</literal></paragraph> +<tip id="par_id741683137839471"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYSINMONTH">DAYSINMONTH wiki page</link>.</tip> </section> <section id="weeks"> <bookmark branch="index" id="bm_id3149048"><bookmark_value>WEEKS function</bookmark_value> <bookmark_value>number of weeks;between two dates</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_DAI_FUNC_DIFFWEEKS" id="bm_id3150435" localize="false"/> -<h2 id="hd_id3149048">WEEKS</h2> +<h2 id="hd_id3149048"><variable id="WEEKSh1"><link href="text/scalc/01/04060111.xhp#daysinmonth">WEEKS</link></variable></h2> <paragraph role="paragraph" id="par_id3153340"><ahelp hid="HID_DAI_FUNC_DIFFWEEKS">Calculates the difference in weeks between two dates.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3147402">WEEKS(StartDate; EndDate; Type)</paragraph> @@ -177,13 +182,14 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph> +<tip id="par_id431683137857863"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKS">WEEKS wiki page</link>.</tip> </section> <section id="weeksinyear"> <bookmark branch="index" id="bm_id3145237"><bookmark_value>WEEKSINYEAR function</bookmark_value> <bookmark_value>number of weeks;in a specific year</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_DAI_FUNC_WEEKSINYEAR" id="bm_id3146883" localize="false"/> -<h2 id="hd_id3145237">WEEKSINYEAR</h2> +<h2 id="hd_id3145237"><variable id="WEEKSINYEARh1"><link href="text/scalc/01/04060111.xhp#weeksinyear">WEEKSINYEAR</link></variable></h2> <paragraph role="paragraph" id="par_id3147410"><ahelp hid="HID_DAI_FUNC_WEEKSINYEAR">Calculates the number of weeks of the year in which the date entered occurs.</ahelp> The number of weeks is defined as follows: a week that spans two years is added to the year in which most days of that week occur.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3145638">WEEKSINYEAR(Date)</paragraph> @@ -194,10 +200,11 @@ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311540873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKSINYEAR</literal></paragraph> +<tip id="par_id291683137884236"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKSINYEAR">WEEKSINYEAR wiki page</link>.</tip> </section> </sort> <h2 id="hd_id3157901">Add-ins through %PRODUCTNAME API</h2> -<paragraph role="paragraph" id="par_id3149351">Add-ins can also be implemented through the %PRODUCTNAME <link href="https://api.libreoffice.org/">API</link>.</paragraph> +<paragraph role="paragraph" id="par_id3149351">Add-ins can also be implemented through the <link href="https://api.libreoffice.org/">%PRODUCTNAME API</link>.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/04060100.xhp#drking"/> </section> |