Putting office suites to the test
File Formats
Apache OpenOffice uses version 1.0 of the Open Document Format (ODF) standardized in 2006 as its default file format. The office suite supplies a decent number of conversion filters, as well: The Writer word processor can import and export all current Microsoft Word formats, in addition to simple text formats. However, in the practical test, OpenOffice fell short in this respect. Although the word processor did import sample documents in the older Microsoft Word format (.doc
extension), the outcome remained unsatisfactory, and the entire layout of the integrated images and graphics of each document was changed.
The font processor in OpenOffice is a further weak point. If certain fonts are not installed, the office suite replaces them with similar fonts, which can cause translocation of paragraphs and incorrect line breaks because of spacing differences. You are best advised to install the relevant fonts globally before loading the documents – assuming the fonts are known.
The free office suite also trips over tables when importing foreign formats. After processing a table, changed font sizes sometimes overwrite or displace columns and rows, making the entire table unreadable. You can resolve this problem by highlighting the sections and reducing the font size.
OpenOffice also encountered difficulty in the complex document test with the OfficeOpen XML format by Microsoft introduced in 2007 (.docx
extension). When importing a spreadsheet for a school class, it completely misplaced images, graphics, and grids, making the document virtually unusable (Figure 3).
Users of the old StarOffice, who still use documents in .sdc
, .sdd
, and .sdw
formats, can no longer read and write these files as of Apache OpenOffice 4.0. In this case, the solution is to install a "portable" older version of the office suite [10] that can still import and export these formats. You can install the portable version along with the current version on your local disk; however, you should note that the tar.gz
archives of the portable variants are not available for all hardware architectures on Linux.
Collaboration
Apache OpenOffice does not have trouble reading documents in non-native formats when the comments of several editors are integrated. It presents the comments very clearly on the right of the screen with a reference, the name of the respective author, and different color schemes. You can process each comment from a small selection menu.
Interfaces
Because of its cross-platform availability and widespread popularity, many special industry solutions support OpenOffice in custom interfaces. The free office suite easily integrates into the major league enterprise resource planning (ERP) solution by SAP through an interface with its in-house MaxDB database back end [11].
Actiware, which manages, analyzes, and exports Actiwatch data, offers an integration solution in the form of Awas-Actiware Active Server [12]. Its Office integration module cooperates with virtually every enterprise solution, irrespective of provider, guaranteeing the transfer of data between business software and the office program.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Canonical Releases Ubuntu 24.04
After a brief pause because of the XZ vulnerability, Ubuntu 24.04 is now available for install.
-
Linux Servers Targeted by Akira Ransomware
A group of bad actors who have already extorted $42 million have their sights set on the Linux platform.
-
TUXEDO Computers Unveils Linux Laptop Featuring AMD Ryzen CPU
This latest release is the first laptop to include the new CPU from Ryzen and Linux preinstalled.
-
XZ Gets the All-Clear
The back door xz vulnerability has been officially reverted for Fedora 40 and versions 38 and 39 were never affected.
-
Canonical Collaborates with Qualcomm on New Venture
This new joint effort is geared toward bringing Ubuntu and Ubuntu Core to Qualcomm-powered devices.
-
Kodi 21.0 Open-Source Entertainment Hub Released
After a year of development, the award-winning Kodi cross-platform, media center software is now available with many new additions and improvements.
-
Linux Usage Increases in Two Key Areas
If market share is your thing, you'll be happy to know that Linux is on the rise in two areas that, if they keep climbing, could have serious meaning for Linux's future.
-
Vulnerability Discovered in xz Libraries
An urgent alert for Fedora 40 has been posted and users should pay attention.
-
Canonical Bumps LTS Support to 12 years
If you're worried that your Ubuntu LTS release won't be supported long enough to last, Canonical has a surprise for you in the form of 12 years of security coverage.
-
Fedora 40 Beta Released Soon
With the official release of Fedora 40 coming in April, it's almost time to download the beta and see what's new.