Adding functionality with extensions

OpenOffice.org 3 Calc Guide

Chapter 14 Setting Up and Customizing Calc

< Previous Section

Next Section >

• Choosing options that affect all of OOo
• Choosing Load/Save options
• Choosing options for Calc
• Controlling AutoCorrect functions
• Customizing the user interface
• Adding functionality with extensions

< Previous Page

[[{{{NextPage}}}|Next Page >]]

An extension is a packages that can be installed into OpenOffice.org to add new functionality.

Although individual extensions can be found in different places, the official OpenOffice.org extension repository is at http://extensions.services.openoffice.org/. Some extensions are free of charge; others are available for a fee. Check the descriptions to see what licenses and fees apply to the ones that interest you.

Installing extensions

To install an extension, follow these steps:

1. Download an extension and save it on your computer.
2. In OOo, select Tools > Extension Manager from the menu bar. In the Extension Manager dialog, click Add.
   

   

   Installing an extension
3. A file browser window opens. Find and select the extension you want to install and click Open. The extension begins installing. You may be asked to accept a license agreement.
4. When the installation is complete, the extension is listed in the Extension Manager dialog.

To get extensions that are listed in the repository, you can open the Extension Manager and click the Get more extensions here link. You do not need to download them separately as in step 1 above.

Installing an extension

To install a shared extension, you need write access to the OpenOffice.org installation directory.

Using extensions

This section describes a few of the extensions to OpenOffice.org. In each case, you need to install the extension as described in the previous section.

Professional Template Pack II

Provides more than 120 templates for Writer, Calc, and Impress. Available in several languages. After you have installed this extension, you will find the templates under File > New > Templates and Documents.

Solver for Nonlinear Programming

Calc ships with a solver engine for linear programming only. This extension adds more solvers, which are capable of handling nonlinear problems as well as linear ones:

• DEPS - Differential Evolution & Particle Swarm Optimization
• SCO - Social Cognitive Optimization

DataPilot Tools for OpenOffice.org Calc

Adds some utility functions that make using DataPilots easier:

• Display the current source range for a DataPilot
• Change the source range for a DataPilot
• Refresh all DataPilots on the current sheet