Tech Focus
Office Apps in the Cloud
CRN Test Center reviews Zoho, Google and Microsoft offerings
By Samara Lynn
T raditional desktop applications, like office productivity suites, continue to ascend into the cloud. Competition is heating up, with vendors' ultimate aim to win over both loyalty and a greater share of what could be—down the road—a powerful market.
The CRN Test Center took a look at four online productivity suites that are vying for a bigger piece of the pie: Google Docs, AdventNet's Zoho, and Microsoft's Office Live Workspace.
Each application was examined and tested for the following criteria: interoperability with other office suite and file formats (like Microsoft Office 2007 or OpenOffice.org's formats), editing capabilities, user interface and pricing.
Zoho Office Suite
Developed by AdventNet, Zoho can integrate with Google and Yahoo accounts for authentication and synchronizing up contacts. The personal edition components include Writer for word processing, Sheet for spreadsheets, Show for presentations, as well as chat and wiki components.
Any user familiar with Microsoft Word's pre-ribbon interface should have little problem working with the toolbars and menus in Zoho Writer. The standard buttons and commands of Word are included in Writer. Other features include the ability to publish a document to make it instantly available online. You can also copy a system-created scriptlet that can be added to a Web site and blog to give visitors access to the document. Writer also supports digital signatures.
Zoho Writer cleanly imported a .doc Word document created in Office 2007. A .docx file, however, lost portions of its formatting upon import. The spell-check feature was robust, but those accustomed to the on-the-fly auto spell-check of Word should be made aware that spell-check has to be initiated manually. Writer can export to a number of file formats, including OpenOffice and PDF.
Zoho Sheet was able to open a highly formatted capital budget template created in Excel. Some of the formatting was a bit off—a few of the cell contents were misaligned. As in Excel, Sheet supports chart and pivot table creation.
Sheet has a VBA editor, which refused to fully load at first, but it was nothing that a page refresh could not handle (we tested in Internet Explorer 7). This was not too much of a problem, although it was a definite reminder that we were working in an online application. Sheet can export as Excel, OpenOffice, OpenDocument, Gnumeric, PDF and other file formats. There is currently no support for .xlsx format. Zoho Presentation also does not support .pptx. Presentation has a bit of a primitive quality to it: There was no ability to incorporate even basic slide-animated transitions and there was no ready way to preview a slide show. It is, however, a good basic presentation creator.
With Zoho Office, you can create your own public wiki, as well as a Notes component. One issue we had with the suite was there was no way to close a file without saving. There is a history function that allows a reversion back to the file before a change was applied. It even showed the differences between the most recent and older versions of the file.
There seemed to be no prebuilt templates with the programs. This is, however, the Personal edition. Zoho has other versions available for a fee. Zoho Business includes all of these applications, in addition to user, group and domain management capability. The Business version also includes Instant Messaging, Contact Manager, Tasks, and Calendar Manager and document storage. Zoho Business is free for the first 10 users, and $50 per user, per year after that. Zoho has other business online services: CRM, Projects and Zoho Creator (for Developers) are all per-month, fee-based services.
Zoho's scorecard: Interoperability with other platforms is good; support for other file formats is good, but there is still no support for Excel and PowerPoint 2007 files. In addition, although .docx is supported, a .docx file did not import as cleanly as the older .doc file. For editing capabilities, Zoho scored 4 out of 5: A point was lost for the VBA editor issue. For the user interface, reviewers gave Zoho 5 stars; the interface is modern, has the same tool bar and menu items as traditional productivity suites, and users familiar with the more traditional suites would have little problem transitioning to Zoho. Pricing also gets 5 stars; this is a pretty affordable solution and at the same time it is a full-blown office suite product. Zoho gets 18 out of a possible 20 stars.
Google Docs
Documents is the no-frills name of the word-processing suite in Google Docs. Again, the interface is comparable to Word, though more Spartan. Documents has handy offline capabilities, so data can be accessed without an Internet connection. Another nice feature is that in the event of an inadvertent log-off, a prompt appears if the document is not saved.
Files can be saved as Word, PDF, OpenOffice, HTML, RTF or text. Documents can be shared with others as collaborators or as read-only viewers. The file can be published as a Web page or sent as an attachment from Writer.
Tables are created easily, though with little variation in formatting options. There aren't many fonts from which to choose, either, but Document has the commonly used ones. Spell-check also does not happen automatically; the user has to click it.
Spreadsheet in Google Docs was impressive. The same complex capital budget spreadsheet opened with formatting more intact than was the case with Zoho. Opening up a new spreadsheet initiated the AutoSave feature. Objects like charts and comments can be added, but we did not find a way to create a pivot chart. Other interesting gadgets can be added, such as interactive tables, animated charts and maps. As with Zoho, there is no support yet for .xlsx files.
Presentation came with an assortment of background templates. There was also no way, though, to view a completed slide show. Again, as in Zoho, there is no support for .pptx. Slide animations, transitions and other audience-rousing affects are not available in Presentation. A .ppt file with a lot of embedded images and heavily formatted background opened up perfectly.
Google Docs give users the ability to make interactive forms complete with check boxes, multiple-choice select buttons and text fields. Google Docs is the productivity suite component of Google Apps Standard and Google Apps Premier. In the Standard version, Google Docs is available for free, as well as 7 GB of Gmail storage and 10 GB of shared storage. Premiere includes Google Docs and 25 GB of Gmail storage, 90-day e-mail archiving, 10 GB of shared storage, plus an additional 500 MB per user among other features, all for $50.00 per user, per year. The same version of Google Docs is in both the Standard and Premier versions.
Google Docs' scorecard: For interoperability, Google Apps gets 5 stars. The suite was able to handle a complex spreadsheet created in Excel and cleanly imported both a .docx file and a file created in Star Office. Editing capabilities score a 4 out of 5. We would like to see some additional features, such as the ability to create a pivot table. User interface scores a 5; although it is more akin to older versions of Office, there is nothing lacking in the menu commands and feature set. Pricing, on par with Zoho, also scores a 5. Google’s total score is 19 out of 20 stars.
Microsoft Office Live Workspace
Not a real full-blown productivity suite, Office Live Workspace is more aligned with Microsoft's inclination to fuse hosted services with an on-site infrastructure. Live Workspace is a way to share documents collaboratively online. The caveat is that the documents can be edited by locally installed Office programs. Live Workspace allows for up to 500 MB of storage and uploaded file size limitations are set at 25 MB. Workspace templates are provided; when "Meeting Workspace" is opened up, preloaded files such as Meeting Notes, Meeting Minutes and List of Attendees are included. Individual documents or workspaces can be shared with up to 100 people.
Editing and versioning capabilities aren't as hearty as in Zoho and Google Docs. Actually, there really is no online editing capability. The Shared View utility allows users to share applications and screens with other users, however only one user at a time can control a shared file or screen.
Also, there is no support for Access files—puzzling because Office Live Workspace is really intertwined with the champion of productivity suites, Microsoft Office. Why not give Access users the functionality? Microsoft incorporates virus protection security using Microsoft Forefront Security for SharePoint. Office Live Workspace can only be accessed using a Windows Live ID and password.
Microsoft's official business offering is Office Live Small Business, which allows small businesses to create Web sites, manage domain names, create company-branded e-mails; it also offers additional online tools for managing customers and projects. Like Live Workspace, though, an install of Microsoft Office is needed to edit documents.
Perhaps it is unfair to include Office Live Workspace in a productivity suite bake-off, yet this online application is being pitted in direct competition to other hosted solutions like Zoho and Google Docs. Problem is, it doesn't compete, on so many levels. Office Live Workspace is a nice collaboration solution for small workgroups that are already using the Microsoft Office application suite. To call it an online productivity suite is a misnomer.
Office Live Workspace's scorecard: For interoperability, not surprising, since there's no support for ODF file format and support is pretty much limited to the Microsoft Office file types and PDF files, the score is 2 out of 5. Note to Microsoft: The digital world is becoming much more standardized and collaborative. For editing, well there simply is no online editing, however there is some pretty decent, though basic, versioning control—for that the score is 3 out of 5. Office Live Workspace scores a 5 for user interface, easily navigable menus and toolbars and being very user-friendly overall, one of Microsoft's greatest strengths. For pricing, well it's free (and usable as long as you have an installed copy of Office) so that gets a 5 out of 5. Microsoft’s score is 15 stars out of 20.
Conclusion
Google Docs is clearly our pick for the leader in this bake-off. Google Docs and Google Apps set the bar for the competition. Google Docs is a true, hosted alternative to Microsoft's Office. Zoho, as runner-up, is proving to be a contender in the online productivity space. This not-as-well-known office suite is nipping at the heels of Google Docs.
Bringing up the rear is Microsoft's Office Live Workspace. Criticized by some as nothing more than "a plug-in for Microsoft Office," it does have some merit. It is a good collaboration tool with an interface that is familiar and easy, even for the most novice users. Microsoft, in tethering Office Live Workspace to its in-the-box Office product, can be accused of being rather counterproductive in its quest to compete with Google. The fact that Microsoft has announced that it is considering advertising in Live Workspace may also not attract new fans to the product. |