Difference between revisions of "Documentation/UserGuide/Migration Guide/Introduction"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Created page with "{{Documentation/MigrationTOC|Migration=block|PrevNext=block|Prev=Documentation/OOoAuthors User Manual/Migration Guide|Next=Documentation/OOoAuthors User Manual/Migration Guide...")
 
m (Other resources and add-ons)
 
(46 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{Documentation/MigrationTOC|Migration=block|PrevNext=block|Prev=Documentation/OOoAuthors User Manual/Migration Guide|Next=Documentation/OOoAuthors User Manual/Migration Guide/Sharing Files}}
+
{{DISPLAYTITLE:Migrating to {{OOo}} }}
+
{{Documentation/MigrationTOC|Migration=block|PrevNext=block|Prev=Documentation/UserGuide/Migration_Guide|Next=Documentation/UserGuide/Migration_Guide/Sharing Files}}
== What is OpenOffice.org? ==
+
{{DISPLAYTITLE:Migrating to {{AOo}} }}
OpenOffice.org (OOo) is a freely-available, full-featured office suite. It includes the following components.
+
==What is {{AOo}}? ==
 +
{{AOo}} (AOO) is a freely-available, full-featured office productivity suite. It includes the following components.
  
=== Writer (word processor) ===
+
===Writer (word processor) ===
  
[[Image:documentation_writer_icon.png|left]]Writer is a feature-rich tool for creating letters, books, reports, newsletters, brochures, and other documents. You can insert graphics and objects from other components into Writer documents. Writer can export files to HTML, XHTML, XML, Adobe’s Portable Document Format (PDF), and several versions of Microsoft Word files. It also connects to your email client.
+
[[Image:documentation_writer_icon.png|left]]Writer is a feature-rich tool for creating letters, books, reports, newsletters, brochures,and other documents. You can insert graphics and objects from other components into Writer documents. Writer can export files to HTML, XHTML, XML, Adobe’s Portable Document Format(PDF), and several versions of Microsoft Word files. It also connects to your email client.
  
=== Calc (spreadsheet) ===
+
===Calc (spreadsheet) ===
  
[[Image:documentation_calc_icon.png|left]]Calc has all of the advanced analysis, charting and decision-making features expected from a high-end spreadsheet. It includes over 300 functions for financial, statistical and mathematical operations among others. The Scenario Manager provides “what if” analyses. Calc generates 2-D and 3-D charts, which can be integrated into other OOo documents. You can also open and work with Microsoft Excel workbooks and save them in Excel format. Calc can export spreadsheets to Adobe’s Portable Document Format (PDF) and to HTML.
+
[[Image:documentation_calc_icon.png|left]]Calc has all of the advanced analysis, charting and decision-making features expected from a high-end spreadsheet. It includes over 300 functions for financial, statistical and mathematical operations among others. The Scenario Manager provides “what if” analyses. Calc generates 2-D and 3-D charts, which can be integrated into other AOO documents. You can also open and work with Microsoft Excel workbooks and save them in Excel format. Calc can export spreadsheets to Adobe’s Portable Document Format (PDF) and to HTML.
  
=== Impress (presentation graphics) ===
+
===Impress (presentation graphics) ===
  
 
[[Image:documentation_impress_icon.png|left]]Impress provides all the common multi-media presentation tools, such as special effects, animation, and drawing tools. It is integrated with the advanced graphics capabilities of the Draw and Math components. Slideshows can be further enhanced with Fontwork’s special effects text, as well as sound and video clips. Impress is compatible with Microsoft’s PowerPoint file format, and can save your work in numerous graphics formats including Macromedia Flash (SWF).
 
[[Image:documentation_impress_icon.png|left]]Impress provides all the common multi-media presentation tools, such as special effects, animation, and drawing tools. It is integrated with the advanced graphics capabilities of the Draw and Math components. Slideshows can be further enhanced with Fontwork’s special effects text, as well as sound and video clips. Impress is compatible with Microsoft’s PowerPoint file format, and can save your work in numerous graphics formats including Macromedia Flash (SWF).
  
=== Draw (vector graphics) ===
+
===Draw (vector graphics) ===
  
[[Image:documentation_draw_icon.png|left]]Draw is a vector drawing tool that can produce everything from simple diagrams or flowcharts to 3-D artwork. Its Smart Connectors feature allows you to define your own connection points. You can use Draw to create drawings for use in any of OOo’s other components, and you can create your own clipart and add it to the Gallery. Draw can import graphics from many common formats and save them in over 20 formats including PNG, HTML, PDF and Flash.
+
[[Image:documentation_draw_icon.png|left]]Draw is a vector drawing tool that can produce everything from simple diagrams or flowcharts to 3-D artwork. Its Smart Connectors feature allows you to define your own connection points. You can use Draw to create drawings for use in any of AOO’s other components, and you can create your own clipart and add it to the Gallery. Draw can import graphics from many common formats and save them in over 20 formats including PNG, HTML, PDF and Flash.
  
=== Base (database) ===
+
===Base (database) ===
  
[[Image:documentation_base_icon.png|left]]Base offers tools for day-to-day database work within a simple interface. It can create and edit forms, reports, queries, tables, views and relations, so managing a connected database is much the same as in other popular database applications. Base provides many new features, such as the ability to analyze and edit relationships from a diagram view. Base incorporates HSQLDB as its default relational database engine. It can also use dBASE, Microsoft Access, MySQL or Oracle, or any ODBC or JDBC compliant database. Base also provides support for a subset of ANSI-92 SQL.
+
[[Image:documentation_base_icon.png|left]]Base offers tools for day-to-day database work within a simple interface. It can create and edit forms, reports, queries, tables, views and relations, so managing a connected database is much the same as in other popular database applications. Base provides many new features,such as the ability to analyze and edit relationships from a diagram view. Base incorporates HSQLDB as its default relational database engine. It can also used BASE, Microsoft Access, MySQL or Oracle, or any ODBC or JDBC compliant database. Base also provides support for a subset of ANSI-92 SQL.
  
=== Math (formula editor) ===
+
===Math (formula editor) ===
  
[[Image:documentation_math_icon.png|left]]Math is OOo’s formula or equation editor. You can use it to create complex equations that include symbols or characters not available in standard font sets. While it is most commonly used to create formulas in other documents, such as Writer and Impress files, Math can also work as a stand-alone tool. You can save formulas in the standard Mathematical Markup Language (MathML) format for inclusion in web pages and other documents not created by OOo.
+
[[Image:documentation_math_icon.png|left]]Math is AOO’s formula or equation editor. You can use it to create complex equations that include symbols or characters not available in standard font sets. While it is most commonly used to create formulas in other documents, such as Writer and Impress files, Math can also work as a stand-alone tool. You can save formulas in the standard Mathematical Markup Language (MathML) format for inclusion in webpages and other documents not created by AOO.
  
== What are the advantages of OpenOffice.org? ==
+
==What are the advantages of Apache OpenOffice? ==
Here are some of the advantages of OpenOffice.org over other office suites:
+
Here are some of the advantages of Apache OpenOffice over other office suites:
  
