OpenOffice temporary template

From CDOT Wiki
Revision as of 22:39, 27 June 2010 by Takasaki (talk | contribs) (OpenOffice Smart Tags)
Jump to: navigation, search


Introduction to OpenOffice Overview

Potential Projects



OpenOffice Extensions

What are extensions

Extensions in OpenOffice extends the capability of the OpenOffice program. Extension can be for OpenOffice Writer, Calc, Presentation, Database or for the core OpenOffice. For OpenOffice writer, there may be extensions that extends the dictionary feature of OpenOffice so that user can use a French dictionary. Similarly there may be extensions that adds extra grammar features. An extension for Calc might do a complex calculation like mortgage calculation or filter data in certain way.

A popular extension might become part of the core program in a future release.

Extensions for OpenOffice can downloaded at

How to install extensions

To install an extension

  • Then open OpenOffice Writer or Calc. On the top menu, click Tools->Extension Manager...
Installing an Extension
  • Click Add... and select the .oxt file (extension file) you downloaded.
Installing an Extension

Usually, you should see a new button or menu item related to the extension you install. Since extension can do different things, sometimes you might not see any button or menu item. That extension might only appear and work on context menu. So if you cannot find it, check the extension's read-me file or manual.

Using extensions

Developing extensions

Checklist for Writing Extensions

Checklist for Writing Extensions

Preparing development environment


Install and SDK program and SDK can be installed through package manager program, such as apt-get, yum, merge and pacman. Also, several GUI font-end for package manager programs are available to make installation easier. On Ubuntu, Synaptic is good choice. YumEx is the best option on Fedora.

  • Ubuntu:
    • With aptitude: launch a terminal and enter following command
    sudo aptitude install
    If you want SDK examples and documentations, install as well.
    sudo aptitude install
    • With Synaptic: Go to menu: System -> Administration -> Synaptic Package Manager. Search openoffice, and click,, packages, then click Mark for Installation and hit Apply on toolbar.
  • Fedora:
    • With Yum:
    sudo yum install {package name}
    To-Do: replace {package name} with real package names under Fedora
    • With YumEx:
    YumEx does not come with distribution. You needed to be installed manually.
    sudo yum install yumex
    After installation, launch YumEx, search openoffice, select those packages and install.

Note: On Fedora, sudo is not set by default. You can add you account to wheel user group so that you can use sudo. Also, you may use su to change to root, and run yum to install packages.
Note: On Ubuntu, if you use program that comes with distribution, and try to install SDK that is downloaded from website, you may encounter dependency issue. You should the SDK that come with distribution.

Install NetBean, and Extension Development Plugin

NetBean can be installed through package manager as well. Package name is netbeans.


sudo aptitude install netbeans


sudo yum install netbeans

To-Do: need someone check if the packages name for Netbeans on Fedora is netbeans.

After installation, you can install development plugin in NetBean. Lunch NetBean, select Plugins under Tool menu. Then switch to Available Plugins tab, and install OOo API plugin. Finally, select Options under Tool menu, and go to Miscellaneous -> OOo API Plugins tab. Fill in the path to program and SDK. Path is provide in following section.

Install Eclipse and Extension Development Plugin

To-Do: guild on install setup Eclipse for OOo Extension Dev

Path to Program and SDK
  • Ubuntu:
    • Program: /usr/lib/openoffice
    • SDK: /usr/lib/openoffice/basis3.2/sdk
    • Examples: /usr/lib/openoffice/basis3.2/sdk/example
  • Mint:
    • Program: /usr/lib/openoffice
    • SDK: /usr/lib/openoffice/basis3.1/sdk
    • Examples: /usr/lib/openoffice/basis3.1/sdk/example

To-Do: need path on Fedora and others major distros.


This is tutorial is to set up a Java development platform on Windows.

You will need the following software: SDK


Make sure you install OpenOffice and the SDK before running Netbeans.

First Open Netbeans and go to:

Tools -> Plugins

Go the Available Plugins tab and look for API Plugin and check the box beside it.

It will prompt you to install and click the Install button on the bottom of the list.

The plugin will install. To change the setting for the plugin go to:

Tools -> Options -> Miscellaneous -> OOo API Plugin

There you will see the directory path to the installation of both OO and The SDK. If you need to change it then you can make the corrections here.


Solaris ?

Programming languages for developing an extension







.Net Resources SDK (Software Development Kit) API (Application Programming Interface) objects and methods, such as paragraphs, spreadsheets, and fonts, are accessible to Basic through the application programming interface, or API. Through the API, for example, documents can be created, opened, modified and printed. The API can be used not only by Basic, but also by other programming languages, such as Java and C++. The interface between the API and various programming languages is provided by something called Universal Network Objects (UNO).

UNO (Universal Network Objects)


Understanding UNO

UNO Concepts

