https://bugs.documentfoundation.org/show_bug.cgi?id=70883
--- Comment #29 from Jax <[email protected]> --- Still present after 12 years! Version: 7.3.7.2 I can't get the workaround to work. I recorded a Macro (it's been a very long while since writing from scratch) and then shoved in the line from Comment 7 but it won't work. Also, I have tried setting the button's 'Take Focus On Click' property to 'No' and that doesn't work either. I'll ask for support in the LO forum but if anyone wants to assist me for others who land here, please do so: The start of my code: sub ListConvert REM **TRIED THE WORKAROUND CODE HERE** rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document REM **TRIED THE WORKAROUND CODE HERE, AS SHOWN** REM ---------------------------------------------------------------------- REM Installed this workaround from https://bugs.documentfoundation.org/show_bug.cgi?id=70883#c7 ThisComponent.CurrentController.Frame.ContainerWindow.setFocus document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") REM **TRIED THE WORKAROUND CODE HERE TOO** rem -----REST OF CODE---------------------------------------------------- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "ToPoint" args1(0).Value = "$A$1:$D$20" -- You are receiving this mail because: You are the assignee for the bug.
