[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #18 from QA Administrators --- Dear raal, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #17 from Alain Romedenne --- incomplete english information: https://en.wikipedia.org/wiki/24-hour_clock?oldid=351779978 -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #16 from Alain Romedenne --- Cases where hh > 24 exist in Japan and Norway: https://fr.wikipedia.org/wiki/Syst%C3%A8me_horaire_sur_24_heures Note: I did not find similar english page, sorry for the french Note that ss > 59

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 LibreOfficiant changed: What|Removed |Added Blocks|107659 |127592 CC|

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #14 from Andreas Heinisch --- The current implementation is here: https://opengrok.libreoffice.org/xref/core/basic/source/runtime/methods.cxx?r=7201db41#1981 sal_Int16 nHour = rPar.Get(1)->GetInteger(); if ( nHour == 24 ) {

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #13 from Mike Kaganski --- https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/timeserial-function -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #12 from Mike Kaganski --- Created attachment 151960 --> https://bugs.documentfoundation.org/attachment.cgi?id=151960=edit Testing results with Excel 2016 The code tested was: > Sub testTimeSerial() > Dim result As

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #11 from Eike Rathke --- Seems the implementation is the linked VBA reference "each TimeSerial argument should be in the normal range for the unit; that is, 0–23 for hours and 0–59 for minutes and seconds" part, not

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com --- Comment #10

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||107659

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #9 from Mike Kaganski --- This should be NEW - but clear spec is required. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 Xisco Faulí changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #7 from Mike Kaganski --- Not convinced. The MS documentation is self-contradictory. First, it declares constraints for hours. Then it declares that *each* parameter can be any number between -32768

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #6 from raal --- Should be fixed for VBA compatibility, at least https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/timeserial-function -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #5 from Mike Kaganski --- Btw: valid values for hours are 0-24 (24 is converted to 0), not 0-23 as help declares. -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #4 from Mike Kaganski --- Actually, it's that way since day 1 (see https://cgit.freedesktop.org/libreoffice/core/commit/?id=c25ec060; look for RTLFUNC(TimeSerial)). Fixing the code to conform to

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 Mike Kaganski changed: What|Removed |Added Version|4.1.0.4 release

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 --- Comment #2 from raal --- Created attachment 138201 --> https://bugs.documentfoundation.org/attachment.cgi?id=138201=edit printscreen of error -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 114229] Basic -timeserial function minutes outside the range 0-59

https://bugs.documentfoundation.org/show_bug.cgi?id=114229 raal changed: What|Removed |Added CC||r...@post.cz --- Comment