OpenOffice NetBeans Integration

From Apache OpenOffice Wiki
Revision as of 11:20, 3 January 2007 by Sg (Talk | contribs)

Jump to: navigation, search


The intention of the StarOffice/ NetBeans Integration is to simplify the development of office extensions. StarOffice/ 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. 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

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

New Preview

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 Preview Updated Center where we will provide future previews.


The plugin org-openoffice-extensions.nbm works only in combination with an installed StarOffice/ installation and an appropriate StarOffice/ Software Development Kit (SDK).

For the Add-on wizard you require the latest version of the uno-skeletonmaker (comes with 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 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/ Extensions

and select a valid office and SDK installation.

OpenOffice Extensions Plugin Options.png

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/

  • StarOffice/ Calc Add-On
  • StarOffice/ Calc Add-Ins
  • StarOffice/ Client Application
  • StarOffice/ 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/ -> <project_type>

For more details about the project types please take a look to

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 2.0.4 first. Please simply rename it to .uno.pkg

Quality Assurance


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

Personal tools