About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

classic Classic list List threaded Threaded
15 messages Options
minhsien0330 minhsien0330
Reply | Threaded
Open this post in threaded view
|

About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Hi~,
I am getting start with writing some Macro for Forms in Libreoffice Base,
I read some tutorials and guidelines, but I still don't know how do I get
the name, properties and actions of Objects ?
Would you tell me any information about this?

e.g.:
I have a table in Form1 (Libreoffice Base).
What's the object name of the table?
What actions can be done for this table?

Thank you!

Best Regards,
Minhsien0330

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Am 28.04.2015 um 10:18 schrieb minhsien0330:

> Hi~,
> I am getting start with writing some Macro for Forms in Libreoffice Base,
> I read some tutorials and guidelines, but I still don't know how do I get
> the name, properties and actions of Objects ?
> Would you tell me any information about this?
>
> e.g.:
> I have a table in Form1 (Libreoffice Base).
> What's the object name of the table?
> What actions can be done for this table?
>
> Thank you!
>
> Best Regards,
> Minhsien0330
>

Hi,

[Tutorial] Introduction into object inspection with MRI
> https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=49294

And of course you need to understand the architecture of services,
interfaces and language independent data types.
This is not for people who can not program anything beyond stolen VBA
snippets.  One advantage is that you are not limited to this awkward
Basic lingo of the early 90ies.



--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
pietervo pietervo
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Andreas Säger wrote:

 > Am 28.04.2015 um 10:18 schrieb minhsien0330:
 > > Hi~,
 > > I am getting start with writing some Macro for Forms in Libreoffice Base,
 > > I read some tutorials and guidelines, but I still don't know how do I get
 > > the name, properties and actions of Objects ?
 > > Would you tell me any information about this?
 > >
 > > e.g.:
 > > I have a table in Form1 (Libreoffice Base).
 > > What's the object name of the table?
 > > What actions can be done for this table?
 > >
 > > Thank you!
 > >
 > > Best Regards,
 > > Minhsien0330
 > >
 >
 > Hi,
 >
 > [Tutorial] Introduction into object inspection with MRI
 > > https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=49294
 >
 > And of course you need to understand the architecture of services,
 > interfaces and language independent data types.
 > This is not for people who can not program anything beyond stolen VBA
 > snippets.  One advantage is that you are not limited to this awkward
 > Basic lingo of the early 90ies.
 >
I can second that about MRI. I think it is invaluable. But if you want to do serious programming you also need the developer's guide (https://wiki.openoffice.org/w/images/d/d9/DevelopersGuide_OOo3.1.0.pdf)
It is huge but you can find valuable information there about all the internals. The code examples are in Java, however.
The document is a bit old, but I don't think much has changed. It is basically the same as the website (https://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide).
Then for Database access you can use Andrew Pitonyak's AndrewBase document that you can download from http://www.pitonyak.org/database/. It has examples of accessing Forms, and it uses Basic.
--
Piet van Oostrum <[hidden email]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Mark LaPierre Mark LaPierre
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Andreas Säger
On 04/28/15 04:37, Andreas Säger wrote:

> Am 28.04.2015 um 10:18 schrieb minhsien0330:
>> Hi~,
>> I am getting start with writing some Macro for Forms in Libreoffice Base,
>> I read some tutorials and guidelines, but I still don't know how do I get
>> the name, properties and actions of Objects ?
>> Would you tell me any information about this?
>>
>> e.g.:
>> I have a table in Form1 (Libreoffice Base).
>> What's the object name of the table?
>> What actions can be done for this table?
>>
>> Thank you!
>>
>> Best Regards,
>> Minhsien0330
>>
>
> Hi,
>
> [Tutorial] Introduction into object inspection with MRI
>> https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=49294
>
> And of course you need to understand the architecture of services,
> interfaces and language independent data types.
> This is not for people who can not program anything beyond stolen VBA
> snippets.  One advantage is that you are not limited to this awkward
> Basic lingo of the early 90ies.
>

I followed the link above.  It took me to a download page for MRI 1.2.4
which fails to install even though it says right under the download link
that it is compatible with LO 4.

I started Libreoffice as root user then used the menu option Tools =>
Extension Manager which opens the Extension Manager window.  I clicked
the [Add] button and navigated to the file MRI 1.2.4.  Again, it fails
to install.

(soffice:11595): Gtk-WARNING **: Attempting to store changes into
`/root/.local/share/recently-used.xbel', but failed: Failed to create
file '/root/.local/share/recently-used.xbel.74D5XX': No such file or
directory

(soffice:11595): Gtk-WARNING **: Attempting to set the permissions of
`/root/.local/share/recently-used.xbel', but failed: No such file or
directory

