The Right Office Apps for the iPad at Work, Round 2
Users and business managers alike are loving the iPad as a potential laptop replacement, for at least part of the time. And more and more workplaces are providing employees iPads or letting employees use their own. So, just as companies typically install a suite of desktop productivity apps (nearly always Microsoft Office), what should the iPad equivalent be?
The answer can't be Office because Microsoft has no iPad-compatible suite. Microsoft's Office Web Apps cloud-based suite doesn't work on an iPad either. Google Docs is also not easily usable on an iPad, despite some improvements in winter 2011.
[Discover the best office apps for the iPhone. | Learn how to manage iPhones, Androids, BlackBerrys, and other smartphones in InfoWorld's 20-page Mobile Management Deep Dive PDF special report. | Keep up on key mobile developments and insights with the Mobile Edge blog and Mobilize newsletter.]
InfoWorld.com first investigated the available programs in December 2010 and put together a recommended business apps suite that should be the standard install on corporate iPads. All have been revised, and new products have become available, so six months later, I've re-reviewed the options to see what makes the most sense today.
I remain surprised to find that none of the iPad productivity suites is ideal, though one continues to come close. (I've added U.S. iTunes links for each app covered.)
Of course, beyond the productivity apps that nearly everyone uses, iPadders have further needs. I've put together a collection of additional business apps that you might make available to employees or point them to for more specialized work.
The office suite candidates are Apple's iWork suite -- Pages ($10), Numbers ($10), and Keynote ($10) -- plus Quickoffice's Quickoffice Pro HD (formerly named Quickoffice Connect Mobile Suite; $15, but its price changes frequently) and DavaViz's Documents to Go Premium ($17). Quickoffice has a word processor, spreadsheet editor, and a slideshow editor; the last item is a recent addition. DocsToGo -- as it's labeled on the iPad -- has a word processor, a spreadsheet editor, and a tool to edit text and add notes to a presentation. All the programs read and write the Microsoft Office file formats.
Also in the mix is Soonr Workplace, which runs $10 per month for three users and 25GB of storage or $30 per month for five users and 100GB; other plans are available based on storage requirements and number of users. In its 3.3 version, Soonr Workplace is a cloud storage service that lets you edit Word, Excel, and PowerPoint documents; you can preview but not edit iWork files. However, you cannot create documents in Soonr. You can work on files downloaded from your Soonr cloud storage or copied into Soonr via iOS's Open In facility.
I'll first pick out the best individual productivity apps, then pull together a recommended suite that includes utilities that should be in your standard installation as well. Note that my iPad choices aren't the same as my recommendations for the best iPhone office apps, due to app differences across the two devices. Here are the winners:
Next page: Best word processors...
The best word processor for the iPad
Choosing the word processor was the toughest call. Note that none of the options support revision tracking; if that's essential to your workflow, you're out of luck.
Pages. Apple's Pages is by far the most capable word processor for the iPad, with real layout controls such as the ability to designate page margins; set tabs; and add footers, headers, and images. It also has the most extensive text-formatting capabilities available, such as fonts, text size, lists, text color, line spacing, and paragraph alignment. It even spell-checks your document, highlighting potentially misspelled words; you can then have it suggest corrections by selecting the word and tapping Dictionary from the contextual menu. The search-and-replace feature also lets you constrain your actions to whole words or text with matching case, as you'd expect on the desktop. One note: If you open the Find capability from the Tools menu and don't see a field for replacement text, tap the Settings button (the gear icon) to change the mode to Find and Replace.
You can create rich, stunning documents on the iPad with Pages -- not with all the bells and whistles available on a Mac or PC in Microsoft Word, but much more than in any other mobile word processor. It's also easy to use. However, Pages has a major flaw that could kill it as an option for many companies and two other issues you should know of in order to avoid them.
The flaw is that it doesn't retain style sheets in the documents it saves. That amounts to significant damage to the original file, and it will cause major issues if the document goes through any publishing workflow, such as for eventual HTML conversion or use in Adobe InDesign. The styles' text formatting is retained, but as local formatting only. Pages does have a styles capability that applies predefined formatting, as well as the ability to "paint" formatting from existing text, but it does not apply a style sheet that is editable by Pages or Word; the Pages "styles" are just local formatting groups.
The first issue to be aware of is that Pages doesn't work directly with cloud sharing services such as Google Docs, Dropbox, and Box.net, though you will be able to share wirelessly across your own devices using Apple's new iCloud service once that's in place later this year. If you want to share files with others, your standard options are limited to email or syncing to your computer via iTunes and sharing from there. Dropbox users have a work-around: The $5-per-month DropDAV.com service adds the CalDAV protocol to Dropbox so that Pages and the other iWork apps can exchange files with it. Box.net users also have a similar (but free) work-around: Log in from iWork apps via CalDAV using your Box.net sign-in credentials.
The second issue is a design foible: Any changes you make to a document are saved immediately in the original. You can't save the changed file later and retain the original file as is. The work-around is to make a duplicate of the file within Pages before you open it.
Quickoffice. Quickoffice's word processor is simple, with straightforward controls for basic formatting, such as font, text size, paragraph alignment, and lists. There are no layout controls, so you can use Quickoffice only to work on text. But Quickoffice retains the style sheets in your imported documents, so they're intact when you later export a document, even though it doesn't let you create, edit, or apply styles. And this week, Quickoffice added the ability to search and replace text, with a nice interface for doing so, but unlike Pages it can't search with criteria such as case-sensitive or whole words.
Quickoffice can connect to Box.net, Dropbox, Google Docs, Huddle, and SugarSync cloud storage, as well as to a computer directly over Wi-Fi. Of course, it can also email documents, and it provides a Save As option, as well as an internal folder structure so that you can organize your documents.
DocsToGo. DataViz's app is similar to Quickoffice in terms of its capabilities: It's also a simple text editor with basic formatting options. However, DocsToGo is more sophisticated than Quickoffice, offering search and replace (with case and whole-word criteria) as well as word counting. Its cloud storage options are nearly the same; it supports all the services Quickoffice does except Huddle.
But I can't recommend DocsToGo due to a really dumb UI design: All the controls are at the bottom of the screen, where they become hidden by the on-screen keyboard. This amounts to hiding the keyboard to do any formatting each and every time -- a real productivity killer. (Pages and Quickoffice put the controls at the top of the screen.)
Soonr Workplace. The text editing features for Word files are pretty sophisticated, with spell-checking, image insertion, and table creation in addition to most of the editing and formatting tools you'd expect. What's lacking are support for styles -- both full style sheets and even "style painting" à la Pages -- and search and replace (it just searches, though it does so with options for whole words and case). Also, Soonr wipes out style sheets from your documents, rendering the files unusable in many workflows.
The verdict: It's a split decision. Pages is all around the better word processor, but its style-sheet flaw makes it unusable for many organizations. If your document workflow rests on style sheets or requires cloud storage services such as Google Docs, your best bet is Quickoffice. Soonr is useful only for editing. It's nice to have if you are using Soonr cloud storage but insufficient to be your main editing tool.
Next page: Best spreadsheet editors...
The best spreadsheet editor for the iPad
The capabilities of the candidate spreadsheet editors are much closer than for the word processors.
Numbers. Similar to Pages in its richness of functionality, Numbers is a full-on spreadsheet editor. You can enter complex formulas, create charts, and have multiple worksheets. The on-screen keyboard adapts to what you are entering, making special symbols and formulas very accessible. What takes a little getting used to is switching your entry mode for a cell, such as to text or to formula or to date, but that's how Numbers knows what controls to put in the on-screen keyboard.
Numbers, like its Mac OS X counterpart, takes an odd approach to spreadsheet creation if you're used to working in Excel: Adding a worksheet results in a blank page with no cells. Excel users will be mystified as to what to do next. What they need to do is add a table to the worksheet -- that's the grid of cells. In Numbers, a worksheet can have multiple tables, whereas Excel has just the one table automatically created. Once you know this, Numbers is easy to use.
Like Pages, Numbers has a good find-and-replace capability. Alas, like Pages, Numbers has no Save As feature; you need to duplicate a document before opening to leave the original intact.
Quickoffice. Excel users will take to Quickoffice quickly, as it works very similarly. Quickoffice has a large set of functions available, and it's easy to work with cells, rows, and columns. Quickoffice's on-screen keyboard doesn't have the sophisticated contextual display that Numbers' does, but its interface is nicely designed, so it works well without that ability.
Quickoffice has a Save As functionality, unlike Numbers. What it doesn't have is a set of charting tools or the ability to sort columns or rows, both of which Numbers can do. Quickoffice also can't hide columns or rows -- but neither can Numbers. Quickoffice can search and replace in spreadsheets, but it lacks Numbers' ability to search based on case and/or whole words.
DocsToGo. The spreadsheet capabilities in DocsToGo are similar to those in Quickoffice, with better search and replace capabilities than Quickoffice. DocsToGo also can hide rows, sort columns, and freeze panes, none of which Quickoffice can do.
But again its user interface is deficient. Switching among worksheets is more work than necessary, for example. The fact that the formatting controls are on the bottom of the screen isn't as problematic as it is for text documents, since you use the keyboard less in a spreadsheet. Still, it remains a pain.
Soonr Workplace. Soonr's spreadsheet editing and formatting tools are fairly complete: You can add and edit formulas, add worksheets, sort rows or columns, insert columns, copy and paste cells, and edit cell contents. What's lacking is the ability to move rows and to create charts, and to replace text (it can only search). Plus there's no numeric keyboard for working with cells as there is in Numbers.
The verdict: Numbers is the most capable of the spreadsheet editors, and its quirks are ones you can adjust to pretty quickly. It's my choice for spreadsheet editor.
Next page: Best presentation software...
The best presentation software for the iPad
Keynote. Apple's presentation app is simply amazing. You can create beautiful presentations with sophisticated transitions and animation effects, as well as draw on capable text and object formatting tools. It's the only iPad spreadsheet editor that has find-and-replace capabilties. There's also a presenter notes feature, and you can add graphics from the Photos app, as well as create charts, tables, and shapes. And you can display your presentation on an external monitor, while seeing it and (optionally) your slide notes on the iPad. Chances are you won't miss PowerPoint if you're using Keynote.
My only frustration with it (besides the lack of Save As across all iWork apps) is that it displays only in landscape orientation -- a real puzzler, given that Apple's other iWork and native iPad apps are orientation-adjusting.
A great, essential add-on for Keynote is Apple's Keynote Remote ($1), which lets you control a Keynote presentation from an iPad, iPhone, or iPod Touch. When I first gave presentations from my iPad, it was hard to walk around without inadvertently yanking the cable from the iPad out of the projector. Keynote Remote lets me set my iPad down on the lectern and then use my iPhone to remote-control it as a I stroll; it also controls Macs running Keynote. Keynote Remote uses either Wi-Fi or Bluetooth, as available, to automatically connect the devices once they have been paired, so you can remote-control your presentation pretty much anywhere.
Quickoffice. The Quickoffice suite added the ability to view, edit, and create presentations in late December. Its tools are fairly sophisticated: You can add shapes, photos, and text boxes on any slide, including new slides you create, and you can add and edit text using formatting controls similar to what the Quickoffice word processor offers. You can also change the stacking order of a slide's elements using the Properties control in the Formatting controls (not where I expected to find it, but it works easily). And Quickoffice lets you display your presentation on an external monitor, with a neat additional feature of being able to tap on the screen to display a laser-pointer-style highlight on the external screen. But Quickoffice has no slide-notes capability.
The handy slide bar shows your slideshow elements and lets you rearrange them by dragging their thumbnails, as well as delete any selected slide by tapping the X icon in the lower-right corner of the thumbnail. There is no outline or notes view, though.
DocsToGo. The DocsToGo suite lets you open PowerPoint presentations and add notes to them, such as to make comments or provide feedback to your spreadsheet jockey.
DocsToGo also has some very basic slide editing capabilities. You can edit the text in your slides, though to do so you must switch to outline mode. Furthermore, you can do no formatting. You can also create blank slides and duplicate or delete existing ones. Note that if you're in outline mode, you have to switch to slide preview mode to insert a new slide. You can't delete or duplicate slides when in outline view, nor can you display your slideshow on an external monitor.
The result is that DocsToGo is fine for touchup work on existing presentations or to create a basic text-only presentation that you might use as the starting point for a slideshow you will complete on the desktop -- but that's all.
Soonr Workplace. The slide editing tools are basic: You can edit text and format it (including working with lists, spacing, and alignment); add, delete, and resize graphics; and ... well, that's it. Soonr works fine for presentation touchup, but you won't be able to revamp a presentation with it.
The verdict: The best choice is Keynote. It's easily the strongest of the three iWork apps, able to replace PowerPoint completely for many users. Quickoffice is certainly capable enough for basic slideshow work, unlike DocsToGo.
Next page: Best PDF markup tools and utilities...
The best PDF markup program for the iPad
There are dozens of apps to open PDF documents on the iPad, but the built-in Preview app does that for mail attachments, and most Wi-Fi file-sharing apps preview PDF documents. What you really want is a program that can mark up PDF files, adding sticky notes and the like.
That app is GoodReader ($5). You can do most of the markup you would in Adobe Reader, such as notes, highlights, and even free-form shapes -- for example, to circle an item. Once you get the hang of using your finger like a mouse for such actions, it's an easy-to-handle app.
GoodReader is not just a PDF markup app. It can also view Office files, text files, and pictures, as well as play audio files and unzip files. In addition, it comes with a Wi-Fi file-sharing capability to transfer documents to your computer.
The best iPad utilities most everyone should have
The iPad can't open Zip files -- an amazing omission in the iPhone and iPod Touch as well. There are several apps that can unzip files, but the best are ZipBox Pro ($2) and Unzip ($1), both of which also work on the iPhone and iPod Touch. Their clean interfaces make them both easy to use. GoodReader also unzips files, so if you use that, you don't need a separate unzip utility.
Although the iPhone comes with a calculator app, the iPad doesn't. There are several calculator apps for the iPad, but I prefer the simple, capable Calculator Pro ($1). If you do lots of calculations and want a tape function to capture all calculations (and email that history as a file), then get the less aesthetically pleasing Calculator HD ($1).
If you view Photoshop native files, such as for page layout, Web, or presentation projects, get the AirFilesHD app ($1), which also offers Wi-Fi file sharing and basic drawing capabilities, a well as the ability to read documents in all sorts of formats. As you can see, Wi-Fi file sharing is built into lots of apps.
The iPad's own Notes app is fine for taking notes, and its Calendar app is perfectly suitable to manage your appointments. There are tons of alternative apps for both, but I don't see the point -- apart from four exceptions. The PhatPad app ($5) combines free-form drawing, handwriting recognition, voice recording, and limited keyboard entry to create richer notes than what is possible on the iPad's own Notes app. The Notes Plus app ($5) lets you take handwritten notes with a stylus (such as Ten One Design's Pogo Stylus), then export them to PDF, though it doesn't convert the handwriting to text. You can also type in text and include audio recordings in Notes Plus; PhatPad can't do either. If your notes include drawings, PhatPad or Notes Plus is the way to go. The Notability app ($1) is designed for people who take notes while recording lectures, presentations, and the like. Afterward, if you tap any text you entered, Notability will play back the audio recording from that point in time, so you can hear what was being said as you were typing. If you want a simple audio-recording app for note-taking, check out Beefon's WaveRecorder ($2), which has a really important capability not found widely: It continues to record when you switch to other apps.
Beyond these broadly useful utilities, chances are some workers will need additional apps for more specialized tasks. I've put together a collection of such business apps that you might make available to employees as part of an in-house catalog or point them to as recommendations.
Next page: Extra hardware and the full "office suite"...
Should you provide a keyboard and VGA connector?
The iPad's on-screen keyboard is surprisingly easy to use, especially in landscape orientation, where it's full size. You don't get the tactile feedback of a key press, but I found I adjusted very quickly to touch tapping regardless.
Apple makes the very nice Bluetooth-enabled Apple Wireless Keyboard ($69); some other Bluetooth keyboards work with the iPad as well. You would think they make typing faster, but they don't unless you're in stenographic mode, transcribing a meeting or call as opposed to writing and editing. The reason is that there are few keyboard shortcuts available for iPad apps, so you're constantly taking your hands off the keyboard and moving them to the iPad's screen. That eliminates any speed advantage of the physical keyboard outside of pure stenographic uses.
When using the Bluetooth keyboard, there are keyboard shortcuts for copy, cut, and paste, and you can Shift-select ranges of text. There are also top-of-document and bottom-of-document shortcuts. Plus, you can enter accented characters and other special symbols using the same Option shortcuts as on a Mac. But there are no shortcuts (or keys) for Page Up and Page Down -- two extremely common editing keys -- or for formatting such as boldface, italics, underline, and paragraph alignment.
Apple also makes a VGA connector that plugs into the iPad's 30-pin connector, the $29 Apple Dock Connector to VGA Adapter. In April 2011, Apple also released the $39 Apple Dock Connector to HDMI Adapter for HDMI-based displays. Either is a worthwhile purchase if you're using Keynote to make presentations via a projector or TV. But note that most apps (unlike Keynote) on the original iPad don't support these connectors; you can't, for example, show a website demo via Safari. Also, Apple prevents the original iPad model from displaying commercial video purchased or rented from iTunes; you can't use it to hook up an iPad to a monitor as you would a laptop when you want a bigger screen for your routine work. But with the iPad 2, you can mirror your display -- and thus any app -- over a VGA or HDMI cable.
Putting it all together: The ideal office "suite"
Given that no one suite does it all well enough, what is the ideal combination? That's a tough decision, but I've concluded the best overall productivity suite is Pages, Numbers, Keynote, and GoodReader.
If Pages' lack of style-sheet retention is a deal breaker, then that recommended iPad productivity suite changes to Quickoffice Pro HD, Numbers, Keynote, and GoodReader -- basically, Quickoffice replaces Pages for text editing. I hesitate to recommend Quickoffice because the application periodically crashes when opening complex files, and once that happens it takes several attempts to reopen the program before you can work on anything else. This flaw has persisted in Quickoffice through several updates. I can't recommend DocsToGo due to its poor placement of the editing controls, where the on-screen keyboard covers them up. That renders DocsToGo too hard to use, even though it's more capable in terms of functionality than Quickoffice.
Either way, toss in AirFilesHD if you need to view Photoshop files and one of the note-taking apps (PhatPad, Notes Plus, Notability, or WaveRecorder) if you need more sophisticated notational capabilities.
Product mentioned in this article
Apple iPad 2 family
The iPad 2 remains a solid choice, thanks to its lower price and strong app choices.