Converting and opening legacy files
Rescued from Oblivion

Can documents from the past 20 years still be opened easily today? The Linux Magazine team rummaged through some old hard disk drives and asked readers for legacy files. The documents we found caused a couple of surprises.
Everyone who was wise enough to make the move to Linux in the mid-1990s tended to write their letters and papers in StarOffice. At the time, no other alternatives provided such a broad range of functions, and it was available for free to non-commercial users. However, anyone wanting to open files that were created back then now faces a problem: OpenOffice and LibreOffice, which are based on the source code published by StarOffice around the turn of the millennium, refuse to cooperate.
In fact, in the history of the two office packages, the file format changed twice. The first OpenOffice in 2002 threw the StarOffice proprietary file format out the window and used its proprietary, but open, format named OpenOffice.org XML. The extension for text documents was SXW.
However, since OpenOffice 2, the standardized Open Document Format is now used, and text documents have an ODT extension. OpenOffice 2 was the last version that could still read and convert the old StarOffice documents with SDW extensions. Anyone wanting to save old letters in the modern era must therefore install OpenOffice 2 once again (Figure 1).

Apache may still provide this old version in its archives for download [1], but it cannot easily be installed on current systems: OpenOffice 2.4.3 crashed repeatedly on a test system with Ubuntu 14.04. A virtual machine provides a solution (see the "Reanimation" box). Current OpenOffice and LibreOffice versions, on the other hand, can still read files from OpenOffice 1.
Reanimation
If a document can no longer be opened or converted with a current program, Linux users once again need to turn to the legacy tools. Using them, you can call up the document, postprocess it if necessary, and then export it to an exchange format. This way, formatting and formulae often survive better than if imported into new software.
If the required application no longer runs on your current computer, and no older computers are accessible, you can reanimate it on a new machine. However, setting up such a computer properly is pretty time-consuming. Besides the actual application, you also need a suitable operating system. Microsoft Works 2.0, for example, wants Windows 3.1, whereas you have to find a Linux distribution from 2009 for OpenOffice 2. This is pretty difficult because many distributors only keep the latest versions of their distribution. Canonical is an exception because they provide all previous Ubuntu versions in an archive [2].
For MS-DOS programs, the specialized DOSBox [3] emulator at least saves you the trouble of installing the operating system; however, it will not launch just any application.
Typewriters
Linux users had to resort to the commercial Applixware in the early days before StarOffice took the stage. On its sites, the vendor Vistasource still offers the ancient 6.1 version of Applixware [4]. The free trial version is time-bombed to stop running after 30 days, but this should be more than enough time to convert old files (Figure 2).

The package provided by Vistasource with the 32-bit version was, however, always broken in our Linux Magazine lab. Version 6, which is still available, can be extracted, but it needs a seven-year-old libstdc++
version. Fortunately, there is still a Debian package available [5]. Alternatively, Calligra Words also imports old Applixware documents, although most of the formatting was lost in our tests (Figure 3).