UNO Concepts Developers Guide

  1. Introduction
  2. First Steps
  3. Professional UNO
  4. Writing UNO Components
  5. Extensions
  6. Advanced UNO
  7. Office Development
  8. Text Documents
  9. Spreadsheet Documents
  10. Drawing and Presentation
  11. Charts
  12. OOo Basic and Dialogs
  13. Database Access
  14. Forms
  15. Universal Control Broker
  16. Configuration Management
  17. Java Beans for Office Componets
  18. Accessibility
  19. Scripting Framework
  20. GUI
  21. Design Guidelines
  22. IDL Documentation Guidelines
  23. Universal Content Providers
  24. UNOIDL Syntax/Grammer

UNO Architecture Introduction

UNO Architecture Diagrams

Related technologies/ frameworks

Factory method design pattern development heavily uses the Factory method design pattern.

Design patterns are conventional templates that describes how to solve common software problems. Since most developers are familiar with the patterns, they can recognize a pattern in others source code. That makes working in teams easier. There are many popular design patterns. One of them is Factory method pattern.

Factory method pattern is a type of creational pattern. Creational pattern pattern solves problems related to creating. Factory pattern solves two major problem generally faced by developers.

1. To reduce too many new operator usage

When working on a large software, numerous instances of classes are created continuously at the runtime. The programmer cannot predict what the user is going to do. So at any given time, the programmer doesn't know what object is create. For example, To create a new document, the user might click new text document or new spreadsheet document. There would several possibilities about what the user is going to do. So, a factory class is assigned to do all these repetitive work of creating a new instance of what the user wants. By separating these repetitive object creations into a factory class, when new classes are added, only the factory class need to be updated.

2. To create object without knowing its class name.

When using the concrete classes, the developer has to remember the class names. In factory pattern, choosing what type of object to be created is delegated to the factory class. Usually this is done by sending a parameter. Based on the parameter passed to the factory, the factory creates an instance of a certain type/class.
Factory Method Pattern

public final class DocumentFactory {

   XDocument document;

   XDocument getDocument(String type){


      document = new TextDocument();


   else if(type.equals("sheet"){

      document = new SpreadSheet();


   return document;



public interface XDocument{



public class TextDocument implements XDocument{

   //concrete class for Text documents


      //method to open text document

      System.out.println("opening a text document...");



public class SpreadSheet implements XDocument{

  //concrete class for spreadsheet documents


     //method to open spreadsheet document

     System.out.println("opening a spreadsheet document...");



class DocumentProgram{

   public static void main(String[] args){

      XDocument doc = df.getDocument("text");  //this just created an instance of TextDocument without knowing its class name.;



Singleton Pattern

In Singleton Pattern, the class can only create a single instance. We want a class to have only a single instance for various reasons.

Sometimes, we want use a global object to keep information about your program. This object should not have any copies. This information might be things like configuration of the program, or a master object that manages pools of resources. So when you need a resource, you ask the master object to get it for you. Now if there were many copies of this master object, you would not know whom to ask for that resource. This single object should not be allowed to have copies. Singleton Pattern forces this rule so that programmer doesn't have to remember about not creating copies. Singleton pattern will create an instance if it doesn't exist and will not create any new instance if an instance already exist. It will just return a reference to that single instance.

class ProgramConfiguration{

    public ProgramConfiguraiton(){

        //default constructor code



A new instance of a class is created by the constructor. Most of the time, we have a public constructor, which is called to create a new instance. Since we want to prohibit multiple instance, we have to restrict access to the constructor. This is done by making the constructor private.

class ProgramConfiguration{

    private ProgramConfiguration(){

        //default private constructor code



then we create a static public method that will make sure that only one instance lives in the whole program.

class ProgramConfiguration{

    private static ProgramConfiguration _configObject;

    private ProgramConfiguration(){

        //default private constructor code


    public getInstance(){


        if an instance exist return that instance otherwise 

        call the constructor to create an instance and return it.


        if(_configObject == null){

        _configObject = ProgramConfiguration();


        return _configObject;



So anytime you want to get that single object, you call the getInstance() method.



    no access to default constructor. so if you did 

    ProgramConfiguration pc = new ProgramConfiguration(); 

    you will get compilation error.


    ProgramConfiguration pc = ProgramConfiguration.getInstance();

    ProgramConfiguration newpc = ProgramConfiguration.getInstance();


    in the above code pc and newpc both point to the same static object. when 

    getinstance() is called for the second time, it finds that _configObject is not null 

    anymore, so it doesn't call the constructor to create any new instance.




UNO Interfaces

UNO Language Bindings


Creating a simple Hello World extension for Writer

Creating a simple extension for Calc

Calc programming API and sample code:

Creating a simple extension for Base

Creating a simple extension for Impress

Sample codes

Some example source codes can be found in the OpenOffice sdk folder.

For Ubuntu distribution: /usr/lib/openoffice/basis3.1/sdk/examples

sample code 1

sample code 2

sample code 3

API Samples

Resources / Links

OpenOffice UX (User Experience)

OpenOffice User Experience

OpenOffice UI (User Interface)

under construction...

OpenOffice Smart Tags

Smart Tag Resources

Smart Tag Presentation

Resources / Links

Development Resources API site SDK site Wiki Projects

Other Resources

Wiki Markup

Syntax highlighting in WikiMedia

use <syntaxhighlight lang="">code here</syntaxhighlight>

int main(){
   int i;
      printf("%d\n", i);
   return 0;