Cut and Paste

 

It may not sound particularly exciting, but many of the new features in Office 2010 revolve around cutting and pasting.

The Office team told me that research has shown that the most common action that users take after pasting a chunk of content into an Office document is hitting the undo button. Office 2010 sports new pre- and post-paste features, housed in context-sensitive Smart Tags, for reducing the need to hit undo.

For instance, in Word, I copied to my clipboard a chunk of text, bullets and images from one document, and shifted to a new document. Right-clicking in the part of my new document in which I meant to paste the content pulled up the familiar menu of options, with a few additional Paste Preview choices. I could retain the formatting from my source document, shift to the formatting style from my new document or retain only text. For each option, I could preview the outcome by hovering my mouse over each paste option. I was also able to switch among these paste formatting options after I'd pasted the content, again via a Smart Tag.

Excel 2010 boasts its own version of undo avoidance with cut and paste. I copied a multicolumn file list from a PowerShell command line and pasted it into Excel 2010, only to find that all my chosen content had been stuffed into a single column. Rather than undo the operation and figure out how to turn Excel's text import engine on my data, I was able to click on a Smart Tag that appeared near the text I'd pasted. The tag offered to re-run my paste operation through Excel's text import wizard.

Similarly, I entered the number 1 in the first cell of a spreadsheet column, grabbed the corner of the cell with my mouse, and dragged down 30 or so rows. Excel filled each cell in the set with a 1, and spawned a Smart Tag to ask if I'd intended to fill the cells with a series of numbers--1, 2, 3 and so on.

Office's handy free-form note-taking application, OneNote, also receives a helping of cut-and-paste goodness in Office 2010. I could, for instance, paste a chunk of text into a OneNote notebook as an image file, and later ask OneNote to recognize and copy the text out of my pasted picture. I found that, as with any OCR operation I've tested, OneNote's text extraction accuracy was less than perfect.

I was also able to paste passages from other Office documents into OneNote, and the application preserved a link back to the source document for future reference. Similarly, through integration with Internet Explorer 8, I could add text and images to my notebooks from the Web, and retain a link back to the source page.

Pictures & Video

Many document- and presentation-building tasks for which Office users tap Word and PowerPoint involve pictures and video. Office 2010 stands to make these tasks a bit easier with an assortment of new multimedia features.

PowerPoint and Word both have an option embedded in their Ribbons for inserting screenshots of active windows into documents or presentations. Choosing this option spawned a dialog with thumbnails of all the open windows on my test machine. I could choose to insert these thumbnails into my document or presentation. I could also grab new screen clippings to insert, but I had to make sure that the window from which I wished to clip was the one I was viewing just before focusing on the Word or PowerPoint window. I found it easier to select a whole window and do my cropping as a second step.

PowerPoint 2010 has picked up some new, slick-looking Smart Art elements, along with some fancy new Apple Keynote-style slide transition effects.

In addition, PowerPoint has gained the ability to trim embedded videos down to size with fairly easy-to-use controls. The application offered the option of embedding Web-hosted videos, but I had trouble getting this feature to work with the YouTube video that I tried out during my test.

I was happy to see that PowerPoint now includes Windows Media Video as an output format--previously, exporting presentations to video required a separate plug-in. I'd like to see PowerPoint join OpenOffice.org Impress in adopting Adobe's SWF as an export format, as well.

During my tests, I had a bit of fun with Word 2010's new image manipulation capabilities, which include a
nifty new Background Removal tool. I was able to click on a person in the foreground area of an image and direct Word to swap out my picture's background for a transparent one. Then, I managed to add a drop shadow to my image with another click.

Excel Charts

Some of my favorite new sets of features in Office 2010 are those that involve data visualization in Excel. Microsoft has enhanced the conditional formatting capabilities of Excel with easy-to-apply visuals such as in-cell data bars. I imported a set of NBA statistics into an Excel spreadsheet, highlighted the rebounds column, and then applied a data bar conditional formatting element to the column. A bar appeared in each cell representing the size of the cell's value relative to the rest of the values in my selection.

Elsewhere, I imported the statistics for a single player across a 10-year span, and illustrated the rise and fall of that player's stats in a compact, single-cell chart called a sparkline. I could add detail to my sparkline charts, highlighting, for instance, the high and low points on the curve.

Given that the OpenDocument Format support that Microsoft added to Office 2007 in SP2 carries over to Office 2010, I was interested to see if any of these handsome visualizations would survive if I saved my spreadsheet in ODF. Not surprisingly, they disappeared when I saved my spreadsheet to ODF.

I also found that the classic XLS format lacked support for sparklines and other in-cell chart goodies. However, unlike saving in ODF, which spawned a generic warning message, Excel 2010 told me explicitly what wouldn't work when I tried to save in XLS format. I would love to see Excel 2010 provide this same level of information to ODF users.

Executive Editor Jason Brooks can be reached at jbrooks@eweek.com.