Re: [libreoffice-users] Predefinied constants (Macro, Basic)
Been there, done that. I noticed just as I was hitting send, or I would have redirected back to the list so that others could see the conversation. On 2018-07-23 16:52, Johnny Rosenberg wrote: Thank you, I'll have a look at it. Also sorry for accidentally mailing you directly, instead of the list. Kind regards Johnny Rosenberg 2018-07-23 19:15 GMT+02:00 Andrew Pitonyak : You can enumerate those with: theTypeDescriptionManager There is a method EnumerateTypesTest. Notice that there is a typeArray. I have note tested this, but, I could likely use the following two types com.sun.star.uno.TypeClass.CONSTANT, _ com.sun.star.uno.TypeClass.CONSTANTS And enumerate the constant types and print them. If I were industrious, I would dump them into a Calc document. I can think of lots of things that I could do. I have a method in the UNO module called EnumerateEnumeratsions, which, given a name, will print the names and associated values. On 2018-07-23 11:14, Johnny Rosenberg wrote: Thanks. I downloaded your OOME_4_0 document and I found it there. I was kind of hoping LibreOffice/Apache OpenOffice had its own constants so compatibility 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, for instance com.sun.star.sheet.CellFlags.VALUE and the others, but I haven't seen a list of all of those. Thanks for replying. Kind regards Johnny Rosenberg 2018-07-23 16:17 GMT+02:00 Andrew Pitonyak : I have not looked at the predefined constants in a while, and I do not remember how I got my list, but it was probably by reading the code. WARNING: I am about to tell you to download a document containing macros. 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 macros is contained in libraries in the document. So, feel free to not enable them, but you will not be able to click on the buttons in the document to test run the contained macros. Navigate here: http://www.pitonyak.org/oo.php Download OpenOffice.org Macros Explained V4 (or just click on this link) http://www.pitonyak.org/OOME_4_0.odt Open the document and search for the text "vbNewLine". This should land you in table 10 Visual Basic-compatible string constants. This table lists 9 of this type of constant, but, they are only available if you enable "compatibility mode" using "Option Compatible" in the module, or, by calling CompatibilityMode(True) in your code before you use these specific constants. 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 macro, but I do not think that it is directly related to your question so I will not spend time finding the code that does that; but it is in the document linked above. 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: Hi! I have done some searching and finally I found this at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: ”OpenOffice.org Basic predefines several constants. Among the most useful are: - 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 rest of the ”several constants”. At work a use Excel (I don't really want to and it's full of bugs, but at least I get paid…) and I wrote some macros in VBA. VBA has a lot of predefined constants, for instance vbNewLine and a lot more, and I'm now trying to find out what constants are available in LibreOffice Basic, since LibreOffice is what I use exclusively at home, so I don't have to reinvent the wheel. So a link to a list of ALL predefined Basic constants would be very appreciated. Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Predefinied constants (Macro, Basic)
Thank you, I'll have a look at it. Also sorry for accidentally mailing you directly, instead of the list. Kind regards Johnny Rosenberg 2018-07-23 19:15 GMT+02:00 Andrew Pitonyak : > > > You can enumerate those with: > > theTypeDescriptionManager > > > > There is a method EnumerateTypesTest. Notice that there is a typeArray. I > have note tested this, but, I could likely use the following two types > > > > com.sun.star.uno.TypeClass.CONSTANT, _ > > com.sun.star.uno.TypeClass.CONSTANTS > > > > And enumerate the constant types and print them. If I were industrious, I > would dump them into a Calc document. I can think of lots of things that I > could do. > > > > I have a method in the UNO module called EnumerateEnumeratsions, which, > given a name, will print the names and associated values. > > > > On 2018-07-23 11:14, Johnny Rosenberg wrote: > > Thanks. > > I downloaded your OOME_4_0 document and I found it there. I was kind of > hoping LibreOffice/Apache OpenOffice had its own constants so compatibility > 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, for > instance com.sun.star.sheet.CellFlags.VALUE and the others, but I haven't > seen a list of all of those. > > Thanks for replying. > > > Kind regards > > Johnny Rosenberg > > > 2018-07-23 16:17 GMT+02:00 Andrew Pitonyak : > >> >> I have not looked at the predefined constants in a while, and I do not >> remember how I got my list, but it was probably by reading the code. >> >> WARNING: I am about to tell you to download a document containing macros. >> 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 macros is >> contained in libraries in the document. So, feel free to not enable them, >> but you will not be able to click on the buttons in the document to test >> run the contained macros. >> >> Navigate here: >> http://www.pitonyak.org/oo.php >> >> Download OpenOffice.org Macros Explained V4 (or just click on this link) >> >> http://www.pitonyak.org/OOME_4_0.odt >> >> >> Open the document and search for the text "vbNewLine". This should land >> you in table 10 Visual Basic-compatible string constants. This table lists >> 9 of this type of constant, but, they are only available if you enable >> "compatibility mode" using "Option Compatible" in the module, or, by >> calling CompatibilityMode(True) in your code before you use these specific >> constants. >> >> 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 macro, >> but I do not think that it is directly related to your question so I will >> not spend time finding the code that does that; but it is in the document >> linked above. >> >> 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: >> >>> Hi! >>> >>> I have done some searching and finally I found this at >>> https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: >>> >>> ”OpenOffice.org Basic predefines several constants. Among the most useful >>> are: >>> >>>- 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 rest >>> of >>> the ”several constants”. >>> >>> At work a use Excel (I don't really want to and it's full of bugs, but at >>> least I get paid…) and I wrote some macros in VBA. VBA has a lot of >>> predefined constants, for instance vbNewLine and a lot more, and I'm now >>> trying to find out what constants are available in LibreOffice Basic, >>> since >>> LibreOffice is what I use exclusively at home, so I don't have to >>> reinvent >>> the wheel. >>> >>> So a link to a list of ALL predefined Basic constants would be very >>> appreciated. >>> >>> Kind regards >>> >>> Johnny Rosenberg >>> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to- >> unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Predefinied constants (Macro, Basic)
I have not looked at the predefined constants in a while, and I do not remember how I got my list, but it was probably by reading the code. WARNING: I am about to tell you to download a document containing macros. 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 macros is contained in libraries in the document. So, feel free to not enable them, but you will not be able to click on the buttons in the document to test run the contained macros. Navigate here: http://www.pitonyak.org/oo.php Download OpenOffice.org Macros Explained V4 (or just click on this link) http://www.pitonyak.org/OOME_4_0.odt Open the document and search for the text "vbNewLine". This should land you in table 10 Visual Basic-compatible string constants. This table lists 9 of this type of constant, but, they are only available if you enable "compatibility mode" using "Option Compatible" in the module, or, by calling CompatibilityMode(True) in your code before you use these specific constants. 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 macro, but I do not think that it is directly related to your question so I will not spend time finding the code that does that; but it is in the document linked above. 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: Hi! I have done some searching and finally I found this at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: ”OpenOffice.org Basic predefines several constants. Among the most useful are: - 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 rest of the ”several constants”. At work a use Excel (I don't really want to and it's full of bugs, but at least I get paid…) and I wrote some macros in VBA. VBA has a lot of predefined constants, for instance vbNewLine and a lot more, and I'm now trying to find out what constants are available in LibreOffice Basic, since LibreOffice is what I use exclusively at home, so I don't have to reinvent the wheel. So a link to a list of ALL predefined Basic constants would be very appreciated. Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Predefinied constants (Macro, Basic)
Howdy, To the best of my knowledge those are it. You would need to recreate those once and then include them in later projects. It's a common thing for folks to do, make their own include library with such. In fact you might want to look at the Access2Base library in the libreoffice distribution, I believe the author may have defined a number of constants (the whole library recreated VBA functions for use in LibreOffice), it may be that what you are looking for is already there you would simply need to load it at runtime. Not to mention you might find some others things there, coming from a VBA background, useful. Best wishes, Drew On Sun, Jul 22, 2018 at 4:26 PM Johnny Rosenberg wrote: > Hi! > > I have done some searching and finally I found this at > https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: > > ”OpenOffice.org Basic predefines several constants. Among the most useful > are: > >- 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 rest of > the ”several constants”. > > At work a use Excel (I don't really want to and it's full of bugs, but at > least I get paid…) and I wrote some macros in VBA. VBA has a lot of > predefined constants, for instance vbNewLine and a lot more, and I'm now > trying to find out what constants are available in LibreOffice Basic, since > LibreOffice is what I use exclusively at home, so I don't have to reinvent > the wheel. > > So a link to a list of ALL predefined Basic constants would be very > appreciated. > > Kind regards > > Johnny Rosenberg > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Predefinied constants (Macro, Basic)
Hi! I have done some searching and finally I found this at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants: ”OpenOffice.org Basic predefines several constants. Among the most useful are: - 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 rest of the ”several constants”. At work a use Excel (I don't really want to and it's full of bugs, but at least I get paid…) and I wrote some macros in VBA. VBA has a lot of predefined constants, for instance vbNewLine and a lot more, and I'm now trying to find out what constants are available in LibreOffice Basic, since LibreOffice is what I use exclusively at home, so I don't have to reinvent the wheel. So a link to a list of ALL predefined Basic constants would be very appreciated. Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy