Home > Articles > Operating Systems, Server > Linux/UNIX/Open Source

  • Print
  • + Share This
This chapter is from the book

What's New in StarOffice and OpenOffice

StarOffice 6.0 and OpenOffice.org 1.0 are fairly different from StarOffice 5.2. Key differences are that the unified desktop is gone, Schedule Mail and StarBase are gone, and the focus groups they did on usability were taking good notes. There's more detail on those and other changes in the following sections.

Compatibility and Migration

StarOffice 5.2, StarOffice 6.0, and OpenOffice.org all play nicely together—you don't need to uninstall any of them. Just be sure to uninstall StarOffice 6.0 BETA before you do any 6.0 GA installation.

You can open 5.2 files in StarOffice 6.0 or OpenOffice.org 1.0, plus save new files back to 5.2. There's an AutoPilot for mass import from 5.2.

Migration is pretty good; it doesn't do everything but does take care of customization and mail. See Chapter 3, Migrating From StarOffice 5.2, on page 47.

Removed Applications and Features

The new StarOffice 6.0 and OpenOffice.org are leaner and trimmer than the somewhat overburdened 5.2 release. This section gives you a quick overview of what's out, and how to compensate for a few of the removals.

What's Gone or Really Different

They took out:

  • The whole integrated desktop thing, including Explorer and Beamer and some associated features.

  • FTP through Explorer.

  • Image as a separate application, though most of the features are still present. Just click on the raster image once or twice in any of the other applications and the image editing toolbar and menus will appear.

  • Mail, though you can export your mail and address book, and connect to an existing address book like Netscape or Outlook.

  • Schedule, including Palm Pilot.

  • Creating databases (though you can still connect to a variety of databases through ODBC, JDBC, etc.). See Removal of Database Creation Ability, Except Adabas on page 12. Adabas is still included in StarOffice, but not OpenOffice.org.

  • Support for creating frames in Web.

  • The Pack feature for presentations. It was removed because the files are so small they don't need packing. The Impress Player standalone program was also removed.

Removal of Database Creation Ability, Except Adabas

Instead of creating and maintaining a proprietary StarOffice database format (.sdb), StarOffice Base 6.0 works with common database connection standards like JDBC and databases like dBase. You can still create an Adabas database from StarOffice.

You can still create database tables, queries and forms, though this varies a bit depending on the underlying method of data storage.

New Application-Wide Features

Here's a somewhat detailed list of what's new. Not a lot is new that will affect how you use the specific features—it's more a case of structure and underpinnings that changed to make the whole experience better.

XML file format Remember creating Impress and Writer files that were over 2 MB before you even got going? That's over. You can create a Writer file that's a couple kilobytes per page. Formatting'll kick it up, but it's still really impressive. You'll have to really work hard to get even a 1 MB file.

SVG and EPS Think Illustrator is the only application for creating cool vector graphics that scale well? Think again. EPS rendering and reading is better, and you can export drawings to SVG, Scalable Vector Graphics, an XML-based format.

Font stuff There are new "metrically compatible" TrueType Microsoft Windows core fonts. Font substitution is better. You can set up font substitution with a new improved algorithm that makes the matching better, including across platforms.

Asian font support It's got Unicode support, Ruby text, and double-byte character support. The Asian version of StarOffice, by the way, is StarSuite. Supported fonts are:

  • Japanese: HG Mincho Light J
  • Chinese Simplified: MSung Light SC
  • Chinese Traditional: MSung Light
  • Korean: HY MyeongJo Light K

Image editing features in all applications Click on any GIF or other raster object and the editing toolbar, formerly only in Image, appears.

and the editing toolbar, formerly only in Image, appears.

Gallery The Gallery of pictures and sounds from 5.2 was moved from the Explorer/Beamer area to Tools > Gallery. It's got a whole lot more in it now. You can add to the existing themes, which you couldn't before, and make your own new themes of images and sounds.

The Gallery feature is present in OpenOffice.org but smaller.

Password encryption The XML-based file format also supports password encryption for text documents and spreadsheets. Passwords are stored as encrypted hash values. When saving files to the old binary format, passwords arn't encrypted. However, when you load a document from a former version, the password will be encrypted again.

Standard address book support You don't have your old 5.2 address book but you can connect to the one you use for mail, or other address books. The AutoPilot steps you through connecting to your address book.

Improved HTML export You can define the text encoding for the HTML export choosing from a variety of character sets, including Unicode, using the new Character Set dialog box in the HTML Compatibility dialog box.

MathML equation support Supports exports and imports of the W3 XML format.

Enhanced cut and paste The Paste button on the Function bar has a drop-down menu where you choose whether you want to paste in the text or object's original format or in a special format. They're the same options you get when you choose Edit > Paste Special.

Better undo/redo You can undo a lot farther back than before; set up the number of undo steps by choosing Tools > Options > program > General.

Writer and Web

Better labels You can modify existing label brands and types and save them as your own label format; includes the latest Avery label specifications.

Section protection enhanced You can assign different passwords to individual sections. In previous StarOffice version, you could only use one password for all sections. Choose Insert > Section > Format > Section > Protect Record.

Password protection for recording editing changes The Records feature is typically used to make changes visible when two or more people collaborate on one document. Choose Edit > Changes > Protect Records.

Improved numbering Restart the numbering of lines with every new page. Choose Tools > Line Numbering.

Negative indents You can set negative (left or right) indents to paragraphs and tables, and specify the first line indent independently from the left indent of a paragraph. Choose Format > Paragraph > Indents & Spacing.

