source/text/scalc/01/func_day.xhp | 19 ++++++++++---------
source/text/scalc/01/func_hour.xhp | 17 +++++++++--------
source/text/scalc/01/func_minute.xhp | 19 ++++++++++---------
source/text/scalc/01/func_month.xhp | 19 ++++++++++---------
source/text/scalc/01/func_second.xhp | 17 +++++++++--------
source/text/scalc/01/func_year.xhp | 19 ++++++++++---------
6 files changed, 58 insertions(+), 52 deletions(-)
New commits:
commit bc1435efdd13fb2f2b6cf78e946c7836db54d9c8
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 13 12:06:07 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue May 14 12:42:57 2024 +0200
tdf#127477 Description of date & time functions in the help
Add precision on rounding and trunking of date and time values
SECOND() rounds value to nearest integer
MINUTE, HOUR, DAY, MONTH, YEAR truncates to integer part.
Change-Id: I115557dd85a9328185b197abfcd233b62b0beb78
reference: https://bugs.documentfoundation.org/show_bug.cgi?id=127476#c9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167605
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_day.xhp
b/source/text/scalc/01/func_day.xhp
index 434f5bae47..94242055a9 100644
--- a/source/text/scalc/01/func_day.xhp
+++ b/source/text/scalc/01/func_day.xhp
@@ -19,26 +19,27 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_dayxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">DAY </title>
+<title id="tit">DAY </title>
<filename>/text/scalc/01/func_day.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147317"><bookmark_value>DAY function</bookmark_value>
+<bookmark branch="index" id="bm_id3147317"><bookmark_value>DAY
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283"
localize="false"/><h1 id="hd_id3147317"><variable id="day"><link
href="text/scalc/01/func_day.xhp">DAY</link>
+<bookmark branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h1
id="hd_id3147317"><variable id="day"><link
href="text/scalc/01/func_day.xhp">DAY</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3147584" xml-lang="en-US"><ahelp
hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is
returned as an integer between 1 and 31. You can also enter a negative
date/time value.</paragraph>
+<paragraph role="paragraph" id="par_id3147584"><ahelp
hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is
returned as an integer between 1 and 31. You can also enter a negative
date/time value.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3149430"
xml-lang="en-US">DAY(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3149443"
xml-lang="en-US"><emph>Number</emph> is the internal date number.</paragraph>
+<paragraph role="code" id="par_id3149430">DAY(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3149443"><emph>Number</emph> is the
internal date number.</paragraph>
+<note id="par_id451715611481885">DAY() returns the integer part of the
day.</note>
<embed href="text/scalc/01/04060102.xhp#datenumberinfo"/>
<embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US"><item
type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at
zero from December 30, 1899)</paragraph>
-<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US"><item
type="input">=DAY(NOW())</item> returns the current day.</paragraph>
-<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US"><item
type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the
date value might get formatted differently after you press Enter).</paragraph>
+<paragraph role="paragraph" id="par_id3151200"><item
type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at
zero from December 30, 1899)</paragraph>
+<paragraph role="paragraph" id="par_id3154130"><item
type="input">=DAY(NOW())</item> returns the current day.</paragraph>
+<paragraph role="paragraph" id="par_id3159190"><item
type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the
date value might get formatted differently after you press Enter).</paragraph>
<section id="relatedtopics">
<tip id="par_id951677016613386"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAY";>DAY
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
diff --git a/source/text/scalc/01/func_hour.xhp
b/source/text/scalc/01/func_hour.xhp
index 90f4afec5b..89af023368 100644
--- a/source/text/scalc/01/func_hour.xhp
+++ b/source/text/scalc/01/func_hour.xhp
@@ -19,26 +19,27 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_hourxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">HOUR </title>
+<title id="tit">HOUR </title>
<filename>/text/scalc/01/func_hour.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value>
+<bookmark branch="index" id="bm_id3154725"><bookmark_value>HOUR
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/>
<h1 id="hd_id3154725"><variable id="hour"><link
href="text/scalc/01/func_hour.xhp">HOUR</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3149747" xml-lang="en-US"><ahelp
hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour
is returned as an integer between 0 and 23.</paragraph>
+<paragraph role="paragraph" id="par_id3149747"><ahelp
hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour
is returned as an integer between 0 and 23.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3150637"
xml-lang="en-US">HOUR(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3147547" xml-lang="en-US">
+<paragraph role="code" id="par_id3150637">HOUR(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3147547">
<emph>Number</emph>, as a time value, is a decimal, for which the hour is to
be returned.</paragraph>
+<note id="par_id451715611481885">HOUR() returns the integer part of the
hour.</note>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3159215" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3159215">
<item type="input">=HOUR(NOW())</item> returns the current hour</paragraph>
-<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3145152">
<item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item
type="input">17:20:00</item>.</paragraph>
<section id="relatedtopics">
<tip id="par_id851677015767824"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR";>HOUR
wiki page</link>.</tip>
diff --git a/source/text/scalc/01/func_minute.xhp
b/source/text/scalc/01/func_minute.xhp
index 3c1b5275cf..8b5021dba0 100644
--- a/source/text/scalc/01/func_minute.xhp
+++ b/source/text/scalc/01/func_minute.xhp
@@ -19,28 +19,29 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_minutexml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">MINUTE</title>
+<title id="tit">MINUTE</title>
<filename>/text/scalc/01/func_minute.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value>
+<bookmark branch="index" id="bm_id3149803"><bookmark_value>MINUTE
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/>
<h1 id="hd_id3149803"><variable id="minute"><link
href="text/scalc/01/func_minute.xhp">MINUTE</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3148988" xml-lang="en-US"><ahelp
hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp>
The minute is returned as a number between 0 and 59.</paragraph>
+<paragraph role="paragraph" id="par_id3148988"><ahelp
hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp>
The minute is returned as a number between 0 and 59.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3148660"
xml-lang="en-US">MINUTE(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3154611" xml-lang="en-US">
+<paragraph role="code" id="par_id3148660">MINUTE(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3154611">
<emph>Number</emph>, as a time value, is a decimal number where the number of
the minute is to be returned.</paragraph>
+<note id="par_id451715611481885">MINUTE() returns the integer part of the
minute.</note>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3148463" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3148463">
<item type="input">=MINUTE(8.999)</item> returns 58</paragraph>
-<paragraph role="paragraph" id="par_id3149419" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3149419">
<item type="input">=MINUTE(8.9999)</item> returns 59</paragraph>
-<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3144755">
<item type="input">=MINUTE(NOW())</item> returns the current minute
value.</paragraph>
<section id="relatedtopics">
<tip id="par_id831677015434176"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE";>MINUTE
wiki page</link>.</tip>
diff --git a/source/text/scalc/01/func_month.xhp
b/source/text/scalc/01/func_month.xhp
index efba950ddc..0213a7981c 100644
--- a/source/text/scalc/01/func_month.xhp
+++ b/source/text/scalc/01/func_month.xhp
@@ -19,27 +19,28 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_monthxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">MONTH </title>
+<title id="tit">MONTH </title>
<filename>/text/scalc/01/func_month.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value>
+<bookmark branch="index" id="bm_id3149936"><bookmark_value>MONTH
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/>
<h1 id="hd_id3149936"><variable id="month"><link
href="text/scalc/01/func_month.xhp">MONTH</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US"><ahelp
hid="HID_FUNC_MONAT">Returns the month for the given date value.</ahelp> The
month is returned as an integer between 1 and 12.</paragraph>
+<paragraph role="paragraph" id="par_id3153538"><ahelp
hid="HID_FUNC_MONAT">Returns the month for the given date value.</ahelp> The
month is returned as an integer between 1 and 12.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3145602"
xml-lang="en-US">MONTH(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3149485" xml-lang="en-US">
- <emph>Number</emph> is the internal date number.</paragraph>
+<paragraph role="code" id="par_id3145602">MONTH(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3149485">
+<emph>Number</emph> is the internal date number.</paragraph>
+<note id="par_id451715611481885">MONTH() returns the integer part of the
month.</note>
<embed href="text/scalc/01/04060102.xhp#datenumberinfo"/>
<embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US"><item
type="input">=MONTH(NOW())</item> returns the current month.</paragraph>
-<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US"><item
type="input">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4
(that date value might get formatted differently after you press
Enter).</paragraph>
+<paragraph role="paragraph" id="par_id3149244"><item
type="input">=MONTH(NOW())</item> returns the current month.</paragraph>
+<paragraph role="paragraph" id="par_id3154790"><item
type="input">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4
(that date value might get formatted differently after you press
Enter).</paragraph>
<section id="relatedtopics">
<tip id="par_id601677015418666"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTH";>MONTH
wiki page</link>.</tip>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
diff --git a/source/text/scalc/01/func_second.xhp
b/source/text/scalc/01/func_second.xhp
index f2bebbcb56..7576e75007 100644
--- a/source/text/scalc/01/func_second.xhp
+++ b/source/text/scalc/01/func_second.xhp
@@ -19,26 +19,27 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">SECOND</title>
+<title id="tit">SECOND</title>
<filename>/text/scalc/01/func_second.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value>
+<bookmark branch="index" id="bm_id3159390"><bookmark_value>SECOND
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/>
<h1 id="hd_id3159390"><variable id="second"><link
href="text/scalc/01/func_second.xhp">SECOND</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3148974" xml-lang="en-US"><ahelp
hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The
second is given as an integer between 0 and 59.</paragraph>
+<paragraph role="paragraph" id="par_id3148974"><ahelp
hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The
second is given as an integer between 0 and 59.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3148407"
xml-lang="en-US">SECOND(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US">
+<paragraph role="code" id="par_id3148407">SECOND(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3155904">
<emph>Number</emph>, as a time value, is a decimal, for which the second is to
be returned.</paragraph>
+<note id="par_id451715611481885">SECOND() rounds to the nearest second,
instead of returning the integer part of the seconds.</note>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3153350">
<item type="input">=SECOND(NOW())</item> returns the current second</paragraph>
-<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3150831">
<item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item
type="input">12:20:17</item>.</paragraph>
<section id="relatedtopics">
<tip id="par_id71677014729834"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND";>SECOND
wiki page</link>.</tip>
diff --git a/source/text/scalc/01/func_year.xhp
b/source/text/scalc/01/func_year.xhp
index 0bdbab6f39..be09c371eb 100644
--- a/source/text/scalc/01/func_year.xhp
+++ b/source/text/scalc/01/func_year.xhp
@@ -19,28 +19,29 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_yearxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">YEAR</title>
+<title id="tit">YEAR</title>
<filename>/text/scalc/01/func_year.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value>
+<bookmark branch="index" id="bm_id3153982"><bookmark_value>YEAR
function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/>
<h1 id="hd_id3153982"><variable id="year"><link
href="text/scalc/01/func_year.xhp">YEAR</link>
</variable></h1>
-<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp
hid="HID_FUNC_JAHR">Returns the year as a number according to the <link
href="text/scalc/01/04060102.xhp#datebase">internal calculation
rules</link>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147496"><ahelp
hid="HID_FUNC_JAHR">Returns the year as a number according to the <link
href="text/scalc/01/04060102.xhp#datebase">internal calculation
rules</link>.</ahelp></paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id3154304"
xml-lang="en-US">YEAR(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3156013" xml-lang="en-US">
+<paragraph role="code" id="par_id3154304">YEAR(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3156013">
<emph>Number</emph> shows the internal date value for which the year is to be
returned.</paragraph>
+<note id="par_id451715611481885">YEAR() returns the integer part of the
year.</note>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id3145668" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3145668">
<item type="input">=YEAR(1)</item> returns 1899</paragraph>
-<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3151168">
<item type="input">=YEAR(2)</item> returns 1900</paragraph>
-<paragraph role="paragraph" id="par_id3150115" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3150115">
<item type="input">=YEAR(33333.33)</item> returns 1991</paragraph>
<paragraph role="paragraph"
id="par_id141577548861101"><input>=YEAR(DATEVALUE("2010-09-28"))</input>
returns 2010.</paragraph>
