https://bugs.documentfoundation.org/show_bug.cgi?id=127476
Albrecht Müller <albrecht.muel...@astrail.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=12
| |7334
CC| |albrecht.muel...@astrail.de
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #2 from Albrecht Müller <albrecht.muel...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
