open office calc presentation

• Get Apache OpenOffice
• How to upload templates
• Slovenščina

Enhance Apache OpenOffice. Pick your Template.

• Search templates
• Highest rated
• Most popular
• Most recent

Average: 3 ( 1 vote)

Average: 3.3 ( 3 votes)

Bracket - Single elimination (landscape)

No votes yet

Lulu.com CD Front-Insert Face

Average: 3 ( 2 votes)

Business Promotion Letter to Increase Sales of a Hotel

Average: 1 ( 1 vote)

CafePress.com & Lulu.com US Letter Sized Book

Lulu.com landscape sized book.

Recommendation Letter for Scholarship

Average: 3.6 ( 14 votes)

Bracket - Single elimination (Writer, landscape)

Apache OpenOffice® is the free and open productivity suite from the Apache Software Foundation .

Apache OpenOffice features six personal productivity applications: a word processor (and its web-authoring component), spreadsheet, presentation graphics, drawing, equation editor, and database. OpenOffice is released on Windows, Linux and macOS, with more communities joining, including ports for FreeBSD and OS/2. OpenOffice is localized, supporting over 110 languages worldwide.

OpenOffice.org was donated to the Apache Software Foundation (ASF) on June 1, 2011. As with any code base brought to the ASF, OpenOffice.org underwent incubation before graduating to a top-level project on 2012-10-17.

A lot of good information can be found on the Apache OpenOffice user portal , including a brief history of OpenOffice.org .

Announcements ¶

2023-12-22 -- Apache OpenOffice 4.1.15 is released!

• Download Source and SDK
• Download Binaries
• Release Notes

2023-02-27 -- Apache OpenOffice 4.1.14 is released!

2022-07-22 -- Apache OpenOffice 4.1.13 is released!

2022-05-04 -- Apache OpenOffice 4.1.12 is released!

2021-10-06 -- Apache OpenOffice 4.1.11 is released!

2021-05-04 -- Apache OpenOffice 4.1.10 is released!

2021-02-07 -- Apache OpenOffice 4.1.9 is released!

2020-11-10 -- Apache OpenOffice 4.1.8 is released!

2019-09-21 -- Apache OpenOffice 4.1.7 is released!

2018-11-18 -- Apache OpenOffice 4.1.6 is released!

2017-12-30 -- Apache OpenOffice 4.1.5 is released!

2017-10-19 -- Apache OpenOffice 4.1.4 is released!

2016-10-12 -- Apache OpenOffice 4.1.3 is released!

2015-10-28 -- Apache OpenOffice 4.1.2 is released!

2014-08-21 -- Apache OpenOffice 4.1.1 is released!

2014-04-29 -- Apache OpenOffice 4.1.0 is released!

2013-10-01 -- Apache OpenOffice 4.0.1 is released!

2013-07-23 -- Apache OpenOffice 4.0.0 is released!

2013-01-30 -- Apache OpenOffice 3.4.1 now available in Danish, Norwegian, Swedish, Korean, Polish, Basque, Asturian and Scottish Gaelic

• Announcement

2012-10-17 -- Apache OpenOffice graduates from the Apache Incubator

2012-08-23 -- Apache OpenOffice 3.4.1 (incubating) is released!

• Release announcement

2012-05-08 -- Apache OpenOffice 3.4.0 (incubating) is released!

What Are the Advantages and Disadvantages of Open Office?

Microsoft has long dominated the software market, but in recent years, the open source movement has made significant inroads against the Washington-based giant. One of the most successful open source products has been OpenOffice. Apache OpenOffice is the premier open source suite of office-related software. Originally developed by Sun Microsystems, OpenOffice has been through a number of revisions and a number of owners. As of mid 2014, Apache OpenOffice 4.1 was the current release version of the product.

Advertisement

Video of the Day

The primary advantage of using Apache OpenOffice as a productivity suite comes from the cost. OpenOffice is open source software that is free to download and free to use. It includes word processing, spreadsheet, presentation, vector graphic editing and database management components. It's easy for beginners to learn to use, but it is powerful enough to do the advanced tasks experienced users want. It's designed so that the commands and functions you perform in one component of the software work throughout the entire suite.

Disadvantages