For tables you can also set negative values for the alignment from left. This lets you align tables independently of the page setup margins.

Hyphenation Define the minimal number of characters for hyphenation by choosing Tools > Options > Language Settings > Writing Aids.

Vertical text Want to write something down the side of your page? You got it. There are now vertical versions of the three Draw text creation tools, available in Writer through the Show Drawing Tools menu.


ROMAN and ARABIC functions Convert a value between 0 and 3999 to a Roman style, or convert a text that represents a Roman number into a value (between 0 and 3999).

Additional new functions The new functions are:

  • MIRR: Calculate the modified internal rate of return for a series of cash flows with interest rates for investments and reinvestments.

  • CELL: Provide information about content, formatting or location of a specific cell.

  • ISPMT: Calculate the interest of a credit or investment with constant redemption rates.

  • Analysis Addin: Provide new analysis functionality and improved Excel import.

Import HTML tables into spreadsheets Insert data from external sources (like linked areas or WebQueries). Choose Insert > External Data.

Sort options Specify language- and locale-dependent sort options. The default sort option depends on the system language setting and locale. Choose Data > Sort > Options.

Matrix arrays Improved complex scientific calculations. The number of elements that can be used in a matrix array, has been increased. In former versions this number was limited to 16384 elements per matrix, the new limit is 512k elements.

New print options Suppress output of empty pages: If this option is active, pages that don't contain cell contents or drawing objects are not printed. Cell attributes (like borders or background color) are an exception and don't count as content. Print only selected sheets: If this option is active, choosing All in the print dialog prints only selected sheets.

Improved calculation time and use less memory The maximum string length in formulas has been increased from 255 bytes to 64KB.

Improved operations Perform multiple operations with greater flexibility. This feature now extends to formulas that contain references to other formulas. A multiple operation is no longer restricted to act only on the formula selected in the dialog box. Instead, cell addresses that are indirectly referred to are replaced in every formula encountered during the calculation of a multiple operation.

Improved percentage calculations The percent sign operator is recognized in formulas and the result is displayed formatted as a percent value if appropriate. The percent sign operator divides the preceding subexpression by 100. This helps with Excel conversion.

Improved recognition of English date formats This is in addition to the default formats set by the system language, when importing a text file into Calc. This enables you to import formats such as 12-Mar-01 independent of the format used by system language. Choose File > Open > Text filter.

Improved Import and export of 16-bit Unicode text files Choose File > Open or File > Save As. and select the Text CSV format.

Improved display of line breaks Solve the problem of having different line breaks appear on print and on screen when you select the line break alignment option for cells. Using this option shows line breaks as they appear in print on-screen.

Hyphenate text in cells This option is when used with the Line Break wrap option.

Database Access and Data Source Creation

You can't create new databases anymore, except with Adabas. You can create data sources, just StarOffice hookups to a stored source of data, that connect to something as simple as an address book, a spreadsheet, or a text file. So yes, you can create new data sources, plus you can connect via JDBC, etc. to industry standard databases like Oracle. See Chapter 35, Creating and Modifying Data Sources, on page 869.

Connect to data sources instead of making them Instead of creating and maintaining a proprietary StarOffice database format (.sdb), StarOffice Base 6.0 only works with data sources. StarOffice Base 6.0 can connect and administer a wide variety of data sources and provide data access to all StarOffice components. Choose Tools > Data Sources and name new data sources, and use them in your documents. Build connections to existing data sources, specify (Calc or Microsoft Excel) spreadsheet documents as data sources, design and edit database tables, define new queries or edit existing ones, and create links to remote data sources.

Administration You can also copy tables and queries between data sources, and copy a query as a table.

Import your StarOffice 5.2 (or earlier) databases The Database Import AutoPilot will store your existing StarOffice queries, forms, and reports in the new DataAccess.xml configuration file. Form documents will be stored as regular documents.

Assign a database table to a combo or list box Pick up data through a field.

New form events Before reloading: Called before a reload on the form is executed. Before unloading: Called before the form is unloaded. Previously, these events could only be used with a scripting language. Form Functions (on the Main toolbar) > Form Properties > Events.

Edit table indexes This component has been completely rewritten. A new Index Design button on the Table Design toolbar gives you one-click access to Indexes dialog box. Right-click a table in the Data Sources browser and select Edit Table from the context.

UTF-8 character suite support This support does not extend to ADO data sources (which don't have a character set), and dBase data sources.

Draw, Impress, and Image-Editing Features

Rotate meta files Used to be, you couldn't rotate metafiles, just bitmaps. Now you can.

Maximum size for cacheing Set an upper limit (in KB) for the total graphics cache size as well as cache a single graphic object. If the size of one object exceeds this predefined size, the graphics output is not cached, which means that the graphic is directly rendered on-screen every time you move or access the graphic. Choose Tools > Options > StarOffice > General.

Vertical text Want to write something down the side of your page? You got it. There are now vertical versions of the three Draw text creation tools, available in Writer as well through the Show Drawing Tools menu.

Printing options for graphics and gradients The new options include the following; to get to them, choose Tools > Options > StarOffice > Print.

  • Reduced Transparency: Treat all transparent objects as non-transparent.

  • No transparency: Always reduces transparency completely.

  • Reduce gradients: Decreases the number of gradient steps to the real number set when the gradient was defined.

  • Reduce bitmaps: Prints transparent bitmaps at the maximum resolution (in dpi). Convert colors to grayscale renders output in grayscale.

EPS and SVG export Create both formats by exporting from Draw.

  • + Share This
  • 🔖 Save To Your Account

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020