diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-05-31 12:34:21 -0300 |
---|---|---|
committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2024-05-31 22:49:19 +0200 |
commit | 692e37447c9af746a7c34bfe46a1b78e0b15322d (patch) | |
tree | 12f4ed0c95d10b69e55a4f3dae8af5e23f105444 /source | |
parent | 3de7c68c52bfe0beadcd791092aaea420cb43a97 (diff) |
Unmute translation on func_weeknum.xhp
+ refactor
Change-Id: Ibba4e057864ccb6339bf2d8a5d93899bd0744380
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168299
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source')
-rw-r--r-- | source/text/scalc/01/func_weeknum.xhp | 90 |
1 files changed, 45 insertions, 45 deletions
diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index 7f139d446c..340d6f96b1 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -19,165 +19,165 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc01func_weeknumxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">WEEKNUM</title> +<title id="tit">WEEKNUM</title> <filename>/text/scalc/01/func_weeknum.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM function</bookmark_value> +<bookmark branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/> +<bookmark branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/> <h1 id="hd_id3159161"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> </variable></h1> -<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value as defined in ODF OpenFormula and compatible with other spreadsheet applications.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id3147220" xml-lang="en-US">Supported are two week numbering systems:</paragraph> +<paragraph role="paragraph" id="par_id3149770"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value as defined in ODF OpenFormula and compatible with other spreadsheet applications.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147220">Supported are two week numbering systems:</paragraph> <table id="tab_id481535122363435"> <tablerow> <tablecell> - <paragraph id="par_id851535122363435" role="tablehead" xml-lang="en-US">System</paragraph> + <paragraph id="par_id851535122363435" role="tablehead">System</paragraph> </tablecell> <tablecell> - <paragraph id="par_id901535122363436" role="tablehead" xml-lang="en-US" localize="false">Description</paragraph> + <paragraph id="par_id901535122363436" role="tablehead">Description</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id691535122363437" role="tablecontent" xml-lang="en-US">System 1</paragraph> + <paragraph id="par_id691535122363437" role="tablecontent">System 1</paragraph> </tablecell> <tablecell> - <paragraph id="par_id3147221" role="tablecontent" xml-lang="en-US">The week containing January 1 is the first week of the year, and is numbered week 1.</paragraph> + <paragraph id="par_id3147221" role="tablecontent">The week containing January 1 is the first week of the year, and is numbered week 1.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id741535122455285" role="tablecontent" xml-lang="en-US">System 2</paragraph> + <paragraph id="par_id741535122455285" role="tablecontent">System 2</paragraph> </tablecell> <tablecell> - <paragraph role="tablecontent" id="par_id3147222" xml-lang="en-US">The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday.</paragraph> + <paragraph role="tablecontent" id="par_id3147222">The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday.</paragraph> </tablecell> </tablerow> </table> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM(Number [; Mode])</paragraph> -<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> +<paragraph role="code" id="par_id3147236">WEEKNUM(Number [; Mode])</paragraph> +<paragraph role="paragraph" id="par_id3147511"> <emph>Number</emph> is the internal date number.</paragraph> -<paragraph role="paragraph" id="par_id3154269" xml-lang="en-US"> +<paragraph role="paragraph" id="par_id3154269"> <emph>Mode</emph> sets the start of the week and the week numbering system. This parameter is optional, if omitted the default value is 1.</paragraph> <table id="tab_id491535122633826"> <tablerow> <tablecell> - <paragraph id="par_id961535122993923" role="tablehead" xml-lang="en-US">System</paragraph> + <paragraph id="par_id961535122993923" role="tablehead">System</paragraph> </tablecell> <tablecell> - <paragraph id="par_id151535122633826" role="tablehead" xml-lang="en-US">Mode</paragraph> + <paragraph id="par_id151535122633826" role="tablehead">Mode</paragraph> </tablecell> <tablecell> - <paragraph id="par_id231535122633827" role="tablehead" xml-lang="en-US">Day of the week</paragraph> + <paragraph id="par_id231535122633827" role="tablehead">Day of the week</paragraph> </tablecell> </tablerow> <tablerow> <tablecell rowspan="9"> - <paragraph id="par_id531535124180000" role="tablecontents" xml-lang="en-US">System 1</paragraph> + <paragraph id="par_id531535124180000" role="tablecontents">System 1</paragraph> </tablecell> <tablecell> - <paragraph id="par_id931535122633827" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> + <paragraph id="par_id931535122633827" role="tablecontent" localize="false">1</paragraph> </tablecell> <tablecell> - <paragraph id="par_id351535122633828" role="tablecontent" xml-lang="en-US">Sunday</paragraph> + <paragraph id="par_id351535122633828" role="tablecontent">Sunday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id441535122735565" role="tablecontents" xml-lang="en-US" localize="false">2</paragraph> + <paragraph id="par_id441535122735565" role="tablecontents" localize="false">2</paragraph> </tablecell> <tablecell> - <paragraph id="par_id591535122756686" role="tablecontents" xml-lang="en-US">Monday</paragraph> + <paragraph id="par_id591535122756686" role="tablecontents">Monday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id541535122798459" role="tablecontents" xml-lang="en-US" localize="false">11</paragraph> + <paragraph id="par_id541535122798459" role="tablecontents" localize="false">11</paragraph> </tablecell> <tablecell> - <paragraph id="par_id881535122835126" role="tablecontents" xml-lang="en-US">Monday</paragraph> + <paragraph id="par_id881535122835126" role="tablecontents">Monday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id941535122866815" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> + <paragraph id="par_id941535122866815" role="tablecontent" localize="false">12</paragraph> </tablecell> <tablecell> - <paragraph id="par_id241535122903569" role="tablecontents" xml-lang="en-US">Tuesday</paragraph> + <paragraph id="par_id241535122903569" role="tablecontents">Tuesday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id271535124253476" role="tablecontents" xml-lang="en-US" localize="false">13</paragraph> + <paragraph id="par_id271535124253476" role="tablecontents" localize="false">13</paragraph> </tablecell> <tablecell> - <paragraph id="par_id31535124277973" role="tablecontents" xml-lang="en-US">Wednesday</paragraph> + <paragraph id="par_id31535124277973" role="tablecontents">Wednesday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id281535124290548" role="tablecontents" xml-lang="en-US" localize="false">14</paragraph> + <paragraph id="par_id281535124290548" role="tablecontents" localize="false">14</paragraph> </tablecell> <tablecell> - <paragraph id="par_id21535124310462" role="tablecontents" xml-lang="en-US">Thursday</paragraph> + <paragraph id="par_id21535124310462" role="tablecontents">Thursday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id721535124338290" role="tablecontents" xml-lang="en-US" localize="false">15</paragraph> + <paragraph id="par_id721535124338290" role="tablecontents" localize="false">15</paragraph> </tablecell> <tablecell> - <paragraph id="par_id921535124365435" role="tablecontents" xml-lang="en-US">Friday</paragraph> + <paragraph id="par_id921535124365435" role="tablecontents">Friday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id781535124380237" role="tablecontents" xml-lang="en-US" localize="false">16</paragraph> + <paragraph id="par_id781535124380237" role="tablecontents" localize="false">16</paragraph> </tablecell> <tablecell> - <paragraph id="par_id211535124416253" role="tablecontents" xml-lang="en-US">Saturday</paragraph> + <paragraph id="par_id211535124416253" role="tablecontents">Saturday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id601535124440320" role="tablecontents" xml-lang="en-US" localize="false">17</paragraph> + <paragraph id="par_id601535124440320" role="tablecontents" localize="false">17</paragraph> </tablecell> <tablecell> - <paragraph id="par_id461535124473824" role="tablecontents" xml-lang="en-US">Sunday</paragraph> + <paragraph id="par_id461535124473824" role="tablecontents">Sunday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell rowspan="2"> - <paragraph id="par_id471535124489997" role="tablecontents" xml-lang="en-US">System 2</paragraph> + <paragraph id="par_id471535124489997" role="tablecontents">System 2</paragraph> </tablecell> <tablecell> - <paragraph id="par_id431535124539573" role="tablecontents" xml-lang="en-US" localize="false">21</paragraph> + <paragraph id="par_id431535124539573" role="tablecontents" localize="false">21</paragraph> </tablecell> <tablecell> - <paragraph id="par_id391535124564520" role="tablecontents" xml-lang="en-US">Monday (ISO 8601)</paragraph> + <paragraph id="par_id391535124564520" role="tablecontents">Monday (ISO 8601)</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id971535124578111" role="tablecontents" xml-lang="en-US" localize="false">150</paragraph> + <paragraph id="par_id971535124578111" role="tablecontents" localize="false">150</paragraph> </tablecell> <tablecell> - <paragraph id="par_id661535124640643" role="tablecontents" xml-lang="en-US">(ISO 8601, for interoperability with Gnumeric)</paragraph> + <paragraph id="par_id661535124640643" role="tablecontents">(ISO 8601, for interoperability with Gnumeric)</paragraph> </tablecell> </tablerow> </table> <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_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1</paragraph> -<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year.</paragraph> -<paragraph role="paragraph" id="par_id3149793" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> -<paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> +<paragraph role="paragraph" id="par_id3150704"><item type="input">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1</paragraph> +<paragraph role="paragraph" id="par_id3149792"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year.</paragraph> +<paragraph role="paragraph" id="par_id3149793"><item type="input">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> +<paragraph role="paragraph" id="par_id3149794"><item type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> <section id="relatedtopics"> <tip id="par_id361677013519430"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM">WEEKNUM wiki page</link>.</tip> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> |