summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-03 15:24:54 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-05-03 20:29:53 +0200
commit15ebd0257b457b87f4de43352d9b5d51272b5dba (patch)
treed61244df0e9decdf8032749021e1964a0165f21c
parent507bed7d6fe7ea2347648813008074e8fd1e90f8 (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.xhp12
-rw-r--r--source/text/scalc/01/04060111.xhp23
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>