There are a number of potential disadvantages to Apache OpenOffice, as well. The primary document format supported by the software is the ODF format, while the most common format in use is the DOC format. OpenOffice can open and edit DOC format files, but they are not its primary medium. Open source software in general has its downside. Without the requirement to create a profitable product, open source software developers might focus more on their own wishes than on the needs of the end user. Open source software also creates a potential for malicious users to introduce bugs and other security risks into the code.

Compared to Microsoft Office

Any discussion of OpenOffice will naturally include a comparison with Microsoft Office, the industry-leading office software suite. Each has strengths over the other. Microsoft Office, for example, has built-in grammar checking tools, while such a tool for OpenOffice requires an add-on. Microsoft Office has more document viewing options, as well as greater diagram-creating capabilities. OpenOffice offers a single interface that provides the user access to the entire suite, while the Microsoft product requires separate applications. OpenOffice also includes robust tools for Web designers who write in HTML.

Technical Support

Technical support for an open source suite of applications isn't quite the same as technical support for a commercial product. Support for Apache OpenOffice comes from the development community, rather than from a single company. This means that bug fixes are often addressed faster because there is no immediate barrier between end users and designers. On the other hand, one-to-one tech support isn't directly available for OpenOffice users the way it is for users of commercial products. This kind of support typically requires a contract agreement with a service provider.

• Apache OpenOffice: Why Apache OpenOffice
• Apache OpenOffice: Apache OpenOffice Product Description
• Entrepreneur Handbook: Open Source Software – The Advantages & Disadvantages
• Tech Soup: Microsoft Office vs. OpenOffice.org
• IdealWare: Comparing Microsoft Office to Open Source Alternatives

Sign up for our daily newsletter

• Privacy Policy
• Advertise with Us

10 OpenOffice Tips and Tricks to Improve Productivity

Apache OpenOffice is a free, open-source office suite that supports user privacy and stores all your work in OpenDocument format (ODF). The software is compatible with popular closed-source office alternatives, such as Microsoft Office, and covers word processing, spreadsheets, presentations, graphics and database applications. Here’s a list of OpenOffice tips that you need to know.

1. Get Acquainted With Extensions

2. change the ui language in openoffice, 3. enable writing aids, 4. customize keyboard shortcuts, 5. create a table of contents, 6. write formulas and expressions, 7. print handouts from your presentation, 8. search the web, 9. send your document as email, 10. try an alternate way of inserting tables, frequently asked questions.

Also read: How to Insert the Degree Symbol in Microsoft Word

If there are features you’d like to use that OpenOffice doesn’t have by default, consider installing an extension for added functionality. Follow the steps below to access the OpenOffice’s extension library from Writer.

Note : some of these extensions haven’t received updates in a while, so they might not be compatible with the latest version of OpenOffice.

• Go to “Tools -> Extension Manager.”

• From the pop-up window that shows up, click the “Get more extensions online” option.

• You’ll be taken to the OpenOffice extension library/ where you can search for various extensions using keywords. Alternatively, you can simply browse.

If you don’t know what to download first, we have a few suggestions:

• Professional Template Pack : with the Pro Template Pack , you get access to a library of professional templates that cover everything from business documents and presentations to posters and press releases. It’s really useful to have around.
• BasicCommentHelper : enable the comments functionality in OpenOffice with the BasicCommentHelper extension. Once installed, add your observations throughout a document, just as you would in Microsoft Word.
• Language Libraries : OpenOffice comes with a large collection of dictionaries that allows you to add more languages so that you can type in your native language.

Also read: How to Convert Google Docs to Microsoft Word (and Vice Versa)

OpenOffice comes with English as its default UI language. However, you can change it to your native language very easily.

• Go to the OpenOffice download page and select your language pack from the drop-down menu. Press “Download language pack.”

• Install it on your device.
• Navigate to “Tools -> Options.”

• From the left side menu, select “Language Settings -> Languages.”

• Select another UI language from the “User interface” drop-down menu on the right.
• Restart the Apache OpenOffice software to have the UI language changed.

If you’re not using your native language in OpenOffice, you might need spellcheck, hyphenation, a thesaurus and other similar features to help you with your writing.

• Navigate to “Tools -> Options -> Language Settings -> Writing Aids” for a list of available language modules.

• Click the top Edit button for “Available language modules” to see which tools are installed for the current language.
• Use the drop-down list to see which languages are installed.

