https://bugs.documentfoundation.org/show_bug.cgi?id=106957
Bug ID: 106957
Summary: outdated documentation for BASIC date functions
Product: LibreOffice
Version: 5.2.3.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
Description:
Date acceptance patterns depending of the locale setting have been introduced
in LibO, it seems, already some years ago. Some date functions which were
affected by this, seem to have been changed accordingly, as they reject dates
in formats not fitting these patterns – or the ISO format. The help texts for
these functions still reflect the former situation.
I propose the following changes for the help texts. There is also a reserve
condition saying that only one of the two ISO formats is accepted for the
moment, which could perhaps be removed in the future if bug 106956 is resolved,
allowing also the other format.
CDate Function:
Replace the string
in the format MM.DD.YYYY HH.MM.SS, as defined by the DateValue and TimeValue
function conventions
by
either in one of the date acceptance patterns defined for your locale setting
(see *Tools - Options - Language Settings - Languages*) or in ISO date format
(momentarily, only the ISO format with hyphens, e.g. "2012-12-31") is accepted.
DateValue Function:
Replace the text starting from
The date can be specified in almost any format.
and containing all the rest of the description of parameter „Date“, i.e. up to
just before „Error Codes“, by
In contrast to the DateSerial function that passes years, months and days as
separate numeric values, the DateValue function requests the date string to be
according to either one of the date acceptance patterns defined for your locale
setting (see *Tools - Options - Language Settings - Languages*) or to ISO date
format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31") is
accepted.
(The text concerning the decimal separator is irrelevant here.)
Steps to Reproduce:
-
Actual Results:
-
Expected Results:
-
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
Firefox/52.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
