Feeds

Microsoft Office for the iPhone (without the Microsoft)

Why wait for Redmond?

SANS - Survey on application security programs

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.

3 Big data security analytics techniques

Next page: Quickoffice Files

More from The Register

next story
Virgin Media so, so SORRY for turning spam fire-hose on its punters
Hundreds of emails flood inboxes thanks to gaffe
A black box for your SUITCASE: Now your lost luggage can phone home – quite literally
Breakfast in London, lunch in NYC, and your clothes in Peru
AT&T threatens to pull out of FCC wireless auctions over purchase limits
Company wants ability to buy more spectrum space in auction
Turnbull leaves Australia's broadband blackspots in the dark
New Statement of Expectations to NBN Co offers get-out clauses for blackspot builds
Facebook claims 100 MEEELLION active users in India
Who needs China when you've got the next billion in your sights?
Facebook splats in-app chat, whacks brats into crack yakety-yak app
Jibber-jabbering addicts turfed out just as Zuck warned
Google looks to LTE and Wi-Fi to help it lube YouTube tubes
Bandwidth hogger needs tube embiggenment if it's to succeed
prev story

Whitepapers

Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.