Feeds

Microsoft Office for the iPhone (without the Microsoft)

Why wait for Redmond?

The Essential Guide to IT Transformation

Quicksheet

Quickoffice's Excel stand-in, Quicksheet, is a more robust module than its Word-wrangling sibling. It's also more difficult to use, seeing as how tapping and dragging tiny spreadsheet cells requires a steady hand and good aim - especially for our admittedly ham-handed fingers.

Fortunately, the same pinching system allows you to grow and shrink your spreadsheet, making cell-selection easier. Be careful, though, to place both fingers on the spreadsheet at the some instant, or you'll select a cell instead.

To test .xls and .xlsx compatibility, we took a mildly formatted Excel spreadsheet and saved it into both formats.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

This simple Excel spreadsheet helped me reorgnize the volumes on my trusty Power Mac G5

Out test file not only had some simple borders, colors, and textures, but also conditional formatting: The numbers in bold green were set to receive that formatting if they were over 100, and the numbers in bold red, under 35.

When we opened both files in Quicksheet they were essentially identical, with one tiny niggle: The .xlsx file opened with a slightly higher zoom than the .xls file. No biggie.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

Not only does a .xlsx document have a larger file size, it looks a touch bigger, as well

When we pinched the file to show the entire width of the spreadsheet in the display, it became apparent that Quicksheet, like Quickword, simplifies an Office file's format.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

Simplify, simplify, simplify

The lack of texturing in the turquoise bars is a vanishingly tiny problem, and we can live without the double-bar and dotted-line borders, but we found the lack of conditional formatting more problematic. A call to Quickoffice confirmed that, yes, conditional formatting is not supported.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

At least the text is smart enough to extend over unfilled cells, à la Excel

When we scolled down to the bottom of our test spreadsheet, we noticed that line 29 - which fit just fine when opened in Excel - jutted out further than it should in Quicksheet.

Inserting and deleting rows and columns is easily accomplished, and a helpful Drag to Align UI made text alignment easy. Quicksheet also allows adding, deleting, or reordering worksheets within an Excel document using a standard iPhone-app UI.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

The Drag to Align UI is sheer genius

Unfortunately, although you can edit cell contents when in landscape mode, changing their formatting is portrait-mode only. Neither can you add formulas when in landscape mode.

Quickoffice Mobile Office Suite 1.4.1 for iPhone - screenshots

Don't worry, most formulas are far more powerful than SUM

Speaking of formulas, Quicksheet is loaded with them - we counted 121, grouped in such categories as Math & Trig, Statistical, Financial, and more, including one appropriate to most of our Excel usage: Common. To use a formula, you tap the ƒx icon and select the formula from its list. The formula then pops into - where else? - the formula bar and a balloon presents you with its syntax. Type in your variables and away you go.

You can also change row and column widths by tapping and holding until directional arrows appear, then drag right and left, or up and down until you're happy with the result. That may sound easy, but we found this to one of the more challenging tricks to convince Quicksheet to perform - that, and double-tapping and dragging to select a range of cells. Perhaps with more practice? Perhaps not.

As with Quickword, a reduced range of formatting options is offered, simply covering the basics. Oh, and don't go looking for chart-formatting options - Quicksheet doesn't support charts of any kind.

Build a business case: developing custom apps

Next page: Quickoffice Files

More from The Register

next story
Trying to sell your house? It'd better have KILLER mobile coverage
More NB than transport links to next-gen buyers - study
iWallet: No BONKING PLEASE, we're Apple
BLE-ding iPhones, not NFC bonkers, will drive trend - marketeers
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
Scotland's BIG question: Will independence cost me my broadband?
They can take our lives, but they'll never take our SPECTRUM
NBN Co adds apartments to FTTP rollout
Commercial trial locations to go live in September
Samsung Z Tizen OS mobe is post-phoned – this time for good?
Russian launch for Sammy's non-droid knocked back
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.