source/text/sbasic/shared/03030101.xhp | 2 +-
source/text/sbasic/shared/03100300.xhp | 4 ++--
source/text/sbasic/shared/03102300.xhp | 2 +-
source/text/scalc/01/02140600.xhp | 2 +-
source/text/swriter/00/00000404.xhp | 2 +-
5 files changed, 6 insertions(+), 6 deletions(-)
New commits:
commit 22c587639a5c06e9a61a390b4ea18da0cb0c0b68
Author: Bogdan Buzea <buzea.bog...@libreoffice.org>
AuthorDate: Mon Dec 9 17:04:55 2024 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Dec 9 23:46:27 2024 +0100
tdf#131332: Replace custom date formats with ISO 8601
Change-Id: Idf08d44bb5287da44b281820e73e08c58e154f99
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178163
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/sbasic/shared/03030101.xhp
b/source/text/sbasic/shared/03030101.xhp
index 0d5af98e14..b0a5aa4f79 100644
--- a/source/text/sbasic/shared/03030101.xhp
+++ b/source/text/sbasic/shared/03030101.xhp
@@ -49,7 +49,7 @@
<paragraph role="paragraph" id="par_id3151043" xml-lang="en-US">
<emph>Day:</emph> Integer expression that indicates the day of the specified
month. The accepted range is from 1-31. No error is returned when you enter a
non-existing day for a month shorter than 31 days.<comment>see
i69463</comment></paragraph>
<paragraph role="paragraph" id="par_id3161832" xml-lang="en-US">The
<emph>DateSerial function</emph> returns the number of days between December
30,1899 and the given date. You can use this function to calculate the
difference between two dates.</paragraph>
-<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US">The
<emph>DateSerial function</emph> returns the data type Variant with VarType 7
(Date). Internally, this value is stored as a Double value, so that when the
given date is 1.1.1900, the returned value is 2. Negative values correspond to
dates before December 30, 1899 (not inclusive).</paragraph>
+<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US">The
<emph>DateSerial function</emph> returns the data type Variant with VarType 7
(Date). Internally, this value is stored as a Double value, so that when the
given date is 1900-01-01, the returned value is 2. Negative values correspond
to dates before December 30, 1899 (not inclusive).</paragraph>
<paragraph role="paragraph" id="par_id3152576" xml-lang="en-US">If a date is
defined that lies outside of the accepted range, $[officename] Basic returns an
error message.</paragraph>
<paragraph role="paragraph" id="par_id3149481" xml-lang="en-US">Whereas you
define the <emph>DateValue function</emph> as a string that contains the date,
the <emph>DateSerial function</emph> evaluates each of the parameters (year,
month, day) as separate numeric expressions.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
diff --git a/source/text/sbasic/shared/03100300.xhp
b/source/text/sbasic/shared/03100300.xhp
index 2308773913..0ea1043d6c 100644
--- a/source/text/sbasic/shared/03100300.xhp
+++ b/source/text/sbasic/shared/03100300.xhp
@@ -53,8 +53,8 @@
<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341009312" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleCDate</paragraph>
- <paragraph id="par_idm1341008080" role="bascode" localize="false"
xml-lang="en-US"> MsgBox cDate(1000.25) ' 09.26.1902 06:00:00</paragraph>
- <paragraph id="par_idm1341006816" role="bascode" localize="false"
xml-lang="en-US"> MsgBox cDate(1001.26) ' 09.27.1902 06:14:24</paragraph>
+ <paragraph id="par_idm1341008080" role="bascode" localize="false"
xml-lang="en-US"> MsgBox cDate(1000.25) ' 1902-09-26 06:00:00</paragraph>
+ <paragraph id="par_idm1341006816" role="bascode" localize="false"
xml-lang="en-US"> MsgBox cDate(1001.26) ' 1902-09-27 06:14:24</paragraph>
<paragraph id="par_idm1341005552" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
<section id="relatedtopics">
diff --git a/source/text/sbasic/shared/03102300.xhp
b/source/text/sbasic/shared/03102300.xhp
index ff2a1f0b3f..d3a04b2e64 100644
--- a/source/text/sbasic/shared/03102300.xhp
+++ b/source/text/sbasic/shared/03102300.xhp
@@ -55,7 +55,7 @@
<bascode>
<paragraph id="par_idm1340791552" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleIsDate</paragraph>
<paragraph id="par_idm1340790320" role="bascode" localize="false"
xml-lang="en-US">Dim sDateVar As String</paragraph>
-<paragraph id="par_idm1340789088" role="bascode" localize="false"
xml-lang="en-US"> sDateVar = "12.12.1997"</paragraph>
+<paragraph id="par_idm1340789088" role="bascode" localize="false"
xml-lang="en-US"> sDateVar = "1997-12-12"</paragraph>
<paragraph id="par_id31508692102" role="bascode" localize="false"
xml-lang="en-US"> Print IsDate(sDateVar) ' True</paragraph>
<paragraph id="par_idm1340786096" role="bascode" localize="false"
xml-lang="en-US"> sDateVar = "12121997"</paragraph>
<paragraph id="par_id31472883695" role="bascode" localize="false"
xml-lang="en-US"> Print IsDate(sDateVar) ' False</paragraph>
diff --git a/source/text/scalc/01/02140600.xhp
b/source/text/scalc/01/02140600.xhp
index 15584eeb39..791573ffe3 100644
--- a/source/text/scalc/01/02140600.xhp
+++ b/source/text/scalc/01/02140600.xhp
@@ -81,7 +81,7 @@
<h3 id="hd_id3150202">AutoFill</h3>
<paragraph id="par_id3156288" role="paragraph"><ahelp
hid="modules/scalc/ui/filldlg/autofill">Forms a series directly in the
sheet.</ahelp> The <emph>AutoFill</emph> function takes account of customized
lists. For example, by entering <emph>January</emph> in the first cell, the
series is completed using the list defined under <switchinline
select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
</caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort
Lists</emph>.</paragraph>
-<paragraph id="par_id3155811" role="paragraph">AutoFill tries to complete a
value series by using a defined pattern. The series 1,3,5 is automatically
completed with 7,9,11,13, and so on. Date and time series are completed
accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days
is used.</paragraph>
+<paragraph id="par_id3155811" role="paragraph">AutoFill tries to complete a
value series by using a defined pattern. The series 1,3,5 is automatically
completed with 7,9,11,13, and so on. Date and time series are completed
accordingly; for example, after 1999-01-01 and 1999-01-15, an interval of 14
days is used.</paragraph>
<paragraph id="par_id2956483" role="paragraph" localize="false"><embedvar
href="text/scalc/guide/calc_series.xhp#calc_series"/></paragraph>
<h2 id="hd_id3148700">Unit of Time</h2>
diff --git a/source/text/swriter/00/00000404.xhp
b/source/text/swriter/00/00000404.xhp
index 2c8bbed237..776a273133 100644
--- a/source/text/swriter/00/00000404.xhp
+++ b/source/text/swriter/00/00000404.xhp
@@ -35,7 +35,7 @@
<section id="insert_field">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3154654">Choose <menuitem>Insert
- Field</menuitem></paragraph>
- <comment>Fields do not have context menus (15.01.20)</comment>
+ <comment>Fields do not have context menus</comment>
<embed href="text/shared/00/00000004.xhp#from_context"/>
<paragraph role="paragraph" id="par_id3146966">Open context menu -
choose <menuitem>Edit Field</menuitem> (inserted fields)</paragraph>
<embed href="text/shared/00/00000004.xhp#from_tabUI"/>
