Wide screens and Ribbons
Dave Ziffer left a comment in my post asking ‘Do you like the Ribbon?’ with a link to a piece he wrote about it called The Computer Industry’s Usability Catastrophe. There’s some good stuff there, so I thought I’d create a new post rather than leave a comment.
In many ways I agree with Dave that the combination of widescreen notebooks and the Ribbon is not a good one. Vertical space on screen is now more valuable than ever and there’s no way to move the Ribbon. At least Toolbars in Office 2003 could be docked on the side of the screen or left floating as shown on the right.
I also miss the ability to customise the Ribbon as I have my own toolbar in Word 2003 with only the tools I need that fits comfortably on one line. That will be partially fixed in Office 2010 as some customisation will be possible in that version.
Having said that, I think that some of the Ribbon criticisms are a little harsh. The Ribbon can be hidden with a quick double click on one of the tabs and it then acts much like the old menus. And all the old keyboard shortcuts still work although there’s no visual feedback until the command is completed. For more information see the Microsoft Office Keyboard shortcuts in the 2007 Office system training page.
Moving from Lotus Notes to Outlook? Use a Nokia mobile
I’ve written before about how good Nokia PC Suite is at connecting mobiles to Windows is but I’ve found a new use for it. Moving contacts and other information from Lotus Notes to Microsoft Outlook.
For all the attractions of Outlook, the big problem was moving all my information from one to another. It’s not a small job and accuracy is important. Sadly there didn’t seem to be any utilities for this with prices within my budget. Creating a text file with the information and then matching the field names didn’t really seem a good use of my time either.
The quick and cheap (assuming you have access to a Nokia phone of some description) solution is to synchronise Notes with the phone and then change the Nokia PC Suite settings to use Outlook instead. Synchronise the phone again and hey presto! All the information is now in Outlook.
It gets even better given the fact that PC Suite works surprisingly well with Bluetooth, so there’s no need to buy a propriety cable.
Fixing problems without System Restore
System Restore is helpful, but can be switched off to save hard disk space. That doesn’t seem like a good idea anymore when something goes wrong with the computer, which happened to me this morning.
The computer seemed to be working but none of the web browsers would start properly. Internet Explorer, Firefox (ordinary and portable) and Opera appeared in Task Manager but not on the Desktop.
System Restore seemed like the best solution but I then realised that I’d turned it off.
Thankfully there is an alternative that was not disabled along with System Restore. Restart the computer and press F5 or F8 to show the Windows Advanced Options Menu. Press the up key until ‘Last Known Good Configuration (your most recent settings that worked)’ is highlighted and press Enter.
In my case, Windows loaded without any further messages and all the browsers were working again.
Because I don’t know exactly what went wrong I can’t say when this would work or not, but it’s certainly worth a go if there are problems with Windows that System Restore can’t fix.
Book Review: Don’t spend a dime
We all want to save money at the moment, and computers can certainly get expensive. Hardware is always going to cost money (although netbooks are surprisingly cheap) but there’s a huge amount of software that costs nothing to use.
Don’t spend a dime takes a look at all how you can save money by using free software rather than expensive alternatives. There is a helpful guide to choosing a computer but the prices are all in dollars so specific advice is a little limited here.
Currency doesn’t matter when the software is free. The first software to come under attention is the office suite with separate chapters for word processing, spreadsheets and presentations. It’s no surprise to see Open Office and Google Docs. Personally I prefer Zoho but Google Docs is still a good choice. Google is also recommended for email and calendars.
I was pleased to see that the advice doesn’t stop there and other important, but maybe less exciting, topics are also covered including anti virus protection and backup. There’s even an alternative to the ever popular (and expensive) World of Warcraft.
This is a very useful introduction to the world of free software, and includes enough help to get you started with all of the recommendations. A longer list of alternatives would be good, especially for the blogging section, although there’s nothing wrong with the suggestions on offer. This book is a good investment when compared to the cost of the software that you could otherwise pay for.
Title: Don’t Spend a Dime – The path to Low-Cost Computing
Author: James Floyd Kelly
Publisher: Apress
Price: £20
ISBN: 978-1-4302-1863-0
Windows Browser Choice annoyance
I was a little surprised to see the Browser Choice window appear on my Windows XP MCE notebook the other day.
Asking around the office revealed that it will appear if Internet Explorer is still selected as the default browser. Frankly I'd stopped it from asking and just started browsers with the Quick Launch toolbar or with Launchy.
The annoyance with the selection window was that there was no way for me to tell it that I already had several of the alternative browsers installed and wanted to use one of them as my default.
In the end I clicked on the install button for Opera just to make the window go away and cancelled the download. I restarted the computer and the Browser Choice window hasn't reappeared. Despite the fact I haven't changed the default. I suppose it's the taking part that's important.
Friday Fives: What's on show at Cebit 2010
CeBIT, held each March in Hannover, Germany, is one of the biggest showcases of new computer technology in the world, and this week Computeractive has been there to check out all the latest products that'll be on sale over the next six months. With thousands of exhibitors there are just too many to list, so we've boiled it all down to the the best products that represent five key trends from this year's show.
1) Loud Laptops
Laptop computers don't have a great reputation when it comes to sound quality, and with good reason: most have tiny, tinny speakers packed into the case as an afterthought. This year, though, several of the biggest computer names at Cebit have been showing portable computers that, they claim, are designed to sound great.
The Asus NX90 is certainly eye-catching: it's huge and completely covered in brushed aluminium. And, alongside some unusual features such as the two touchpads - one on either side of the keyboard - it has a powerful sound system provided by Bang and Olufsen IcePower. Its speaker enclosures have a volume of 108cc, and although it's very hard to judge the quality of sound in a busy trade show we can testify to the volume on offer.
A similar product was also on show at the stand of Asus's key rival MSI. Its GT660 gaming laptop packs a Core i7 processor, Blu-ray, two hard disks and Nvidia 285M graphics, but also a 2.1 sound system from Dynaudio - again, it's impressively thunderous.
2) Smart Storage
Network attached storage devices are to be found everywhere at the show, with the manufacturers seemingly adding new functions each and every year, but a few in particular stood out. The new Thecus N4200 has an unusual case with two displays, but there's also a lithium-ion battery in the back - if the mains power supply fails, this gives it enough power to shut down properly, saving your data.
Not to be outdone, rival Qnap was demonstrating its new QMobile tool for the iPhone and iPod Touch - this gives access to the multimedia functions of its NAS devices from any Apple mobile handset.
3) Neat Networking
Network storage aside, there are plenty of clever networking products on show. We particularly liked Devolo's new Smart+ powerline network adapters: instead of using LEDs to indicate the network status, these use an LCD display to provide far more information on the status of the network. The company was also showing this prototype of a new product due in September - this little white box will run at speeds of up to 500Mbps:
Also, good news for anyone who was tempted by our review of the AVM Fritzbox but couldn't stretch to the price: the company is launching a new, simpler model with the ISDN functions removed and a much lower price. The Fritzbox WLAN 3370 includes 802.11N networking, and should cost around £115 - it'll be available in a few months.
4) Powerful Programs
Although Cebit includes hall upon hall of new computer hardware, there are also dozens of software vendors showing off their new tools. As we reported previously, security firm Kaspersky Lab used Cebit to launch its new PURE antivirus product - read our story on that here.
Another clever new tool could be found on the Laplink stand. The company is adding a new feature to its PCMover software called the PCMover Image Assistant. This allows users to move both programs and files from a hard disk image to a new PC: so, for example, if you have an image backup of a Windows XP computer, and that fails, you can use the tool to move your programs onto a new Windows 7 PC without having to first reinstall XP. As well as appearing in future versions of PCMover, it'll be included with some disk imaging tools from O&O.
5) New and Unusual
From USB keys in every imaginable shape to foldable pianos to somewhat tasteless computer accessories (don't ask) there's all manner of odd goods on show at Cebit. Some look downright awful, but then there are a few unusual products that caught our eye. Thermaltake's Tt eSports brand may have a very strange name - that extra "t" is not a typing error - but its new keyboard might appeal to gamers or workaholics: reach around the back and there's a small fan that can be clipped onto the top of the keyboard to keep your fingers cool during frantic activities such as gaming or filling in an online self-assessment tax form at the last possible minute. The keys also illuminate in any one of 256 colours.
Also, while Asus and MSI compete to show the biggest range of unusual PCs - from 3D desktops and laptops to concept models and Asus's Bamboo range ("panda friendly", we're assured), there's one computer that really sticks out: the Eee Keyboard.
We saw a prototype at last year's Cebit, but with the finished product due in May this device finally seems to be ready for the market. It has a 5 inch capacitative touchscreen built in, runs Windows XP and can link up to your television via an ultra-wideband transmitter. It uses an Atom N270 processor, 1GB of memory and will be available with 16GB or 32GB of solid state storage - expect to see it on sale for less than £600.
Extending conditional formatting in Excel 2003
Excel 2003 is limited to three conditions for Conditional Formatting but it is possible to add more by using a macro instead. It’s a little harder than Excel 2007 but it is still possible.
The macro must be set to run every time the spreadsheet is updated so you can’t use the recorder. Our example uses a score sheet for the BBC Weekly Quiz.
Before we start writing any macros, though, we need to decide on the colours for the winner cell because the macro will refer to the colour by its number not the name. A list of the colours can be found at at mvps.org. I printed out the spreadsheet and wrote the numbers down as I found them.
Click on the Tools menu, Macro and then Visual Basic Editor. Alternatively you could press Alt and F11 as the keyboard shortcut to launch the Visual Basic Editor.
Double click on Sheet1(Sheet1) in the section VBAProject (7 days quiz.xls), where the text within the brackets is the name of the spreadsheet. Click on the drop down menu at the top of the right hand section of the window that says (General) and select Worksheet. Next select Change from the drop down menu on the right. Left-click in the gap above the first text [code]End Sub[/code].
Type [code]Dim winner As Range[/code], press Enter and then type [code]Set winner = Range(“E4”), where E4 is the cell with the winners name in. Press Enter and type [code] Dim winnerColor As Integer[/code], press enter twice, type [code]Select Case winner.Value[/code] and press enter.
The following section is where you enter the name of each entrant their colour. For example type [Case “Nick”[/code], press Enter, type [code]winnerColor = 3[/code] and press Enter. Repeat this for as many people are in the quiz.
When all the names are in the list, type [code]End Select[/code], press Enter and type [code]winner.Interior.ColorIndex = winnerColor[/code].
The completed code should look the screenshot on the right.
Click on the save icon in the toolbar at the top of the Visual Basic Editor to save the changes. Click on the Excel icon to the left of the Save icon to return to the spreadsheet. Try changing the scores to test that the correct colours are used.
Apart from having to use the Visual Basic Editor to add or change the entrants to the quiz, the only drawback with this solution is that Excel Macro Security must be set to Medium to allow the macro to run.
Download review TimeEdition
Tracking how much time you’ve spent on a task may not sound like fun, but it can be a helpful tool for staying on top of the todo list. I also find it helpful for staying focussed on a particular task.
TimeEdition is a time tracker that offers lots of advantages over trying to keep track of time with pen and paper. It divides time by client, project and task. If that sounds a bit corporate you could divide time up between Subject, Project and essay. All of these can be selected via the drop down menus and then started with the play button.
The link above is for the Windows version but there are Mac and Linux versions on the TimeEdition download page.
There are some helpful tools to make sure that it is as accurate as possible. It keeps an eye on the computer and will automatically stop if the computer is left idle for a certain length of time. Alternatively, the timer can be set to display a countdown to give a greater sense of urgency.
One disappointment with TimeEdition is that it has no way of keeping it on top other windows, so I found it easy to forget to start the timer again after getting a coffee or lunch.
TimeEdition is also very capable at exporting the information it gathers. Files can be created for Excel, CSV, iCal or XML. If you fancy being very open (and therefore scarily accountable) TimeEdition can create appointments in iCal, Outlook and Google Calendar based on the time spent of different projects.]
TimeEdition is open source, so there’s no charge for downloading or using it. Unlike far too many open source projects, there’s a well written manual, so there’s no need to mess about with settings getting your bearings.
I have to admit that I’m using Klok, an Adobe Air program for my own personal time tracking. This is mainly because it can show how the week has been spent and it has a simple system for making template projects. TimeEdition is a much better program if you want to charge for time spent on projects and the autopause avoids forgetting to stop the timer when nipping out for lunch or a coffee. TimeEdition also has the advantage that it is self contained in one folder, so you can run it from a USB memory key or from a folder synchronised online with a service like Dropbox.
Browser design flaw? Or is it search engines?
I took call from a reader today who couldn't access a link in the magazine because they had entered it into the search engine box rather than the address bar of the browser. It's an easy mistake to make. After all, the search box is right in the middle of the screen.
It's not always a problem, type www.computeractive.co.uk into Google and the website is the first result in the list. But, type www.snipca.com/X911 (a shortened link to Windows Update) and there are no matches.
Surely it's not beyond the likes of Google to look through the search term and warn that it might be a link in the wrong place if www or http:// is found.
There’s no such thing as privacy
Fascinating post on the F-Secure blog about what privacy settings in Facebook really mean. Sean added a photo to a Facebook account making sure that every option was set to private. Unfortunately Facebook still adds a public link for the image. Checking the link I realised that this isn’t just a link for anyone on Facebook, you don’t even need to logged in to view it.
Something to bear in mind before you post photos, no matter how funny they are.
