OpenOffice.org 3.0 Novell Edition

October 2008

1 Overview

The information in this file pertains to OpenOffice.org 3.0 Novell® Edition.
2 Installing OpenOffice.org Novell Edition

If you are using an installation CD, insert it, and if AutoRun is enabled, the installer will start automatically. Otherwise, in the top folder of the CD, run setup.exe to install OpenOffice.org. If you have unpacked the software from a zip archive, run setup.exe in the top folder.

In addition to the user interface (UI) in English (US) you can optionally install UI languages for one or more of: Afrikaans, Arabic, Bengal, Catalan, Chinese (Simplified), Chinese (Traditional), Czech, Danish, Dutch, English (UK), Finnish, French, German, Greek, Gujarati, Hebrew, Hindi, Hungarian, Italian, Japanese, Korean, Marathi, Norwegian (Bokmål), Norwegian (Nynorsk), Polish, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Russian, Slovak, Spanish, Swedish, Tamil, Xhosa, and Zulu.

By default the English UI and the UI for the language of your Windows installation will be installed, plus the UI for your locale's language, if different from either of those. You can modify which UI languages are installed by choosing a Custom installation. All the UI localizations are not of the same quality � some have only partial coverage and English strings may appear instead.

Follow the on-screen installation instructions.
3 Enhancements in OpenOffice.org Novell Edition for Windows

The Novell Edition of OpenOffice.org contains enhancements and bug fixes that are not included in the Sun or community builds. These include:
Enhanced Support for Microsoft Office File Formats

OpenOffice.org supports import and export of Microsoft Office file formats, even taking advantage of compatible fonts to match document length. Transparent document sharing makes OpenOffice.org the best choice if you are deploying it in a mixed Linux/Windows environment.
3.1 Calc

Improved Excel compatibility for certain built-in functions (e.g. CELL, INFO, INDIRECT etc.), hyperlinks and filters, improved ergonomics, 'merge and center' fix. Adds support for 'R1C1' style addresses. Performance enhancement on certain text functions such as SEARCH. Natural sorting option in cell range sorting.
Data Pilots

Data Pilots are interoperable with MS Pivot Tables(TM). Novell OO.o substantially improves the Data Pilot feature, making it possible to edit pilots after creation.
Excel VBA Macro Interoperability

The Novell Edition of OpenOffice.org eases the migration of many macros from Microsoft Excel. Although not all macros can be successfully migrated, this interoperability offers more than the standard edition, which does not support migration of macros.

The Novell Edition has support for event handlers for the toolbox controls, for instance CommandButton1_Click, CommandButton1_MouseMove etc. Support is also provided for some Workbook events such as Workbook_Open and Worksheet_SelectionChanged.
Excel compatibility

The Novell Edition supports multiple formula syntax for cell and cell range addresses and formula expressions: Calc A1 - the traditional format (default), Excel A1, and Excel R1C1. Text numbers and dates are interpreted as numbers or dates when appropriate, similar to how Excel interprets text as numbers or dates. Our version allows toggling of cell grid lines per sheet, while the Sun version only allows global toggling across all sheets. Many details of the Calc user interface have been tweaked to make migration from Excel to OpenOffice.org easier.
3.2 Writer
Navigator

The Writer navigator allows a tree view of the document structure, giving a slicker navigation experience. We have also improved change-tracking interoperability, improved HTML export, and improved printing of fonts. For CJK locales we auto-generate bold and italic fonts where they are (commonly) missing.
Writing aids

The Novell Edition has spelling dictionaries for more than 50 languages and hyphenation support and thesauri for more than 30 languages built-in.
3.3 Fonts

For the Novell Edition of OpenOffice.org, Novell licensed fonts from Agfa Monotype which are metrically identical and visually compatible with some of the key Microsoft fonts. This allows OpenOffice.org to match fonts when opening documents originally composed in Microsoft Office, and very closely match pagination and page formatting. The fonts have different names, but are transparently mapped on export and import to their equivalents
3.4 ODMA Integration

The Novell Edition of OpenOffice.org for Windows includes improved integration with ODMA (Open Document Management Architecture) services, for example with GroupWise®. If you have the GroupWise client installed on the machine, OpenOffice.org will offer to open documents from GroupWise, or save documents in GroupWise. If you want to open or save documents using the normal Windows file dialog instead, click the �Use Application Dialog� button when offered to select a document from GroupWise or to save a document into GroupWise. To avoid the GroupWise dialogs altogether, toggle the corresponding button in the Tools->Options->General dialog.


I also added Novell's OpenOffice Translator 2 to the upload. The OpenXML Translator provides support for opening AND SAVING Microsoft* OpenXML-formatted word processing documents (.docx), spreadsheet documents (.xslx) and slideshow documents (.pptx) in OpenOffice.org. 

This version of the suite is compatible with all extensions available from http://extensions.services.openoffice.org


Enjoy!