Openoffice

The StarOffice code, originally developed by the German company StarDivision as part of a proprietary project, was purchased by Sun Microsystems in 1999 . The free version of StarOffice 5.2 was released in August 1999.

On July 19, 2000, Sun Microsystems announced the launch of StarOffice source code simultaneously under the LGPL and SISSL licenses with the intention of creating an open source community around software. The new project became known as OpenOffice.org, and its site began to exist on October 13, 2000 .

In early 2003, work began on version 2.0. The following goals were set:

• improved interaction with Microsoft Office;
• improved performance - reduced memory requirements and increased speed;
• scripting language improvement;
• improved integration, in particular with GNOME ;
• easier to use database interface: front-end for creating reports, forms and queries;
• new built-in SQL database;
• improved user interface .

The beta version was released on March 4, 2005 .

On September 2, 2005, Sun announced its abandonment of SISSL ^[28] . As a result, the OpenOffice.org community has announced that it will no longer support dual licensing of office programs, and future versions will only be released under the LGPL license ^[29] .

The formal public release of OpenOffice.org 2.0 took place on October 20, 2005 ^[30] . Eight weeks after the release, an update was released, OpenOffice.org 2.0.1. It corrected non-critical errors and had new features.

Starting with the release 2.0.3, OpenOffice.org changed the frequency of releases from 18 months to the release of updates, improvements, and bug fixes every three months ^[31] .

The stable version of OpenOffice.org 3.0 was released on October 13, 2008. At the same time, the development of version 2.x continued for some time: the last two releases occurred after the release of version 3.0 ^[32] .

OpenOffice.org developers have long been rumored about discontent, which resulted in complaints about the "extreme inflexibility and lack of real leaders" in the project. It was reported that the structure of the project needs to be improved, an approach is needed that is much less tied to the principle of top-down leadership and freezes the hands of developers who want to participate in the project ^[14] . On September 28, 2010, leading developers of OpenOffice.org announced the creation of a new non-profit organization, The Document Foundation, with the goal of continuing the development of an office suite in the form of a LibreOffice project, independent of Oracle ^[15] . In October 2010, it was announced that the most popular Linux-based distribution, Ubuntu, abandoned OpenOffice and switched to LibreOffice ^[16] .

StarOffice

Sun has funded the development of OpenOffice.org to use as the basis for its commercial proprietary StarOffice application. Versions of StarOffice, starting with 6.0, were based on the source code of OpenOffice.org with some additional proprietary components, including:

• Additionally included fonts (mostly East Asian ).
• Adabas D Database;
• Additional document templates;
• Clip art ;
• Sort for Asian languages;
• Additional file filters;
• Tools to simplify migration (in Enterprise Edition);
• Utilities for transferring macros (in Enterprise Edition);
• Utilities for managing configurations (in Enterprise Edition).

OpenOffice.org, in turn, borrowed many functions from the original StarOffice, on which the OpenOffice.org XML file format was also based , which has been replaced with OpenDocument from version 2.

The package includes common for all applications:

• macro recording system
• startup acceleration means by preloading.

In OpenOffice.org version 1.0, the default file format used was OpenOffice.org XML . Starting with version 2.0, the open OpenDocument format based on it is used.

The OpenOffice.org API is based on the Universal Network Objects ( UNO ) component model.

Starting with version 2.0.4, OpenOffice.org supports XUL extensions in the .oxt format, which are easily added in the same way as it is organized in Mozilla Firefox . Many extensions are available on the official website ^[33] .

The most interesting and fairly popular extensions:

• MySQL Connector for OpenOffice.org - MySQL database driver. It allows you to easily and quickly make queries in the database ^[34] .
• Sun Report Builder is an extension for creating reports from a database with flexible settings and a convenient interface ^[35] .
• CompPad - allows you to do mathematical and engineering calculations in the form of entering mathematical expressions using the equation editor (see also: OpenOffice.org Math ) ^[36] .
• Language Tool is an extension for grammar checking in Writer. Implemented the ability to check for Russian, English, German, Polish and other languages ^[37] .
• Typography for LLC - extension allows you to bring the text in accordance with typographic standards (quotation marks, dashes, extra spaces) in Writer ^[38] .
• AltSearch is an extension for improving search options and replacing text in Writer. Supports regular expressions ^[39] .

OpenOffice.org is often one of the first software products to be installed on enterprise computers when migrating to free or free software.

Among major Russian organizations using OpenOffice.org are Rostelecom since 2007 ^[40] , the Pension Fund of the Russian Federation and the Federal Bailiff Service since 2009 ^[41] .

According to a study conducted by the German company Webmasterpro.de using its FlashCounter Statistics Service ^[42] in early 2010, OpenOffice.org and its derived office suites are installed on 21% of German computers ^[43] .

In recent years, European countries have been actively implementing OpenOffice.org as the main office suite for government organizations. For example, in 2008, the German Foreign Ministry installed OpenOffice.org on their desktops ^[44] , the transition to Belgian Justice Ministry OpenOffice.org was completed ^[45] , and in 2009, the French police reported savings thanks to Open Source applications (in their including OpenOffice.org) ^[46] , the transition to the OpenOffice.org administration of Amsterdam ^[47] and a number of Belgian cities ^[48] was announced.

There are third-party projects - branches or modifications that exist for various reasons.

