List of and elements

asked 2020-01-14 22:51:19 +0100

mrjjacobs gravatar image

updated 2020-01-14 22:54:03 +0100

Hello everyone,

I am quite stymied as why the subject of this thread turns up sweet-blow-all in the search results on the internet, except perhaps that I, an experienced GW-Basic,Thoroughbred Basic and Visual Basic programmer, am not understanding about how to use "" statements. Oh, that's totally possible, yes.

So I'm working with hints like

Sub J_FNFilePicker
    ' ---- From his Ref Card document about dialog controls
    Dim oFilePicker As Object
    Dim FileName As String

    FileName = ""
    'FilePicker initialization
    oFilePicker = CreateUnoService("")
    oFilePicker.DisplayDirectory = ConvertToURL("C:\Path\To\SomeDir")
    oFilePicker.appendFilter("Calc Documents", "*.ods")
    oFilePicker.CurrentFilter = "Calc Documents"
    oFilePicker.Title = "Select a Calc document"
    'execution and return check (OK?)
    If oFilePicker.execute = _ Then
            FileName = oFilePicker.Files(0)
    End If
End sub

And if there's isn't a list, I'm making one.

  1. I remember reading somewhere that they're case-sensitive.

I started with the following list drawn from Nifenecker’s RefCard #6, and then I found code in Pitonyak’s document that produced a lo-o-o-ong list of, which is, as yet, Martian to me.

SYNTAX: oFilePicker = CreateUnoService("")

' ==== CONTROLS ' ---- File selection dialog ' ---- Refined file selection dialog ' ---- Refined file selection dialog ' ---- Folder selection dialog ' ---- Refined folder selection dialog ' ---- Refined folder selection dialog
' ==== ' ---- e.g. vbOkonly, vbYesNoCancel (a guess)

et cetera

I could really use all the help I can get. I’m new here, and I’m new to these forums (so I’m just waiting to flamed by a mod because I’m posting this in the wrong place – sorry!) and it’s a bit demotivating to have been through some topics and lot of replies are wishy-washy, with very few “Yay it worked!” responses. My favourite was in the lines of “Is there, like, a beginner manual?” (like for me who at least knows what Option Base 1 means), and the reply was “No, there isn’t.” And that was the end of that… So my hopes aren’t really up there.

I’m actually trying to write a UI for a spreadsheet payroll system that I wrote. (Note please that I am not looking for anyone to suggest using LO Base or available payroll systems to me, this is a personal “Learn LO Basic” project.) I’ve got as far as creating a number of dialogs with text boxes and checkboxes and things, and task #next is to populate them with spreadsheet information and click NEXT / PREVIOUS buttons to just LOOK at the information and, oh, my sweet baby Apollo, I feel as dumb as a withered plant…

I’ve got this, and ... (more)

edit retag flag offensive close merge delete



Sorry but I got tired of reading through all this and decided maybe this will get you started:

Namespace List

Ratslinger gravatar imageRatslinger ( 2020-01-15 06:18:42 +0100 )edit

Thank you, I'm sure it will help. Opaque also replied with a useful looking similar. However, where are the controls?? I see a FRAME (useless as frames may be) and a FORM and a TEXT (which i doubt refers to a UNO). So there's basically ONE control type on the list: FRAME.

If anyone has anything other than "tl;dr" to say, I'm still here.


mrjjacobs gravatar imagemrjjacobs ( 2020-01-15 06:48:13 +0100 )edit


When there is an arrow to the left of the category there are sub categories. Click on the arrow to open and there, under 'Form' you will find 'Control'.

Ratslinger gravatar imageRatslinger ( 2020-01-15 18:31:25 +0100 )edit