• If you’re not seeing your language, click “Get more dictionaries online.”

Also read: How to Add Your Own Custom Color in LibreOffice

OpenOffice offers a wide range of predefined keyboard shortcuts, but you can also make your own. Assign different keys for different functionalities and get the job done without touching the mouse.

• Open a document in OpenOffice.
• Navigate to “Tools -> Customize.”
• Switch to the “Keyboard” tab at the top to find a list of shortcuts.

• Select individual software such as Writer or apply it globally using the OpenOffice option at the top.
• To change what a key combination does, find it in the list and press the “Modify” button.

• From the “Functions” section select what the key combination will trigger instead. For instance, you can have Shift + 8 trigger the creation of an HTML document.

Also read: How to Change Margins on Google Docs

If you’re working on a lengthy document, having a table of contents may come in handy, as it will allow readers to skim through the document quickly. Using OpenOffice, you can create a table of contents with a click of a button.

Before creating a table of contents, add some headings to your document to create a structure.

• Locate heading styles by going to “Format -> Styles and Formatting.”

• Double-click on one of the options that appear in the pop-up window to add your headings.

• Click where you want the table of contents to appear.
• Navigate to the “Insert -> Indexes and Tables” option.

• On the “Insert Index/Table” page, set the number of levels (or heading numbers) you want to include. Change the “Evaluate up to level” setting if you do not want all of them.

• Ensure that the “Outline” checkbox is marked and click the “…” button next to it. If the button appears grayed out, check the “Additional Styles” option.

• Select one of the various styles to customize your table of contents.
• Click “OK” in the main tab, and your table of contents should appear in your document.
• If you decide to add new content to your document later, the table of contents won’t update automatically. To update it, right-click on your table of contents and select the “Update Index/Table” option. The new headings should populate your table.

Also read: How to Add a Written Signature to Google Docs

OpenOffice has very robust support for writing special characters and formulas, and inserting them into a document is very simple.

• Navigate to “Insert -> Special Character.”

• Find the special character you want in the small window that pops up. If you select several, you will see them all displayed at the bottom of the window, and they will all be inserted.

• Writing formulas is a bit more complex than adding special characters. First, go to “Insert -> Object -> Formula.”

• This will open an editing window at the bottom, a box where you’ll be writing your equation in the document, and the “Floating” windows where you will add your elements.

• Select from the various items in “Elements” to add functions, multiplications, operators, and operations such as addition, subtraction or Boolean.
• To change the “a” and “b” variables, click on each in the equation box in the document. Once you’re finished writing your equation, click anywhere outside.

Tip : use the Formula Reference Tables to type in your equations quickly and efficiently.

Also read: How to Password Protect Your Excel Workbook or File

Handouts can offer a quick overview of your presentation. If you print your presentation directly, each slide will take a page, which is inefficient. With handouts, however, you can get two to six slides on a page.

• Open a presentation and click on the “Handout” tab above the slide view.

• In the “Layouts” tab on the right side, choose the number of slides you want per page.

• The default page layout is Landscape. If you want Portrait (vertical), choose “Format -> Page” and select “Portrait.”
• To add horizontal lines for people to take notes, you can use the line tool to draw a set of three to four lines by the first slide.

• To add a page number at the bottom of each piece of paper (not every slide), use the “Text” tool to draw a text box at the bottom of the page and type the word “Page.”

• Go to “Insert -> Fields -> Page Number” to add an automatically incrementing page number.

Also read: How to Move a Column in Microsoft Excel

You can use OpenOffice to search for any URL and keyword from your document.

• Navigate to “View -> Toolbars -> Hyperlink Bar.” Click on it, and you should see a new bar appear at the top of your document.

• Whenever you want to search the Web for a certain term that appears in your document, highlight the word(s) in the text.

• Press on the binoculars icon in the toolbar and select a search engine. You only get a few options, but Google is included.
• This will open search results of your highlighted keyword(s) in your default browser.
• Alternatively, you can use the URL bar at the top to go to a site directly from OpenOffice.

Also read: How to Find and Remove Duplicates in Excel

You can use OpenOffice to send documents directly from the program. This feature will be convenient if you need to send multiple emails a day.

• Click on “Files -> Send.”

• You have several options, including sending “Document as e-mail” and “E-mail as OpenDocument text.”

