Category Archives: microsoft

Six abandoned features from the history of Microsoft Office

With Office 2010 about to launch, it’s fun to look back at earlier Office launches, especially some of the features which were hyped as breakthroughs at the time, only to be dropped or hidden a couple of versions later. Here are six which come to mind.

Smart Tags

Smart Tags were the big new feature of Office XP. You would be typing a document, and as you typed it would pull in data or run wizards by recognising the content of your document. Smart Tags were originally envisaged for Internet Explorer as well, but controversial since they overlay third-party content with Microsoft’s interpretation of what it might be about; that feature was dropped. Smart Tags just about persisted into Office 2003, after which Microsoft stopped talking about them.

image

Curiously, if you hit Display Map in Word 2003, then after a few Internet Explorer convulsions a map of New York appears with the location marked (I have no idea if it exists, I just picked the numbers 12345). In Word 2010, the feature is hidden, but if I right-click the address I do get Display Map under Additional Actions:

image

However, if I select Display Map I just get a map of the UK with a search box. It appears that this feature in Word 2010 did not receive the most rigorous attention or testing.

The Tip Wizard

Introduced in Office 95 (along with the Answer Wizard), the Tip Wizard would observe your actions and come up with a tip if it thought you might need help. It was actually a better approach than the Office Assistant which was to follow, being less intrusive and occasionally even helpful.

image

The Answer Wizard was less impressive – billed as some sort of intelligent question parser, but in practice little different than simply searching help for keywords.

The Office Assistant

The unforgettable Clippy, introduced in Office 97, whose opening remarks were usually “It looks like you’re writing a letter.” Clippy had a wonderful range of animations though; almost as if more effort went into the animations than the artificial intelligence. You did not have to have Clippy; there were a variety of other characters available. The Office Assistant also hijacked certain dialogs, such as the option to save when closing a document.

image

So what was actually wrong with Clippy? Part of it was the faulty AI, but more seriously the application overstepped the mark between what is helpful and what is annoying and intrusive. Someone even wrote a paper on the subject.

Although everyone loves to poke fun at Clippy, Office 97 (in which he first appeared) was a huge success for Microsoft – accordng to the company, it was the fastest selling application in PC history at the time. Clippy did not last though; by the time of Office XP the Assistant was off by default, and in Office 2007 it is not available at all.

Adaptive Menus

Here is an idea which really seems to make sense. The problem: too many menu options that few people use, cluttering up the user interface. The solution: menus which only present the features you actually use. The other options are hidden by default, but can be revealed by clicking a double-arrow. If you use a hidden menu a few times, it starts to appear by default; if you do not use an option for a while, it hides itself. The feature arrived in Office 2000.

image

The problem with adaptive menus was the wrong things got hidden. I always found it annoying when Office hid the Print menu, even though I rarely print documents (which is why it got hidden).

They also fail the consistency test. Humans need landmarks in order to navigate, and making them shift and change over time is disorientating.

Outlook Net Folders

Once you have a network, then among the most obvious things to do is to start sharing basic things like contact lists. Microsoft has a feature in Exchange called Public Folders which does this nicely. But what about little workgroups that do not have Exchange? Outlook 98 introduced Net Folders, aimed at exactly this need. You could configure a Net Folder, in which case hidden emails were sent round the network to synchronize everyone’s changes.

Unfortunately nobody in Microsoft used Net Folders. Why would they, when they had Exchange? In consequence, the Net Folders feature never worked correctly; they would inevitably become corrupt or non-functional after a while. After Outlook 2000, the feature disappeared.

Access Data Projects

Microsoft Access has a decent user interface for managing data, but the underlying JET database engine is a bit hopeless over a network. That was the thinking behind Access Data Projects, introduced in Access 2000. Keep the friendly Access UI, but have the underlying database engine be SQL Server.

At the time Microsoft hinted that JET was nearing end of life, and that the local SQL Server engine might take over. It was a hard sell though. Users understood the MDB: a file that has all their data in it. You could copy it to a USB drive and take it home, or email it to someone, and it would happily open in another Access installation (version differences aside). SQL Server is just more fiddly. In any case, you can connect to SQL Server from an MDB or Accdb, so why bother? After Access XP, Microsoft moved away from the idea of Access Data Projects.

