OpenOffice NetBeans Integration
The intention of the StarOffice/OpenOffice.org NetBeans Integration is to simplify the development of office extensions. StarOffice/OpenOffice.org offers an API to program with or for the office and allows to automate tasks even remote or in process and allows to extend the office with completely new functionality. The NetBeans integration should simplify the access and usage of the API in new projects and should simplify the task of creating complete office extension packages (comparable to NetBeans plugin modules).
The focus is on creating new wizards for various tasks plus common basic functionality. The main programming language is Java but the support of C++ is also planned and depends on the C++ support in NetBeans which will be available at least for NetBeans 6.0. The planned feature list is not final and probably more specialized wizards for other service provider interfaces (SPI) are coming in the future.
New Project Types
- OpenOffice.org Client Application Project Type
This project type will create an adapted J2SE client application project with additional support of the simple UNO bootstrap feature. Means an adapted manifest file to support the bootstrap feature and bundling of some precompiled bootstrap glue code with the client application jar.
- OpenOffice.org Calc Add-In Project Type
This new project type will create an adapted J2SE class library project with special support for an UNO component library and an office extension package. The wizard will collect necessary information for new Calc built-in functions and abstracts from the underlying UNO technology.
- General UNO Component Project Type
This new project type will create an adapted J2SE class library project with special support for an UNO component library and an office extension package. The wizard will collect information about services and additional optional interfaces which should be implemented and will generate a complete code skeleton with already implemented component helper functions and default implemented interface methods.
- OpenOffice.org Add-On Project Type
This new project type will create an adapted J2SE class library project with special support for an UNO component library and an office extension package. The wizard will collect necessary information for an office Add-On component and will generate an Add-On specific code skeleton.
- OpenOffice.org Scripting Project Type
This new project type will create an adapted J2SE class library project with special support for office scripting. It should provide the possibility to import scripts from the office and open documents, edit, change and build these scripts, debug them and export them back (currently the support is planned for Java scripts only).
- OpenOffice.org API Library API Wrapper Project Type
This new project type should create a Library Wrapper Module to support simply usage of the office API in own projects. It bundles the necessary API jar files from the office in the library and in client applications. This of course is necessary to make use of the office API in clients running on machines where no office is installed and where the communication with the office is made over a remote socket connection.
- UNOIDL Support
Means support of a new file type for UNOIDL files, including compiling, UNOIDL editor with syntax highlighting. A wizard for defining new UNOIDL types should be supported as well.
- Debug Support
Means debug support directly from NetBeans for new built and deployed extensions in the office process as well as the debugging of scripts in the office.
- Support of office extension package
This have to be defined in detail but it should at least support the browsing of a .oxt file in the NetBeans file system similar to jar|zip files.
- File type for xcu files
This have to be defined in detail but we can think of a special editor for office configuration files.
The current preview (version 0.7) supports four project types, one client application wizard, a Calc Add-In wizard, a wizard for general UNO components and a simple Add-on wizard. The Calc Add-In allows the definition of new Calc build-in functions for the spreadsheet application which can be directly used from the build-in functions wizard. The user don't need any knowledge of the underlying UNO technology and can define new functions on a higher level. The general UNO component wizard requires some more UNO base knowledge but simplify the initial creation of a new component enormously. The Add-on wizard supports currently the definition of new top-level menus and generates the appropriate code skeleton and the necessary config files. The generated project can be used as a start point to extend it to a more coomplex Add-on.
Once you have installed the plugin manually you will be able to easy update to future releases by using the integrated Update Center in NetBeans. The plugin comes with it's own OpenOffice.org Preview Updated Center where we will provide future previews.
The plugin org-openoffice-extensions.nbm works only in combination with an installed StarOffice/OpenOffice.org installation and an appropriate StarOffice/OpenOffice.org Software Development Kit (SDK).
- org-openoffice-extensions.nbm - the plugin module
- OpenOffice.org 2.0.4 or StarOffice 8 Product Update 4 or higher versions of both programs
- OpenOffice.org Software Development Kit (SDK) 2.0.4 or a higher version
For the Add-on wizard you require the latest version of the uno-skeletonmaker (comes with OpenOffice.org SDK 2.2.0) and you can download a precompiled binary from the file section of the API project (Linux-x86, Solaris-Sparc, Solaris-x86, Windows)
The current version of the NetBeas plugin is a first preview and has to be installed manually as a normal NetBeans plugin over the “Update Center” in NetBeans. The manual installation is only necessary the first time and then you can use the integrated OpenOffice.org Preview Update Center. Simply choose
- NetBeans -> Tools -> Update Center -> Install Manually Downloaded Modules (.nbm Files)
select the downloaded module and follow the wizard to install it.
Before you can use the new project types you have to configure the plugin because it needs an installed office and SDK installation.
The current version of the plugin ask during the installation for an office and SDK installation but you also configure or change both programs later. But note that if you change the office or SDK installation these changes are effective for new created projects only. This will be changed in the future and you will be asked if you want accept these changes for existing projects also.
For changing the office and SDK installation please choose
- Tools -> Options -> Miscellaneous -> StarOffice/OpenOffice.org Extensions
and select a valid office and SDK installation.
The configuration step installs automatically a new office library which can be used in other projects directly to support the office API. Including this library in own projects enables context sensitive help and code completion automatically.
Working with new Project Types
The plugin integrates four new project types under the category StarOffice/OpenOffice.org:
- StarOffice/OpenOffice.org Calc Add-On
- StarOffice/OpenOffice.org Calc Add-Ins
- StarOffice/OpenOffice.org Client Application
- StarOffice/OpenOffice.org Component
The wizards will collect the necessary information to create the new projects and should follow the NetBeans philosophy. You can simply choose
- File -> New Project -> StarOffice/OpenOffice.org -> <project_type>
For more details about the project types please take a look to
- OpenOffice.org UNO Client Application Project Type
- OpenOffice.org Calc Add-In Project Type
- OpenOffice.org Component Project Type
- OpenOffice.org Add-On Project Type
Known Problems and Missing Features
- context sensitive help doesn't work on Linux (Solaris not yet tested), even the javadoc generated Java UNO runtime reference documentation doesn't work on Linux. Under Windows both work as expected.
- the integrated update center module doesn't work on Unix systems (known bug 72960 in NetBeans which is fixed in NetBeasn 6.0). Workaround is to install NetBeans locally where you have write access.
- the backward compatibility mode for Calc Add-Ins creates still an .oxt extension package. This of course makes no sense for older office versions because this file extension is introduced in OO.org 2.0.4 first. Please simply rename it to .uno.pkg
- projects are currently not platform independent. If you want to build a project on a different platfrom you have to adapt the <projectname>/nbproject/project-uno.properties file by hand.
If you find bugs please submit a new issue in the category sdk and the subcomponent netbeans-integration
Things to be done
This is a preview only and the whole stuff is under development and needs to be improved. Feedback is welcome and highly appreciated and we would like to invite you to discuss it on firstname.lastname@example.org (Note: you have to be subscribed on the mailing list).