• After clicking any of the options above, OpenOffice will open your default mail client with the document as an attachment. This technique doesn’t work if you have a web-based email client like Gmail. You must install a native email client like Thunderbird or Mailspring to solve the issue.

In OpenOffice, you can also insert tables by using a series of hyphens (-) or tabs separated by plus (+) signs. The plus signs are used to indicate column dividers, while hyphens (or tabs) are used to outline the width of a column.

To make sure this trick works, check that the function is enabled.

• Go to “Tools -> Autocorrect,” and in the “Options” tab, make sure the “Create table” option is checked.

• Go to “Format -> AutoCorrect” and if “While Typing” is not enabled, click on it.

• Write (or copy/paste) something like this in OpenOffice: +—————–+—————+——+

• Press Enter and to instantly create the table.

Also read: How to Change Gmail Name on Mobile and PC

Does OpenOffice Impress support animations?

Yes. OpenOffice Impress has excellent support for element animation and page transitions. Do note that if you import a Microsoft Office presentation file, Impress may not recognize the animation.

Can OpenOffice fully replace Microsoft Office?

Depending on your needs, the OpenOffice suite might offer just enough for you to complete your tasks. However, you should keep in mind that some Microsoft Office features don’t have a substitute in OpenOffice. On the bright side, you might be able to add some of these missing options to OpenOffice via extensions.

How do I convert a Word document to OpenOffice format?

Right-click on the Word document in question and find “Open with.” Select OpenOffice to open the Word file. If the document is not formatted properly, you can format it manually. Next, click on the “File -> Save As” option, then select ODF text document (.odt) to save it as such. Alternatively, you can use one of the many online file converters, such as Convertio .

Image credit: Amy Hirschi via Unsplash . All screenshots taken by Hrishikesh Pathak.

Our latest tutorials delivered straight to your inbox

Developer and writer. Write about linux and web.

• Accessories
• Entertainment
• PCs & Components
• Wi-Fi & Networks
• Newsletters
• Digital Magazine – Subscribe
• Digital Magazine – Info
• Smart Answers
• Back to School
• Best laptops
• Best antivirus
• Best monitors
• Laptop deals
• Desktop PC deals

When you purchase through links in our articles, we may earn a small commission. This doesn't affect our editorial independence .

Apache Open Office review: The original Office alternative

Expert's Rating

• Excellent compatibility with Office formats
• Familiar Office-like interface
• No native cloud storage
• Doesn’t support real-time collaboration

Our Verdict

Open Office has the essential features you need to work with Office formats, but its lack of cloud support makes it unsuited for collaboration.

Best Prices Today: Open Office

Open Office was the first legitimate free contender to Microsoft Office, though it has ceded that spotlight in recent years to alternatives like Google Docs, Sheets, and Slides, and its own spinoff product Libre Office. The open source suite includes word processing (Write), spreadsheets (Calc), presentation (Impress), and database management (Base) programs, along with drawing and math apps that don’t have a direct Microsoft corollary.

Open Office works with most Microsoft formats including DOCX, XLS, PPT, and XML. It’s free to use on Windows, Mac, and Linux platforms.

This review is part of our  roundup   of  best Microsoft Office alternatives . Go there for details on competing products and buying advice.

If you still remember how Microsoft Office looked circa 2003, Open Office’s interface will seem eerily familiar. The component programs make no concessions to the trendy ribbon interface, using only old-school menus and toolbars. That’s good news if you’re still sore over Microsoft’s decade-old UI makeover, but it can take some readjusting if you’re now accustomed to tabbing around your document and spreadsheet programs.

Open Office has excellent compatibility with Office formats and can export to PDF from all three apps.

By default, Open Office uses the Open Document standard for native files, but you can change it to save to Microsoft formats, and it can read and write existing Word, Excel, and PowerPoint files. It does so flawlessly most of the time, even with complexly formatted documents like resumes and multi-column newsletters. Occasionally, it will hiccup as when it removed all the embedded images from a Word doc I had open. But those instances usually only require minor tweaks to correct. You can also export files to PDF from all three programs.

Where Open Office diverges from Microsoft’s productivity suite is in collaboration. MS Office’s tight integration with OneDrive and Outlook allows you to easily share and work on files with others without leaving the respective program. Open Office supports document review features like commenting and track-changes, but it has no native cloud storage or email program. It does, however, offer an extension that lets you connect to dozens of third-party cloud storage providers including Box and Google Drive, and the Open Office programs can be configured to work with select open source email clients like Mozilla Thunderbird.

