You can enumerate those with:
There is a method EnumerateTypesTest. Notice that there is a
have note tested this, but, I could likely use the following two
And enumerate the constant types and print them. If I were
would dump them into a Calc document. I can think of lots of things
I have a method in the UNO module called EnumerateEnumeratsions,
given a name, will print the names and associated values.
On 2018-07-23 11:14, Johnny Rosenberg wrote:
I downloaded your OOME_4_0 document and I found it there. I was kind
hoping LibreOffice/Apache OpenOffice had its own constants so
mode hasn't to be used, but not much to do about that, I guess.
I already use a couple of constants when working with spreadsheets,
instance com.sun.star.sheet.CellFlags.VALUE and the others, but I
seen a list of all of those.
Thanks for replying.
2018-07-23 16:17 GMT+02:00 Andrew Pitonyak <firstname.lastname@example.org>:
I have not looked at the predefined constants in a while, and I do
remember how I got my list, but it was probably by reading the
WARNING: I am about to tell you to download a document containing
The document looks just fine if you tell it to disable macros, but,
it is a
document about macro programming and almost every one of those
contained in libraries in the document. So, feel free to not enable
but you will not be able to click on the buttons in the document to
run the contained macros.
Download OpenOffice.org Macros Explained V4 (or just click on this
Open the document and search for the text "vbNewLine". This should
you in table 10 Visual Basic-compatible string constants. This
9 of this type of constant, but, they are only available if you
"compatibility mode" using "Option Compatible" in the module, or,
calling CompatibilityMode(True) in your code before you use these
And no, I do not have an exhaustive list of defined constants. The
constants defined by the UNO object model, you can obtain using a
but I do not think that it is directly related to your question so
not spend time finding the code that does that; but it is in the
And yes, Pi is a defined constant in LO Basic.
Hope this helped at least a little.
On 2018-07-22 16:26, Johnny Rosenberg wrote:
I have done some searching and finally I found this at
”OpenOffice.org Basic predefines several constants. Among the
- True and False, for Boolean assignment statements
- PI as a type Double numeric value”
I assume this is true for LibreOffice as well, but I can't find
the ”several constants”.
At work a use Excel (I don't really want to and it's full of bugs,
least I get paid…) and I wrote some macros in VBA. VBA has a lot
predefined constants, for instance vbNewLine and a lot more, and
trying to find out what constants are available in LibreOffice
LibreOffice is what I use exclusively at home, so I don't have to
So a link to a list of ALL predefined Basic constants would be
To unsubscribe e-mail to: email@example.com
Posting guidelines + more:
List archive: https://listarchives.libreoffice.org/global/users/