Re: [api-dev] Problem with with NetBeans Plug-In
Hi, the way how the SDK is installed on Ubuntu is more or less the same idea i have in mind for the SDK in the future. On Ubuntu the SDK is installed in a sudirectory (/usr/lib/openoffice/sdk) under the office installation. My plan is to make the SDK an optional part of a normal office installation and put the necessary tools exactly in such a subdirectory. How this will look like exactly is not defined yet because the plan is also to remove some parts of the documentation (when the DevGuide is in the wiki) and make the examples optional, ... But the idea behind is to improve the usability in general, the installation and of course also the usage from external IDE's like NetBeans or Eclipse. A well defined place and structure makes the configuration much easier. Juergen Max Giesbert wrote: Hi Steffen, thx for the explanations. I posted a bug under http://www.openoffice.org/issues/show_bug.cgi?id=80183 I didn't know your username. So go and get it. It's all yours ;-) Thx Max Steffen Grund wrote: Hi Max, the problem is that Ubuntu inserts the wrapper scripts to call the sdk commands. Commands are renamed with extension .bin and the scripts take the place of the commnds. So the plugin calls the scripts with an environment which is customized for the commands. This environment does not contain a path to call basename, so it is simply not found and calling uno-skeletonmaker.bin fails because the name is not constructed correctly. Now that I know it, I can easily extend the plugin to be aware of this and work correctly on Ubuntu. Would you like to write me a bug for it? Regards, Steffen Max Giesbert wrote: CRITICAL # org.openoffice.extensions.util.ProjectCreator,line 486: /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker: 4: basename: not found /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker: 4: /usr/lib/openoffice/sdk/linux/bin/.bin: not found ---this happened with the Ubuntu SDK ---then i changed /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker from #!/bin/sh # wrapper script for OOos SDK programs LD_LIBRARY_PATH=/usr/lib/openoffice/program /usr/lib/openoffice/sdk/linux/bin/`basename $0`.bin $@ ---to #!/bin/sh # wrapper script for OOos SDK programs LD_LIBRARY_PATH=/usr/lib/openoffice/program /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker.bin $@ Maybe you can enlighten me what exactly went wrong in the first place because I don't really get it. Thx Max - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
Hi Simon, Simon B. Margulies wrote: thanks for your answers! I'm now looking into porting the existing vba-code to StarBasic and trying to get java working for future developments. the work on better VBA support is ongoing and probably usable for some simpler macros and maybe more complex things in the future. Anyway the API concept in OO.org is completely different than VBA. I would recommend to switch to StarBasic and or Java as soon as possible and go forward with OO.org API. You can also combine StarBasic for simple things with more complex features realized as add-on or whatever and implemented in Java. The advantage of Java is that you can use all the available Java API's as well and combine this way office functionality with interesting other stuff. Anyway you work with Eclipse but i think you should give our NetBeans plugin a try as well. It simplifies a lot of things and helps you to get started, see http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration for more details. Well Mac OS X is currently not supported but it is planned for the next version (planned for the beginning of September). Juergen thanks a lot simon On 30.07.2007, at 22:39, Andrew Douglas Pitonyak wrote: Simon B. Margulies wrote: Hi all, I'm still evaluating open office as the new solution for my parents tax software, which has been built in excel with some vba scripts. ... What do you think? Are there any developers using VBA in Open Office? Is VBA supported in openoffice for windows AND os x? Should all be ported to some other scripting language? I suspect that I do not properly understand what you are proposing. Are you proposing to continue using VBA and then use that to access OOo? This would not be very cross-platform compatible. Using Java should be, but it has a higher learning curve and you still need to learn the OOo API. Have you considered using StarBasic included with OOo? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [api-dev] Problem with with NetBeans Plug-In
You could also lend another idea from Eclipse, then... just write a small config file into a predefined OOo-subfolder that points to the location of the SDK. regards Alexander -Original Message- From: Juergen Schmidt [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 9:39 AM To: dev@api.openoffice.org Subject: Re: [api-dev] Problem with with NetBeans Plug-In Hi, the way how the SDK is installed on Ubuntu is more or less the same idea i have in mind for the SDK in the future. On Ubuntu the SDK is installed in a sudirectory (/usr/lib/openoffice/sdk) under the office installation. My plan is to make the SDK an optional part of a normal office installation and put the necessary tools exactly in such a subdirectory. How this will look like exactly is not defined yet because the plan is also to remove some parts of the documentation (when the DevGuide is in the wiki) and make the examples optional, ... But the idea behind is to improve the usability in general, the installation and of course also the usage from external IDE's like NetBeans or Eclipse. A well defined place and structure makes the configuration much easier. Juergen Max Giesbert wrote: Hi Steffen, thx for the explanations. I posted a bug under http://www.openoffice.org/issues/show_bug.cgi?id=80183 I didn't know your username. So go and get it. It's all yours ;-) Thx Max Steffen Grund wrote: Hi Max, the problem is that Ubuntu inserts the wrapper scripts to call the sdk commands. Commands are renamed with extension .bin and the scripts take the place of the commnds. So the plugin calls the scripts with an environment which is customized for the commands. This environment does not contain a path to call basename, so it is simply not found and calling uno-skeletonmaker.bin fails because the name is not constructed correctly. Now that I know it, I can easily extend the plugin to be aware of this and work correctly on Ubuntu. Would you like to write me a bug for it? Regards, Steffen Max Giesbert wrote: CRITICAL # org.openoffice.extensions.util.ProjectCreator,line 486: /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker: 4: basename: not found /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker: 4: /usr/lib/openoffice/sdk/linux/bin/.bin: not found ---this happened with the Ubuntu SDK ---then i changed /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker from #!/bin/sh # wrapper script for OOos SDK programs LD_LIBRARY_PATH=/usr/lib/openoffice/program /usr/lib/openoffice/sdk/linux/bin/`basename $0`.bin $@ ---to #!/bin/sh # wrapper script for OOos SDK programs LD_LIBRARY_PATH=/usr/lib/openoffice/program /usr/lib/openoffice/sdk/linux/bin/uno-skeletonmaker.bin $@ Maybe you can enlighten me what exactly went wrong in the first place because I don't really get it. Thx Max - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] problem removing XDispatchProviderInterceptor ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Carsten, ok, i will send it again ... did you get the source code ? Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGrv4eTiyrQM/QSkURAsm3AKCEcAjof+OGDrk1f4PgE0qo369bSQCffB5S oYRmriBo1zKIKzu1VItesG8= =xlBM -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-dev] Strange Problem with OOoBean 2.1.0, SuSE 9.2
Hi all, first of all, I apologize, because this does not seem to be a problem with OOo, but merely with the configuration of our linux system. Still, you might have a hint. We use the OOoBean within a Java application, connecting through a named pipe. When the connection is started OOo won't show in the Java frame. After some timeout an ConnectionException get's thrown and another soffice.bin process is getting started. The number of soffice.bin processes increases. This happens right before the second OSL_Pipe file is created in /tmp. The problem does not exist when I log in as root. So it obviously is some kind of user restriction that causes this - but other applications work. Even starting OOo as normal user is working. Is there anybody who might give an hint? Your help would be greatly appreciated Cheers Harald - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] problem removing XDispatchProviderInterceptor ...
Oliver Brinzing wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Carsten, ok, i will send it again ... did you get the source code ? Hi Oliver, Yes, I got your source code. Please give me some time as we are now short before code freeze (Thursday) and there are some important tasks to fix . I will give you feedback as soon as possible. Regards, Carsten - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
I started this a few years back (so it is dated and incomplete), but it might be useful. I think that on the hosting web page, there are better links, but I threw this up just because I had it sitting around. http://www.pitonyak.org/OOoBasicVBCompare.pdf Simon B. Margulies wrote: thanks for your answers! I'm now looking into porting the existing vba-code to StarBasic and trying to get java working for future developments. thanks a lot simon On 30.07.2007, at 22:39, Andrew Douglas Pitonyak wrote: Simon B. Margulies wrote: Hi all, I'm still evaluating open office as the new solution for my parents tax software, which has been built in excel with some vba scripts. ... What do you think? Are there any developers using VBA in Open Office? Is VBA supported in openoffice for windows AND os x? Should all be ported to some other scripting language? I suspect that I do not properly understand what you are proposing. Are you proposing to continue using VBA and then use that to access OOo? This would not be very cross-platform compatible. Using Java should be, but it has a higher learning curve and you still need to learn the OOo API. Have you considered using StarBasic included with OOo? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] problem removing XDispatchProviderInterceptor ...
Hello Oliver, I had a look on your example (because dispatch interception is more my area then Carsten ones). One question ... is the demo you sent the real application or a demo only ? The problem is that your main() method does the following one: a) bootstrap an office b) retrieving the UNO context from the office c) retrieving important UNO services (a'la Desktop, CurrentComponent etcpp) d) register the dispatch interceptor e) disable all macro-commands by returning NULL inside queryDispatch() f) leaving main g) terminating the JVM ! And thats exactly your problem. Nobody hold the client process alive. So you register some UNO listener inside the office, shutdown the JVM and all these listener are dead. Solution: Please make sure your demo application will wait for an event which indicates that all processes are finished. Or better: write an AddOn instead of a client application. Such AddOn is used inside the office process and lives till all UNO-Java objects are gone or the office process will be terminated explicitly. Best Regards Andreas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] problem removing XDispatchProviderInterceptor ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Andreas, One question ... is the demo you sent the real application or a demo only ? no, it's only a part of my addon, i use the remote connection sometimes for debugging purpose ... g) terminating the JVM ! And thats exactly your problem. Nobody hold the client process alive. So you register some UNO listener inside the office, shutdown the JVM and all these listener are dead. I just tried it with my addon again, and got the same result as before: register Interceptor setMasterDispatchProvider() setSlaveDispatchProvider() - - all macro:/// cmd's are disabled now ... i change to a different sheet, where my cmd's should be enabled (XActivationEventListener) ... now i see: unregisterInterceptor getSlaveDispatchProvider() getMasterDispatchProvider() setSlaveDispatchProvider() setMasterDispatchProvider( but all macro:/// cmd's stay disabled... :-) at this time and after the addon is still running ... I try to send you a demo addon, but this will take some time ... using oo 2.2.1 with vista business ... thanks Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGr1e+TiyrQM/QSkURApQhAKCk/l1kBlzgY5dE9q9vPYKJ/xsycwCgiQXA qdbdzg5dQmz6GJhQaQkBxQI= =Ptej -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-dev] how to do custom formula functions embedded in the document?
I belive some form of macro would be suitable for this job. The function has to fetch some xml from a remote url, the xml has to be parsed and the parameters for the url are sent as post data (as xml) I've failed to find apis for doing url fetching in basic. Python would be suitable for doing that (rich standard library, good docs) but, again, i've failed to find a way to use python functions as formula functions (basic functions are callable from a formula but, there is no obvious way to call some python functions from the basic macro) Any help is apreciated. -- http://ionel.zapto.org ionel.
Re: [api-dev] how to do custom formula functions embedded in the document?
Ionel Maries Cristian wrote: I belive some form of macro would be suitable for this job. The function has to fetch some xml from a remote url, the xml has to be parsed and the parameters for the url are sent as post data (as xml) I've failed to find apis for doing url fetching in basic. Python would be suitable for doing that (rich standard library, good docs) but, again, i've failed to find a way to use python functions as formula functions (basic functions are callable from a formula but, there is no obvious way to call some python functions from the basic macro) Any help is apreciated. Have you looked at any stock quote examples with Calc? They usually obtain a document from a URL of some sort and then parse it. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