Standout features

• Excellent Microsoft Office compatibility
• Familiar, Microsoft-like interface

Missing features

• Native cloud storage and email support
• Mobile apps

Apache Open Office is best for:

If you just need to work with Microsoft Office formats, and you don’t mind what some would consider a dated interface, Open Office has all the comprehensive formatting and functionality you need. If you need to collaborate with others on those files, though, there are other office alternatives that make it much easier.

• Creating a new presentation

• Parts of the main Impress window
• Working with views
• Formatting a presentation
• Slide masters and styles
• Working with slide masters
• Adding and formatting text
• Creating tables
• Adding graphics, spreadsheets, and other objects
• Setting up and running the slide show

This section describes how to set up a new presentation. The settings selected here are general: they apply to all the slides.

Planning a presentation

The first thing to do is to decide what you are going to do with the presentation. For example, putting a group of digital photos together in a presentation requires very little planning. However, using a presentation to increase the knowledge of others about your topic requires much more planning.

You need to ask and answer many questions before you begin creating a presentation. If you are not acquainted with creating presentations, the answers will be more general. Those who have created a variety of presentations in the past will want to have more specific answers.

Who is to see the presentation? How will it be used? What is the subject matter? What should be in its outline? How detailed should the outline be? Will an audio file be played? Is animation desirable? How should the transition between slides be handled? These are some of the many questions that should be asked, answered, and written down before creating the presentation. Sound and animation are more advanced topics and are explained in the Impress Guide .

Again, it is not always necessary at this point to have specific answers to every question. Making an outline is extremely important. You may already know exactly what some of the slides will contain. You may only have a general idea of what you want on some of the slides. That is alright. You can make some changes as you go. Change your outline to match the changes you make in your slides.

The important part is that you have a general idea of what you want and how to get it. Put that information on paper. That makes it much easier to create the presentation.

Using the Presentation Wizard

You can start Impress in several ways:

• From the OOo Welcome screen, if no component is open.
• From the system menu or the OOo Quickstarter. Details vary with your operating system; see Chapter 1 (Introducing openOffice.org) for more information.
• From any open component of OOo. Click the triangle to the right of the New icon on the main toolbar and select Presentation from the drop-down menu or choose File > New > Presentation from the menu bar.

When you start Impress, the Presentation Wizard appears.

• Select Empty Presentation under Type . It creates a presentation from scratch.

• Click Next . The example below shows the Presentation Wizard step 2 as it appears if you selected Empty Presentation at step 1. If you selected From Template , an example slide is shown in the Preview box.

• Choose a design under Select a slide design . The slide design section gives you two main choices: Presentation Backgrounds and Presentations . Each one has a list of choices for slide designs. If you want to use one of these other than <Original>, click it to select it.
• The types of Presentation Backgrounds are shown in the example. By clicking an item, you will see a preview of the slide design in the Preview window. Impress contains three choices under Presentations : < Original >, Introducing a New Product , and Recommendation of a Strategy .
• <Original> is for a blank presentation slide design.
• Both Introducing a New Product and Recommendation of a Strategy have their own prepackaged slide designs. Each design appears in the Preview window when its name is clicked.

• Select how the presentation will be used under Select an output medium. Most often, presentations are created for computer screen display. Select Screen .
• Click Next . The Presentation Wizard step 3 appears.

• Select the desired slide transition from the Effect drop-down menu.
• Select the desired speed for the transition between the different slides in the presentation from the Speed drop-down menu. Medium is a good choice for now.
• Click Create. A new presentation is created.

• CC-BY License
• Getting Started (Documentation)
• View source

Personal tools

• Recent changes
• Download AOO
• Documentation
• What links here
• Related changes
• Special pages
• Permanent link
• Page information

In other languages

• This page was last modified on 14 July 2018, at 21:33.
• Content is available under ALv2 unless otherwise noted.
• Privacy policy
• About Apache OpenOffice Wiki
• Disclaimers

• Gehigarriak
• Hautatutako arloak

Apache OpenOffice Calc

The all-purpose spreadsheet

Calc is the spreadsheet program you’ve always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.

