source/text/scalc/01/04060102.xhp | 86 +++++++++++++--------------
source/text/scalc/01/04060111.xhp | 120 +++++++++++++++++++-------------------
2 files changed, 103 insertions(+), 103 deletions(-)
New commits:
commit 507bed7d6fe7ea2347648813008074e8fd1e90f8
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed May 3 14:39:21 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed May 3 20:28:40 2023 +0200
Refactor help page - no contents change
Change-Id: Ib45b27e20c047b9c1b65251729a54dcac40e48ba
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151340
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060102.xhp
b/source/text/scalc/01/04060102.xhp
index 2e1fd17996..81988d0981 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -20,19 +20,19 @@
<meta>
<topic id="textscalc0104060102xml" indexer="include">
- <title id="tit" xml-lang="en-US">Date & Time Functions</title>
+ <title id="tit">Date & Time Functions</title>
<filename>/text/scalc/01/04060102.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154536">
+<bookmark branch="index" id="bm_id3154536">
<bookmark_value>date and time functions</bookmark_value>
<bookmark_value>functions; date & time</bookmark_value>
<bookmark_value>Function Wizard; date & time</bookmark_value>
</bookmark>
<h1 id="hd_id3154536"><variable id="h1">Date & Time
Functions</variable></h1>
-<paragraph id="par_id3153973" role="paragraph" xml-lang="en-US"><variable
id="datumzeittext">These spreadsheet functions are used for inserting and
editing dates and times. </variable></paragraph>
+<paragraph id="par_id3153973" role="paragraph"><variable
id="datumzeittext">These spreadsheet functions are used for inserting and
editing dates and times. </variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#eikadaze"/>
@@ -41,53 +41,53 @@
<section id="ADD_note">
<note id="par_idN10600">The functions whose names end with _ADD or _EXCEL2003
return the same results as the corresponding Microsoft Excel 2003 functions
without the suffix. Use the functions without suffix to get results based on
international standards.</note>
</section>
-<paragraph id="par_id3150437" role="paragraph" xml-lang="en-US">$[officename]
internally handles a date/time value as a numerical value. If you assign the
numbering format "Number" to a date or time value, it is converted to a number.
For example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the
decimal point corresponds to the date; the value following the decimal point
corresponds to the time. If you do not want to see this type of numerical date
or time representation, change the number format (date or time) accordingly. To
do this, select the cell containing the date or time value, call its context
menu and select <emph>Format Cells</emph>. The <emph>Numbers</emph> tab page
contains the functions for defining the number format.</paragraph>
+<paragraph id="par_id3150437" role="paragraph">$[officename] internally
handles a date/time value as a numerical value. If you assign the numbering
format "Number" to a date or time value, it is converted to a number. For
example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the
decimal point corresponds to the date; the value following the decimal point
corresponds to the time. If you do not want to see this type of numerical date
or time representation, change the number format (date or time) accordingly. To
do this, select the cell containing the date or time value, call its context
menu and select <emph>Format Cells</emph>. The <emph>Numbers</emph> tab page
contains the functions for defining the number format.</paragraph>
<section id="datebase">
<h2 id="hd_id2408825">Date base for day zero</h2>
-<paragraph id="par_id9988402" role="paragraph" xml-lang="en-US">Dates are
calculated as offsets from a starting day zero. You can set the day zero to be
one of the following:</paragraph>
+<paragraph id="par_id9988402" role="paragraph">Dates are calculated as offsets
from a starting day zero. You can set the day zero to be one of the
following:</paragraph>
<table id="tbl_id1661427">
<tablerow>
<tablecell>
- <paragraph id="par_id6401257" role="tablehead" xml-lang="en-US">Date
base</paragraph>
+ <paragraph id="par_id6401257" role="tablehead">Date base</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id5841242" role="tablehead"
xml-lang="en-US">Use</paragraph>
+ <paragraph id="par_id5841242" role="tablehead">Use</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id6794030" role="tablecontent"
xml-lang="en-US">'12/30/1899'</paragraph>
+ <paragraph id="par_id6794030"
role="tablecontent">'12/30/1899'</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id7096774" role="tablecontent"
xml-lang="en-US">(default)</paragraph>
+ <paragraph id="par_id7096774" role="tablecontent">(default)</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id5699942" role="tablecontent"
xml-lang="en-US">'01/01/1900'</paragraph>
+ <paragraph id="par_id5699942"
role="tablecontent">'01/01/1900'</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id6420484" role="tablecontent" xml-lang="en-US">(used
in former StarCalc 1.0)</paragraph>
+ <paragraph id="par_id6420484" role="tablecontent">(used in former
StarCalc 1.0)</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id6986602" role="tablecontent"
xml-lang="en-US">'01/01/1904'</paragraph>
+ <paragraph id="par_id6986602"
role="tablecontent">'01/01/1904'</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id616779" role="tablecontent" xml-lang="en-US">(used
in Apple software)</paragraph>
+ <paragraph id="par_id616779" role="tablecontent">(used in Apple
software)</paragraph>
</tablecell>
</tablerow>
</table>
</section>
-<paragraph id="par_id791039" role="paragraph" xml-lang="en-US">Choose
<switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME -
Preferences</emph>
+<paragraph id="par_id791039" role="paragraph">Choose <switchinline
select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
</caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc -
Calculate</emph> to select the date base.</paragraph>
<warning id="par_id1953489">When you copy and paste cells containing date
values between different spreadsheets, both spreadsheet documents must be set
to the same date base. If date bases differ, the displayed date values will
change!</warning>
<h2 id="hd_id757469">Two digits years</h2>
-<paragraph id="par_id3149720" role="paragraph" xml-lang="en-US">In
<switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME -
Preferences</emph>
+<paragraph id="par_id3149720" role="paragraph">In <switchinline
select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
</caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - $[officename] -
General</emph> you find the area <emph>Year (two digits)</emph>. This sets the
period for which two-digit information applies. Note that changes made here
have an effect on some of the following functions.</paragraph>
<section id="datenumberinfo">
<note id="par_id3150654">When entering dates as part of formulas, slashes or
dashes used as date separators are interpreted as arithmetic operators.
Therefore, dates entered in this format are not recognized as dates and result
in erroneous calculations. To keep dates from being interpreted as parts of
formulas use the DATE function, for example, DATE(1954;7;20), or place the date
in quotation marks and use the ISO 8601 notation, for example, "1954-07-20".
Avoid using locale dependent date formats such as "07/20/54", the calculation
may produce errors if the document is loaded under different locale
settings.</note>
@@ -102,34 +102,34 @@
<section id="datetimefunctions">
<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"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_date.xhp#date"/>
</paragraph>
-<paragraph id="par_id6354457" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_datedif.xhp#datedif"/>
</paragraph>
-<paragraph id="par_id3372295" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_datevalue.xhp#datevalue"/>
</paragraph>
-<paragraph id="par_id5375835" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph>
-<paragraph id="par_id1208838" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_days.xhp#days"/>
</paragraph>
-<paragraph id="par_id7679982" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/>
</paragraph>
-<paragraph id="par_id1074251" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph>
-<paragraph id="par_id5684377" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_edate.xhp#edate"/>
</paragraph>
-<paragraph id="par_id1346781" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/>
</paragraph>
-<paragraph id="par_id224005" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/>
</paragraph>
-<paragraph id="par_id3886533" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/> </paragraph>
-<paragraph id="par_id3953062" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_minute.xhp#minute"/>
</paragraph>
-<paragraph id="par_id2579729" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_month.xhp#month"/>
</paragraph>
-<paragraph id="par_id8951384" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_networkdays.xhp#networkdays"/> </paragraph>
-<paragraph id="par_id231020162315043955" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> </paragraph>
-<paragraph id="par_id6501968" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph>
-<paragraph id="par_id372325" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_second.xhp#second"/>
</paragraph>
-<paragraph id="par_id2354503" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_time.xhp#time"/>
</paragraph>
-<paragraph id="par_id7765434" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/>
</paragraph>
-<paragraph id="par_id7576525" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_today.xhp#today"/>
</paragraph>
-<paragraph id="par_id9172643" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/>
</paragraph>
-<paragraph id="par_id3886532" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/>
</paragraph>
-<paragraph id="par_id614947" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph>
-<paragraph id="par_id3886534" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph>
-<paragraph id="par_idN10683" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/>
</paragraph>
-<paragraph id="par_id231020163315043955" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar
href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph>
-<paragraph id="par_id641193" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_year.xhp#year"/>
</paragraph>
-<paragraph id="par_id5189062" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/>
</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_id7679982" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_days360.xhp#days360"/> </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 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 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>
+<paragraph id="par_id372325" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_second.xhp#second"/> </paragraph>
+<paragraph id="par_id2354503" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_time.xhp#time"/> </paragraph>
+<paragraph id="par_id7765434" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_timevalue.xhp#timevalue"/> </paragraph>
+<paragraph id="par_id7576525" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_today.xhp#today"/> </paragraph>
+<paragraph id="par_id9172643" role="paragraph" localize="false"> <embedvar
href="text/scalc/01/func_weekday.xhp#weekday"/> </paragraph>
+<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 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>
</section>
<section id="relatedtopics">
diff --git a/source/text/scalc/01/04060111.xhp
b/source/text/scalc/01/04060111.xhp
index 5c5e8b5b75..1e7710ccf8 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -21,93 +21,93 @@
<meta>
<topic id="textscalc0104060111xml" indexer="include">
-<title id="tit" xml-lang="en-US">Add-in Functions</title>
+<title id="tit">Add-in Functions</title>
<filename>/text/scalc/01/04060111.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150870"><bookmark_value>add-ins; functions</bookmark_value>
+<bookmark branch="index" id="bm_id3150870"><bookmark_value>add-ins;
functions</bookmark_value>
<bookmark_value>functions; add-in functions</bookmark_value>
<bookmark_value>Function Wizard; add-ins</bookmark_value>
</bookmark>
<h1 id="hd_id3150870"><variable id="head_addin"><link
href="text/scalc/01/04060111.xhp">Add-in Functions</link></variable></h1>
-<paragraph role="paragraph" id="par_id3147427" xml-lang="en-US"><variable
id="addintext">The following describes and lists some of the available add-in
functions.
+<paragraph role="paragraph" id="par_id3147427"><variable id="addintext">The
following describes and lists some of the available add-in functions.
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3163713" xml-lang="en-US"><link
href="text/scalc/01/04060112.xhp#addinconcept">Add-in concept</link></paragraph>
-<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US">You will also
find a <link href="text/scalc/01/04060112.xhp">description of the $[officename]
Calc add-in interface</link> in the Help. In addition, important functions and
their parameters are described in the Help for the <switchinline
select="sys"><caseinline select="UNIX">Shared Library
+<paragraph role="paragraph" id="par_id3163713"><link
href="text/scalc/01/04060112.xhp#addinconcept">Add-in concept</link></paragraph>
+<paragraph role="paragraph" id="par_id3146120">You will also find a <link
href="text/scalc/01/04060112.xhp">description of the $[officename] Calc add-in
interface</link> in the Help. In addition, important functions and their
parameters are described in the Help for the <switchinline
select="sys"><caseinline select="UNIX">Shared Library
</caseinline><defaultinline>$[officename] Calc add-in
DLL</defaultinline></switchinline>.</paragraph>
<h2 id="hd_id3151075">Add-ins supplied</h2>
-<paragraph role="paragraph" id="par_id3156285" xml-lang="en-US">$[officename]
contains examples for the add-in interface of $[officename] Calc.</paragraph>
-<paragraph role="paragraph" id="par_id3159267" xml-lang="en-US"><link
href="text/scalc/01/04060115.xhp">Analysis Functions Part One</link></paragraph>
-<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US"><link
href="text/scalc/01/04060116.xhp">Analysis Functions Part Two</link></paragraph>
+<paragraph role="paragraph" id="par_id3156285">$[officename] contains examples
for the add-in interface of $[officename] Calc.</paragraph>
+<paragraph role="paragraph" id="par_id3159267"><link
href="text/scalc/01/04060115.xhp">Analysis Functions Part One</link></paragraph>
+<paragraph role="paragraph" id="par_id3154703"><link
href="text/scalc/01/04060116.xhp">Analysis Functions Part Two</link></paragraph>
<sort order="asc" descendant="h2">
<section id="isleapyear">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149566"><bookmark_value>ISLEAPYEAR function</bookmark_value>
+<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>
-<paragraph role="paragraph" id="par_id3150297" xml-lang="en-US"><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="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"
xml-lang="en-US">ISLEAPYEAR(Date)</paragraph>
-<paragraph role="paragraph" id="par_id3159239" xml-lang="en-US">
+<paragraph role="code" id="par_id3150205">ISLEAPYEAR(Date)</paragraph>
+<paragraph role="paragraph" id="par_id3159239">
<emph>Date</emph> specifies whether a given date falls within a leap year. The
Date parameter must be a valid date.</paragraph>
<embed href="text/scalc/01/ful_func.xhp#warnexcelbadleapyear"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3150786"
xml-lang="en-US">=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">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">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>
+<paragraph role="paragraph" id="par_id3150786">=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">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">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>
<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>
</section>
<section id="years">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3154656"><bookmark_value>YEARS function</bookmark_value>
+<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 xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DIFFYEARS"
id="bm_id3150368" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_DIFFYEARS" id="bm_id3150368"
localize="false"/>
<h2 id="hd_id3154656">YEARS</h2>
-<paragraph role="paragraph" id="par_id3150886" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DIFFYEARS">Calculates the difference in years between two
dates.</ahelp></paragraph>
+<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" xml-lang="en-US">YEARS(StartDate;
EndDate; Type)</paragraph>
-<paragraph role="paragraph" id="par_id3145387" xml-lang="en-US">
+<paragraph role="code" id="par_id3146114">YEARS(StartDate; EndDate;
Type)</paragraph>
+<paragraph role="paragraph" id="par_id3145387">
<emph>StartDate</emph> is the first date</paragraph>
-<paragraph role="paragraph" id="par_id3156290" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3156290">
<emph>EndDate</emph> is the second date</paragraph>
-<paragraph role="paragraph" id="par_id3152893" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3152893">
<emph>Type</emph> calculates the type of difference. Possible values are 0
(interval) and 1 (in calendar years).</paragraph>
<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>
</section>
<section id="months">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3152898"><bookmark_value>MONTHS function</bookmark_value>
+<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 xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DIFFMONTHS"
id="bm_id3148839" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_DIFFMONTHS" id="bm_id3148839"
localize="false"/>
<h2 id="hd_id3152898">MONTHS</h2>
-<paragraph role="paragraph" id="par_id3153066" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DIFFMONTHS">Calculates the difference in months between two
dates.</ahelp></paragraph>
+<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" xml-lang="en-US">MONTHS(StartDate;
EndDate; Type)</paragraph>
-<paragraph role="paragraph" id="par_id3145075" xml-lang="en-US">
+<paragraph role="code" id="par_id3146869">MONTHS(StartDate; EndDate;
Type)</paragraph>
+<paragraph role="paragraph" id="par_id3145075">
<emph>StartDate</emph> is the first date</paragraph>
-<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3157981">
<emph>EndDate</emph> is the second date</paragraph>
-<paragraph role="paragraph" id="par_id3150111" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3150111">
<emph>Type</emph> calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).</paragraph>
<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>
</section>
<section id="rot13">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3159094"><bookmark_value>ROT13 function</bookmark_value>
+<bookmark branch="index" id="bm_id3159094"><bookmark_value>ROT13
function</bookmark_value>
<bookmark_value>encrypting text</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_ROT13"
id="bm_id3153283" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_ROT13" id="bm_id3153283"
localize="false"/>
<h2 id="hd_id3159094">ROT13</h2>
-<paragraph role="paragraph" id="par_id3146781" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_ROT13">Encrypts a character string by moving the characters
13 positions in the alphabet.</ahelp> After the letter Z, the alphabet begins
again (Rotation). By applying the encryption function again to the resulting
code, you can decrypt the text.</paragraph>
+<paragraph role="paragraph" id="par_id3146781"><ahelp
hid="HID_DAI_FUNC_ROT13">Encrypts a character string by moving the characters
13 positions in the alphabet.</ahelp> After the letter Z, the alphabet begins
again (Rotation). By applying the encryption function again to the resulting
code, you can decrypt the text.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph role="code" id="par_id3159205"
xml-lang="en-US">ROT13(Text)</paragraph>
-<paragraph role="paragraph" id="par_id3153249" xml-lang="en-US">
+<paragraph role="code" id="par_id3159205">ROT13(Text)</paragraph>
+<paragraph role="paragraph" id="par_id3153249">
<emph>Text</emph> is the character string to be encrypted. ROT13(ROT13(Text))
decrypts the code.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id151626469224135" role="paragraph"><input>=ROT13("Gur
Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.")</input> returns the string
"The Document Foundation was founded in September 2010.". Notice how spaces,
digits, and full stops are unaffected by ROT13.</paragraph>
@@ -117,53 +117,53 @@
<tip id="par_id221626469509161">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13";>ROT13</link>
wiki page for more details about this function.</tip>
</section>
<section id="daysinyear">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3151300"><bookmark_value>DAYSINYEAR function</bookmark_value>
+<bookmark branch="index" id="bm_id3151300"><bookmark_value>DAYSINYEAR
function</bookmark_value>
<bookmark_value>number of days; in a specific year</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DAYSINYEAR"
id="bm_id3153972" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_DAYSINYEAR" id="bm_id3153972"
localize="false"/>
<h2 id="hd_id3151300">DAYSINYEAR</h2>
-<paragraph role="paragraph" id="par_id3143220" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DAYSINYEAR">Calculates the number of days of the year in
which the date entered occurs.</ahelp></paragraph>
+<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"
xml-lang="en-US">DAYSINYEAR(Date)</paragraph>
-<paragraph role="paragraph" id="par_id3153803" xml-lang="en-US">
+<paragraph role="code" id="par_id3154651">DAYSINYEAR(Date)</paragraph>
+<paragraph role="paragraph" id="par_id3153803">
<emph>Date</emph> is any date in the respective year. The Date parameter must
be a valid date according to the locale settings of %PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3153811"
xml-lang="en-US">=DAYSINYEAR(A1) returns 366 days if A1 contains 1968-02-29, a
valid date for the year 1968.</paragraph>
+<paragraph role="paragraph" id="par_id3153811">=DAYSINYEAR(A1) returns 366
days if A1 contains 1968-02-29, a valid date for the year 1968.</paragraph>
<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>
</section>
<section id="daysinmonth">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3154737"><bookmark_value>DAYSINMONTH function</bookmark_value>
+<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 xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DAYSINMONTH"
id="bm_id3155593" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_DAYSINMONTH" id="bm_id3155593"
localize="false"/>
<h2 id="hd_id3154737">DAYSINMONTH</h2>
-<paragraph role="paragraph" id="par_id3149316" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DAYSINMONTH">Calculates the number of days of the month in
which the date entered occurs.</ahelp></paragraph>
+<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"
xml-lang="en-US">DAYSINMONTH(Date)</paragraph>
-<paragraph role="paragraph" id="par_id3147501" xml-lang="en-US">
+<paragraph role="code" id="par_id3150955">DAYSINMONTH(Date)</paragraph>
+<paragraph role="paragraph" id="par_id3147501">
<emph>Date</emph> is any date in the respective month of the desired year. The
Date parameter must be a valid date according to the locale settings of
%PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3155742"
xml-lang="en-US">=DAYSINMONTH(A1) returns 29 days if A1 contains 1968-02-17, a
valid date for February 1968.</paragraph>
+<paragraph role="paragraph" id="par_id3155742">=DAYSINMONTH(A1) returns 29
days if A1 contains 1968-02-17, a valid date for February 1968.</paragraph>
<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>
</section>
<section id="weeks">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149048"><bookmark_value>WEEKS function</bookmark_value>
+<bookmark branch="index" id="bm_id3149048"><bookmark_value>WEEKS
function</bookmark_value>
<bookmark_value>number of weeks;between two dates</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DIFFWEEKS"
id="bm_id3150435" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_DIFFWEEKS" id="bm_id3150435"
localize="false"/>
<h2 id="hd_id3149048">WEEKS</h2>
-<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DIFFWEEKS">Calculates the difference in weeks between two
dates.</ahelp></paragraph>
+<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" xml-lang="en-US">WEEKS(StartDate;
EndDate; Type)</paragraph>
-<paragraph role="paragraph" id="par_id3151387" xml-lang="en-US">
+<paragraph role="code" id="par_id3147402">WEEKS(StartDate; EndDate;
Type)</paragraph>
+<paragraph role="paragraph" id="par_id3151387">
<emph>StartDate</emph> is the start date in the interval.</paragraph>
-<paragraph role="paragraph" id="par_id3146324" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3146324">
<emph>EndDate</emph> is the end date in the interval. The end date must be
greater than the start date, or else an error is returned.</paragraph>
-<paragraph role="paragraph" id="par_id3166467" xml-lang="en-US">
+<paragraph role="paragraph" id="par_id3166467">
<emph>Type</emph> specifies the type of difference to be calculated. Possible
values are 0 (time interval) or 1 (calendar weeks).</paragraph>
<paragraph role="paragraph" id="par_id81641990941192">If <emph>Type = 0</emph>
the function will assume that 7 days is equivalent to one week without
considering any specific day to mark the beginning of a week.</paragraph>
<paragraph role="paragraph" id="par_id31641991010650">If <emph>Type = 1</emph>
the function will consider Monday to be the first day of the week. Therefore,
except for the start date, each occurrence of a Monday in the interval is
counted as an additional week.</paragraph>
@@ -179,25 +179,25 @@
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph>
</section>
<section id="weeksinyear">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145237"><bookmark_value>WEEKSINYEAR function</bookmark_value>
+<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 xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_WEEKSINYEAR"
id="bm_id3146883" localize="false"/>
+<bookmark branch="hid/SC_HID_DAI_FUNC_WEEKSINYEAR" id="bm_id3146883"
localize="false"/>
<h2 id="hd_id3145237">WEEKSINYEAR</h2>
-<paragraph role="paragraph" id="par_id3147410" xml-lang="en-US"><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>
+<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"
xml-lang="en-US">WEEKSINYEAR(Date)</paragraph>
-<paragraph role="paragraph" id="par_id3149946" xml-lang="en-US">
+<paragraph role="code" id="par_id3145638">WEEKSINYEAR(Date)</paragraph>
+<paragraph role="paragraph" id="par_id3149946">
<emph>Date</emph> is any date in the respective year. The Date parameter must
be a valid date according to the locale settings of %PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3147614"
xml-lang="en-US">WEEKSINYEAR(A1) returns 53 if A1 contains 1970-02-17, a valid
date for the year 1970.</paragraph>
+<paragraph role="paragraph" id="par_id3147614">WEEKSINYEAR(A1) returns 53 if
A1 contains 1970-02-17, a valid date for the year 1970.</paragraph>
<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>
</section>
</sort>
<h2 id="hd_id3157901">Add-ins through %PRODUCTNAME API</h2>
-<paragraph role="paragraph" id="par_id3149351" xml-lang="en-US">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 %PRODUCTNAME <link
href="https://api.libreoffice.org/";>API</link>.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
