Office Home & Student - Professional Office Suite 2012 - Word & Excel Compatible 

Writer - For all your documents

Compatible with Microsoft Word

WRITER has everything you wouldexpect from a modern, fully equipped wordprocessor or desktop publisher. It's simple enough for a quick memo, powerful enough to create complete books with contents, diagrams, indexes, etc. You're free to concentrate on your message - while WRITER makes it lookgreat.

The Wizards takes all the hassle out ofproducing standard documents such as letters, faxes, agendas, minutes, or carrying out more complextasks such as mail merges. You are of course free to create your own templates,or download templates from our Extensionsrepository. Styles andFormatting puts the power of style sheetsinto the hands of every user.

Trap typing mistakes on the fly with the AutoCorrect dictionary, which can check your spelling as you type. If you need to use different languages in your document - WRITER can handle that too. Reduce typing effort with AutoComplete, which suggests common words and phrases to complete what you are typing. Text frames and linking give you the power to tackle desktop publishing tasks for newsletters, flyers, etc. laid out exactly the way you want them to be. Increase the usefulness of your long, complex documents by generating a table of contents or indexing terms, bibliographical references, illustrations, tables, and other objects.

Save your documents in OpenDocument format, the new international standard for office documents. This XML based format means you're not tied in to WRITER. You can access your documents from any OpenDocument compliant software. WRITER can of course read all your old Microsoft Word documents, or save your work in Microsoft Word format for sending to people who are still locked into Microsoft products. From version 3.0 WRITER can also open .docx files created with Microsoft Office 2007 or Microsoft Office 2008 for Mac OS X.

Calc - The all-purpose spreadsheet

Compatible with Microsoft Excel

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, summarise, 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.

Impress - More power to your presentations

Compatible with Microsoft PowerPoint

IMPRESS is a truly outstanding tool for creating effective multimedia presentations. Your presentations will stand out with 2D and 3D clip art, special effects, animation, and high-impact drawing tools.

Master Pages simplify the task of preparing your materials. Save even more time by downloading templates from our Extensions repository. A complete range of Views are supported: Drawing / Outline / Slides / Notes / Handouts to meet all the needs of presenters and audiences, plus an optional multi-pane view to put all the tools at your fingertips.

IMPRESS supports multiple monitors, so that presenters can look at something else while presenting their slides on a projector. Make the most of this With the free Presenter Console Extension, which lets you see your next slides as well as the time and the speaker notes.

IMPRESS has a complete range of easy-to-use drawing and diagramming tools to spice up your presentation. 'Park' your most commonly used drawing tools around your screen ready for single-click access. Slide show Animation and Effects bring your presentation to life. Fontworks provides stunning 2D and 3D images from text. Create lifelike 3D images with astounding speed and response.

Save your presentations in OpenDocument format, the new international standard for office documents. This XML based format means you're not tied in to IMPRESS. You can access your presentations from any OpenDocument compliant software. Of course, you are free to use your old Microsoft PowerPoint presentations, or save your work in PowerPoint format for sending to people who are still locked into Microsoft products. Alternatively, use IMPRESS's built-in ability to create Flash (.swf) versions of your presentations.

Draw - The powerful graphics package

DRAW - from a quick sketch to a complex plan, DRAW gives you the tools to communicate with graphics and diagrams. With a maximum page size of 300cm by 300cm, DRAW is powerful tool for technical or general posters, etc.

'Park' your most commonly used drawing tools around your screen ready for single-click access. Use Styles and Formatting to put all your graphics styles at your finger tips. Manipulate objects, rotate in two or three dimensions; the 3D controller puts spheres, rings, cubes, etc. at your disposal. Arrange objects: group, ungroup, regroup, and edit objects while grouped. Sophisticated rendering let you create photorealistic images with your own texture, lighting effects, transparency, perspective, and so on.

Smart connectors make short work of flowcharts, organisation charts, network diagrams, etc. Define your own 'glue points' for connectors to 'stick' to. Dimension lines automatically calculate and display linear dimensions as you draw. Use the picture Gallery for clipart; create your own art and add it to the Gallery.

Save your graphics in OpenDocument format, the new international standard for office documents. This XML based format means you're not tied in to DRAW. You can access your graphics from any OpenDocument compliant software. Import graphics from all common formats (including BMP, GIF, JPEG, PNG, TIFF, and WMF). Use DRAW's free ability to create Flash (.swf) versions of your work.

Base - Desktop management system

Compatible with Microsoft Access

BASE is a fully featured desktop database management system, designed to meet the needs of a broad array of users, from

• just tracking your personal CD collection, to
• producing a corporate monthly departmental sales report.

BASE offers wizards to help users new to database design (or just new to BASE) to create Tables, Queries, Forms and Reports, along with a set of predefined table definitions for tracking Assets, Customers, Sales Orders, Invoices and much more.

When a personal use database is all you need, BASE offers the full HSQL relational database engine, configured for single user, with the data stored right in the BASE file, as well as native support for dBase flat files.

For power users in the enterprise, BASE delivers native support drivers for a variety of multi-user database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, support for JDBC and ODBC standard drivers allows you to connect to virtually any existing database.

BASE integrates seamlessly into the rest of the Open Office suite applications, for example:

• supplying address book data for mail merge in WRITER using the industry standard LDAP protocol, or common address book formats such as Microsoft Outlook, Microsoft Windows and Mozilla;
• creating linked data ranges in CALC files for data pilot analysis or as the basis for charts.

Math - Create equations and formulae for your documents

MATH is a component for mathematical equations. It is most commonly used as an equation editor for text documents, but it can also be used with other types of documents or stand-alone. When used inside WRITER, the equation is treated as an object inside the text document. Similarly, one can also insert these into other Open Office programs like CALC and IMPRESS.

Using MATH, there are three main ways of entering a formula:

Type markup in the equation editor.

Right-click on the equation editor and select the symbol from the context menu.

Select a symbol from the Selection toolbox.