OpenOffice NetBeans Integration

Overview

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).

Planned Features

The focus is on creating new wizards for various tasks plus common basic functionality. We focus primary on Java but the support of C++ is also planned and depends on the C++ support in NetBeans which is planned 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 comming 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 a 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.

Common Features

• 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.

Preview

The current preview supports three new project types, one client application wizard,a Calc Add-In wizard and a wizard for general UNO components. The Clac 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 intial creation of a new component enormously.
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.

Requirements

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
• OpenOffice.org Software Development Kit (SDK) 2.0.4

Installation

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.

Configuration

Before you can use the new project types you have to configure the plugin because it needs an installed 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 diectly 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 two new project types under the category StarOffice/OpenOffice.org:

• 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 or OpenOffice.org Component 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 Linux (known bug 72960 in NetBeans which is fixed in NetBeasn 6.0). Workaround is to install NetBeans locally where you have write access.
• syntax highlighting of UNOIDL files does work proper and needs to be improved

Feedback

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 dev@api.openoffice.org (Note: you have to be subscribed on the mailing list).