Original URL: https://www.theregister.com/2009/09/21/microsoft_web_office_preview_review/

Microsoft's Office Web Apps - a long way from here

Inside the (half-baked) tech preview

By Tim Anderson

Posted in Channel, 21st September 2009 21:34 GMT

Review The arrival of an online version of Microsoft Office is a significant event, especially after IDC's Melissa Webster reported that nearly 20 per cent of companies already use Google Docs (if not exclusively). Last week, Redmond released an invitation-only Technical Preview of Office Web Apps. But does it have what it takes to fend off the likes of Google, Zoho, and Adobe's Acrobat.com?

It's a tough question to answer, since much of it is not yet done. This is one of the least complete Technical Previews that I have known Microsoft to release, raising doubts about whether it will be ready in time for the release of Office 2010, set for the end of June next year. In the current preview, only Excel and PowerPoint documents can be created and edited online, and OneNote is not yet supported at all, though it is promised for the final release.

I soon found other shortcomings. Opening online documents in desktop Office did not work on the Mac, for example, even with Office 2008 installed. On Linux with Firefox 3.5, the Web Apps did not work at all. The Excel Web App does not support printing. There is no sign of the promised ability to embed a PowerPoint deck in a web site, which sounds a good feature even though rivals like SlideShare already do it nicely. Performance is generally poor, errors abounded, and there is also the question of whether users will be satisfied with the limited set of editing tools currently on offer.

How limited? That too is difficult to answer, since Microsoft says the feature set will change based on feedback during the preview. Some aspects are impressive. Online Excel, for example, seems to support most if not all the formulae present in desktop Excel, but you cannot freeze header rows, merge cells, or insert a new worksheet - to mention just three of countless missing features.

Excel toolbar for MS Office Web Apps preview

Web Office Excel toolbar: What you see if what you get

On the other hand, the fidelity of rendering existing Excel workbooks is impressive, aside from the slow performance. Grouped rows expand and contract fine in Excel Web App, provided that they already exist. An Excel workbook which Google Apps could not properly import displayed fine in Excel Web App.

Microsoft Office Web Apps v Google

Microsoft Office Web Apps v Google Apps (Click to Enlarge)

What you are meant to do when encountering editing limitations is to click the "Open in Excel" button. Microsoft says this is because most people prefer to work in the rich desktop client, though the fact that the company makes a large part of its profit by supplying Office licenses can hardly be ignored. If you do open a document in Office, it will save directly back to its online source, although the feature is slow and unreliable in the preview.

The Web Apps seem to be built around the new Open XML document formats. You can open the older Office formats, but they are read-only unless you save into the new format, which is not ideal for broad compatibility. Another snag is that spreadsheets driven by VBA will not work.

A key feature of Office Web Apps is collaboration - though in the preview, this only works in Excel. You can share a document with others and enjoy simultaneous editing, but I found this problematic in practice because there is no indication of what another person is currently editing. This means you can inadvertently overwrite another person's work. Once again, this may improve in later iterations of the product.

The SharePoint connection

The technical foundation of Office Web Apps is the work Microsoft has done on the server-side Office for SharePoint. Excel Web Services already exists in SharePoint 2007, which may explain why Excel is the most advanced application in this Technical Preview. Microsoft is adding other services in SharePoint 2010, including Word and PowerPoint.

The further implication is that the API for Office Web Apps will be the SharePoint API and that many tools will not be available to Windows Live users. The preview uses Windows Live, though, and according to product manager Chris Adams, this partly explains why it is so rough. "The web applications on SharePoint are significantly more progressed than the ones on Windows Live, because of the different ship cycles between Windows Live and the Office SharePoint team," he told me.

SharePoint users - whether they're using the hosted or on-premise version - will get additional features, including document history, active directory integration, auditing, and backup/restore.

The Office Web Apps look great, present a familiar Office-like user interface, and generally render faithfully. The Silverlight-driven previews look particularly good, with smooth zooming and the ability to pop-out documents into a separate window. The main hesitations are around the limited editing features and the poor performance, which we must hope will be fixed before release.

Judging by this preview, Microsoft currently does not intend to compete with Google or others for cloud-based users. "We see the web apps, for most businesses, as an extension of the Office experience, not a replacement for them," says Adams, which is why the editing features on offer are more like touch-up facilities rather than full document tools. There is value in that, but it will do little to disrupt competitors who are offering freedom from desktop installations. At the same time, with these server-side Office engines Microsoft is laying the foundation for a more complete Web Office, which it will inevitably have to deliver as the competitive pressure increases. ®