LibreOffice viewer app for Android
Outdoor Office Helper
The LibreOffice Viewer for Android displays office documents on mobile devices and now even has simple editing features. We investigate whether the smartphone and tablet app is useful as a helper for the main office suite.
At the end of May 2015, the LibreOffice developers released the first stable version of LibreOffice Viewer for Android on Google play [1]. The free app has been released under the Mozilla Public License and was developed in cooperation with Igalia, Collabora, and Smoose, as well as some Google Summer of Code students. If you run Android without Google, you will find an APK at the Document Foundation website [2].
The viewer uses the same engine as the desktop version of LibreOffice. The front end is based on Firefox for Android. According to the release notes, the app displays the free ODT, ODS, and ODP formats, and the Microsoft DOX, DOCX, XLS, XLSX, PPT, and PPTX formats. An experimental editing feature provides tools for bold and italic fonts as well as underline and strikethrough.
LibreOffice Viewer requires at least Android 4.0. The test team installed the app on a tablet (Tolino Tab 8.9 with Android 4.2.2) and on a smartphone (Galaxy Nexus, Android 4.3) and tasked the mobile office assistant with opening Writer, Calc, and Impress files as well as MS Word, Excel, and PowerPoint documents; we also tried to edit them (Table 1) in the viewer. One thing up front: The app did not open password-protected documents as a matter of principle – it even crashed reproducibly.
Table 1
Features at a Glance
File Type | View | Edit |
---|---|---|
Word Processor |
||
ODT |
Yes |
Yes |
DOC |
Yes |
No |
DOCX |
(Yes) |
No |
Spreadsheet |
||
ODS |
No |
No |
XLS |
(Yes) |
No |
XLSX |
Yes |
No |
Presentation |
||
ODP |
Yes |
Yes |
PPT |
Yes |
No |
PPTX |
(Yes) |
No |
Successful Start?
A file manager that displays the folders on the device, including the hidden directories, appears after launch. The icons are clear-cut on a tablet but too big on a small smartphone display. Via the menus, users can filter the list alphabetically, show only certain file types, or just show the latest or biggest files. If you rotate the device at this point, you can say goodbye to the viewer. Changing the orientation repeatedly caused crashes on both test devices.
After you select a file, the viewer can take some time to open it, depending on the memory capacity of the tablet or smartphone. Documents with images, charts, and several font types are often pixilated until the app finishes rendering them correctly. In the Settings menu, users can switch to Experimental Mode, which displays the editing features at the top.
The developers warn both in the app and in the Release Notes: Use at your own risk – and this is very much justified, as our lab tests revealed. If you try out this mode, you will find small buttons for bold and italic highlighting of words and for underline and strikethrough. An icon with a keyboard displays the keyboard at the bottom if it does not appear automatically.
Pretty Much Presentable
The ODT file and the MS Word document (DOC) looked quite good on both test devices, and the DOCX, which contained several columns and images, was accessible. Although the desktop version of LibreOffice showed a very fragmented view of the document, the viewer did this slightly better. Of course, the display still wasn't perfect, but all the content was readable.
Switching to edit mode worked in some cases but not always. If it did work, it took a while for a tap to reach the document in the viewer. Both test devices finally understood the request, showed the cursor, and unfolded the keyboard at the bottom (Figure 1).
The app does not select words or paragraphs. To format something, you need to tap on a word and then press the corresponding button. Inserting text into a document also takes quite a while, so that function should currently only be used to make short additions. It makes more sense to use a desktop to type longer passages of text.
Attempts to view a simple Calc spreadsheet with a sum formula ended in disappointment, with or without the embedded chart: The viewer refused to comply. An Excel file (.xls
) was slightly better; however, the column width was not perfect, and the pie chart was also unimpressive (Figure 2). An attempt to modify an XLS file also failed on both devices.
The test team did have one positive surprise on opening an XLSX file. The viewer correctly presented the charts, and the column width was correct. To make up for this, the diacritical marks (specifically, the umlaut) were broken. The Parts selection from the menu at the top right or a swipe gesture from the left to the middle displays a bar with the spreadsheets on the left.
The Parts menu entry is also available in presentations and lets you access the slides. The thumbnail on the left did not always survive rotating the device. Sometimes the thumbnails appeared again after several minutes, and sometimes they didn't. ODP files worked quite well in the test, and we were also able to edit them – with a little patience.
The app also displayed Microsoft formats. The viewer presented the PPT file quite convincingly, even if the animations were missing. When navigating through the slides via the sidebar, or after swiping, the viewer returned significantly better performance than with its native file format. The PPTX file took ages to open and annoyed the test team with broken umlauts.
Staff or Paid Help?
The viewer failed to display password-protected files. It would be useful if the app could just give users a hint of this. At best, it returns to the folder view, and in the worst case, it crashes. As with the other crashes in our lab, the only remedy was to forcibly shut down the app in the system settings and clear the cache.
Given the fairly mediocre performance, the question is whether the LibreOffice developers have done themselves a favor in declaring the beta version to be "stable." LibreOffice Viewer for Android certainly has potential but is not currently suitable for production use. If you do want to test the app, be sure to report diligently all the bugs you find via the LibreOffice bug tracker [3].
Infos
- LibreOffice Viewer on Google Play: https://play.google.com/store/apps/details?id=org.documentfoundation.libreoffice
- APK download: http://downloadarchive.documentfoundation.org/libreoffice/old/loviewer-v1
- LibreOffice bug tracker: https://bugs.documentfoundation.org
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
-
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.
-
New Pentesting Distribution to Compete with Kali Linux
SnoopGod is now available for your testing needs