Advanced DataPilot technology makes it easy to pull in raw data from corporate databases; cross-tabulate, summarize, and convert it into meaningful information.

Natural language formulas let you create formulas using words (e.g. “sales - costs”).

The Intelligent Sum Button inserts a sum function or a subtotal automatically, depending on context.

Wizards guides you through choosing and using a comprehensive range of advanced spreadsheet functions, or download templates from our Extensions repository for ready-made spreadsheet solutions.

Styles and Formatting makes it easy to apply flexible cell formatting options, including freely rotating contents, templates, backgrounds, borders, and many more. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work.

Scenario Manager allows “what if …” analysis at the touch of a button - e.g. compare profitability for high / medium / low sales forecasts.

Calc ’s solver component allows solving optimization problems where the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells.

Encourage collaborative working on spreadsheets with Calc ’s multiple users support. By sharing a spreadsheet other users can easily add their data to the spreadsheet. The spreadsheet owner can then easily integrate the new data with a few clicks. This collaboration feature helps avoid editing conflicts.

Save your spreadsheets in OpenDocument format, the new international standard for office documents. This XML based format means you’re not tied in to Calc . You can access your spreadsheets from any OpenDocument compliant software.

Of course, you are free to use your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are still locked into Microsoft products. If all they want to see is your results, then use Portable Document Format (.pdf) - no need to buy any extra software. Since version 3.0, Calc has been able to read .xlsx files created with Microsoft Office 2007 or Microsoft Office 2008 for Mac OS X.

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.

Community announces the Getting Started Guide 24.8

The book is released on time for the new libreoffice 24.8 release..

The community members of the LibreOffice documentation team are happy to announce the immediate availability of the Getting Started Guide 24.8 , at the same time of the release of LibreOffice Community 24.8, our latest major update.

The book is for anyone who wants to get up-to-speed quickly with LibreOffice 24.8 . It introduces Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor), and Base (database) as well as important information on common features and settings of all modules.

Olivier Hallot , LibreOffice Documentation Coordinator at The Document Foundation, said:

We sought a companion product for the recently released LibreOffice Community 24.8 in order to enable users to download the software and have the appropriate software documentation readily available. We are offering a complete solution of software and documentation to anyone who wants to deploy LibreOffice in offices and organizations or for individual use.

The guide is an effort of a multi-regional, multi-language documentation team of advanced users that collaborates on the update and authoring of new features introduced with LibreOffice Community 24.8. Special thanks to Jean Hollis Weber (AU), Claire Wood (UK), Steve Fanning (UK), Luciana Motta (BR), B. Antonio Fernández (ES), Olivier Hallot (BR), Timothy Brennan Jr. (BR), Vítor Ferreira (BR), Rafael Lima (BR), Rob Thornton (USA), Edward Olson (USA), Peter Schofield (PL) .

Leave a Reply Cancel reply

You must be logged in to post a comment.

Privacy Preference Center

Consent management.

Privacy Policy

Thank you for visiting our website and your interest in our services and products. As the protection of your personal data is an important concern for us, please click on the "More information" link to access our Privacy Policy page - which will open in a separate browser tab - where we explain what information we collect during your visit to our website, how it is processed, and whether or how it may be used. Once you have carefully read our Privacy Policy page, close the browser tab to return to this page and click on the "Save Preferences" button under this text to acknowledge it, close the dialogue and return to the website. We take all the necessary technical and organisational security measures to protect your personal data from loss and misuse. Your data is stored in a secure operating environment that is not accessible to the public.

• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

Apache OpenOffice Product Description

Compatible with other major office suites, Apache OpenOffice is free to download, use, and distribute. Download it now , and get:

• Writer a word processor you can use for anything from writing a quick letter to producing an entire book.
• Calc a powerful spreadsheet with all the tools you need to calculate, analyze, and present your data in numerical reports or sizzling graphics.
• Impress the fastest, most powerful way to create effective multimedia presentations.
• Draw lets you produce everything from simple diagrams to dynamic 3D illustrations.
• Base lets you manipulate databases seamlessly. Create and modify tables, forms, queries, and reports, all from within Apache OpenOffice.
• Math lets you create mathematical equations with a graphic user interface or by directly typing your formulas into the equation editor.

Why Apache OpenOffice?

Apache OpenOffice is synonymous with quality :

