Version: 7.4.1.2 / LibreOffice Community Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Hello, Sorry but I don't find this bug in bugzilla In LO 7.4 the Button parameter (2nd) of Msgbox function/instruction is no longer optional msgbox "hello" -> good msgbox "hello",,"title" -> fail ??? msgbox "hello",0,"title" -> good thank you for your look.
Reading https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/msgbox-function, it seems all args after first one are optional. Any thoughts here?
(In reply to Julien Nabet from comment #1) > Reading > https://learn.microsoft.com/en-us/office/vba/language/reference/user- > interface-help/msgbox-function, it seems all args after first one are > optional. > > Any thoughts here? OK for the link Indeed the arguments after the first must be optional. It's like that from the origin of LO! But in version 7.4 it doesn't work anymore Have you really tested in version 7.4?
(In reply to Julien Nabet from comment #1) > Reading > https://learn.microsoft.com/en-us/office/vba/language/reference/user- > interface-help/msgbox-function, it seems all args after first one are > optional. > > Any thoughts here? Sorry, the last comment was for Mike and Andreas, I should have put: Andreas/Mike: any thoughts here?
I am not sure I understood correctly, but the following code works for me: Sub test MsgBox "Message", Title := "Dialog title" End Sub I did not have to specify the Buttons argument.
BTW, I forgot to mention in Comment #4 that I'm using LO 7.4.1 Version: 7.4.1.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1 Calc: threaded
(In reply to Rafael Lima from comment #5) > BTW, I forgot to mention in Comment #4 that I'm using LO 7.4.1 > > Version: 7.4.1.2 / LibreOffice Community > Build ID: 40(Build:2) > CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) > Locale: pt-BR (pt_BR.UTF-8); UI: en-US > Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1 > Calc: threaded Yes, but you use a named parameter (it is heavy !) The question why this code failed ? While he has never posed a problem since LO 1.0! Sub test MsgBox "Message",,"Dialog title" End Sub I don't know how to be clearer Thanks a lot
Confirmed in: Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: cc82ae8fb23d84c263fbe6886320f6f819248db2 CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL threaded
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6f3532f6aaafb6ad58a9e32dc0eff43a0d54862b tdf#151012 - Initialize optional parameters with their default values It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/a2838a17498001c07b365d2087239710e7f0473a tdf#151012 - Initialize optional parameters with their default values It will be available in 7.4.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Sorry but is not available in Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
(In reply to TISSENDIER Pierre from comment #10) > Sorry but is not available in > > Version: 7.4.2.3 / LibreOffice Community > Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf > CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 > Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR > Calc: threaded Quite expected since it'll be fixed from 7.4.3 (not 7.4.2) as Whiteboard indicates.