Actually, Access Data Projects are still there even in Access 2010, just hidden. Go to the backstage view, select New, and type a filename with an .adp extension. Then click Create. Access will ask if you want a new or existing SQL Server database.

image

And more…

I could go on. The Office Binder – a great feature of Office 95-2000 that rolls documents of multiple types into one file. Data Access Pages – a somewhat misconceived feature of Access 2000 for binding HTML to database fields. What’s your favourite abandoned feature?

Exchange 2007: ESEUTIL beats the wizard

Today I was asked to help find missing email in Small Business Server 2008, in other words Exchange 2007. Somehow, thousands of emails had disappeared from a user’s mailbox. They were there a couple of days earlier, so we restored a backup. The procedure is nicely explained by John Bay. You restore the Exchange database to a temporary directory, leaving Exchange up and running. Then you mount the restored backup into a “recovery storage group”, from where you can merge items from the recovered mailbox into the live one.

All went well, until the point where you mount the restored backup. The database would not mount. The event viewer said it was in an inconsistent state. Bay anticipates this, and suggests using the Exchange Troubleshooting Assistant to repair the database. The repair chugged away and completed; but the database still would not mount. I tried again, same result.

I gave up on the Assistant and reverted to the traditional command-line tools. I used the sequence:

ESEUTIL /P

ESEUTIL /D

ISINTEG

running against the recovered database. The first does a repair; the second defragments; and the third runs integrity checks and applies fixes.

Now, you would have thought that the Troubleshooting Assistant would use these very same tools underneath its pretty GUI, but that cannot be the case. Apart from anything else, ESEUTIL /P took much longer than the Assistant. In particular, it appeared to hang while doing something mysterious called Deleting Unicode fixup table.

image

It carried on saying this for around 7 hours. There was evidence that the process was still alive though, so I left it be.

It worked. I ran the other two commands, mounted the database, and merged the mailbox to recover about 4,000 emails.

image

The question remains: where did the emails go? All I know is that the problem coincided with a newly installed Windows and Outlook, which I’m guessing is significant.

Word 2010 ugly font in .doc format

I’ve come across what looks like a bug in Word 2010. I generally do not send documents in the new Word .docx format, because it can cause problems for the recipient; I prefer to use the old .doc format. I’m also averse to the multi-colour default style set in Word, and generally change it to the Word 2003 style set.

So I typed a document in that style set, and prepared it for sending by using Save As to convert it from .docx to .doc.

Here’s the before:

image

and after:

image

The font spacing has gone awry in the heading. I don’t know to what extent this is specific to a particular font or style; but I have verified the behaviour on a second machine and confirmed that the error exists in the printed output as well as on screen.

It’s unfortunate because .doc support remains a critical feature of Office – if this is a common problem, it would be enough to send me back to Word 2007.

I would love to know what is causing it. I realise there are cases where a .docx cannot be quite the same when saved as .doc, because of different features, but I have never before come across this kind of corruption. Excellent compatibility between .doc and .docx is meant to be a key reason to use Microsoft’s Open XML.

Incidentally, it is not unique to documents which start life as .docx. I get the same problem if I set the default format to .doc and type the same content.

Update

I got this one wrong. It is not a bug in Word 2010; it is the same in Word 2007, and I’m surprised I have not noticed it before. The likely reason is that it only occurs at 16pt and higher, which is when kerning is enabled by default. The fix is to disable kerning in that style (Heading 1):

image

Curiously, the ugly font does look better in Word 2003 on Windows XP; I don’t have Office 2003 installed on Windows 7 so cannot test that combination.

Of course this does still illustrate that saving a .docx as .doc can spoil the formatting.

A business web site implemented entirely in Silverlight

Ever wondered what the web would look like if Silverlight or Flash were used for everything? The other day I came across a business site implemented entirely in Silverlight – well, apart from the forums, which seem to be HTML and JavaScript. ForefrontSecurity.org is a third-party resource site for Microsoft’s firewall and server security products. It is mostly documents and videos.

image

