Problem with invocation of Java Addin method from Calc

Ted · Newbie Joined: 01 Oct 2004 Posts: 1

I have succesfuly built Calc Add-In using Java. The function i have added shows up properly in the AutoPilot Functions dialog.

The problem is that the function return nothing ;( When i use it as Formula, i have this: #VALUE! in cell.

When i use it in a Basic Macros, i got an error message:

DannyB · Posted: Fri Oct 01, 2004 5:37 am Post subject:

I have recently managed to build Calc add in's in Java.
http://www.oooforum.org/forum/viewtopic.php?t=12589
http://www.oooforum.org/forum/viewtopic.php?t=12537
I have not yet posted source code. If necessary, I can send you some. I am using NetBeans.org version 3.6.

One thing I see wrong in what you describe.

DannyB · Posted: Fri Oct 01, 2004 5:53 am Post subject:

Just for your amusement, here is additional source code to the above example. No elaboration or explanation provided.

I use the XCommand interface for debugging. So don't pay too much attention to that one. The purpose of XCommand is so that from Basic, I can do stuff like...

Arkas · Posted: Tue Oct 05, 2004 8:07 am Post subject:

Hi Danny,

at first, thx for that detailed post in this thread. it helped me for an better understanding of the uno-java-combination and save much time, i hope.

but i have some problems to get our files installed and running respectively.

so i need some help. could you take a look???

i made an project-structure where i saved your posted code and an ant build-file which does nearly the same as your batch files.

you only have to edit the file openoffice.properties on top-level and call "ant"

Sorry i have to remove the the link, post another soon

i hope you or someone else could help me

thanks a lot

Jan

DannyB · Posted: Tue Oct 05, 2004 11:51 am Post subject:

Right now, I use NetBeans 3.6.

I was not planning to learn Ant until NetBeans 4 comes out. About December (although they do not specify which year).

If I get a chance I'll take a look.

Really, all I'm doing to build an add in is....
1. compiling the source I gave you -- into a Jar, with a manifest.
2. compiling the IDL's into RDB files (using various batch files to invoke the necessary command line tools)
3. Zip up the jar and the rdb files.
4. Put into "user/uno_components", and run pkgchk.
_________________
Want to make OOo Drawings like the colored flower design to the left?

r_apodaca · General User Joined: 15 Sep 2004 Posts: 34

Hello Arkas,

I had a go at using your ant project setup. Yours is actually the first use of ant to build an OOo Java project, so thanks for putting this together. Here is my experience with it.

After customizing openoffice.properties and build.xml for my system (Linux), I ran ant. I got the following error several times whenever the sdk tools were accessed:

error while loading shared libraries: libsal.so.3: cannot open shared object file: No such file or directory

So I ran my setsdkenv_unix script and then ran ant again. Ant finished with only one error that I could find:

Arkas · Posted: Tue Oct 05, 2004 11:45 pm Post subject:

you catche me red-handed Smile

I forgot to say that mechanism of moving and installing the zip isn't finished,yet, but is in work Smile

I also tested it only on a windows machine, but if you are interessted in my ant project, im going to test it on a unix/linux machine.

error about the shared libraries, is also caused by this problem. i'm going to solve this problem.

about the waring of cpp: the file idli_sMfulV is an temprarry created file of idlc, i got the same but i think its no problem for running.

i would proud if somebody could help with the warning while register the addin.

I try to make an new fixed version until end of week

DannyB · Posted: Wed Oct 06, 2004 7:21 am Post subject:

r_apodaca · General User Joined: 15 Sep 2004 Posts: 34

Thanks to the DannysCalcFunctions1.uno.zip file in the last post, I was able to pinpoint the problem with the ant project build.

The problem is with the MANIFEST.MF file that gets created by ant and which gets incorporated into CalcFunc.jar. The default manifest is getting created by ant, which just isn't good enough for OOo. Cool

So here is what I did to get it to work:

(1) use ant to build the project

(2) unzip CalcFunc.zip in the build directory

(3) unjar the CalcFunc.jar file in the folder containing the expanded CalcFunc.zip

(4) re-jar the CalcFunc.jar using the MANIFEST.MF contained in the file in Danny's last post:

r_apodaca · General User Joined: 15 Sep 2004 Posts: 34

I now have a build.xml file that seems to work. Here is my build.xml file:

r_apodaca · General User Joined: 15 Sep 2004 Posts: 34

One more thing. The build.xml above is for Linux. To make it work under Windows, ".exe" must be appended to the OOo binary tool paths, ie javamaker becomes javamaker.exe, etc.

build.xml should probably read the OS type from a config file, then use the appropriate versions of the binary build tools.

Arkas · Posted: Thu Oct 07, 2004 1:20 am Post subject:

thx for all this help.

now it works fine. i try to create an zip with an useful poroject structure and support for windows and linux.

if there are wishes or proposals post them in this thread.

r_apodaca · General User Joined: 15 Sep 2004 Posts: 34

Here's another thing I found out.

The above build.xml still requires that the setsdkenv script be run prior to running ant. I was able to pinpoint the environment variable that needs to be set. So using the <env key> tag and setting the "LD_LIBRARY_PATH" environment variable for the targets invoking the SDK binary tools fixes the problem. For example:

Arkas · Posted: Wed Oct 20, 2004 6:21 am Post subject:

I spend some time to warp the executables into an tasks.

the whole project (src, jar, docs) is avalible at

http://www2.fht-esslingen.de/~jafuit00/openoffice-ant.zip

@r_apodaca:

with this tasks you can select mor than one *.idl file without a specific name. the idl-files also could be in different directories.

at this time it es only tested on windows machines. i will be glad if somebody test it on a linux system and give me some response.

arkaz

John Harrison · Newbie Joined: 06 Dec 2004 Posts: 1

Hi All,

Thanks for the good information! I'm actually developing an ant script for building/testing
uno components using cpp. I've implemented some of the approaches above (e.g):

<target name="idl" if="idl.file" >
<basename property="componentname" file="${idl.file}" suffix=".idl"/>
<echo message="Execute command: ${openoffice.sdk.bin.dir}/idlc -I${openoffice.sdk.dir}/idl -I${basedir}/${componentname} -I${basedir} -O.. ${basedir}/${componentname}/${idl.file}" />
<echo message=""/>
<exec executable="${openoffice.sdk.bin.dir}/idlc" outputproperty="idl.out" dir="${basedir}/${componentname}/Main">
<arg value="-I${openoffice.sdk.dir}/idl" />
<arg value="-I${basedir}/${componentname}" />
<arg value="-I${basedir}" />
<arg value="-O.." />
<arg value="${basedir}/${componentname}/${idl.file}" />
</exec>
</target>

<target name="regmerge" if="idl.file" depends="idl">
<basename property="componentname" file="${idl.file}" suffix=".idl"/>
<echo message="Execute command: rm -f ${componentname}.rdb" />
<echo message=""/>
<exec executable="rm" dir="${basedir}/${componentname}/Main">
<arg value="-f" />
<arg value="${componentname}.rdb"/>
</exec>
<echo message="Execute command: rm -rf ./geninc" />
<echo message=""/>
<exec executable="rm" dir="${basedir}/${componentname}/Main">
<arg value="-rf" />
<arg value="./geninc"/>
</exec>
<echo message="Execute command: ${openoffice.sdk.bin.dir}/regmerge ${componentname}.rdb /UCR ../${componentname}.urd" />
<echo message=""/>
<exec executable="${openoffice.sdk.bin.dir}/regmerge" outputproperty="regmerge.out" dir="${basedir}/${componentname}/Main">
<arg value="./${componentname}.rdb"/>
<arg value="/UCR" />
<arg value="../${componentname}.urd"/>
</exec>
<echo message="Execute command: ${openoffice.sdk.bin.dir}/regmerge ${componentname}.rdb / /usr/local/OpenOffice.org1.1.2/program/types.rdb" />
<echo message=""/>
<exec executable="${openoffice.sdk.bin.dir}/regmerge" outputproperty="regmerge.out" dir="${basedir}/${componentname}/Main">
<arg value="./${componentname}.rdb"/>
<arg value="/"/>
<arg value="/usr/local/OpenOffice.org1.1.2/program/types.rdb"/>
</exec>
</target>

<target name="cppumaker" if="idl.file" depends="regmerge" >
<basename property="componentname" file="${idl.file}" suffix=".idl"/>
<exec executable="${openoffice.sdk.bin.dir}/xml2cmp" outputproperty="xml2cmp.out" dir="${basedir}/${componentname}/Main">
<arg value="-types" />
<arg value="stdout" />
<arg value="${componentname}.xml" />
</exec>
<propertyregex property="mxml2cmp.out"
input="${xml2cmp.out}"
regexp=" "
replace=" -T"
global="true" />
<echo message="Execute command: cppumaker -Gc -BUCR -O./geninc ${mxml2cmp.out} ${componentname}.rdb" />
<echo message=""/>
<exec executable="cppumaker" outputproperty="cppumaker.out" dir="${basedir}/${componentname}/Main">
<arg value="-Gc" />
<arg value="-BUCR" />
<arg value="-O./geninc" />
<arg value="${mxml2cmp.out}" />
<arg value="./${componentname}.rdb" />
</exec>
</target>

Everything appears to be correct syntactically. However, I currently receive the
following response from cppumaker:

/usr/office/sdk110/OpenOffice.org1.1_SDK/linux/bin/ccpumaker : init registries failed,
check your registry files.

Result: 99

Does anyone have any ideas/suggestions on this?

Thanks

John