It appears to have installed as a User extension, not a system
extension, not that it matters since it seems to not work.  If I right
click on the extension in the Extension Manager window and select
"Update" from the drop down then version 1.2.5 is displayed as an
update.  When I click to accept the update it fails to download.

At the bottom of the window there is a hyperlink "Get more extensions
online..." which brings me to http://extensions.libreoffice.org/.  There
I click on the "Extensions" tab.  There I type "MRI" in the text box
next to the [Search] button.  I click the [Search] button.  the MRI-UNO
Object Inspection Tool is found.  It says the latest release is
compatible with LibreOffice 3.3, 3.4, and 3.5.  I have 4.0.4.2. :-(


--
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Manfred BERTL Manfred BERTL
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Am 29.04.2015 um 02:38 schrieb Mark LaPierre:
> On 04/28/15 04:37, Andreas Säger wrote:

>
> I followed the link above.  It took me to a download page for MRI 1.2.4
> which fails to install even though it says right under the download link
> that it is compatible with LO 4.
>
> [...many lines deleted...]
> compatible with LibreOffice 3.3, 3.4, and 3.5.  I have 4.0.4.2. :-(
>

I have MRI Version 1.2.4 successfully installed on LO 4.3.6.2 on CentOS7 64Bit,
and it works fine.

regards,
fred
--
_____________________________________________________
EDV-Systemberatung * Planung * Installation * Support
     Manfred BERTL, D-83451 Piding, Wiesenweg 16
         Homepage at http://www.edv-bertl.de
Tel.: +43-676-89692622    mailto:[hidden email]



--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Am 29.04.2015 um 09:10 schrieb Manfred Bertl:

> Am 29.04.2015 um 02:38 schrieb Mark LaPierre:
>> On 04/28/15 04:37, Andreas Säger wrote:
>
>>
>> I followed the link above.  It took me to a download page for MRI 1.2.4
>> which fails to install even though it says right under the download link
>> that it is compatible with LO 4.
>>
>> [...many lines deleted...]
>> compatible with LibreOffice 3.3, 3.4, and 3.5.  I have 4.0.4.2. :-(
>>
>
> I have MRI Version 1.2.4 successfully installed on LO 4.3.6.2 on CentOS7 64Bit,
> and it works fine.
>
> regards,
> fred
>

There is one minor problem, though. The [IDL Ref] button leads to
nowhere. In OpenOffice it takes you to the online object reference for
the current item.
LibreOffice changed the whole structure of the IDL reference so you need
to look up your items manually or point it to the OpenOffice reference
keeping in mind that there may be some differences.


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
pietervo pietervo
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Manfred BERTL
Manfred Bertl wrote:

 > Am 29.04.2015 um 02:38 schrieb Mark LaPierre:
 > > On 04/28/15 04:37, Andreas Säger wrote:
 >
 > >
 > > I followed the link above.  It took me to a download page for MRI 1.2.4
 > > which fails to install even though it says right under the download link
 > > that it is compatible with LO 4.
 > >
 > > [...many lines deleted...]
 > > compatible with LibreOffice 3.3, 3.4, and 3.5.  I have 4.0.4.2. :-(
 > >
 >
 > I have MRI Version 1.2.4 successfully installed on LO 4.3.6.2 on CentOS7 64Bit,
 > and it works fine.

I installed 1.2.5 from Github (https://raw.githubusercontent.com/hanya/MRI/master/files/MRI-1.2.5.oxt) on LO 4.4.3.1 and on master, on Mac OS X 10.10.3 (Yosemite) for all users with sudo unopkg, without problems. But if I remember correctly, I first did a user install, just with Tools > Extension Manager, selecting the downloaded file, also without problems.
--
Piet van Oostrum <[hidden email]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Mark LaPierre
Am 29.04.2015 um 02:38 schrieb Mark LaPierre:

> (soffice:11595): Gtk-WARNING **: Attempting to store changes into
> `/root/.local/share/recently-used.xbel', but failed: Failed to create
> file '/root/.local/share/recently-used.xbel.74D5XX': No such file or
> directory
>
> (soffice:11595): Gtk-WARNING **: Attempting to set the permissions of
> `/root/.local/share/recently-used.xbel', but failed: No such file or
> directory
>

/root ???


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Alex Thurgood Alex Thurgood
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Mark LaPierre
Le 29/04/2015 02:38, Mark LaPierre a écrit :

Hi,

> I followed the link above.  It took me to a download page for MRI 1.2.4
> which fails to install even though it says right under the download link
> that it is compatible with LO 4.
>
> I started Libreoffice as root user then used the menu option Tools =>
> Extension Manager which opens the Extension Manager window.  I clicked
> the [Add] button and navigated to the file MRI 1.2.4.  Again, it fails
> to install.

>From memory, you shouldn't need to be root to install the extension, it
should install just fine as a normal user extension.


Alex



--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Mark LaPierre Mark LaPierre
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Andreas Säger
On 04/29/15 05:20, Andreas Säger wrote:

> Am 29.04.2015 um 02:38 schrieb Mark LaPierre:
>
>> (soffice:11595): Gtk-WARNING **: Attempting to store changes into
>> `/root/.local/share/recently-used.xbel', but failed: Failed to create
>> file '/root/.local/share/recently-used.xbel.74D5XX': No such file or
>> directory
>>
>> (soffice:11595): Gtk-WARNING **: Attempting to set the permissions of
>> `/root/.local/share/recently-used.xbel', but failed: No such file or
>> directory
>>
>
> /root ???
>
>

Yup, root.  I was trying to install it as a system wide extension.  That
would take root powers.

Maybe I need a little hand holding.  I RTFM and followed the
instructions but no soap.  Can any of you who were successful tell me
how you got it installed for Libreoffice 4 as a system wide extension?

--
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Mark LaPierre Mark LaPierre
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Alex Thurgood
On 04/30/15 02:19, Alex Thurgood wrote:

> Le 29/04/2015 02:38, Mark LaPierre a écrit :
>
> Hi,
>
>> I followed the link above.  It took me to a download page for MRI 1.2.4
>> which fails to install even though it says right under the download link
>> that it is compatible with LO 4.
>>
>> I started Libreoffice as root user then used the menu option Tools =>
>> Extension Manager which opens the Extension Manager window.  I clicked
>> the [Add] button and navigated to the file MRI 1.2.4.  Again, it fails
>> to install.
>
>>From memory, you shouldn't need to be root to install the extension, it
> should install just fine as a normal user extension.
>
>
> Alex
>

That is probably true as that's pretty much what happened when I tried
to install it, even though it didn't work.  I want it to be a system
wide extension so I'm going to need root powers to do that some time.  I
have no clue how though.  Can someone leave me a bread crumb trail?


--
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Mark LaPierre
Am 04.05.2015 um 02:15 schrieb Mark LaPierre:

> On 04/29/15 05:20, Andreas Säger wrote:
>> Am 29.04.2015 um 02:38 schrieb Mark LaPierre:
>>
>>> (soffice:11595): Gtk-WARNING **: Attempting to store changes into
>>> `/root/.local/share/recently-used.xbel', but failed: Failed to create
>>> file '/root/.local/share/recently-used.xbel.74D5XX': No such file or
>>> directory
>>>
>>> (soffice:11595): Gtk-WARNING **: Attempting to set the permissions of
>>> `/root/.local/share/recently-used.xbel', but failed: No such file or
>>> directory
>>>
>>
>> /root ???
>>
>>
>
> Yup, root.  I was trying to install it as a system wide extension.  That
> would take root powers.
>
> Maybe I need a little hand holding.  I RTFM and followed the
> instructions but no soap.  Can any of you who were successful tell me
> how you got it installed for Libreoffice 4 as a system wide extension?
>

$ cd $LO_PATH/program
$ ./unopkg --help

Under Ubuntu you can run the following to start the graphical extension
manager with root permissions:
$ sudo ./unopkg gui


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

Am 04.05.2015 um 09:12 schrieb Andreas Säger:
> $ sudo ./unopkg gui
>
>


NOOOO. DO NOT RUN THAT!
Now I can not start the program anymore. I get a (translated) error
message when starting LO:
"Application can not start. The user-defined installation could not be
finished."
Solutions anyone?


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
pietervo pietervo
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Mark LaPierre
Mark LaPierre wrote:

 > Yup, root.  I was trying to install it as a system wide extension.  That
 > would take root powers.
 >
 > Maybe I need a little hand holding.  I RTFM and followed the
 > instructions but no soap.  Can any of you who were successful tell me
 > how you got it installed for Libreoffice 4 as a system wide extension?

I did it on Mac OS X with
sudo /Applications/LibreOffice.app/Contents/MacOS/unopkg

On other systems you would have to locate unopkg, but for the rest it should be the same.

You can use unopkg add, or (as I did if I remember correctly) unopkg gui.
For help give unopkg --help

The difference between sudo and running as root is that with sudo you get root privileges, but you are still running in the user's environment.

--
Piet van Oostrum <[hidden email]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

In reply to this post by Andreas Säger
Am 04.05.2015 um 09:23 schrieb Andreas Säger:

> Am 04.05.2015 um 09:12 schrieb Andreas Säger:
>> $ sudo ./unopkg gui
>>
>>
>
>
> NOOOO. DO NOT RUN THAT!
> Now I can not start the program anymore. I get a (translated) error
> message when starting LO:
> "Application can not start. The user-defined installation could not be
> finished."
> Solutions anyone?
>
>

Restored my user profile from yesterday's backup.


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted