But I haven't found the function to display the search bar, at the bottom (triggered by Ctrl+F), Does it exist?
Thanks a lot in advance!
openoffice 4.1.5-1 on Linux Arch
Are you using the LibreOffice?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Run this against some spreadsheet document. It generates a new spreadsheet with all availlable spreadsheet dispatches. Can be used with any other type of frame as well.
Sub fetchDispatchInformation()
REM dump current frame's "ConfigurableDispatchInformation" into a new spreadsheet as hyperlinks
REM if the current frame happens to be a spreadsheet frame, you can test the hyperlinks
Dim oCurrentController As Variant
Dim oFrame As Variant
Dim oConfigurableDispatchInformation As Variant
Dim oConfigurableDispatchInformation2 As Variant
Dim oConfigurableDispatchInformation3 As Variant
oCurrentController = ThisComponent.getCurrentController()
oFrame = oCurrentController.getFrame()
oDoc = StarDesktop.loadComponentFromURL("private:factory/scalc","_blank",0,Array())
sh = oDoc.Sheets.getByIndex(0)
c = 0
on error goto exitErr
do
oConfigurableDispatchInformation = oFrame.getConfigurableDispatchInformation(c)
for each p in oConfigurableDispatchInformation
sh.getCellByPosition(c,r).setFormula("=HYPERLINK("""& p.Command &""")")
r = r +1
next p
c = c +1
r = 0
loop
exitErr:
End Sub
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
It is vnd.sun.star.findbar:FocusToFindbar
I found it in <profile>/config/soffice.cfg/modules/scalc/menubar/menubar.xml
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Sub test_findbar
dim document as object
dim dispatcher as object
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, "vnd.sun.star.findbar:FocusToFindbar", "", 0, Array())
End Sub
openoffice 4.1.14 on Arch Linux (Cinnamon desktop)
Nobody answered there (I've tried the mailing list too, without success). I could have deleted the post there but I thought it better not deleting it for future users...
openoffice 4.1.14 on Arch Linux (Cinnamon desktop)