• The roots of Apache OpenOffice go back twenty years, creating a mature and powerful product
• Many millions of users
• Independent reviewers around the world have recommended the product
• With a fully open development process, Apache OpenOffice has nothing to hide - the product stands or falls on its reputation

Apache OpenOffice is easy to use :

• The software looks and feels familiar and is instantly usable by anyone who has used a competitive product
• It’s easy to change to Apache OpenOffice - the software reads most file types of major competitors
• Few language barriers - if it’s not yet available in your language, the chances are it will be soon
• Apache OpenOffice is supported by a global community of friendly volunteers, happy to provide assistance to newcomers and advanced users alike

Apache OpenOffice is free software :

• You may download Apache OpenOffice completely free of any license fees
• Install it on as many PCs as you like
• Use it for any purpose - private, educational, government and public administration, commercial…
• Pass on copies free of charge to family, friends, students, employees, etc.

Apache OpenOffice is standards compliant :

• The first software package in the world to use OASIS OpenDocument Format (ISO/IEC 26300) as its native file format.

Find out more or try it today !

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.

Creating hyperlinks

• Inserting hyperlinks
• Editing hyperlinks
• Saving Writer documents as web pages
• Saving Calc spreadsheets as web pages
• Saving Impress presentations as web pages
• Saving Draw documents as web pages

When you type text (such as a website addresses or URL) that can be used as a hyperlink, and then press the spacebar or the Enter key , OOo automatically creates the hyperlink and applies formatting to the text (usually a color and underlining). If this does not happen, you can enable this feature using Tools > AutoCorrect Options > Options and selecting the URL Recognition option.

If you do not want OOo to convert a specific URL to a hyperlink, choose Edit > Undo Insert from the menu bar or press Control+Z immediately after the formatting has been applied.

In Writer and Calc (but not Draw or Impress), you can also change the Internet link character style or define and apply new styles to selected links.

You can also insert hyperlinks using the Navigator and the Hyperlink dialog, and you can modify all hyperlinks using the Hyperlink dialog as described in this section.

Using the Hyperlink dialog

• Internet : the hyperlink points to a web address, normally starting with http://
• Mail & News : the hyperlink opens an email message that is pre-addressed to a particular recipient
• Document : the hyperlink points to another document or to another place in the current document
• New document : the hyperlink creates a new document

The top right part of the dialog changes according to the choice made for the hyperlink category in the left panel. A full description of all the choices and their interactions is beyond the scope of this chapter. Here is a summary of the most common choices.

For an Internet hyperlink, choose the type of hyperlink (Web, FTP, or Telnet), and enter the required web address (URL).

For a Mail and News hyperlink, specify whether it is a mail or news link, the receiver’s address, and for email, also the subject.

For a Document hyperlink, specify the document path (the Open File button opens a file browser) or leave this blank if you want to link to a target in the same document. Optionally specify the target in the document (for example a specific slide). Click on the Target in Document icon to open the Navigator where you can select the target; or if you know the name of the target, you can type it into the box.

For a New Document hyperlink, specify whether to edit the newly created document immediately ( Edit now ) or just create it ( Edit later ), enter the file name, and select the type of document to create (text, spreadsheet, and so on). Click the Select Path button to open a file browser and choose where to store the file.

The Further settings section in the bottom right part of the dialog is common to all the hyperlink categories, although some choices are more relevant to some types of links.

• Set the value of Frame to determine how the hyperlink will open. This applies to documents that open in a Web browser.
• Form specifies if the link is to be presented as text or as a button. A hyperlink button is a type of form control. See Chapter 15 of the Writer Guide for more information.
• Text specifies the text that will be visible to the user. If you do not enter anything here, OOo uses the full URL or path as the link text. Note that if the link is relative and you move the file, this text will not change, though the target will.
• Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink.
• Events button : click this button to open the Assign Macro dialog and choose a macro to run when the link is clicked. See Chapter 13 (Getting Started with Macros) for more information.

• CC-BY License
• Getting Started (Documentation)
• View source

Personal tools

• Recent changes
• Download AOO
• Documentation
• What links here
• Related changes
• Special pages
• Permanent link
• Page information

• This page was last modified on 14 July 2018, at 21:31.
• Content is available under ALv2 unless otherwise noted.
• Privacy policy
• About Apache OpenOffice Wiki
• Disclaimers