The right office apps for the iPad at work
If you provide or allow employees an iPad, here are the productivity apps that you should install on themFollow @MobileGalen
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 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. The on-screen keyboard doesn't have the sophisticated contextual display that Numbers does, but Quickoffice's 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.
DocsToGo. The spreadsheet capabilities in DocsToGo are similar to those in Quickoffice, but again its user interface is deficient. Switching among worksheets is more work than necessary, for example. But it can hide rows, sort columns, and freeze panes, none of which Quickoffice can do.
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. Still, it remains a pain.
The verdict: Numbers is the most capable of the spreadsheet editors, and its quirks are ones you can adjust to pretty quickly. It's our choice for spreadsheet editor.