Office 2010 Beta – 32-bit or 64-bit – The Choice is Clear

Monday, November 23rd, 2009

Microsoft Office 2010 Beta comes in both 32-bit and 64-bit versions and this is the first time that a 64-bit version of Office has been available. 64-bit processing brings some advantages but are they outweighed by the disadvantages of being on the bleeding edge of technology?

If you’re running 64-bit Windows Vista or Windows 7 (or Server 2008 or Server 2008 R2), you can choose whether to the install 64-bit version of Office 2010 beta. (It is not compatible with 64-bit Windows XP.)

The advantages of the 64-bit version are that it lets you use additional memory installed on your computer – for example Excel 2010 workbooks can be bigger than 2GB. Project 2010 can work with very large projects consisting of many sub-projects. You also get enhanced security through Data Execution Prevention (DEP) by default.

But, not many people will actually need Excel Workbooks bigger than 2GB. If you ever made one, you could not store it in SharePoint – 2GB is SharePoint’s limit for any file – and you could not share it with anyone who wasn’t running 64-bit Office 2010 because they wouldn’t be able to open it.

Access databases with their code removed (split data & code in separate files) can’t be shared between 32-bit and 64-bit versions of Office and any VBA code may not be compatible between 32-bit and 64-bit versions, particularly where the code declares API calls to Windows or uses the new LongLong or LongPtr data types introduced in the 64-bit version.

Graphic elements may render more slowly in the 64-bit version of Office because 64-bit CPUs may lack MMX support for multimedia and communications.

The biggest problem by far is that ActiveX controls Add-Ins and COM DLLs written for 32-bit Office will not work with the new 64-bit version. Microsoft are due to release a new VSTO (Visual Studio Tools for Office) runtime which will bridge this gap for DLLs and Add-Ins written using VSTO but it isn’t available yet. Other manufacturers will have to test, possibly change, and re-issue their DLLs and Add-Ins in 64-bit versions to get them to work.

There are yet more problems if you try to work with web based solutions that use ActiveX controls. For instance SharePoint uses an ActiveX control to render SharePoint lists in Datasheet View. This view is not supported if you install the 64-bit version of Office 2010.

All in all, the 64-bit version of Office is useful to very few people and has many limitations. The vast majority of people will be much better off sticking to the 32-bit version.

Outlook 2010 People Pane – does it spell death to Xobni

Thursday, November 19th, 2009

Completely new in Outlook 2010 Beta is the People Pane. This appears below the Reading pane in the main window and in all the individual item windows. It shows thumbnail images, one for every person (or email address) associated with the item and lets you quickly access other items which are also associated with that person/address.

The contents shown in the People Pane are derived from the Windows Search index which is kept up to date as new items are created or arrive via email. When you first install Office 2010 Beta all your existing Outlook items must be re-indexed so don’t expect the People Pane to spring to life immediately but once indexing is complete all the other emails, attachments and meetings known for a person are just a click away. (more…)

Co-Authoring in Word 2010 and SharePoint Foundation 2010

Thursday, November 19th, 2009

Now Microsoft have released beta test versions of Office 2010 and SharePoint 2010 we can start to see what they’ve been talking about in the “co-authoring” arena. SharePoint Foundation 2010 supports multiple people editing Word, Excel, PowerPoint and OneNote documents at the same time. When you store your documents in a SharePoint document library, any number of people can open the document and they see who else is editing the document in the status bar. Your changes are bracketed with a blue line in the left margin and you get notifications when other people’s updates are available.

When you save your changes, you also get to see the other person’s changes that they have saved highlighted in green.

It seems that making small changes and saving often is the best way not to tread on each other’s toes.

In the Info section in Backstage (File | Info) you can see who is editing the document and send messages to them by email or by instant message (if you have Office Communicator). At the bottom of the Info section you can also see and manage all the different versions of the file, either autosaved or previous versions held in the SharePoint document library.

Co-authoring documents is going to be very useful for many people and it is good to see it is included in the free SharePoint Foundation 2010 and not reserved for SharePoint Server 2010 which will cost quite a lot of money.

Office 2010 Applications & Editions

Monday, July 13th, 2009

The, invitation only, Office 2010 Technical Preview has finally started and Microsoft have released details of which applications are going to be available in which editions of the Office suite.

As the information is a little difficult to take in, I thought I’d do a quick summary table.

The main changes are the reduction of the number of editions from eight to five and the fact that the Small Business Edition (which had more applications than Standard Edition) is retired and replaced by the new Home & Business Edition (which has fewer applications than Standard Edition). Another change is that Standard Edition is only going to be available through Volume Licensing.

