source/text/scalc/01/04060102.xhp | 8 ++++----
source/text/scalc/01/04060111.xhp | 8 ++++----
source/text/scalc/01/func_date.xhp | 2 +-
source/text/scalc/01/func_value.xhp | 2 +-
4 files changed, 10 insertions(+), 10 deletions(-)
New commits:
commit c73747f8fb95caee2f4bd5095b886e305bd7d684
Author: Bogdan Buzea <buzea.bog...@libreoffice.org>
AuthorDate: Mon Nov 25 19:51:43 2024 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 27 13:25:02 2024 +0100
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.hal...@libreoffice.org>
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>
