OpenOffice Calc is the spreadsheet part of the OpenOffice software package. Calc is similar to Microsoft Excel, with almost the same abilities.Calc is capable of opening and saving spreadsheets in Microsoft Excel's file format. This step by step tutorial on creating basic formulas in OpenOffice Calc using cell references, including the order of operations followed by the program.
3.4 Beta 1 / 12 April 2011; 7 years ago ( 2011-04-12) Written in and,,,,,, 143.4 (3.3.0 en-US Windows.exe without JRE) (s) (ISO/IEC 26300) Available in 121 languages under the and GNU (OpenOffice.org 2 Beta 2 and earlier) (OpenOffice.org 2 and later) Website See 28 April 2011 at the. OpenOffice.org ( OOo), commonly known as OpenOffice, is a discontinued. It was an open-sourced version of the earlier, which acquired in 1999 for internal use. OpenOffice included a (Writer), a (Calc), a application (Impress), a application (Draw), a (Math), and a application (Base). Its default was the Format (ODF), an / standard, which with OpenOffice.org. It could also read a wide variety of other file formats, with particular attention to those from Microsoft Office.
Sun open-sourced the OpenOffice in July 2000 as a competitor to, releasing version 1.0 on 1 May 2002. In 2011, the then-owner of Sun, announced that it would no longer offer a commercial version of the suite and soon after donated the project to the. Apache renamed the software. Other active successor projects include (the most actively developed ) and (commercial, only for macOS). OpenOffice.org was primarily developed for, and, and later for, with to other. It was distributed under the version 3 (LGPL); early versions were also available under the (SISSL).
See also: OpenOffice.org originated as, a office suite developed by German company from 1985 on. In August 1999, Star Division was acquired by for US$59.5 million, as it was supposedly cheaper than licensing for 42,000 staff. On 19 July 2000 at, Sun Microsystems announced it would make the source code of StarOffice available for download with the intention of building an open-source development community around the software and of providing a free and open alternative to Microsoft Office. The new project was known as OpenOffice.org, and the code was released as open source on 13 October 2000. The first public preview release was Milestone Build 638c, released in October 2001 (which quickly achieved 1 million downloads ); the final release of OpenOffice.org 1.0 was on 1 May 2002. OpenOffice.org became the standard office suite on Linux and spawned many derivative versions. It quickly became noteworthy competition to Microsoft Office, achieving 14% penetration in the large enterprise market by 2004.
The file format – in a archive, easily machine-processable – was intended by Sun to become a standard interchange format for office documents, to replace the different binary formats for each application that had been usual until then. Sun submitted the format to the (OASIS) in 2002 and it was to form the standard in 2005, which was ratified as 26300 in 2006. It was made OpenOffice.org's native format from version 2 on. Many governments and other organisations, particularly given there was a free implementation of it readily available. Development of OpenOffice.org was sponsored primarily by Sun Microsystems, which used the code as the basis for subsequent versions of StarOffice. Developers who wished to contribute code were required to sign a Contributor Agreement granting joint ownership of any contributions to Sun (and then Oracle), in support of the StarOffice business model. This was controversial for many years.
An alternative Public Documentation Licence (PDL) was also offered for documentation not intended for inclusion or integration into the project code base. After in January 2010, continued developing OpenOffice.org and StarOffice, which it renamed Oracle Open Office, though with a reduction in assigned developers. Oracle's lack of activity on or visible commitment to OpenOffice.org had also been noted by industry observers. In September 2010, the majority of outside OpenOffice.org developers left the project, due to concerns over Sun and then Oracle's management of the project and Oracle's handling of its open source portfolio in general, to form (TDF). TDF released the in January 2011, which most soon moved to. In April 2011, Oracle stopped development of OpenOffice.org and fired the remaining Star Division development team.
Its reasons for doing so were not disclosed; some speculate that it was due to the loss of mindshare with much of the community moving to LibreOffice while others suggest it was a commercial decision. In June 2011, Oracle contributed the trademarks to the. It also contributed Oracle-owned code to Apache for relicensing under the, at the suggestion of (to whom Oracle had contractual obligations concerning the code), as IBM did not want the code put under a license. This code drop formed the basis for the project.
Governance [ ] During Sun's sponsorship, the OpenOffice.org project was governed by the Community Council, comprising OpenOffice.org community members. The Community Council suggested project goals and coordinated with producers of derivatives on long-term development planning issues. Both Sun and Oracle are claimed to have made decisions without consulting the Council or in contravention to the council's recommendations, leading to the majority of outside developers leaving for LibreOffice. Oracle demanded in October 2010 that all Council members involved with the Document Foundation step down, leaving the Community Council composed only of Oracle employees. Naming [ ] The project and software were informally referred to as OpenOffice since the Sun release, but since this term is a held by Open Office Automatisering in since 1999, OpenOffice.org was its formal name. Due to a similar trademark issue (a Rio de Janeiro company that owned that trademark in Brazil), the version of the suite was distributed under the name BrOffice.org from 2004, with BrOffice.Org being the name of the associated local nonprofit from 2006. (BrOffice.org moved to LibreOffice in December 2010.
) Features [ ] OpenOffice.org 1.0 was launched under the following: “ The mission of OpenOffice.org is to create, as a community, 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. ” Components [ ] Icon Title Description Writer A analogous to. Calc A analogous to.
Impress A analogous to. Impress could export presentations to (SWF) files, allowing them to be played on any computer with a Flash player installed.
Presentation templates were available on the OpenOffice.org website. Draw A comparable in features to the drawing functions in Microsoft Office. Math A tool for creating and editing mathematical formulas, analogous to. Formulas could be embedded inside other OpenOffice.org documents, such as those created by Writer.
Base A analogous to. Base could function as a front-end to a number of different database systems, including Access databases (JET), data sources, and. Psd To Pdf Converter. Base became part of the suite starting with version 2.0. Was the included database engine. From version 2.3, Base offered report generation via.
The suite contained no, or analogous to, despite one having been present in StarOffice 5.2. Such functionality was frequently requested. The OpenOffice.org Groupware project, intended to replace Outlook and, spun off in 2003 as OpenGroupware.org, which is now. The project considered bundling and for OpenOffice.org 3.0. Supported operating systems [ ] The last version, 3.4 Beta 1, was available for versions of Service Pack 2 or later, (IA-32 and x64), and 10.4 or later, and the version of Solaris. The latest versions of OpenOffice.org on other operating systems were: • (): v1.0.3 •: v1.1.2 •: v2.1 •: v1.1.5 •: v2.0.1 • and: v2.4.3 Fonts [ ] OpenOffice.org included,, the (from 2.4) and the fonts (from 3.2).
Versions up to 2.3 included the fonts. OpenOffice.org also used the default fonts of the running operating system.
Fontwork is a feature that allows users to create stylized text with special effects differing from ordinary text with the added features of gradient colour fills, shaping, letter height, and character spacing. It is similar to used by Microsoft Word. When OpenOffice.org saved documents in Microsoft Office file format, all Fontwork was converted into WordArt. Extensions [ ] From version 2.0.4, OpenOffice.org supported third-party extensions.
As of April 2011, the OpenOffice Extension Repository listed more than 650 extensions. Another list was maintained by the. OpenOffice Basic [ ]. Main article: OpenOffice.org included OpenOffice Basic, a similar to Microsoft (VBA). OpenOffice Basic was available in Writer, Calc and Base.
OpenOffice.org also had some Microsoft VBA macro support. Connectivity [ ] OpenOffice.org could interact with databases (local or remote) using ODBC (), JDBC () or SDBC (StarOffice Database Connectivity). File formats [ ] From Version 2.0 onward, OpenOffice.org used ISO/IEC as its native format.
Versions 2.0–2.3.0 default to the ODF 1.0 file format; versions 2.3.1–2.4.3 default to ODF 1.1; versions 3.0 onward default to ODF 1.2. OpenOffice.org 1 used as its native format. This was contributed to and OpenDocument was developed from it. OpenOffice.org 1.1 logo The preview, Milestone 638c, was released October 2001.
OpenOffice.org 1.0 was released under both the LGPL and the SISSL for Windows, Linux and Solaris on 1 May 2002. The version for Mac OS X (with interface) was released on 23 June 2003. OpenOffice.org 1.1 introduced One-click Export to PDF and Export presentations to Flash (.SWF). It also allowed third-party addons. OpenOffice.org was used in 2005 by to illustrate what it saw as the limitations of open-source software. OpenOffice.org 2 [ ] Work on version 2.0 began in early 2003 with the following goals (the 'Q Product Concept'): better interoperability with Microsoft Office; improved speed and lower memory usage; greater capabilities; better integration, particularly with GNOME; a more usable database; digital signatures; and improved.