Some very good news is that all editions will now carry OneNote. Hooray!

Update: Just for clarification, the spot against Web Apps in the table above is the right to run the new Word, Excel, PowerPoint and OneNote web based applications on your own server hardware. Everyone will have access to the Web Apps free through Office Live or through a hosted subscription service.

Infragistics Quince

Tuesday, February 24th, 2009

Infragistics, who make User Interface controls for Windows Forms, WPF, Silverlight and ASP.NET applications, have just introduced a new web site called Quince.

Quince is a community tool that lets you explore and contribute to a growing library of UI Design Patterns – ways of designing a user interface to make it easier to use. Each pattern relates to a little piece of UI functionality, such as data validation, modal dialogs, filtering, etc and explains, with examples from real-world applications, when you might use that pattern and how you might implement it.

Users can contribute by adding text to say how they think the pattern might be changed or improved, adding extra examples or simply voting to say “I use this” so future users can see which patterns are popular.

You can explore the patterns in many ways, from an outline form where patterns are listed in-place or by tag relations which groups and connects patterns together to show how the patterns relate to one another. There are even RSS feeds so you can get alerts to newly entered patterns or comments.

(more…)

Want to try IBM Lotus Symphony?

Wednesday, August 6th, 2008

If you want to download and try Lotus Symphony, IBM’s free office productivity suite, be prepared to be treated as a criminal suspect. IBM won’t let you have the installation kit until they’ve checked you out. You have to hand over your name, country and email address and then you get the message:

“This product is subject to strict US export control laws. Prior to providing access, we must validate whether you are eligible to receive it under an available US export authorization. Your request is being reviewed. Upon completion of this review, you will be contacted if we are able to give access. We apologize for any inconvenience.”

It’s a word processor, not the designs for a nuclear bomb. No, they’re easier to obtain.

After waiting a day you then get an email entitled “IBM Lotus Symphony 1 failure”

“Your business with IBM Lotus Symphony 1 is very important to us. We are sorry that your previous transaction with us did not go through. We have fixed this error in your account. Please return to the IBM Lotus Symphony 1 web site to resubmit your transaction. Thank you and sorry for the inconvenience.”

What failure? What error? What account? At least they include a URL in the email to get you back to the download page, where you have to give you name, email address and country again.

What a palaver.

Navigating in Excel

Sunday, June 8th, 2008

I’m often amazed when watching people use Excel how difficult they seem to find navigating around their workbooks. They’re always using the mouse and reaching for the scrollbars to drag the sheet around to find a particular cell. If you’re lucky they know to use the mouse wheel to scroll. If you’re unlucky they use the mouse wheel to scroll long distances which can be tedious in the extreme.

Excel, like all good applications can be used entirely from the keyboard and often this is much faster than reaching for the mouse.

Everyone should know that the arrow (cursor) keys move the current focus or insertion point left, right, up or down and I hope they know that holding the Shift key down at the same time selects the characters, cells, etc in the given direction. Far fewer people, however, seem to know that holding the Ctrl+Arrow will take you to the edge of the current contiguous block of data, that Ctrl+Home takes you to the top left cell or that Ctrl+End moves focus to the bottom right cell of the current worksheet.

Here’s a quick summary of useful navigation keys for Excel.

In “End Mode” the next arrow key moves the focus to that edge of the current data range, the same as Ctrl+Arrow. If you press End and then Shift+Arrow, you select the cells to that edge of the data range, the same as Ctrl+Shift+Arrow.

To select the whole of the current data range, press Ctrl+Shift+* or Ctrl+A. Ctrl+A is a little more intelligent as it selects just table data, if focus is in a table. Pressing it a second time includes the table header. Pressing it a third time will select the whole sheet.

Why doesn’t it “Just Work”?

Thursday, May 15th, 2008

Bluetooth is the bane of my life at the moment. Designed to make quick and easy wireless connections between disparate devices it often fails to be quick, easy or indeed connect.

I have Jabra BT620 headphones for listening to music while I work without disturbing my colleagues. Every time I use them they connect in mono using the “handsfree” profile which gives tinny monophonic sound suitable for phone calls. To get stereo I have to go through the pairing process. Every time!

The Pioneer radio/SatNav system in our car will connect using Bluetooth to Mike’s phone to route phone calls to the car’s speakers and microphone. It will connect to my phone too but only so the phone can provide audio from its media player, a function it won’t do from Mike’s. What is even more annoying is that both phones are HTC TyTN II. Why can’t they both connect using both profiles? It is a mystery.