* '''No licensing fees'''. OOo is free for anyone to use and distribute at no cost. Many features that are available as extra cost add-ins in other office suites (like PDF export) are free with OOo. There are no hidden charges now or in the future.
+
*'''No licensing fees'''. AOO is free for anyone to use and distribute at no cost. Many features that are available as extra cost add-ins in other office suites (like PDF export) are free with AOO. There are no hidden charges, and all future upgrades are free.
* '''Open source. '''You can distribute, copy, and modify the software as much as you wish, in accordance with either of OOo's Open Source licenses.
+
*'''Open source. '''You can distribute, copy, and modify the software as much as you wish, in accordance with AOO's Open Source license.
* '''Cross-platform.''' OOo 2.0 runs on several hardware architectures and under multiple operating systems, such as Microsoft Windows, Mac OS X, Linux, and Sun Solaris.
+
*'''Cross-platform.''' AOO 4.0 runs on several hardware architectures and under multiple operating systems, such as Microsoft Windows, MacOS X, Linux, BSD Unix and Sun Solaris.
* '''Extensive language support'''. OOo’s user interface is available in over 40 languages and the OOo project provides spelling, hyphenation and thesuarus dictionaries in over 70 languages and dialects. OOo also provides support for both Complex Text Layout (CTL) and Right to Left (RTL) layout languages (such as Hindi, Hebrew and Arabic).
+
*'''Extensive language support'''. AOO’s user interface is available in over 25 languages and the AOO project provides spelling, hyphenation and thesaurus dictionaries in over 70 languages and dialects. AOO also provides support for both Complex Text Layout (CTL)and Right to Left (RTL) layout languages (such as Hindi, Hebrew and Arabic).
* '''Consistent user interface'''. All''' '''the components have a similar “look and feel”, making them easy to use and master.
+
*'''Consistent user interface'''. All''' '''the components have a similar “look and feel”, making them easy to use and master.
* '''Integration.''' The components of OpenOffice.org are well integrated with one another.
+
*'''Integration.''' The components of Apache OpenOffice are well integrated with one another.
** All the components share a common spelling checker and other tools, which are used consistently across the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but enhanced versions in Impress and Draw.
+
**All the components share a common spelling checker and other tools, which are used consistently across the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but enhanced versions in Impress and Draw.
** You do not need to know which application was used to create a particular file (for example, you can open a Draw file from Writer).
+
**You do not need to know which application was used to create a particular file (for example, you can open a Draw file from Writer).
* '''Granularity.''' Usually, if you change an option, it affects all components. However, options can be set at a component level or even document level.
+
*'''Granularity.''' Usually, if you change an option, it affects all components. However, options can be set at a component level or even document level.
* '''File compatibility.''' OOo includes PDF and Flash export capabilities, as well as support for opening and saving files in many common formats including Microsoft Office, HTML, XML, WordPerfect and Lotus 123 formats.
+
*'''File compatibility.''' AOO includes PDF and Flash export capabilities, as well as support for opening and saving files in many common formats including Microsoft Office, HTML, XML, Word Perfect and Lotus 123 formats.
* '''No vendor lock-in. '''OOo 2.0 uses OpenDocument, an XML (eXtensible Markup Language) file format developed as an industry standard by OASIS (Organization for the Advancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their framework is open and published.
+
*'''No vendor lock-in. '''AOO 4.0 uses OpenDocument, an XML(eXtensible Markup Language) file format developed as an industry standard by OASIS (Organization for the Advancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their framework is open and published.
  
* '''You have a voice.''' Enhancements, software fixes and release dates are community-driven. You can join the community and affect the course of the product you use.
+
*'''You have a voice.''' Enhancements, software fixes and release dates are community-driven. You can join the community and affect the course of the product you use.
  
You can read more about OpenOffice.org, its mission, history, licensing and other organizational information here: [http://www.openoffice.org/about.html http://www.openoffice.org/about.html]
+
You can read more about {{AOo}}, its mission, history, licensing and other organizational information here: [https://www.openoffice.org/about.html https://www.ApacheOpenOffice/about.html]
  
=== How does OpenOffice.org compare? ===
+
===How does Apache OpenOffice compare? ===
OpenOffice.org can match and exceed the feature set of competing office suites. The following table lists the main components of OOo and compares them with their equivalents in two leading office suites, ''Microsoft Office 2003'' (MSO) and ''WordPerfect Office X3'' (WP).
+
Apache OpenOffice can match and exceed the feature set of competing officesuites. The following table lists the main components of AOO and compares them with their equivalents in two leading office suites,''Microsoft Office 2003'' (MSO) and ''WordPerfect Office X3''(WP).
  
  
{| border=1 style="border-collapse:collapse;" cellpadding=4  
+
{|border=1 style="border-collapse:collapse;" cellpadding=4  
! Function
+
!Function
! <center>{{OOo}}</center>
+
!<center>{{AOo}}</center>
! <center>Microsoft Office</center>
+
!<center>Microsoft Office</center>
! <center>WordPerfect Office</center>
+
!<center>WordPerfect Office</center>
  
 
|-
 
|-
| Word processor
+
|Word processor
| Writer
+
|Writer
| Word®
+
|Word®
| WordPerfect® X3
+
|WordPerfect® X3
  
 
|-
 
|-
| Spreadsheet
+
|Spreadsheet
| Calc
+
|Calc
| Excel®
+
|Excel®
| Quattro Pro® X3
+
|Quattro Pro® X3
  
 
|-
 
|-
| Vector Graphics
+
|Vector Graphics
| Draw
+
|Draw
| no
+
|no
| no
+
|no
  
 
|-
 
|-
| Presentation Graphics
+
|Presentation Graphics
| Impress
+
|Impress
| PowerPoint®
+
|PowerPoint®
| Presentations™ X3
+
|Presentations™ X3
  
 
|-
 
|-
| Database
+
|Database
| Base
+
|Base
| Access® <sup>1</sup>
+
|Access® <sup>1</sup>
| Paradox® <sup>2</sup>
+
|Paradox® <sup>2</sup>
  
 
|-
 
|-
| Math or Formula Editor
+
|Math or Formula Editor
| Math
+
|Math
| yes
+
|yes
| no
+
|no
  
 
|}
 
|}
<sup>''1</sup> Professional ''version only''.''
+
<sup>''1</sup>Professional ''version only''.''
  
<sup>''2</sup> Professional ''and'' Student and Teacher ''editions only.
+
<sup>''2</sup>Professional ''and'' Student and Teacher''editions only.
  
=== Features ===
+
===Features ===  
The following tables list some important features of OpenOffice.org and compare them with two leading office suites, ''Microsoft Office 2003'' (MSO) and ''WordPerfect X3 ''(WP).
+
The following tables list some important features of Apache OpenOffice and compare them with two leading office suites,''Microsoft Office'' (MSO) and ''WordPerfect X3 ''(WP).
  
==== Styles and formatting ====
+
====Styles and formatting ====
  
{| border=1 style="border-collapse:collapse;" cellpadding=4  
+
{|border=1 style="border-collapse:collapse;" cellpadding=4  
! Feature
+
!Feature
! <center>{{OOo}}</center>
+
!<center>{{AOo}}</center>
! <center>Microsoft Office</center>
+
!<center>Microsoft Office</center>
! <center>WordPerfect Office</center>
+
!<center>WordPerfect Office</center>
  
 
|-
 
|-
| Navigator
+
|Navigator
| <center>yes</center>
+
|<center>yes</center>
| <center>limited<sup>1</sup></center>
+
|<center>limited<sup>1</sup></center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Styles and Formatting window
+
|Styles and Formatting window
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Keyboard support for paragraph styles
+
|Keyboard support for paragraph styles
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Support for page, frame, and list styles
+
|Support for page, frame, and list styles
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Word completion
+
|Word completion
| <center>yes</center>
+
|<center>yes</center>
| <center>Excel only</center>
+
|<center>Excel only</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Spelling and language proofing modules
+
|Spelling and language proofing modules
| <center>70+</center>
+
|<center>70+</center>
| <center>50+<sup>2</sup></center>
+
|<center>50+<sup>2</sup></center>
| <center>25</center>
+
|<center>25</center>
  
 
|-
 
|-
| Formula or equation tools
+
|Formula or equation tools
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
  
 
|}
 
|}
<sup>1 </sup>“Outline View” in Word offers a subset of the features of OOo’s ''Navigator''.
+
<sup>1</sup>“Outline View” in Word offers a subset of the features of AOO’s ''Navigator''.
  
<sup>2</sup> Requires an additional license for the the ''Multilingual User Interface Pack.''
+
<sup>2</sup>Requires an additional license for the ''Multilingual User Interface Pack.''
  
==== Interoperability ====
+
====Interoperability ====
  
{| border=1 style="border-collapse:collapse;" cellpadding=4  
+
{|border=1 style="border-collapse:collapse;" cellpadding=4  
 
|-valign=top
 
|-valign=top
! Feature
+
!Feature
! <center>{{OOo}}</center>
+
!<center>{{AOo}}</center>
! <center>Microsoft Office</center>
+
!<center>Microsoft Office</center>
! <center>WordPerfect Office</center>
+
!<center>WordPerfect Office</center>
 
|-
 
|-
| PDF export capability
+
|PDF export capability
| <center>yes</center>
+
|<center>yes</center>
| <center>yes<sup>1</sup></center>
+
|<center>yes<sup>1</sup></center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Flash export capability
+
|Flash export capability
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| XML export capability
+
|XML export capability
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| OpenDocument XML format
+
|OpenDocument XML format
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Import/Export Microsoft Office files
+
|Import/Export Microsoft Office files
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Import WordPerfect files
+
|Import WordPerfect files
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Import Lotus 123 files
+
|Import Lotus 123 files
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Connect to external databases (MySQL, Oracle, Access, etc.)
+
|Connect to external databases (MySQL, Oracle, Access, etc.)
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Languages available (localizations)
+
|Languages available (localizations)
| <center>40+</center>
+
|<center>40+</center>
| <center>35+</center>
+
|<center>35+</center>
| <center>30</center>
+
|<center>30</center>
  
 
|-
 
|-
| Supported operating systems
+
|Supported operating systems
| <center>Windows, Mac OS X, Linux, Solaris</center>
+
|<center>Windows, macOS, Linux, Solaris</center>
| <center>Windows only<sup>2</sup></center>
+
|<center>Windows only<sup>2</sup></center>
| <center>Windows only</center>
+
|<center>Windows only</center>
  
 
|-
 
|-
| Unicode language support
+
|Unicode language support
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
  
 
|}
 
|}
<sup>1</sup> Requires additional third-party software, such as ''PDF Writer'' or ''PDF Converter''.<sup>2</sup> ''Microsoft Office: Mac'' is not feature compatible with ''Microsoft Office 2003.''
+
<sup>1</sup>Requires additional third-party software, such as ''PDF Writer'' or ''PDF Converter''.<sup>2</sup>''Microsoft Office: Mac''is not feature compatible with ''Microsoft Office 2003.''
  
==== Programmability ====
+
====Programmability ====
 
Macros are programs which automate tasks and can be embedded in a document. The following table lists the languages available for macro development in each office suite.
 
Macros are programs which automate tasks and can be embedded in a document. The following table lists the languages available for macro development in each office suite.
  
 
+
{|border=1 style="border-collapse:collapse;" cellpadding=4  
{| border=1 style="border-collapse:collapse;" cellpadding=4  
+
!Feature
! Language
+
!<center>{{AOo}}</center>
! <center>{{OOo}}</center>
+
!<center>Microsoft Office</center>
! <center>Microsoft Office</center>
+
!<center>WordPerfect Office</center>
! <center>WordPerfect Office</center>
+
  
 
|-
 
|-
| Basic-derived language
+
|Basic-derived language
| <center>OpenBasic</center>
+
|<center>OpenBasic</center>
| <center>VBA</center>
+
|<center>VBA</center>
| <center>VBA</center>
+
|<center>VBA</center>
  
 
|-
 
|-
| Beanshell
+
|Beanshell
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Java
+
|Java
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| JavaScript
+
|JavaScript
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Python
+
|Python
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|}
 
|}
Beyond simple macros, some office suites can be extended to include new features. This capability usually takes the form of plug-ins. In the case of OpenOffice.org, it can also be done through changes to the source code.
+
Beyond simple macros, some office suites can be extended to include new features. This capability usually takes the form of plug-ins. In the case of {{AOo}}, it can also be done through changes to the source code.
 
+
 
+
{| border=1 style="border-collapse:collapse;" cellpadding=4
+
! Feature
+
! <center>{{OOo}}</center>
+
! <center>Microsoft Office</center>
+
! <center>WordPerfect Office</center>
+
  
 +
{|border=1 style="border-collapse:collapse;" cellpadding=4
 +
!Feature
 +
!<center>{{AOo}}</center>
 +
!<center>Microsoft Office</center>
 +
!<center>WordPerfect Office</center>
  
 
|-
 
|-
| C and C++
+
|C and C++
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Java
+
|Java
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| Python
+
|Python
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|-
 
|-
| '''Source code available!'''
+
|'''Source code available!'''
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
| <center>no</center>
+
|<center>no</center>
  
 
|}
 
|}
  
==== Security ====
+
====Security ====
  
{| border=1 style="border-collapse:collapse;" cellpadding=4  
+
{|border=1 style="border-collapse:collapse;" cellpadding=4  
! Feature
+
!Feature
! <center>{{OOo}}</center>
+
!<center>{{AOo}}</center>
! <center>Microsoft Office</center>
+
!<center>Microsoft Office</center>
! <center>WordPerfect Office</center>
+
!<center>WordPerfect Office</center>
  
 
|-
 
|-
| Digital signatures
+
|Digital signatures
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Strong encryption
+
|Strong encryption
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
  
 
|-
 
|-
| Secure paths for macro execution
+
|Secure paths for macro execution
| <center>yes</center>
+
|<center>yes</center>
| <center>yes</center>
+
|<center>yes</center>
| <center>no</center>
+
|<center>no</center>
  
 
|}
 
|}
  
=== New features in version 2 ===
+
===New features in version 4 ===
OpenOffice.org 2.0 delivers hundreds of improvements and new features. Here are some of the major enhancements.
+
{{AOo}} 4.0 delivers hundreds of improvements and new features. Here are some of the major enhancements.
  
* '''Simplified installation'''. Installations are now performed by platform-native installers with no need to use command-line switches (or flags) for multi-user installations. You can also specify which version of Java (if any) is to be used by OOo from the installation interface.
+
==What are the minimum requirements? ==
* '''New database component'''. In the new stand-alone database component, you can create forms, reports, queries, tables, views and relations. OOo now includes HSQLDB, a small, fast, relational database engine that supports a subset of ANSI-92 SQL, along with an easy to use interface. Additionally, it is now easier than ever to use other databases (dBASE, MySQL, Oracle, among others).
+
{{AOo}} 4.0 requires one of the following operating systems:
* '''New file format'''. OOo 2.0 uses the new OpenDocument standard XML file format (standardized by OASIS, [http://www.oasis-open.org/home/index.php http://www.oasis-open.org/home/index.php]) as its default file format. This new file format is also used in StarOffice, IBM Workspace and KOffice, and will be used by other products in the future. OOo 2.0 can still read and save files in formats previously supported by OOo 1.x, including Microsoft Office formats.
+
* '''Native system theme integration'''. To further integrate OpenOffice.org with the underlying operating system, all user interface elements (such as buttons and scrollbars) have the same look as those used in other native applications for each platform.
+
* '''Digital signatures'''. Digital signatures provide authentication of the true author or editor of a document. This feature provides further security with running macros.
+
* '''Enhanced encryption'''. Implementation of the new XML (eXtensible Markup Language) encryption algorithm offers additional document security.
+
* '''Usability improvements'''. Redesigned toolbars are more usable, and display only selected default tools and related options. The usability of the '''Menus''' tab of the '''Tools > Customize''' dialog has been improved. Several features have been renamed to conform with common office suite terminology (for example, “AutoPilot” is now a “Wizard”).
+
* '''Thumbnails'''. The new plug-in for the the native file explorer provides a thumbnail preview of an OOo file. Some of the more common file system explorers that can use this new feature are Nautilus (Gnome), Konqueror (KDE), and Microsoft Windows Explorer.
+
* '''Import and export filters'''
+
** Improved PDF export filter now includes PDF bookmarks, PDF notes, and more.
+
** Import and export of Microsoft Office 95 and Office 97 spin buttons and scrollbars have been added to the Word filters.
+
** The import filter for Microsoft PowerPoint documents now creates text objects having font-independent line spacing enabled.
+
** Enhanced export to HTML produces valid “XHTML 1.0 Strict” documents. XHTML export has been enabled for Calc, Draw and Impress.
+
** You can now open Microsoft Office password-protected documents.
+
** New import filters for WordPerfect and Lotus 123.
+
  
* '''Send document as e-mail'''. OOo 2.0 makes it easier to use your email client to send the active document as an attachment.
+
*'''Microsoft Windows''' Windows 2000 (Service Pack 2 or higher), Windows 2003, Windows 7,8, 10 and Windows 11
* '''Enhanced mail merge feature'''. Enhancements include better management of databases and saving into one single file.
+
*'''GNU/Linux Kernel version 2.2.13''' and glibc 2.4.0 or newer
* '''Drag and drop selections to create styles'''. Drag and drop a text selection into the Styles and Formatting window to create a new paragraph style or character style.
+
*'''Mac''' OS X 10.3.x (10.3.5 recommended), Mac OS X 10.4.x, plusX11
* '''Form controls'''. Form controls can be embedded in all OOo documents that support a form layer.
+
*'''Solaris '''version 8 or higher
* '''New keyboard shortcuts'''. You can now use the keyboard to perform the actions found under '''Edit > Paste Special'''. Multiple selected sheets in a spreadsheet can be deselected using the keyboard. Paragraph and other styles can be assigned to key combinations.
+
  
* '''Auto recovery of files and the workspace environment'''. The OOo Error Reporting tool and the document recovery features have been combined. Now if OOo crashes, the active documents are saved. You can recover the documents, and send an error report.
 
  
* '''Enhanced features in Calc'''. These enhancements include improved number recognition, an improved Hyperlink function, conditional arrays, a greater selection of predefined headers and footers, more options for defining how to print sheets, new options for the DataPilot feature, and support for right-to-left languages.
+
Some {{AOo}} features (wizards and the database component) require that the Java Runtime Environment (JRE) be installed on your computer. Although {{AOo}} will work fine without Java-support, some features will not be available. You can download the latest version from [https://www.java.com/ https://www.java.com] or from [https://adoptium.net/ https://adoptium.net/].
* '''Calc row limit increased'''. The number of spreadsheet rows has been increased to 65536, the same number of rows as Microsoft Excel.
+
* '''Enhanced multimedia'''. The multimedia presentation model uses the W3C’s Synchronized Multimedia Integration Language (SMIL) standard. Now Impress can render nearly all of the Microsoft PowerPoint animation effects. Two new task panels provide access to shape and slide transition effects.
+
* '''Programmatic control of menu and toolbar items'''. Third-party developers can write plugins to manipulate menu bar and toolbar layouts to their needs. Developers can now insert, remove, and modify menu items, context menus, and toolbar items at runtime.
+
* '''Scripting framework'''. The scripting framework allows you to write macros in a number of languages other than OOo Basic. You can assign these macros to menu items, keyboard combinations, application and document events, form controls within documents, and various objects within documents.
+
  
For a complete, detailed listing, go to the OpenOffice.org 2.0 Office Suite, Guide to New Features located at [http://marketing.openoffice.org/2.0/featureguide.html#enduser http://marketing.openoffice.org/2.0/featureguide.html#enduser]
+
For a more detailed (and up-to-date) listing of requirements, see: [https://www.openoffice.org/dev_docs/source/sys_reqs_20.html https://www.openoffice.org/dev_docs/source/sys_reqs_20.html]
  
== What are the minimum requirements? ==
+
==How do I get the software? ==
OpenOffice.org 2.0 requires one of the following operating systems:
+
You can get the {{AOo}} installation package in any of these ways:
  
* '''Microsoft Windows''' 98, Windows ME, Windows 2000 (Service Pack 2 or higher), Windows XP or Windows 2003
+
*Download a copy from the project’s homepage: [https://www.openoffice.org/ https://www.openoffice.org].
* '''GNU/Linux Kernel version 2.2.13''' and glibc 2.2.0 or newer
+
*Download a copy using the Peer to Peer client, BitTorrent. The instructions are here: [https://www.openoffice.org/distribution/p2p/ https://www.openoffice.org/distribution/p2p/].
* '''Mac''' OS X 10.3.x (10.3.5 recommended), Mac OS X 10.4.x, plus X11
+
*Purchase a copy on a CD-ROM or other digital form from a third partydistributor.  
* '''Solaris '''version 8 or higher
+
*The Apache OpenOffice ''Porting Project'' has links to versions of the software that have been, or are currently being “ported” to run under various operating systems. [https://www.openoffice.org/porting/index.html https://www.openoffice.org/porting/index.html.]
  
More operating systems will be supported in the future.  
+
==How do I install Apache OpenOffice? ==
 +
Information on installing and setting up Apache OpenOffice on the various supported operating systems is given here: [https://www.openoffice.org/download/common/instructions.html https://www.openoffice.org/download/common/instructions.html]
  
Some OpenOffice.org features (wizards and the database component) require that the Java Runtime Environment (JRE) be installed on your computer. Although OOo will work fine without Java support, some features will not be available. You can download the latest version from [http://www.java.com/ http://www.java.com].
+
You can also download the more detailed ''Setup Guide'' (in several languages) from [https://www.openoffice.org/documentation/setup_guide2/index.html https://www.openoffice.org/documentation/setup_guide2/index.html]
  
For a more detailed (and up-to-date) listing of requirements, see: [http://www.openoffice.org/about.html http://www.openoffice.org/about.html][http://www.openoffice.org/dev_docs/source/sys_reqs_20.html http://www.openoffice.org/dev_docs/source/sys_reqs_20.html]
+
==How do I get support? ==
 +
AOO comes with an extensive Help system. This is your first line of support for using {{AOo}}.  
  
== How do I get the software? ==
+
To display the full Help system, press {{key|F1}} or select '''Apache OpenOffice Help''' from the Help menu. In addition, you can choose whether to activate tooltips, extended tips, and the Help Agent (using {{menu|Tools|Options|General}}).
You can get the OpenOffice.org installation package in any of these ways:
+
  
* Download a copy from the project’s home page: [http://www.openoffice.org/ http://www.openoffice.org].
+
If tooltips are enabled, place the mouse pointer over any of the icons to see a small box (“tooltip”) with a brief explanation of the icon’s function. For a more detailed explanation, select {{menu|Help|What's This?}} and hold the pointer over the icon.
* Download a copy using the Peer to Peer client, BitTorrent. The instructions are here: [http://distribution.openoffice.org/p2p/ http://distribution.openoffice.org/p2p/].
+
* Purchase a copy on a CD-ROM or other digital form from a third party distributor. The project maintains a listing of distributors; however these distributors are not connected with, nor endorsed by OpenOffice.org:[http://distribution.openoffice.org/cdrom/sellers.html http://distribution.openoffice.org/cdrom/sellers.html].
+
* The OpenOffice.org ''Porting Project'' has links to versions of the software that have been, or are currently being “ported” to run under various operating systems. [http://porting.openoffice.org/index.html http://porting.openoffice.org/index.html.]
+
 
+
== How do I install OpenOffice.org? ==
+
Information on installing and setting up OpenOffice.org on the various supported operating systems is given here: [http://download.openoffice.org/common/instructions.html http://download.openoffice.org/common/instructions.html]
+
 
+
You can also download the more detailed ''Setup Guide'' (in several languages) from [http://documentation.openoffice.org/setup_guide2/index.html http://documentation.openoffice.org/setup_guide2/index.html]
+
 
+
== How do I get support? ==
+
OOo comes with an extensive Help system. This is your first line of support for using OOo.
+
 
+
To display the full Help system, press ''F1'' or select '''OpenOffice.org Help''' from the Help menu. In addition, you can choose whether to activate tooltips, extended tips, and the Help Agent (using '''Tools > Options > General''').
+
 
+
If tooltips are enabled, place the mouse pointer over any of the icons to see a small box (“tooltip”) with a brief explanation of the icon’s function. For a more detailed explanation, select '''Help > What's This?''' and hold the pointer over the icon.
+
  
 
[[Image:documentation_help_menu.png|thumb|''The Help menu'']]
 
[[Image:documentation_help_menu.png|thumb|''The Help menu'']]
  
=== Free online support ===
+
===Free online support ===
The OpenOffice.org community not only develops software, but provides free, volunteer-based support. Users of OOo can get comprehensive online support from community venues such as newsgroups, forums or mailing lists. There are also numerous websites run by users that offer free tips and tutorials.
+
The {{AOo}} community not only develops software, but provides free, volunteer-based support. Users of {{AOo}} can get comprehensive online support from community venues such as newsgroups, forums or mailinglists. There are also numerous websites run by users that offer free tips and tutorials.
  
  
{| border=1 style="border-collapse:collapse;" cellpadding=3
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
! colspan="2" | Free OpenOffice.org support
+
!colspan="2" | Free Apache OpenOffice support
  
 
|-
 
|-
| User FAQ
+
|User FAQ
| [[Documentation/FAQ|Frequently Asked Questions]] for Users
+
|[[Documentation/FAQ|Frequently Asked Questions]] for Users
  
 
|-
 
|-
| Users Mailing List
+
|Users Mailing List
| Free community support provided by a network of hundreds of experienced users. You must be subscribed to post messages. To subscribe, send a blank email to [mailto:sympa@openoffice.org?Subject=subscribe%20users sympa@openoffice.org]
+
|Free community support provided by a network of hundreds of experienced users. You must be subscribed to post messages. To subscribe, send a blank email to [mailto:users-subscribe@openoffice.apache.org?subject=subscribe users subscribe]
  
List archives are here: [http://www.openoffice.org/servlets/SummarizeList?listName=users http://www.openoffice.org/servlets/SummarizeList? listName=users]
+
Listarchives are here:  
 +
https://mail-archives.apache.org/mod_mbox/
  
 
|-
 
|-
| Documentation Project
+
|Documentation Project
| Templates, user guides, how-tos, and other documentation. [http://documentation.openoffice.org/ http://documentation.openoffice.org/]
+
|Templates, user guides, how-tos, and other documentation. [https://www.openoffice.org/documentation/ https://www.openoffice.org/documentation/]
  
 
|-
 
|-
| Native Language Project
+
|Native Language  
| Information, resources, and mail lists in your language. [http://projects.openoffice.org/native-lang.html http://projects.openoffice.org/native-lang.html]
+
|[Edit needed]
  
 
|-
 
|-
| Mac Support
+
|The Apache OpenOffice Forum
| Support for installing and using the Mac OS X (X11 based) port. [http://porting.openoffice.org/mac/support.html http://porting.openoffice.org/mac/support.html]
+
|https://forum.openoffice.org/en/forum/
 
+
|-
+
| The OpenOffice.org Forum
+
| Extensive discussion forum for OpenOffice.org issues from setup to advanced programming features. [http://www.oooforum.org/ http://www.oooforum.org/]
+
 
+
|-
+
| OOo KnowledgeBase
+
| A collection of questions and answers that users can query. [http://mindmeld.cybersite.com.au/ http://mindmeld.cybersite.com.au/]
+
  
 
|}
 
|}
Read more about the support options for OpenOffice.org at:[http://support.openoffice.org/index.html http://support.openoffice.org/index.html]
+
Read more about the support options for {{AOo}} at: [https://www.openoffice.org/support/index.html https://www.openoffice.org/support/index.html]
  
=== Paid support and training ===
+
===Paid support and training ===
Alternatively, you can pay for support services. Service contracts can be purchased from a vendor or consulting firm specializing in OpenOffice.org.  
+
Alternatively, you can pay for support services. Service contracts can be purchased from a vendor or consulting firm specializing in Apache OpenOffice.  
  
OOo is supported by Sun Microsystems, Inc. under the Sun Software Support program, which includes two levels of support that cover extended business hours or around-the-clock service for mission-critical deployments. [http://www.sun.com/service/support/software/openoffice/index.html http://www.sun.com/service/support/software/openoffice/index.html]
 
  
A list of independent consultants and the services they offer, listed alphabetically by region and then by country, is provided on the OpenOffice.org website. [http://bizdev.openoffice.org/consultants.html http://bizdev.openoffice.org/consultants.html]
+
A list of independent consultants and the services they offer, listed alphabetically by region and then by country, is provided on the Apache OpenOffice website. (Edit needed)
  
=== Other resources and addons ===
+
===Other resources and add-ons ===
Several websites provide additional free resources and addons to enhance OpenOffice.org. The following table lists a few of these websites.
+
Several websites provide additional free resources and add-ons to enhance {{AOo}}. The following table lists a few of these websites.
  
  
{| border=1 style="border-collapse:collapse;" cellpadding=3
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
! colspan="2" | Free OOo templates, artwork and other addons
+
!colspan="2" | Free AOO templates, artwork and other add-ons
  
 
|-
 
|-
| OOExtras
+
|OpenOffice.org Macros
| Provides templates, samples and macros in several languages. [http://ooextras.sourceforge.net/ http://ooextras.sourceforge.net/]
+
|A repository for AOO macros and addons, and documentation about writing macros and/or extending {{AOo}}. [https://sourceforge.net/projects/ooomacros/files/ https://sourceforge.net/projects/ooomacros/files/]
  
 
|-
 
|-
| OOoMacros
+
|Open Clip Art Library
| A repository for OOo macros and addons, and documentation about writing macros and/or extending OOo. [http://www.openoffice.org/servlets/SummarizeList?listName=users http://www.ooomacros.org/]
+
|An archive of clip art that can be used for free for any use. [https://openclipart.org/ openclipart.org]
  
 
|-
 
|-
| Open Clip Art Library
+
|Apache OpenOffice Macro Information
| An archive of clip art that can be used for free for any use. [http://documentation.openoffice.org/ http://www.openclipart.org/]
+
|Andrew Pitonyak, the author of ''Apache OpenOffice Macros Explained'', maintains this site which provides extensive documentation on AOO's macro capability. Many good referral links are also provided at: [https://www.pitonyak.org/oo.php https://www.pitonyak.org/oo.php]
 
+
|-
+
| OpenOffice.org Macro Information
+
| Andrew Pitonyak, the author of ''OpenOffice.org Macros Explained'', maintains this site which provides extensive documentation on OOo's macro capability. Many good referral links are also provided at: [http://www.pitonyak.org/oo.php http://www.pitonyak.org/oo.php]
+
  
 
|}
 
|}
  
== What is involved in the initial migration? ==
+
==What is involved in the initial migration? ==
=== Sharing files ===
+
===Sharing files ===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Sharing Files|Sharing Files with Microsoft Office Users]] in this guide for information about opening and saving files of various formats.
+
See [[Documentation/UserGuide/Migration_Guide/Sharing_Files|Sharing Files with Microsoft Office Users]] in this guide for information about opening and saving files of various formats.
  
=== How do I import other files used in Microsoft Office? ===
+
===How do I import other files used in Microsoft Office? ===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Importing Files|Importing other Microsoft Office Files]] in this guide for information about importing custom dictionaries, AutoCorrect entries and AutoText entries into OpenOffice.org.
+
See [[Documentation/UserGuide/Migration_Guide/ImportingFiles|Importing other Microsoft Office Files]] in this guide for information about importing custom dictionaries, AutoCorrect entries and AutoText entries into {{AOo}}.
  
== What changes do I need to make in the way that I work? ==
+
==What changes do I need to make in the way that I work? ==
While the interfaces of OpenOffice.org and Microsoft Office are sufficiently similar to allow immediate productivity, they are not identical. Some functions are based on different underlying concepts. The chapters in this guide will to help you with these differences.
+
While the interfaces of Apache OpenOffice and Microsoft Office are sufficiently similar to allow immediate productivity, they are not identical. Some functions are based on different underlying concepts.The chapters in this guide will to help you with these differences.
  
=== In general what is different in use between Microsoft Office and OpenOffice.org? ===
+
===In general what is different in use between Microsoft Office and Apache OpenOffice? ===
See [[Documentation/OOoAuthors User Manual/Migration Guide/General Differences|General Differences in Use between OpenOffice.org and Microsoft Office]] in this guide first, as it gives an overall view of differences; the other chapters build on the information presented in that chapter.
+
See [[Documentation/UserGuide/Migration_Guide/GeneralDifferences|General Differences in Use between Apache OpenOffice and Microsoft Office]] in this guide first, as it gives an overall view of differences; the other chapters build on the information presented in that chapter.
  
=== What are the specific differences in use between Word and Writer? ===
+
===What are the specific differences in use between Word and Writer?===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Writer and Word|Differences in Use between Writer and Word]] in this guide for specific information related to text documents.
+
See [[Documentation/UserGuide/Migration_Guide/Writer_and_Word|Differences in Use between Writer and Word]] in this guide for specific information related to text documents.
  
=== What are the specific differences in use between Excel and Calc? ===
+
===What are the specific differences in use between Excel and Calc?===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Calc and Excel|Differences in Use between Calc and Excel]] in this guide for specific information related to spreadsheets.
+
See [[Documentation/UserGuide/Migration_Guide/Calc_and_Excel | Differences in Use between Calc and Excel]] in this guide for specific information related to spreadsheets.
  
=== What are the specific differences in use between PowerPoint and Impress? ===
+
===What are the specific differences in use between PowerPointandImpress? ===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Impress and PowerPoint|Differences in Use between Impress and PowerPoint]] in this guide for specific information related to presentations.
+
See[[Documentation/UserGuide/Migration_Guide/Impress_and_PowerPoint | Differences in Use between Impress and PowerPoint]]in this guide for specific information related to presentations.
  
=== How can I change OpenOffice.org to make it work even more like the way I have worked in Microsoft Office? ===
+
===How can I change Apache OpenOffice to make it work even more like the way I have worked in Microsoft Office? ===
See [[Documentation/OOoAuthors User Manual/Migration Guide/Customizing|Customizing OpenOffice.org]] in this guide for information about changing OpenOffice.org to make it work your way. That chapter includes links to macros that were written to help ease the transition.
+
See [[Documentation/UserGuide/Migration_Guide/Customizing|Customizing Apache OpenOffice]] in this guide for information about changing {{AOo}} to make it work your way. That chapter includes links to macros that were written to help ease the transition.
  
=== How do I use the Math Object editor (OpenOffice.org’s equivalent to Equation Editor)? ===
+
===How do I use the Math Object editor ({{AOo}}’s equivalent to Equation Editor)? ===
 
See [[Documentation/OOoAuthors_User_Manual/Writer_Guide/Math_Objects|Math Objects]] in the [[Documentation/OOoAuthors_User_Manual/Writer_Guide|Writer Guide]].
 
See [[Documentation/OOoAuthors_User_Manual/Writer_Guide/Math_Objects|Math Objects]] in the [[Documentation/OOoAuthors_User_Manual/Writer_Guide|Writer Guide]].
  
=== What about that database functionality? ===
+
===What about that database functionality? ===
See [[Documentation/OOoAuthors User Manual/Getting Started/Getting Started with Base|Getting Started with Base]] in the [[Getting Started|Getting Started Guide]], and the [[Documentation/OOoAuthors_User_Manual/Base_Guide|Database Guide]] for details on the new Base component of OpenOffice.org.
+
See [[Documentation/OOo3_User_Guides/Getting_Started/Getting_Started_with_Base|Getting Started with Base]] in the [[Documentation/OOo3_User_Guides/Getting_Started|Getting Started Guide]], and the [[Documentation/OOoAuthors_User_Manual/Base_Guide|Database Guide]] for details on the new Base component of {{AOo}}.
  
=== Is there an equivalent to WordArt? ===
+
===Is there an equivalent to WordArt? ===
 
Yes. See Chapter 15 “Using Fontwork” in the ''Getting Started'' guide.
 
Yes. See Chapter 15 “Using Fontwork” in the ''Getting Started'' guide.
  
== What are the issues when migrating from WordPerfect to Writer? ==
+
==What are the issues when migrating from WordPerfect to Writer? ==
=== Can I open WordPerfect files in OOo? ===
+
===Can I open WordPerfect files in AOO? ===
Yes, a WordPerfect filter is now available in the standard OpenOffice.org installation.
+
Yes, a WordPerfect filter is now available in the standard Apache OpenOffice installation.
 
+
=== What macros are available to make Writer work more like WordPerfect? ===
+
==== Reveal codes ====
+
OpenOffice.org’s Writer does not have underlying codes in the same way that WordPerfect does. But a macro is being written that will allow you to work in a similar way to WordPerfect’s reveal codes. See [http://homepages.paradise.net.nz/hillview/OOo/RevealCodes3.sxw RevealCodes3.sxw] available at [http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/] for more information.
+
 
+
==== Hanging indents ====
+
The hanging indent concept in Writer is quite different from the concept used in WordPerfect. The best approach in OpenOffice.org is to use styles, but to ease the transition, see either [http://homepages.paradise.net.nz/hillview/OOo/AltKeyHandler.sxw AltKeyHandler.sxw] or [http://homepages.paradise.net.nz/hillview/OOo/Indents.sxw Indents.sxw] available from [http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/] for a macro that approximates WordPerfect’s way of implementing hanging indents.
+
  
== How is OpenOffice.org licensed? ==
+
==How is Apache OpenOffice licensed? ==
OpenOffice.org is distributed under the Open Source Initiative (OSI) approved Lesser General Public License (LGPL). The LGPL can be viewed on the OOo website at: [http://www.openoffice.org/licenses/lgpl_license.html http://www.openoffice.org/licenses/lgpl_license.html]
+
Apache OpenOffice is distributed under the Open Source Initiative (OSI) approved Apache Licence Vers. 2, (ALV2). License information can be viewed on the Apache website at: [https://www.apache.org/licenses/LICENSE-2.0.html Apache License Page]
  
For more general information on OOo’s licensing, please refer to: [http://www.openoffice.org/license.html http://www.openoffice.org/license.html].
+
For more general information on AOO’s licensing, please refer to: [https://www.openoffice.org/license.html https://www.openoffice.org/license.html].
  
== What is “open source”? ==
+
==What is “open source”? ==
 
The ideals of open-source software can be explained by the four essential rights, which are embodied within the Free Software Foundation’s ''General Public License ''(GPL):
 
The ideals of open-source software can be explained by the four essential rights, which are embodied within the Free Software Foundation’s ''General Public License ''(GPL):
  
* The right to use the software for any purpose.
+
*The right to use the software for any purpose.
* Freedom to redistribute the software for free or for a fee.
+
*Freedom to redistribute the software for free or for a fee.
* Access to the complete source code of the program (that is, the “blueprints”).
+
*Access to the complete source code of the program (that is, the“blueprints”).
* The right to modify any part of the source, or use portions of it in other programs.
+
*The right to modify any part of the source, or use portions of it in other programs.
  
 
Another view of this philosophy comes from the ''Open Source Definition'':
 
Another view of this philosophy comes from the ''Open Source Definition'':
Line 545: Line 491:
 
For more information on Free and Open Source software, visit these websites:
 
For more information on Free and Open Source software, visit these websites:
  
''Open Source Initiative ''(OSI): [http://www.opensource.org/ http://www.opensource.org]
+
''OpenSource Initiative'' (OSI): [https://www.opensource.org/ https://www.opensource.org]
  
''Free Software Foundation'' (FSF): [http://www.gnu.org/ http://www.gnu.org]
+
''FreeSoftware Foundation'' (FSF): [https://www.fsf.org/ https://www.fsf.org]
  
 
{{CCBY}}
 
{{CCBY}}
'''굵은 글씨'''
+
'''굵은글씨'''

Latest revision as of 12:01, 1 September 2022




What is Apache OpenOffice?

Apache OpenOffice (AOO) is a freely-available, full-featured office productivity suite. It includes the following components.

Writer (word processor)

Documentation writer icon.png
Writer is a feature-rich tool for creating letters, books, reports, newsletters, brochures,and other documents. You can insert graphics and objects from other components into Writer documents. Writer can export files to HTML, XHTML, XML, Adobe’s Portable Document Format(PDF), and several versions of Microsoft Word files. It also connects to your email client.

Calc (spreadsheet)

Documentation calc icon.png
Calc has all of the advanced analysis, charting and decision-making features expected from a high-end spreadsheet. It includes over 300 functions for financial, statistical and mathematical operations among others. The Scenario Manager provides “what if” analyses. Calc generates 2-D and 3-D charts, which can be integrated into other AOO documents. You can also open and work with Microsoft Excel workbooks and save them in Excel format. Calc can export spreadsheets to Adobe’s Portable Document Format (PDF) and to HTML.

Impress (presentation graphics)

Documentation impress icon.png
Impress provides all the common multi-media presentation tools, such as special effects, animation, and drawing tools. It is integrated with the advanced graphics capabilities of the Draw and Math components. Slideshows can be further enhanced with Fontwork’s special effects text, as well as sound and video clips. Impress is compatible with Microsoft’s PowerPoint file format, and can save your work in numerous graphics formats including Macromedia Flash (SWF).

Draw (vector graphics)

Documentation draw icon.png
Draw is a vector drawing tool that can produce everything from simple diagrams or flowcharts to 3-D artwork. Its Smart Connectors feature allows you to define your own connection points. You can use Draw to create drawings for use in any of AOO’s other components, and you can create your own clipart and add it to the Gallery. Draw can import graphics from many common formats and save them in over 20 formats including PNG, HTML, PDF and Flash.

Base (database)

Documentation base icon.png
Base offers tools for day-to-day database work within a simple interface. It can create and edit forms, reports, queries, tables, views and relations, so managing a connected database is much the same as in other popular database applications. Base provides many new features,such as the ability to analyze and edit relationships from a diagram view. Base incorporates HSQLDB as its default relational database engine. It can also used BASE, Microsoft Access, MySQL or Oracle, or any ODBC or JDBC compliant database. Base also provides support for a subset of ANSI-92 SQL.

Math (formula editor)

Documentation math icon.png
Math is AOO’s formula or equation editor. You can use it to create complex equations that include symbols or characters not available in standard font sets. While it is most commonly used to create formulas in other documents, such as Writer and Impress files, Math can also work as a stand-alone tool. You can save formulas in the standard Mathematical Markup Language (MathML) format for inclusion in webpages and other documents not created by AOO.

What are the advantages of Apache OpenOffice?

Here are some of the advantages of Apache OpenOffice over other office suites:

  • No licensing fees. AOO is free for anyone to use and distribute at no cost. Many features that are available as extra cost add-ins in other office suites (like PDF export) are free with AOO. There are no hidden charges, and all future upgrades are free.
  • Open source. You can distribute, copy, and modify the software as much as you wish, in accordance with AOO's Open Source license.
  • Cross-platform. AOO 4.0 runs on several hardware architectures and under multiple operating systems, such as Microsoft Windows, MacOS X, Linux, BSD Unix and Sun Solaris.
  • Extensive language support. AOO’s user interface is available in over 25 languages and the AOO project provides spelling, hyphenation and thesaurus dictionaries in over 70 languages and dialects. AOO also provides support for both Complex Text Layout (CTL)and Right to Left (RTL) layout languages (such as Hindi, Hebrew and Arabic).
  • Consistent user interface. All the components have a similar “look and feel”, making them easy to use and master.
  • Integration. The components of Apache OpenOffice are well integrated with one another.
    • All the components share a common spelling checker and other tools, which are used consistently across the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but enhanced versions in Impress and Draw.
    • You do not need to know which application was used to create a particular file (for example, you can open a Draw file from Writer).
  • Granularity. Usually, if you change an option, it affects all components. However, options can be set at a component level or even document level.
  • File compatibility. AOO includes PDF and Flash export capabilities, as well as support for opening and saving files in many common formats including Microsoft Office, HTML, XML, Word Perfect and Lotus 123 formats.
  • No vendor lock-in. AOO 4.0 uses OpenDocument, an XML(eXtensible Markup Language) file format developed as an industry standard by OASIS (Organization for the Advancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their framework is open and published.
  • You have a voice. Enhancements, software fixes and release dates are community-driven. You can join the community and affect the course of the product you use.

You can read more about Apache OpenOffice, its mission, history, licensing and other organizational information here: https://www.ApacheOpenOffice/about.html

How does Apache OpenOffice compare?

Apache OpenOffice can match and exceed the feature set of competing officesuites. The following table lists the main components of AOO and compares them with their equivalents in two leading office suites,Microsoft Office 2003 (MSO) and WordPerfect Office X3(WP).


Function
Apache OpenOffice
Microsoft Office
WordPerfect Office
Word processor Writer Word® WordPerfect® X3
Spreadsheet Calc Excel® Quattro Pro® X3
Vector Graphics Draw no no
Presentation Graphics Impress PowerPoint® Presentations™ X3
Database Base Access® 1 Paradox® 2
Math or Formula Editor Math yes no

1Professional version only.

2Professional and Student and Teachereditions only.

Features

The following tables list some important features of Apache OpenOffice and compare them with two leading office suites,Microsoft Office (MSO) and WordPerfect X3 (WP).

Styles and formatting

Feature
Apache OpenOffice
Microsoft Office
WordPerfect Office
Navigator
yes
limited1
no
Styles and Formatting window
yes
yes
no
Keyboard support for paragraph styles
yes
yes
no
Support for page, frame, and list styles
yes
no
no
Word completion
yes
Excel only
no
Spelling and language proofing modules
70+
50+2
25
Formula or equation tools
yes
yes
no

1“Outline View” in Word offers a subset of the features of AOO’s Navigator.

2Requires an additional license for the Multilingual User Interface Pack.

Interoperability

Feature
Apache OpenOffice
Microsoft Office
WordPerfect Office
PDF export capability
yes
yes1
yes
Flash export capability
yes
no
yes
XML export capability
yes
yes
yes
OpenDocument XML format
yes
no
no
Import/Export Microsoft Office files
yes
yes
yes
Import WordPerfect files
yes
yes
yes
Import Lotus 123 files
yes
yes
yes
Connect to external databases (MySQL, Oracle, Access, etc.)
yes
yes
yes
Languages available (localizations)
40+
35+
30
Supported operating systems
Windows, macOS, Linux, Solaris
Windows only2
Windows only
Unicode language support
yes
yes
no

1Requires additional third-party software, such as PDF Writer or PDF Converter.2Microsoft Office: Macis not feature compatible with Microsoft Office 2003.

Programmability

Macros are programs which automate tasks and can be embedded in a document. The following table lists the languages available for macro development in each office suite.

Feature
Apache OpenOffice
Microsoft Office
WordPerfect Office
Basic-derived language
OpenBasic
VBA
VBA
Beanshell
yes
no
no
Java
yes
no
no
JavaScript
yes
no
no
Python
yes
no
no

Beyond simple macros, some office suites can be extended to include new features. This capability usually takes the form of plug-ins. In the case of Apache OpenOffice, it can also be done through changes to the source code.

Feature
Apache OpenOffice
Microsoft Office
WordPerfect Office
C and C++
yes
yes
yes
Java
yes
no
no
Python
yes
no
no
Source code available!
yes
no
no

Security

Feature
Apache OpenOffice
Microsoft Office
WordPerfect Office
Digital signatures
yes
yes
yes
Strong encryption
yes
yes
yes
Secure paths for macro execution
yes
yes
no

New features in version 4

Apache OpenOffice 4.0 delivers hundreds of improvements and new features. Here are some of the major enhancements.

What are the minimum requirements?

Apache OpenOffice 4.0 requires one of the following operating systems:

  • Microsoft Windows Windows 2000 (Service Pack 2 or higher), Windows 2003, Windows 7,8, 10 and Windows 11
  • GNU/Linux Kernel version 2.2.13 and glibc 2.4.0 or newer
  • Mac OS X 10.3.x (10.3.5 recommended), Mac OS X 10.4.x, plusX11
  • Solaris version 8 or higher


Some Apache OpenOffice features (wizards and the database component) require that the Java Runtime Environment (JRE) be installed on your computer. Although Apache OpenOffice will work fine without Java-support, some features will not be available. You can download the latest version from https://www.java.com or from https://adoptium.net/.

For a more detailed (and up-to-date) listing of requirements, see: https://www.openoffice.org/dev_docs/source/sys_reqs_20.html

How do I get the software?

You can get the Apache OpenOffice installation package in any of these ways:

How do I install Apache OpenOffice?

Information on installing and setting up Apache OpenOffice on the various supported operating systems is given here: https://www.openoffice.org/download/common/instructions.html

You can also download the more detailed Setup Guide (in several languages) from https://www.openoffice.org/documentation/setup_guide2/index.html

How do I get support?

AOO comes with an extensive Help system. This is your first line of support for using Apache OpenOffice.

To display the full Help system, press  F1  or select Apache OpenOffice Help from the Help menu. In addition, you can choose whether to activate tooltips, extended tips, and the Help Agent (using Tools → Options → General).

If tooltips are enabled, place the mouse pointer over any of the icons to see a small box (“tooltip”) with a brief explanation of the icon’s function. For a more detailed explanation, select Help → What's This? and hold the pointer over the icon.

The Help menu

Free online support

The Apache OpenOffice community not only develops software, but provides free, volunteer-based support. Users of Apache OpenOffice can get comprehensive online support from community venues such as newsgroups, forums or mailinglists. There are also numerous websites run by users that offer free tips and tutorials.


Free Apache OpenOffice support
User FAQ Frequently Asked Questions for Users
Users Mailing List Free community support provided by a network of hundreds of experienced users. You must be subscribed to post messages. To subscribe, send a blank email to users subscribe

Listarchives are here: https://mail-archives.apache.org/mod_mbox/

Documentation Project Templates, user guides, how-tos, and other documentation. https://www.openoffice.org/documentation/
Native Language [Edit needed]
The Apache OpenOffice Forum https://forum.openoffice.org/en/forum/

Read more about the support options for Apache OpenOffice at: https://www.openoffice.org/support/index.html

Alternatively, you can pay for support services. Service contracts can be purchased from a vendor or consulting firm specializing in Apache OpenOffice.


A list of independent consultants and the services they offer, listed alphabetically by region and then by country, is provided on the Apache OpenOffice website. (Edit needed)

Other resources and add-ons

Several websites provide additional free resources and add-ons to enhance Apache OpenOffice. The following table lists a few of these websites.


Free AOO templates, artwork and other add-ons
OpenOffice.org Macros A repository for AOO macros and addons, and documentation about writing macros and/or extending Apache OpenOffice. https://sourceforge.net/projects/ooomacros/files/
Open Clip Art Library An archive of clip art that can be used for free for any use. openclipart.org
Apache OpenOffice Macro Information Andrew Pitonyak, the author of Apache OpenOffice Macros Explained, maintains this site which provides extensive documentation on AOO's macro capability. Many good referral links are also provided at: https://www.pitonyak.org/oo.php

What is involved in the initial migration?

Sharing files

See Sharing Files with Microsoft Office Users in this guide for information about opening and saving files of various formats.

How do I import other files used in Microsoft Office?

See Importing other Microsoft Office Files in this guide for information about importing custom dictionaries, AutoCorrect entries and AutoText entries into Apache OpenOffice.

What changes do I need to make in the way that I work?

While the interfaces of Apache OpenOffice and Microsoft Office are sufficiently similar to allow immediate productivity, they are not identical. Some functions are based on different underlying concepts.The chapters in this guide will to help you with these differences.

In general what is different in use between Microsoft Office and Apache OpenOffice?

See General Differences in Use between Apache OpenOffice and Microsoft Office in this guide first, as it gives an overall view of differences; the other chapters build on the information presented in that chapter.

What are the specific differences in use between Word and Writer?

See Differences in Use between Writer and Word in this guide for specific information related to text documents.

What are the specific differences in use between Excel and Calc?

See Differences in Use between Calc and Excel in this guide for specific information related to spreadsheets.

What are the specific differences in use between PowerPointandImpress?

See Differences in Use between Impress and PowerPointin this guide for specific information related to presentations.

How can I change Apache OpenOffice to make it work even more like the way I have worked in Microsoft Office?

See Customizing Apache OpenOffice in this guide for information about changing Apache OpenOffice to make it work your way. That chapter includes links to macros that were written to help ease the transition.

How do I use the Math Object editor (Apache OpenOffice’s equivalent to Equation Editor)?

See Math Objects in the Writer Guide.

What about that database functionality?

See Getting Started with Base in the Getting Started Guide, and the Database Guide for details on the new Base component of Apache OpenOffice.

Is there an equivalent to WordArt?

Yes. See Chapter 15 “Using Fontwork” in the Getting Started guide.

What are the issues when migrating from WordPerfect to Writer?

Can I open WordPerfect files in AOO?

Yes, a WordPerfect filter is now available in the standard Apache OpenOffice installation.

How is Apache OpenOffice licensed?

Apache OpenOffice is distributed under the Open Source Initiative (OSI) approved Apache Licence Vers. 2, (ALV2). License information can be viewed on the Apache website at: Apache License Page

For more general information on AOO’s licensing, please refer to: https://www.openoffice.org/license.html.

What is “open source”?

The ideals of open-source software can be explained by the four essential rights, which are embodied within the Free Software Foundation’s General Public License (GPL):

  • The right to use the software for any purpose.
  • Freedom to redistribute the software for free or for a fee.
  • Access to the complete source code of the program (that is, the“blueprints”).
  • The right to modify any part of the source, or use portions of it in other programs.

Another view of this philosophy comes from the Open Source Definition:

“The basic idea behind open source is very simple: When programmers can read, redistribute, and modify the source code for a piece of software, the software evolves. People improve it, people adapt it, people fix bugs. And this can happen at a speed that, if one is used to the slow pace of conventional software development, seems astonishing.”

For more information on Free and Open Source software, visit these websites:

OpenSource Initiative (OSI): https://www.opensource.org

FreeSoftware Foundation (FSF): https://www.fsf.org

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).



굵은글씨

Personal tools