On the plus side, the site looks good, provided you can run Silverlight; and given the target readership that’s not too much of a stretch in this instance. Playing the embedded screencasts is very smooth, and they feel seamlessly integrated with the site, more so than with HTML plus a video plug-in.

That said, I found the site infuriating. Without thinking, I tried to scroll a document using the mouse wheel; nothing happened. The page up and down keys do not work either. Copying text works with Ctrl-C, but if you select and right-click, you just get the Silverlight “about” menu. I also found that the graphic effects – screens typically fade in as they change – made the site seem slow. Some things, like hyperlinks in full-screen mode, did not work as expected.

An interesting experiment; but for a site like this which is mainly about finding and reading documents, its hard to see a good reason not to use HTML.

Office Web Apps better then Open Office for .docx on Linux

I’ve been reviewing Office and SharePoint 2010, and trying out Ubuntu Lucid Lynx, so I thought I would put the two together with a small experiment.

I borrowed a document from Microsoft’s press materials for Office 2010. Perhaps surprisingly, they are in .doc format, not the Open XML .docx that was introduced in Office 2007. That didn’t suit my purposes, so I converted it to .docx using Save As in Office 2010.

image

Then I stuck it on SharePoint 2010.

Next, I downloaded it to Ubuntu and opened it in Open Office. It was not a complete disaster, but the formatting was badly messed up.

Finally, still in Ubuntu, I navigated to SharePoint and viewed the same document there. It looked fine.

Even better, I was able to click Edit in Browser, make changes, and save. The appearance is not quite WYSIWYG in edit mode, but is the same as in IE on Windows.

The exercise illustrates two points. One is that Open Office is not a good choice for working with Open XML – incidentally, the document looked fine when opened in the old binary .doc format. The other is that SharePoint 2010 and Office Web Apps will have real value on mixed networks suffering from document compatibility issues with Office and its newer formats.

HP hedges mobile bets by buying Palm and webOS

I love that this industry is full of surprises. This week has brought a couple. One is HP getting seriously into mobile by buying Palm – I think this is good news since webOS, based on JavaScript and the W3C DOM, is an interesting platform that was otherwise near to death. But surely HP is Microsoft’s trusted partner and might be expected to back Windows Phone 7? That’s the other intriguing aspect. HP has suffered as Windows Mobile has stuttered, and with mobile fast becoming the computing client that matters most, Microsoft’s platform does not look like a safe bet.

HP’s problem though is that webOS does not look like a safe bet either. In the context of HP’s overall business, Windows Mobile, now Windows Phone, makes more sense; and it cannot afford not to do the Windows stuff alongside whatever is planned for webOS. As HP told the Reg:

HP intends to continue selling Windows-based devices. "We believe in choice," Bradley said. But it sees a brighter future in offering Windows phones and tablets alongside systems based on webOS, which debuted earlier this year on the Palm Pre. "With Palm, HP acquires a strong operating system to deliver a unique customer experience," Bradley said.

It’s a mixed message, which means it is hard to articulate, and hard to make it work.

Nor it is the first time HP has wavered over Windows for mobile devices. Remember when HP rebadged the iPod, back in 2004? It was a short-lived experiment, to nobody’s surprise. This deal makes more sense than becoming an Apple OEM, but it will still be hard for HP to pull off.

The other surprise, also mobile related? Apple no longer lovers Mac developers.

Microsoft – make up your mind about Moonlight

I’ve been trying out Microsoft’s Office Web Apps, as provided for the release version of SharePoint 2010. The cross platform story is uneven, whether across Mac/Windows/Linux, or across different browsers, or even across different versions of Windows and Office. So far it does mostly work though, even if there are problems with certain tasks like printing or opening an online document in a desktop application.

The biggest problem I’ve had is on Linux. Supposedly Firefox 3.5 on Linux is supported. I ran up Ubuntu and Firefox 3.5, and went to look at a document in Word Web App. When I selected the document, Firefox quit. Every time.

After checking that Firefox was up-to-date it occurred to me that the problem might be related to Moonlight, the Linux implementation of Silverlight done by the Mono team. I disabled it. Suddenly, everything worked, even Edit in browser.

Moonlight is not just an open source project like the original Mono. It has a certain amount of official blessing from Microsoft. Here’s what VP Scott Guthrie said back in September 2007:

Over the last few months we’ve been working to enable Silverlight support on Linux, and today we are announcing a formal partnership with Novell to provide a great Silverlight implementation for Linux.  Microsoft will be delivering Silverlight Media Codecs for Linux, and Novell will be building a 100% compatible Silverlight runtime implementation called “Moonlight”.

Moonlight will run on all Linux distributions, and support FireFox, Konqueror, and Opera browsers.  Moonlight will support both the JavaScript programming model available in Silverlight 1.0, as well as the full .NET programming model we will enable in Silverlight 1.1.

You would think therefore that Microsoft would test the Firefox/Linux/Moonlight combination with its shiny new Office Web Apps. Apparently not. Here’s what the user experience is like for Office Word App. I figured that the solution might be to upgrade Moonlight to the latest version, so I did, installing what is now called Novell Moonlight 2.2. I went back to Word Web App. Firefox no longer crashes, but I now get a blank area where the Word document should be shown, and an error if I resize the browser window:

Now let’s see what happens if I disable Moonlight:

Everything is fine – except now there is a banner inviting me to “Improve my experience” by installing Silverlight. If I follow the link I eventually get back to the same Moonlight install that I have just enabled, which would actually break rather than improve Word Web App.

It is obvious that if users have to disable Moonlight to work with Office Web Apps, this will not help Moonlight adoption on Linux.

Office Web Apps are new and I’d hope this is something that Microsoft, Novell and the Mono team can soon fix between them. One reason for highlighting it now is the hope that something could be done before the full roll-out of Office and SharePoint 2010 on May 12th.

The real point though is what this says about the extent to which Microsoft cares about Moonlight and Linux users, and how much or little communication takes place between Microsoft and Novell. Silverlight isn’t required for Office Web Apps – as you can see from the above – but it is used to good effect where available, and this Office release is therefore an important release for Silverlight as well.

Microsoft should make up its mind. Is Novell really a trusted partner for Silverlight on Linux? Or a third-party product that has to take its chances?

DevExpress merges its Silverlight and WPF UI controls, says VS 2010 is light years ahead

Developer Express is a component vendor with add-ons for Visual Studio and Delphi. It has offered a library of components for Silverlight for some time, and a separate set for WPF (Windows Presentation Foundation), but now says that Silverlight and WPF are close enough that it can merge the two into a single codebase to be called XPF (Express Presentation Framework). CTO Julian Bucknall says:

Silverlight in v4 has the ability to create desktop applications that aren’t sandboxed into triviality. In fact, Silverlight, more than ever, resembles a WPF-lite on the desktop side, to the extent of pundits considering their eventual merging. At long last it is possible to write one set of non-trivial code and compile it both for Silverlight and for WPF without having to reinvent so many wheels on the Silverlight side (and to a much lesser extent on the WPF side).

Even though Visual Studio 2010 is only just released, DevExpress is focusing all its new Silverlight and WPF development on the new platform and IDE:

The Silverlight and WPF controls in DXperience v2010.1 will require .NET 4 and VS2010. In particular, you must use the new Silverlight 4 and WPF 4; the controls will not function with the previous versions of WPF and Silverlight, such as Silverlight 3. Similarly, you cannot use VS2008 or earlier, but must use VS2010. To my mind this isn’t that much of a downside: VS2010 is light years ahead of its earlier brethren in terms of user experience and its use is de rigueur if you are creating applications with either Silverlight or WPF.

Of course it’s in Bucknall’s interests to move developers on; he’s keen to sell upgrades. I still find this interesting. Like him, I find Visual Studio 2010 a major advance on earlier versions. More significant though is the idea of a common WPF and Silverlight codebase, though presumably still with added capabilities when running on WPF. I don’t think Windows-only development is dead; the success of Windows 7 may even stimulate the market for applications that take advantage of its new features. That said, for the large subset of applications where cross-platform is desirable, Silverlight seems to me a better choice than WPF.

Keeping track of Microsoft financials

I’m in the habit of drawing up a simple table to summarise Microsoft’s quarterly results.

Quarter ending March 31st 2010 vs quarter ending March 31st 2009, $millions

Segment Revenue Change Profit Change
Client (Windows + Live) 4415 +967 3061 +788
Server and Tools 3575 +84 1255 +31
Online 581 +59 -713 -302
Business (Office) 4243 -265 2622 -134
Entertainment and devices 1665 +36 165 +206

Windows 7 booming, Office a bit slow prior to the release of the 2010 version, Online still draining money. Xbox doing OK. In other words, nothing much of interest.

First look Outlook 2010 RTM – speed good, conversation view bad

I’ve been trying Office 2010. I use Outlook with Exchange 2007 and was interested to see how it compares to Outlook 2007.

In terms of things I care about, not much has changed. That said, it took me a long time to wrest good performance out of Outlook 2007 – which is why this blog is a top Google hit on “slow outlook 2007” – whereas the speed of Outlook 2010 seems fine right out of the box. I haven’t tried all the permutations though: cached and non-cached, 32 or 64 bit, and so on, so consider this only a preliminary impression.

One of the reasons is that the Outlook team has abandoned integration with Windows Desktop Search for online mailboxes:

The Search Toolbar add-in setup code is removed in Outlook 2010. The Search Toolbar add-in enables local indexing of online mode Exchange Server mailbox stores by using Windows Desktop Search. As a result of this change, e-mail in online Exchange mailboxes will not appear in the results of Windows Explorer searches. The online indexing add-in is a legacy component that adversely affects performance of Outlook during startup and shutdown. With this removed in Outlook 2010, users will experience improved Outlook reliability and significantly lower Exchange bandwidth usage. For fast search, use Cached Exchange Mode or for online mode, use Exchange Search in Exchange 2007 and later versions.

So what else is new? You can see a technical summary here. Outlook has now had the full Ribbon treatment, which I suppose is good for consistency, though plenty of annoyances remain. For example, let’s say you’re trying to figure out whether an email is genuine or not. I had one that gave me pause for thought, supposedly from Amazon.com. The first thing I check is the message header – no, not the thing Outlook still calls the “message header”, which adds a couple of fields to the top bar. What I need to see is the email header, showing the origin of the message and its path across the Internet. I clicked around hopefully. Eventually I found it – you have to click the down arrow at bottom right of the Tags (huh?) section of the ribbon:

image

This opens what Outlook calls Properties, including the “Internet headers” which are what I want to see. The message was spam, by the way – it came from a domain that has nothing to do with Amazon:

image

Fortunately you can add this dialog to the Quick Access Toolbar. Simply go to Customize Quick Access Toolbar –> More commands, and add the Properties command. Except it’s not called Properties. The dialog is called Properties, but the command is called Message Options…

image

I am so used to this sort of thing with Outlook that I expect it; Outlook 2010 is no worse than its predecessor.

[Update: Ed Bott points out in the comments that you can also get to the Properties dialog through the File tab.]

Other new features include Quick Step macros – could be handy though I can’t think of a reason I will use it; connection to multiple Exchange accounts which will be excellent for those who need it, especially if you can use cached mode with all of them (I’ve not checked); and a bunch of stuff that only lights up if you have Exchange Server 2010, such as (at last) server-based archiving – no more archive.pst files littered around every machine you ever use.

I do want to mention one persistent disappointment though. Conversation view. Why can’t Outlook behave like a discussion forum, where each thread is grouped? In theory it can: just switch on Conversation View. In practice it is useless, because instead of using the In-Reply-To field that identifies a message which is a reply to another message, Outlook 2010 uses the subject line.

The subject line is hopeless as a means of defining conversations. Worse, it’s dangerous. Let’s say you’ve got an unimportant “conversation” with the subject “June 20th” – it’s about a meeting you don’t need to attend. Then you get an email also entitled “June 20th” from someone else; this one is critically important. By grouping it into the existing “conversation”, Outlook disguises its importance.

I recall being told at Microsoft’s PDC last November that the Outlook team was aware of this problem in the preview and it would be fixed somehow. However, when I switched Conversation View on briefly in Outlook 2010 RTM I saw exactly the same problem. I suppose there is a chance that upgrading to Exchange 2010 magically fixes it; this on the to-do list for me. For now, the solution is not to use Conversation View at all.