Apache OpenOffice is a free, open-source office suite for Windows, macOS and Linux. It combines word processing, spreadsheets, slide presentations, drawing, databases and equation editing in a desktop package. The components share tools for tasks such as formatting and spelling, while each provides controls suited to a different kind of office document.
Writer documents
Writer handles both short correspondence and longer publications. Styles control the appearance of text throughout a document, while templates provide a starting layout for recurring work. For books and reports, Writer can generate a table of contents, indexes and references to illustrations, tables and other objects.
Text frames arrange content on the page. Linking frames lets text flow between them, supporting layouts such as newsletters and flyers. Mail merge combines a document with recipient data to produce personalized correspondence, and wizards assist with documents such as letters and agendas.
During editing, Writer can check spelling in different languages, correct typing mistakes and suggest completions for words and phrases. Comments appear beside the page, with colors distinguishing their authors. Writer also exports documents to HTML or PDF, including PDF/A.
Spreadsheet analysis with Calc
Calc organizes numbers, text and formulas in spreadsheets. Its function wizard helps construct calculations, and the sum button can insert either a total or a subtotal according to the selected data. Cell formatting controls borders, backgrounds and text orientation, allowing labels and calculated results to remain distinguishable in a report.
For larger data sets, DataPilot takes raw records, including data from databases, and groups them into cross-tabulated summaries. Instead of reading each record individually, a user can examine totals across categories. Base can supply linked data ranges to Calc for this analysis or for charts.
OpenOffice also includes two different ways to investigate a spreadsheet model. Scenario Manager stores alternative sets of values for comparison, such as different sales forecasts. Solver works toward an optimum value in a selected cell while observing constraints defined through other cells. Shared spreadsheets let contributors enter data and allow the owner to integrate their changes.
Impress slides
Impress builds presentations from slides containing text, graphics and other media. Master Pages establish shared slide designs, while drawing tools, text effects and animation control individual slide content. The editing views separate slide layout from an outline of the presentation, speaker notes and audience handouts.
When presenting with more than one screen, Impress can display the slide show on a projector while keeping the Presenter Screen on the presenter’s display. That screen includes upcoming slides, speaker notes and the time.
Draw diagrams
Draw works with graphical objects for diagrams, plans and posters. Shapes can be rotated, grouped and edited within a group, while styles apply consistent formatting to graphics. Smart connectors attach to defined glue points on objects, giving flowcharts and organization charts connections tied to their shapes. Dimension lines calculate and display linear measurements within a drawing.
The component also includes three-dimensional shapes and controls for their lighting, textures, transparency and perspective. Existing pictures can be imported in formats including PNG, JPEG, TIFF and WMF. The Gallery holds reusable artwork and can accept the user’s own graphics for use in later documents.
Base databases
Base provides tables, queries, forms and reports for working with structured records. Wizards help create these elements, and predefined table definitions cover subjects such as customers, assets and invoices. A form provides an interface for entering records; queries select data, and reports present it as a formatted output.
For a local personal database, Base can store the data inside its own file using an embedded HSQL relational database engine. This arrangement is intended for a single user. Base can also connect to external database systems through supported connections and JDBC or ODBC drivers. Those connections let OpenOffice work with data held elsewhere, including supplying address information for Writer mail merges.
Math equations
Math creates formatted mathematical expressions for documents. Equations can be entered as markup, assembled from symbols in the Elements toolbox or built through the editor’s context menu. Math works on its own or inserts an equation as an object in Writer, Calc or Impress, allowing mathematical notation to sit alongside prose, spreadsheet content or presentation material.
Apache OpenOffice file formats
OpenOffice saves its documents in OpenDocument formats, including ODT for text and ODP for presentations. Opening a suite document launches the appropriate component, and information can be transferred between components using their shared tools.
Writer, Calc and Impress can import Microsoft Office documents and save in Microsoft Office formats. Writer reads DOCX files, and Calc reads XLSX files, alongside older Word and Excel documents. Native OpenDocument files retain an editable working copy, while PDF export in Writer and Calc provides an additional distribution format.





