diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-05-03 14:39:21 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-05-03 20:28:40 +0200 |
| commit | 507bed7d6fe7ea2347648813008074e8fd1e90f8 (patch) | |
| tree | dc5839751097e1d564c67fda7794973ad59b3c11 /source | |
| parent | f50afd07d060f8f67a4503d2d6bbe468bba747d8 (diff) | |
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.hallot@libreoffice.org>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060102.xhp | 86 | ||||
| -rw-r--r-- | source/text/scalc/01/04060111.xhp | 120 |
2 files changed, 103 insertions, 103 deletions
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> |