[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #13 from QA Administrators --- Dear Luis, 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 for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #12 from QA Administrators --- Dear Luis, 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 for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 LibreOfficiant changed: What|Removed |Added Blocks|107659 |127592 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107659 [Bug 107659] [META] Macro bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=127592 [Bug 127592] [META] LibreOffice Basic incl."Option Compatible" modules -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #11 from Oliver Brinzing --- i can confirm this with: Version: 6.2.5.2 (x64) Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: current situation: according to help, values inside range 1-31 should be accepted, but that is not the case at the moment, and with "Option VBASupport 1" we have a full roll over. IMO at least the help should be adjusted including a hint what "Option VBASupport" does. -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||107659 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107659 [Bug 107659] [META] Macro bugs and enhancements -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Eike Rathke changed: What|Removed |Added Hardware|x86-64 (AMD64) |All Version|6.0.4.2 release |5.4.0.0.alpha0+ --- Comment #10 from Eike Rathke --- I consider accepting invalid dates as wrong, but.. seems that odd roll-over behaviour was for VBA "compatibility" (and for VBA mode it does work)? But then again, why was 02-31 accepted but not 02-32 (which VBA apparently accepts)? I suspect that was due to the dumb old algorithm. So, do we want to accept any day (and month) number there and roll over? Or should we restrict to the arbitrary previous margin values 1<=month<=12 and 1<=day<=31? Which IMHO does not make sense and I certainly would not accept any complaint that suddenly also day 32 is accepted.. My take: do the full roll-over if that is what VBA does as well. -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 raal changed: What|Removed |Added Ever confirmed|0 |1 CC||er...@redhat.com, ||r...@post.cz OS|Windows (All) |All Keywords||bibisected, bisected, ||regression Status|UNCONFIRMED |NEW --- Comment #9 from raal --- This seems to have begun at the below commit. Adding Cc: to Eike Rathke ; Could you possibly take a look at this one? Thanks a831a75b6b64c8064bb357efce185b5fb7aef1c2 is the first bad commit commit a831a75b6b64c8064bb357efce185b5fb7aef1c2 Author: Jenkins Build User Date: Tue May 2 22:33:54 2017 +0200 source sha:1b13548f33720d80f53d493f6d70cbcce6b1a0fb author Eike Rathke 2017-05-02 15:53:04 +0200 committer Eike Rathke 2017-05-02 15:56:20 +0200 commit 1b13548f33720d80f53d493f6d70cbcce6b1a0fb (patch) tree0b797dde491986b97a94b96ed4fb83a6295c1a72 parent d2007136587a8722d0e7045828bca6a6d82fd244 (diff) BASIC: handle the full tools::Date range from -32768-01-01 to 32767-12-31 -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #8 from Luis --- I can try to patch this issue myself but who decides the desired bebavior? -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #7 from Luis --- Hi himajin10 ¿Are you testing the code in VBA? Mi test file was made for LibreOffice Basic. I liked the link to source code. But ¿where is method IsValidDate? I can see that now must be a strict check of date that was not present before. I reported this bug because the behavior change of DateSerial breaked a function that I use in a LO application and relied on the previous documented behavior. -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #6 from himajin100...@gmail.com --- ah, I just now noticed that String concatenation operator is &, not + in VBA . -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #5 from himajin100...@gmail.com --- minor note: I haven't checked how implicit type conversion works on StarBasic, but the code provided at least complained about type mismatch. I did Cstr(dDate). -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #4 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/basic/source/runtime/methods.cxx?r=44391aec#4617 https://help.libreoffice.org/latest/he/text/sbasic/shared/03103350.html -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Luis changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 --- Comment #3 from Luis --- Test document provided. The document has 5 buttons with attached macros: Button 1: "Call DateSerial(2018,02,28)" macro that calls function DateSerial(2018,02,28) Button 2: "Call DateSerial(2018,02,29)" macro that calls function DateSerial(2018,02,29) Button 3: "Call DateSerial(2018,02,30)" macro that calls function DateSerial(2018,02,30) Button 4: "Call DateSerial(2018,02,31)" macro that calls function DateSerial(2018,02,31) Button 5: "Call DateSerial(2018,02,32)" macro that calls function DateSerial(2018,02,32) Results on LO 5.3.0.3 (correct behavior): Pressing button 1 returns the date of February 28 Pressing button 2 returns the date of March 1 Pressing button 3 returns the date of March 2 Pressing button 4 returns the date of March 3 Pressing button 5 halts macro with the error message: "Action not supported. Invalid procedure call." Results on LO 5.4.0.3 and 6.4.0.2 (incorrect behavior): Pressing button 1 returns the date of February 28 Pressing button 2, 3, 4 or 5 halts macro with error message "Action not supported. Invalid procedure call." -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Luis changed: What|Removed |Added CC||luismiguel.laco...@gmail.co ||m --- Comment #2 from Luis --- Created attachment 143053 --> https://bugs.documentfoundation.org/attachment.cgi?id=143053=edit Test document. -- 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
[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.
https://bugs.documentfoundation.org/show_bug.cgi?id=117878 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #1 from Buovjaga --- Please attach a document with an example use so we can see the failure. Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document. -- 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
