Difference between revisions of "OpenOffice.org"

From CDOT Wiki
Jump to: navigation, search
(OOo Category)
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
[[Category:Open Source Communities]][http://www.openoffice.org/ OpenOffice.org] is an open source community working to build ''the leading international office suite that will run on all major platforms and provide access to all functionality and data through open-component based APIs and an XML-based file format.''
+
{{Admon/obsolete}}
 +
 
 +
[[Category:OpenOffice.org]]
 +
[[Category:Open Source Communities]]
 +
(Under construction)
 +
=Introduction to OpenOffice=
 +
[http://www.openoffice.org/ OpenOffice.org] is an open source community working to build ''the leading international office suite that will run on all major platforms and provide access to all functionality and data through open-component based APIs and an XML-based file format.''
 +
 
 +
[[OpenOffice.org Overview]]
  
 
Seneca students are working alongside Seneca professor [[User:Fardad|Fardad Soleimanloo]] within the OpenOffice.org. This work is centered in the [[OSD600]] and [[DPS909]] courses.
 
Seneca students are working alongside Seneca professor [[User:Fardad|Fardad Soleimanloo]] within the OpenOffice.org. This work is centered in the [[OSD600]] and [[DPS909]] courses.
  
−
To view OpenOffice.org projects taking place within CDOT, see the [[Project List]].
+
==OpenOffice.org Writer==
 +
==OpenOffice.org Calc==
 +
==OpenOffice.org Base==
 +
==OpenOffice.org Impress==
 +
==OpenOffice.org Math==
 +
==OpenOffice.org Draw==
 +
==OpenOffice.org Chart==
 +
 
 +
=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 http://extensions.services.openoffice.org
 +
<!--
 +
===OpenOffice.org Writer extensions===
 +
===OpenOffice.org Calc extensions===
 +
===OpenOffice.org Base extensions===
 +
===OpenOffice.org Impress extensions===
 +
===OpenOffice.org Math extensions===
 +
===OpenOffice.org Draw extensions===
 +
===OpenOffice.org Chart extensions===
 +
-->
 +
==How to install extensions==
 +
To install an extension
 +
* First download an extension from http://extensions.services.openoffice.org
 +
* Then open OpenOffice Writer or Calc. On the top menu, click Tools->Extension Manager...
 +
[[Image:install_extension01.png|border|none|thumb|200px|Installing an Extension]]
 +
* Click Add... and select the .oxt file (extension file) you downloaded.
 +
[[Image:install_extension02.png|border|none|thumb|200px|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 OpenOffice.org extensions=
 +
==Checklist for Writing Extensions==
 +
[http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Extensions/Checklist_for_Writing_Extensions Checklist for Writing Extensions]
 +
==Preparing development environment==
 +
===Linux===
 +
====Install OpenOffice.org and SDK====
 +
OpenOffice.org 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
 +
*: <pre>sudo aptitude install openoffice.org openoffice.org-dev</pre>
 +
*: If you want SDK examples and documentations, install openoffice.org-dev-doc as well.
 +
*: <pre>sudo aptitude install openoffice.org-dev-doc</pre>
 +
** With Synaptic: Go to menu: System -> Administration -> Synaptic Package Manager. Search openoffice, and click openoffice.org, openoffice.org-dev, openoffice.org-dev packages, then click Mark for Installation and hit Apply on toolbar.
 +
* Fedora:
 +
** With Yum:
 +
*: <pre>sudo yum install {package name}</pre>
 +
*: ''' 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.
 +
*: <pre>sudo yum install yumex</pre>
 +
*: After installation, launch YumEx, search openoffice, select those packages and install.
 +
''Note: On Fedora, <code>sudo</code> is not set by default. You can add you account to wheel user group so that you can use <code>sudo</code>. Also, you may use <code>su</code> to change to root, and run yum to install packages. <br/>
 +
''Note: On Ubuntu, if you use OpenOffice.org program that comes with distribution, and try to install SDK that is downloaded from OpenOffice.org website, you may encounter dependency issue. You should the SDK that come with distribution.
 +
====Install NetBean, and OpenOffice.org Extension Development Plugin====
 +
NetBean can be installed through package manager as well. Package name is netbeans.
 +
Ubuntu:
 +
<pre>sudo aptitude install netbeans</pre>
 +
Fedora:
 +
<pre>sudo yum install netbeans</pre>
 +
''' 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 OpenOffice.org program and SDK. Path is provide in following section.
 +
====Install Eclipse and OpenOffice.org Extension Development Plugin====
 +
''' To-Do: guild on install setup Eclipse for OOo Extension Dev
 +
====Path to OpenOffice.org 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.
 +
===Windows===
 +
This is tutorial is to set up a Java development platform on Windows.
 +
You will need the following software:
 +
[http://download.openoffice.org  OpenOffice.org]
 +
[http://download.openoffice.org/sdk/index.html OpenOffice.org SDK]
 +
[http://netbeans.org/downloads/index.html Netbeans]
 +
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 OpenOffice.org 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.
 +
===Mac===
 +
===Solaris ?===
 +
==Programming languages for developing an extension==
 +
===Java===
 +
===Python===
 +
===StarBasic===
 +
===Javascript===
 +
===C++===
 +
===CLI===
 +
[http://blog.nkadesign.com/2008/net-working-with-openoffice-3/ .Net Resources]
 +
=OpenOffice.org SDK (Software Development Kit)=
 +
=OpenOffice.org API (Application Programming Interface)=
 +
http://api.openoffice.org/
 +
----
 +
OpenOffice.org objects and methods, such as paragraphs, spreadsheets, and fonts, are accessible to OpenOffice.org Basic through the OpenOffice.org 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 OpenOffice.org 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)=
 +
==Introduction==
 +
[http://wiki.services.openoffice.org/wiki/Uno/Article/Understanding_Uno Understanding UNO]
 +
<!-- [[User:Asamimi|asa]] no need for this, it is already set as your work :) -->
 +
==UNO Concepts==
 +
[http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/UNO_Concepts UNO Concepts]
 +
[http://api.openoffice.org/docs/DevelopersGuide/DevelopersGuide.xhtml Developers Guide]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Preface/ReadersGuide.xhtml Introduction]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/FirstSteps/FirstSteps.xhtml First Steps]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/ProfUNO/ProfUNO.xhtml Professional UNO]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Components/Components.xhtml Writing UNO Components]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Extensions/Extensions.xhtml Extensions]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/AdvancedUNO/AdvancedUNO.xhtml Advanced UNO]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/AdvancedUNO/AdvancedUNO.xhtml Office Development]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Text/Text.xhtml Text Documents]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Spreadsheet/Spreadsheet.xhtml Spreadsheet Documents]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Drawing/Drawing.xhtml Drawing and Presentation]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Charts/Charts.xhtml Charts]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/BasicAndDialogs/BasicAndDialogs.xhtml OOo Basic and Dialogs]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Database/Database.xhtml Database Access]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Forms/Forms.xhtml Forms]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/UCB/UCB.xhtml Universal Control Broker]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Config/Config.xhtml Configuration Management]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/OfficeBean/OfficeBean.xhtml Java Beans for Office Componets]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Accessibility/Accessibility.xhtml Accessibility]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/ScriptingFramework/ScriptingFramework.xhtml Scripting Framework]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/GUI/GUI.xhtml GUI]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Appendix/IDLDesignGuide/IDLDesignGuide.xhtml Design Guidelines]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Appendix/IDLDocumentationGuide/IDLDocumentationGuide.xhtml IDL Documentation Guidelines]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Appendix/UCPs/UCPs.xhtml Universal Content Providers]
 +
# [http://api.openoffice.org/docs/DevelopersGuide/Appendix/IDLSyntax/IDLSyntax.xhtml UNOIDL Syntax/Grammer]
 +
==UNO Architecture Introduction==
 +
==UNO Architecture Diagrams==
 +
==Related technologies/ frameworks==
 +
===[[Design Patterns]]===
 +
 
 +
==UNO Interfaces==
 +
==UNO Language Bindings==
 +
==Tutorials==
 +
===Creating a simple Hello World extension for OpenOffice.org Writer===
 +
===Creating a simple extension for OpenOffice.org Calc===
 +
Calc programming API and sample code:<br/>
 +
http://wiki.services.openoffice.org/wiki/Calc/API/Programming
 +
===Creating a simple extension for OpenOffice.org Base===
 +
===Creating a simple extension for OpenOffice.org Impress===
 +
==Sample codes==
 +
Some example source codes can be found in the OpenOffice sdk folder.
 +
For Ubuntu distribution: <code>/usr/lib/openoffice/basis3.1/sdk/examples</code>
 +
===sample code 1===
 +
===sample code 2===
 +
===sample code 3===
 +
=== API Samples ===
 +
http://wiki.services.openoffice.org/wiki/API/Samples
 +
==Resources / Links==
 +
 
 +
=OpenOffice UX (User Experience)=
 +
[http://ux.openoffice.org/ OpenOffice User Experience]
 +
=OpenOffice UI (User Interface)=
 +
under construction...
 +
=OpenOffice Smart Tags=
 +
[http://wiki.services.openoffice.org/wiki/Writer/Smart_Tags Smart Tag Resources]
 +
[http://marketing.openoffice.org/ooocon2007/programme/thursday_128.pdf Smart Tag Presentation]
 +
= [[OpenOffice.org Potential Projects|Potential Projects]] =
 +
== Extensions ==
 +
== Others ==
 +
* [[OpenOffice.org Potential Projects#Python_Scriptablity_project|Python Scriptablity]]
  
−
[[Category:OpenOffice.org]]
+
=Resources / Links=
 +
==Development Resources==
 +
[http://api.openoffice.org/ OpenOffice.org API site]<br/>
 +
[http://download.openoffice.org/sdk/index.html OpenOffice.org SDK site]<br/>
 +
[http://wiki.services.openoffice.org/wiki/Main_Page  OpenOfice.org Wiki Projects]
 +
==Other Resources==
 +
[http://en.wikipedia.org/wiki/Help:Wiki_markup Wiki Markup]
 +
===Syntax highlighting in WikiMedia===
 +
use &lt;syntaxhighlight lang=""&gt;code here&lt;/syntaxhighlight&gt;
 +
<syntaxhighlight lang="csharp">
 +
int main(){
 +
  int i;
 +
  for(i=0;i<10;i++){
 +
      printf("%d\n", i);
 +
  }
 +
  return 0;
 +
}
 +
</syntaxhighlight>

Latest revision as of 19:44, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

(Under construction)

Contents

Introduction to OpenOffice

OpenOffice.org is an open source community working to build the leading international office suite that will run on all major platforms and provide access to all functionality and data through open-component based APIs and an XML-based file format.

OpenOffice.org Overview

Seneca students are working alongside Seneca professor Fardad Soleimanloo within the OpenOffice.org. This work is centered in the OSD600 and DPS909 courses.

OpenOffice.org Writer

OpenOffice.org Calc

OpenOffice.org Base

OpenOffice.org Impress

OpenOffice.org Math

OpenOffice.org Draw

OpenOffice.org Chart

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 http://extensions.services.openoffice.org

How to install extensions

To install an extension

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 OpenOffice.org extensions

Checklist for Writing Extensions

Checklist for Writing Extensions

Preparing development environment

Linux

Install OpenOffice.org and SDK

OpenOffice.org 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 openoffice.org openoffice.org-dev
    If you want SDK examples and documentations, install openoffice.org-dev-doc as well.
    sudo aptitude install openoffice.org-dev-doc
    • With Synaptic: Go to menu: System -> Administration -> Synaptic Package Manager. Search openoffice, and click openoffice.org, openoffice.org-dev, openoffice.org-dev 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 OpenOffice.org program that comes with distribution, and try to install SDK that is downloaded from OpenOffice.org website, you may encounter dependency issue. You should the SDK that come with distribution.

Install NetBean, and OpenOffice.org Extension Development Plugin

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

sudo aptitude install netbeans

Fedora: 

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 OpenOffice.org program and SDK. Path is provide in following section.

Install Eclipse and OpenOffice.org Extension Development Plugin

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

Path to OpenOffice.org 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.

Windows

This is tutorial is to set up a Java development platform on Windows. You will need the following software: OpenOffice.org OpenOffice.org SDK Netbeans 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 OpenOffice.org 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.

Mac

Solaris ?

Programming languages for developing an extension

Java

Python

StarBasic

Javascript

C++

CLI

.Net Resources

OpenOffice.org SDK (Software Development Kit)

OpenOffice.org API (Application Programming Interface)

http://api.openoffice.org/

OpenOffice.org objects and methods, such as paragraphs, spreadsheets, and fonts, are accessible to OpenOffice.org Basic through the OpenOffice.org 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 OpenOffice.org 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)

Introduction

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

Design Patterns

UNO Interfaces

UNO Language Bindings

Tutorials

Creating a simple Hello World extension for OpenOffice.org Writer

Creating a simple extension for OpenOffice.org Calc

Calc programming API and sample code:
http://wiki.services.openoffice.org/wiki/Calc/API/Programming

Creating a simple extension for OpenOffice.org Base

Creating a simple extension for OpenOffice.org 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

http://wiki.services.openoffice.org/wiki/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

Potential Projects

Extensions

Others

Resources / Links

Development Resources

OpenOffice.org API site
OpenOffice.org SDK site
OpenOfice.org Wiki Projects

Other Resources

Wiki Markup

Syntax highlighting in WikiMedia

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

int main(){
   int i;
   for(i=0;i<10;i++){
      printf("%d\n", i);
   }
   return 0;
}
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=OpenOffice.org&oldid=104094"