[Libreoffice-bugs] [Bug 127477] Incomplete description of date & time functions in the help information

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127477

Olivier Hallot <olivier.hallot at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #2 from Olivier Hallot <olivier.hallot at libreoffice.org> ---
Trying to sumarize.

1) The YEAR, MONTH... help pages are short in description and navigation
between similar topics. Help does not help... -> OK to improve.

2) YEAR("1999-12-31 23:25:59,6") is not a valid argument for the function, but 
YEAR(DATEVALUE("1999-12-31 23:25:59,6")) is. Besides we are 35 minutes before
the hour in your example and it can't be the reason to round the year. Assuming
it is a typo...

=YEAR(DATEVALUE("1999-12-31 23:59:59.99999")) is 1999
=YEAR(DATEVALUE("1999-12-31 23:59:59.9999999")) is 2000

Versão: 6.3.4.2
ID de compilação: 60da17e045e08f1793c57c00ba83cdfce946d0aa
Threads da CPU:8; SO:Linux 5.3; Realizador da interface: GL; VCL: kde5; 
Local: en-US (pt_BR.UTF-8); Idioma de IU: pt-BR
Calc: threaded

3) We suppose the function(s) are compliant with the ISO-IEC 23600 standard
(aka Open Document Format from OASYS), therefore the Help pages contents can be
based on (e.g. YEAR)
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018216_715980110

If they are not compliant, we must bring to the development for fixing.

4) as result of 3) we either flag the difference with MSExcel 97 or we just
ignore Excel 97 as not a standard in which we rely. Many Calc functions were
introduced to accommodate the "de-facto" excel standard and deviates from ODFF
standard.

5) If the standard ISO-IEC 23600  is not accurate on how rounding error are
handled... -> development.

However I doubt the samples above can be considered a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191227/98efeba2/attachment-0001.htm>