Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Adding functionality with extensions"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Adding functionality with extensions}} {{Documentation/CG3AppDTOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Customizing the user interface |Sho...)
 
 
(8 intermediate revisions by 4 users not shown)
Line 5: Line 5:
 
|ShowNextPage=none
 
|ShowNextPage=none
 
}}
 
}}
−
= Adding functionality with extensions =
+
An extension is a packages that can be installed into OpenOffice.org to add new functionality.  
−
An extension is a package 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/ 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.
+
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 ==
+
= Installing extensions =
 
To install an extension, follow these steps:
 
To install an extension, follow these steps:
  
−
# Download an extension and save it anywhere on your computer.  
+
<ol><li> Download an extension and save it on your computer.  
−
# In OOo, select '''Tools > Extension Manager''' from the menu bar. In the Extension Manager dialog (Figure 17), click '''Add'''.
+
<li> In OOo, select '''Tools > Extension Manager''' from the menu bar. In the Extension Manager dialog, click '''Add'''.
−
# 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.
+
−
# When the installation is complete, the extension is listed in the Extension Manager dialog.
+
  
−
{{Documentation/Tip| 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&nbsp;1 above.}}
+
[[Image:CG3Ch14F24a.png|thumb|none|600px|''Installing an extension'']]
  
−
[[Image:CG3AppDF17.png|thumb|none|500px|''Installing an extension—get new example for Calc'']]
+
<li> 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.
 +
<li> When the installation is complete, the extension is listed in the Extension Manager dialog.
 +
</li>
 +
</li></ol>
  
−
{{Documentation/Note| To install a ''shared'' extension, you need write access to the OpenOffice.org installation directory.}}
+
{{Tip| 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&nbsp;1 above.}}
 +
 
 +
[[Image:CG3AppDF17.png|thumb|none|500px|''Installing an extension'']]
 +
 
 +
{{Note| To install a ''shared'' extension, you need write access to the OpenOffice.org installation directory.}}
  
 
== Using extensions ==
 
== Using extensions ==
−
This section describes several of the more important and popular extensions to OpenOffice.org. In each case, you need to first install the extension as described in the previous section.
+
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'''
 
'''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'''. From Sun Microsystems. Freeware.
+
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'''
  
−
'''Template Changer'''
+
Adds some utility functions that make using DataPilots easier:
  
−
Adds two new items to the '''File > Templates''' menu that allow you to assign a new template to the current document or to a folder of documents. All styles and formatting will be loaded from that template and the document will behave as it was created using that template. Open source.
+
* Display the current source range for a DataPilot
 +
* Change the source range for a DataPilot
 +
* Refresh all DataPilots on the current sheet
  
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Latest revision as of 21:16, 15 July 2018



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.
Tip.png 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
Documentation note.png 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


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Adding_functionality_with_extensions&oldid=242845"
Personal tools