[Libreoffice-bugs] [Bug 127476] Rounding behaviour of YEAR and SECOND function is inconsistent

[bugzilla-daemon at bugs.documentfoundation.org]

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

Albrecht Müller <albrecht.mueller at astrail.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=12
                   |                            |7334
                 CC|                            |albrecht.mueller at astrail.de
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #2 from Albrecht Müller <albrecht.mueller at astrail.de> ---
I think it is not useful to upload a sample file for the following reasons:

1) It is pretty easy to see the effect. Just enter the formulas into some cells
of a spreadsheet and check what the results are. Maybe you have to set an
option such that Calc accepts time values that are given as strings.

2) Uploading a file may distract from the real problem I want to address with
this report. Note that I made this bug report to depend on bug 127477 to point
out that you cannot fix this bug before this other bug has been fixed.

Some background information: I have a 6.2.6.2 Ubuntu version available and
discovered that I do not want to upgrade to this version as date & time
arithmetic has changed and that about 50% of the results of trivial date & time
calculations are now wrong. For details see bug 127334.

So I learned that it is the specified behaviour of date & time functions like
HOUR, MINUTE or SECOND to deliver pseudo random values that are correct in 50%
of the cases and one off in the other 50%. Of course, the help information does
not rule out this behaviour. Some other specification seems to exist that has
exactly this behaviour as a consequence. So a change in behaviour I consider a
critical bug has been classified as NOTABUG.

Thus the real problem is that as a user I cannot know what these date & time
functions are supposed to do. That's the reason for bug 127477. I think there
is a lot of confusion about how the date & time arithmetic is intended to work
which results in a couple of bug reports and fixes. This is the reason why I
just uploaded an additional comment to bug 127477 that tries to clarify what I
see a common source of confusion and unnecessary work.

-- 
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/20190911/495ac21f/attachment-0001.html>