Difference between revisions of "API/Samples/Java/CalcAddin"

From Apache OpenOffice Wiki
< API‎ | Samples‎ | Java
Jump to: navigation, search
Line 14: Line 14:
 
<BR>
 
<BR>
 
Select 'File'->'New Project' to bring up the following dialog, then select 'OpenOffice.org Calc Add-in' project type in 'OpenOffice.org' Categories, click 'Next' button to proceed to next step.<BR><BR>
 
Select 'File'->'New Project' to bring up the following dialog, then select 'OpenOffice.org Calc Add-in' project type in 'OpenOffice.org' Categories, click 'Next' button to proceed to next step.<BR><BR>
[[Image:Example.jpg]]<BR>Figure 1, choose project type<BR><BR><BR>
+
[[Image:]]<BR>Figure 1, choose project type<BR><BR><BR>
  
 
=== Set project details ===
 
=== Set project details ===

Revision as of 08:30, 3 January 2008

Create Calc Addin


2008.01.03

Environment: Netbeans 5.5.1, OpenOffice.org and OpenOffice.org SDK, OpenOffice.org API plugin for Netbeans For installation instruction, please visit: [OpenOffice NetBeans Integration] This step-by-step illustration shows how to create the sdk example, CalcAddin by using OpenOffice.org API plugin in NetBeans.



Create a Calc Addin project by using OpenOffice.org API plugin


Select 'File'->'New Project' to bring up the following dialog, then select 'OpenOffice.org Calc Add-in' project type in 'OpenOffice.org' Categories, click 'Next' button to proceed to next step.

[[Image:]]
Figure 1, choose project type


Set project details


Set project name and Calc Add-in name as 'CalcAddin',assign this project to 'org.openoffice.sdk.example.Spreadsheet' package, chose the project location where the source code are stored, then click 'Next' to proceed to next step.

Example.jpg
Figure 2, Set project details

Check 'Create backward compatible Cacl Add-In' option to create extra backward compatible Calc Addin(*.xcs file).


Add functions and Parameters


Adding two function for this AddIn. [java,N] public int getMyFirstValue(

                     com.sun.star.beans.XPropertySet        xOptions)

public int getMySecondValue(

                     com.sun.star.beans.XPropertySet        xOptions,
                     int                                    intDummy)



GetMyFirstValue function configuration


  • Double click Function1 to expand function settings for the first function:

Example.jpg
Figure 3, The first function Name and its type

  • Set the first Function name as 'getMyFirstValue”
  • Set return Type as 'int'
  • Set Category as “Add-In'
  • Double click parameter0 to configure parameter settings

Example.jpg
Figure 4, The first function parameter

  • Set parameter name as 'xOptions', and set type as 'XpropertySet'

Finaly, the first function will be like the following figure:

Example.jpg
Figure 5, The first function setting

Add the second function – getMySecondValue method


  • click 'Add function' button at top right of dialog

Example.jpg
Figure 6, Add new function

  • setting function name as 'getMySecondValue'
  • click 'Add parameter' to add one more parameter for the second function

Example.jpg
Figure 7, Add new parameter

  • set parameter0's name as ' xOptions', set it's type as 'XpropertySet'
  • set parameter1's name as ' intDummy', set it's type as 'int'

Example.jpg
Figure 8, Configuration completed

  • Click Finish button to finish the wizards.

Now, the Calc Add-In project has been created. From project browser, it will be like the following figure: Example.jpg
Figure 9, Project Browser


Implement functions


To implement two functions specified previously, open CalcAddinImpl.java file from project browser and find the function bodies.

[java,N]

   // org.openoffice.sdk.example.Spreadsheet.XCalcAddin:
   public int getMyFirstValue(com.sun.star.beans.XPropertySet xOptions)
   {
       // TODO: Exchange the default return implementation for "getMyFirstValue" !!!
       // NOTE: Default initialized polymorphic structs can cause problems
       // because of missing default initialization of primitive types of
       // some C++ compilers or different Any initialization in Java and C++
       // polymorphic structs.
       return 0;
   }
   public int getMySecondValue(com.sun.star.beans.XPropertySet xOptions, int intDummy)
   {
       // TODO: Exchange the default return implementation for "getMySecondValue" !!!
       // NOTE: Default initialized polymorphic structs can cause problems
       // because of missing default initialization of primitive types of
       // some C++ compilers or different Any initialization in Java and C++
       // polymorphic structs.
       return 0;
   }

Figure 10. Original code
Modify a few lines of these two functions: [java,N]

   // org.openoffice.sdk.example.Spreadsheet.XCalcAddin:
   public int getMyFirstValue(com.sun.star.beans.XPropertySet xOptions)
   {
       // TODO: Exchange the default return implementation for "getMyFirstValue" !!!
       // NOTE: Default initialized polymorphic structs can cause problems
       // because of missing default initialization of primitive types of
       // some C++ compilers or different Any initialization in Java and C++
       // polymorphic structs.
       return (int) 1;
   }
   public int getMySecondValue(com.sun.star.beans.XPropertySet xOptions, int intDummy)
   {
       // TODO: Exchange the default return implementation for "getMySecondValue" !!!
       // NOTE: Default initialized polymorphic structs can cause problems
       // because of missing default initialization of primitive types of
       // some C++ compilers or different Any initialization in Java and C++
       // polymorphic structs.
       return ( (int) 2 + intDummy);
   }

Figure 11, Completed implementation

you may get error message on line 13 like 'cannot find symbol', ignore it. After the first build, the message will not not shown any more.

Example.jpg
Figure 12, Error message for XCalcAddin


Deploy and test CalcAddin


Deployement


Save all changes and 'clear and build' the project, then the addin can be deployed via right click the 'CalcAddin' in the project browser. Example.jpg
Figure 13, Delpoy the Addin

Extension manager dialog, the new addin is available to use now:
Example.jpg
Figure 14, Extension manager

In the function wizard (Ctrl+F2), these two function could be found in the 'Addin'
Example.jpg
Figure 15, Function Wizard

Testing


Go to the example folder'/CalcAddin/test/' to open the 'CalcAddins.ods' file to test these two functions. Example.jpg
Figure 16, Test Addins

Personal tools