In the 1990s, basically everyone who owned a computer was familiar with the funny-sounding programs Works, Ami Pro, and Word Pro. The small office suite Works, which was far cheaper than the big Word office suite and, above all, came free with many newly purchased computers, was from Microsoft. It was only four years ago that Microsoft dumped the small suite to focus on its Office suite. Thus, it's all the more surprising that any program can import the documents into Linux.
Only LibreOffice (but not OpenOffice) can open text documents with the WPS extension. Additionally, all of the formatting survived the import in our sample documents (Figure 4). However, LibreOffice has no idea what to do with tables and databases from Works. Importing tables can be forced, but the results are useless. Shortly after the submission deadline, the document foundation published LibreOffice 4.3, which was supposed to be able to import Works files. Lo and behold, we really were able to open those documents, although some of the relationships mutated into HTML entities in the process. The new version converts Works databases into tables.
Anyone having problems with Works documents needs to install the Windows program on a virtual machine (see the "Reanimation" box). Microsoft also provides an official conversion tool [6], which also requires a Windows environment. Databases can alternatively be converted into CSV tables on the Works website [7].
Computer retailer Escom included Lotus SmartSuite with its PCs in the 1990s. Among other things, it contained the Ami Pro word processor, which has operated under the name Word Pro since 1995. Libre- and OpenOffice will open documents from Word Pro with LWP extensions, but not Ami Pro files with SAM extensions. KWord, which was absorbed by Calligra Words, could read simple Ami Pro documents, but Calligra itself no longer provides Ami Pro file imports.
LibreOffice reliably reads simple Word Pro documents, and the layout survived in the tests (Figure 5). The results were a bit different with complex documents containing tables: LibreOffice ignored them, leaving us sitting in front of a blank page on occasion.
Can Opener
LibreOffice also imported Word documents with the DOC extension as far back as Word for Windows in version 6 or 95. This process did not, however, always work flawlessly in our lab: Although the layout of simple test documents was preserved, more complex documents looked a bit frayed at the edges (Figure 6). LibreOffice also refused to cooperate with a Word document.
Importing Word documents in Calligra Words was as disaster: Hardly any of the layout remained intact and, in one case, the word processor actually painted all the text blue (Figure 7). The above-mentioned good results do not apply to the first versions of Word for DOS. Libre and OpenOffice only recognized one text document created by a reader in the early 1990s with MS Word 5 (extension .txt
) as plain text and displayed all the control characters. The same was true for documents from Word for OS/2, also known as PM Word. At least the pure text content was retrieved, however.
The command-line program Antiword [8], which many distributions include, can also help. It converts ancient Word formats into plain text, XML, Postscript, or PDF. Users need to decide whether they want to keep the layout or edit the text.
Wordperfect documents from the 1990s, on the other hand, can be imported perfectly. This word processor was the market leader before the appearance of Microsoft Word and also appeared later in a native version for Linux. However, the current owner, Corel, put aside the native conversion and instead sold a Windows version powered by Wine for Linux.
In the early 1990s, the WordStar word processor lived in the shadow of Word and Wordperfect. Although the program retained some followers, testers could find no conversion option. Only the Windows versions of StarOffice 5.2 to 8 imported WordStar documents (WSD extension). A WordStar clone is currently being programmed under the code-name WordTsar [9].
Old LaTeX documents can be compiled without complications – provided they do not use extremely exotic add-on packages.
Paper Box
LibreOffice imported Excel tables with XLS extensions without problems; formulas and diagrams remained intact (Figure 8). The spreadsheet only threw the macros out of the window. The results in Calligra Sheets are unsatisfactory in comparison: Not only did the layout slip, but the spreadsheet also replaced the charts with an image of a question mark (Figure 9). One striking point was that the test documents almost exclusively contained simple formulas and simple calculations. The majority of Excel users seem to use only a fraction of its functions.
The Calligra Stage presentation program impresses with its handling of PowerPoint documents. Only the bullet points were missing in the test documents. LibreOffice does not have any problems with this either. Kexi can at least import tables from Access databases. A test document made the application crash, but the conversion seemed to work.
MDB Tools provides an alternative [10]. The mdb-export
command-line program contained in the package converts a database into CSV format; gmdb2
provides a graphical user interface that peeps into an MDB file (Figure 10). Incidentally, MDB Tools includes libraries and tools for developers that they can use to get to Access databases from C programs. Libre- and OpenOffice cannot currently open Access databases.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Direct Download
Read full article as PDF:
Price $2.95
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
News
-
KDE Plasma 6 Looks to Bring Basic HDR Support
The KWin piece of KDE Plasma now has HDR support and color management geared for the 6.0 release.
-
Bodhi Linux 7.0 Beta Ready for Testing
The latest iteration of the Bohdi Linux distribution is now available for those who want to experience what's in store and for testing purposes.
-
Changes Coming to Ubuntu PPA Usage
The way you manage Personal Package Archives will be changing with the release of Ubuntu 23.10.
-
AlmaLinux 9.2 Now Available for Download
AlmaLinux has been released and provides a free alternative to upstream Red Hat Enterprise Linux.
-
An Immutable Version of Fedora Is Under Consideration
For anyone who's a fan of using immutable versions of Linux, the Fedora team is currently considering adding a new spin called Fedora Onyx.
-
New Release of Br OS Includes ChatGPT Integration
Br OS 23.04 is now available and is geared specifically toward web content creation.
-
Command-Line Only Peropesis 2.1 Available Now
The latest iteration of Peropesis has been released with plenty of updates and introduces new software development tools.
-
TUXEDO Computers Announces InfinityBook Pro 14
With the new generation of their popular InfinityBook Pro 14, TUXEDO upgrades its ultra-mobile, powerful business laptop with some impressive specs.
-
Linux Kernel 6.3 Release Includes Interesting Features
Although it's not a Long Term Release candidate, Linux 6.3 includes features that will benefit end users.
-
Arch-Based blendOS Features Cool Trick
If you're looking for a Linux distribution that blends Linux, Android, and web apps together, blendOS might be what you're looking for.