tdf#131332: Replace custom date formats with ISO 8601

Change-Id: I46c451df1f3b957a3129f167e0a8d45726ef78c4
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177295
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

4 files changed, 10 insertions, 10 deletions

diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp
index 37afdc78ec..8317212b09 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -41,7 +41,7 @@
 <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">$[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, 2000-01-01 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>
@@ -58,7 +58,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id6794030" role="tablecontent">'12/30/1899'</paragraph>
+      <paragraph id="par_id6794030" role="tablecontent">'1899-12-30'</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id7096774" role="tablecontent">(default)</paragraph>
@@ -66,7 +66,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id5699942" role="tablecontent">'01/01/1900'</paragraph>
+      <paragraph id="par_id5699942" role="tablecontent">'1900-01-01'</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id6420484" role="tablecontent">(used in former StarCalc 1.0)</paragraph>
@@ -74,7 +74,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id6986602" role="tablecontent">'01/01/1904'</paragraph>
+      <paragraph id="par_id6986602" role="tablecontent">'1904-01-01'</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id616779" role="tablecontent">(used in Apple software)</paragraph>
diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp
index b7f6105014..e9ed72c69b 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -175,10 +175,10 @@
 <note id="par_id971641990480242">This function considers Monday to be the first day of the week regardless of the current locale settings.</note>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph role="paragraph" id="par_id671641994821992">In the following examples, dates are passed as strings. However, they can also be stored in separate cells and be passed as references.</paragraph>
-<paragraph role="paragraph" id="par_id71641991391639"><input>=WEEKS("01/12/2022","01/17/2022",0)</input> returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in the interval.</paragraph>
-<paragraph role="paragraph" id="par_id71641991390039"><input>=WEEKS("01/12/2022","01/19/2022",0)</input> returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the interval.</paragraph>
-<paragraph role="paragraph" id="par_id71641991391123"><input>=WEEKS("01/12/2022","01/17/2022",1)</input> returns 1 because <emph>Type</emph> was set to 1 and the interval contains a Monday, since 01/12/2022 is a Wednesday and 01/17/2022 is a Monday.</paragraph>
-<paragraph role="paragraph" id="par_id71641991332523"><input>=WEEKS("01/10/2022","01/15/2022",1)</input> returns 0 because <emph>Type</emph> was set to 1 and the interval does not contain any Mondays, except for the start date.</paragraph>
+<paragraph role="paragraph" id="par_id71641991391639"><input>=WEEKS("2022-01-12","2022-01-17",0)</input> returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in the interval.</paragraph>
+<paragraph role="paragraph" id="par_id71641991390039"><input>=WEEKS("2022-01-12","2022-01-19",0)</input> returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the interval.</paragraph>
+<paragraph role="paragraph" id="par_id71641991391123"><input>=WEEKS("2022-01-12","2022-01-17",1)</input> returns 1 because <emph>Type</emph> was set to 1 and the interval contains a Monday, since 2022-01-12 is a Wednesday and 2022-01-17 is a Monday.</paragraph>
+<paragraph role="paragraph" id="par_id71641991332523"><input>=WEEKS("2022-01-12","2022-01-15",1)</input> returns 0 because <emph>Type</emph> was set to 1 and the interval does not contain any Mondays, except for the start date.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
 <embed href="text/scalc/01/common_func.xhp#notODFF"/>
 <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph>
diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp
index be186d3a0c..ad6a5e3ed6 100644
--- a/source/text/scalc/01/func_date.xhp
+++ b/source/text/scalc/01/func_date.xhp
@@ -42,7 +42,7 @@
 <paragraph role="paragraph" id="par_id3156260" xml-lang="en-US">If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type="input">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type="input">=DATE(00;13;31)</item> the result will be 2001-01-31.</paragraph>
 <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
 <paragraph role="paragraph" id="par_id3152589" xml-lang="en-US">
-<item type="input">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY.</paragraph>
+<item type="input">=DATE(00;1;31)</item> yields the date 2000-01-31 written as 1/31/00 if the cell format setting is MM/DD/YY.</paragraph>
 <section id="relatedtopics">
     <tip id="par_id701677016652715"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE">DATE wiki page</link>.</tip>
     <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
diff --git a/source/text/scalc/01/func_value.xhp b/source/text/scalc/01/func_value.xhp
index 1211759c1b..03ac5f4701 100644
--- a/source/text/scalc/01/func_value.xhp
+++ b/source/text/scalc/01/func_value.xhp
@@ -34,7 +34,7 @@
   <paragraph role="paragraph" id="par_id101628778036375"><input>=VALUE("+1,234.567")</input> returns 1234.567 (considering en-US locale). Note that the "+" sign could have been omitted.</paragraph>
   <paragraph role="paragraph" id="par_id991628779914913"><input>=VALUE("$100")</input> returns 100 (considering en-US locale). Note that the currency prefix must match the current locale settings.</paragraph>
   <paragraph role="paragraph" id="par_id101628780114427"><input>=VALUE("50%")</input> returns 0.5. Note that the character "%" causes the numeric part to be divided by 100.</paragraph>
-  <paragraph role="paragraph" id="par_id731628780240876"><input>=VALUE("07/30/2021")</input> returns 44407 (considering en-US locale) which is the date-time sequence number corresponding to the specified date.</paragraph>
+  <paragraph role="paragraph" id="par_id731628780240876"><input>=VALUE("2021-07-30")</input> returns 44407 (considering ISO 8601 format) which is the date-time sequence number corresponding to the specified date.</paragraph>
   <paragraph role="paragraph" id="par_id501628780340635"><input>=VALUE("09:20:25")</input> returns 0.389178240740741 which is the date-time sequence number corresponding to the specified time value.</paragraph>
   <tip id="par_id801628779804928">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE">VALUE</link> wiki page for more details about this function.</tip>