• LibreOffice is an independent branch of OpenOffice with a freer development policy. It appeared due to the disagreement of some developers with the Oracle policy on project development control. For the development of LibreOffice , the independent non-profit organization The Document Foundation was created , which at the end of October 2010 transferred 33 developers, leaving OpenOffice.org . This project, in particular, includes the achievements of the Go-oo branch, which merged with LibreOffice .
• IBM Lotus Symphony merged with Apache OpenOffice.org.
• BrOffice.org - The purpose of the assembly is the official distribution of the OpenOffice.org package in Brazil. The assembly is aimed not only at residents of this particular country, but also at users from other Latin American countries. At the end of 2010, the developers announced that all available developments will go in favor of LibreOffice . In response, LibreOffice provides synchronized output to BrOffice.org.
• OpenGroupware.org is a set of extension programs for sharing OpenOffice.org documents, calendars, notebooks, working with e-mail, instant messaging, and providing shared access to various teamwork applications .
• OOExtras is an attempt to systematize the creation and exchange of document templates and other useful additions ^[49] .
• A set of Perl extensions is available through CPAN , which allows processing OpenOffice.org documents with external programs ^[50] . These libraries do not use the OpenOffice.org API. They interact with OpenOffice.org files directly, using Perl language file compression / decompression mechanisms, XML access and UTF-8 encoding modules.
• Portable OpenOffice.org is a version of OpenOffice.org designed to work from a USB drive ^[51] .
• OOo4Kids - designed to facilitate the use of the package for educational purposes.
• OxygenOffice Professional is an extended version of OpenOffice.org based on Go-oo .
• Ulteo offered free online access to all OpenOffice.org Online applications from any computer without the need to install software ^[52] .
• InfraOffice.pro is a commercial development of the Russian company Infra-Resource, which also produces its own (somewhat modified for Russian users) non-commercial assemblies OpenOffice.org. The commercial version is positioned as a solution intended for organizations and enterprises working with documents containing confidential information, in particular personal data . In fact, it is a build of the original OpenOffice.org with enhanced security checks. The licensing scheme is deliberately brought into external compliance with the licensing schemes of commercial software products distributed in Russia in order to eliminate buyers ’problems with regulatory authorities that verify the licensed cleanliness of the software used. Version 3.3 was the last to be released; the i-rs.ru company website has not been available since December 2013 [1] .

• Kostromin V.A. OpenOffice.org is an open office for Linux and Windows. - SPb. : BHV-Petersburg, 2005 .-- S. 272. - ISBN 5-94157-266-2 .
• The basics of working in OpenOffice . - M .: Open Systems, 2007.
• OpenOffice.org 2. User Guide - SPb. : BHV-Petersburg, 2007 .-- 320 p. - ISBN 978-5-94157-590-9 .
• OpenOffice.org pro for the professional. - 2nd, rev. and add. - M .: DMK Press, 2008 .-- 448 p. - ISBN 978-5-94074-427-6 .
• Pitonyak E. OpenOffice.org pro Automation of work. - M .: DMK Press, 2008 .-- 512 p. - ISBN 978-5-94074-441-2 .
• Khakhaev I.A., Mashkov V.V., Gubkina G.E. et al. OpenOffice.org: Theory and Practice . - M .: ALT Linux, Beanom. Laboratory of Knowledge, 2008. - 318 p. - ISBN 978-5-94774-891-8 .
• Kozodaev R., Majugin A. OpenOffice.org 3. Complete user guide . - SPb. : BHV-Petersburg, 2009 .-- S. 704. - ISBN 978-5-9775-0385-3 .
• Andrew Pitonyak. OpenOffice.org pro for programmers. In 4 parts. Part I. Concept, Forms, Handlers ( Electronic Edition ) = Useful Macro Information For OpenOffice By Andrew Pitonyak / Per. from English - A.N. Zaimskikh ( cc by-nc-nd ). - 2nd ed., Rev. - M .: Infra-Resource, 2011. - P. 119. Archived on September 26, 2011. Archived September 26, 2011 on Wayback Machine
• Andrew Pitonyak. OpenOffice.org pro for programmers. In 4 parts. Part II Language (Ed.) = Useful Macro Information For OpenOffice By Andrew Pitonyak / Transl. from English - A.N. Zaimskikh ( cc by-nc-nd ). - 2nd ed., Rev. - M .: Infra-Resource, 2011. - P. 119. (unavailable link)
• Andrew Pitonyak. OpenOffice.org pro for programmers. In 4 parts. Part III. Macros Calc and Writer (Ed.) = Useful Macro Information For OpenOffice By Andrew Pitonyak / Per. from English - A.N. Zaimskikh ( cc by-nc-nd ). - 2nd ed., Rev. - M .: Infra-Resource, 2011. - P. 179 p. (Unavailable link)
• Andrew Pitonyak. OpenOffice.org pro for programmers. In 4 parts. Part IV Examples (Ed.) = Useful Macro Information For OpenOffice By Andrew Pitonyak / Per. from English - A.N. Zaimskikh ( cc by-nc-nd ). - 2nd ed., Rev. - M .: Infra-Resource, 2011. - P. 161. (unavailable link)
• D. Chernov. OpenOffice.org pro. Calc. Directory of functions . - M .: Infra-Resource, 2011. - P. 531. (unavailable link)

• Official site.
• OpenOffice.org Wiki Encyclopedia.
• OpenOffice.org project at SourceForge.net .
• OpenOffice in the Open Directory Project Link Directory (dmoz)
• User Support Forum
• Accessible and just about OpenOffice.org.
• The formed list of free extensions for OOo. (eng.)
• Installing and configuring OpenOffice in an Active Directory domain (Russian)