And now, Excel 2007 has a few nasty surprises

I ran into something maddening today. I have a large number of self-study questions in plaintext format that I’ve been using to prepare for my upcoming test. To weed out the large number of duplicates, I massaged the file into a tab-separated format so I could load it into Excel and alphabetize it by the question wording. It worked nicely, especially in Excel 2003.

I got a nasty surprise when I loaded the same file on an Excel 2007-equipped machine.
Read more

Fixing my boss’ Outlook

My boss’ PC went wacky on Tuesday afternoon and wouldn’t let him log in, so he had no choice but to shut down the computer. The computer came back up OK, but Outlook didn’t. He got a lot of weird error messages that I didn’t see, and Outlook created a new OST file on his desktop. But Outlook refused to connect to the Exchange server, and his inbox came up empty.

Like a lot of Outlook problems, the solution was the tag-team of Scanpst and Scanost. Fortunately, you don’t have to have admin rights to run them.

Read more

Happy Patch Tuesday, September 2011

Microsoft has five updates and Adobe has two for us on this fine Patch Tuesday, in addition to a patch Mozilla pushed out for Firefox last week.

Don’t get too complacent if you run something other than Windows. If you run Microsoft Office on a Mac, or Adobe Reader or Acrobat on a Mac, or Adobe Reader on Unix or Linux, you’re vulnerable. The vulnerabilities in those affected products are more serious than the vulnerabilities for Windows. So keep that in mind. Don’t be smug about security. It’ll bite you.

Read more

Google jumps into the e-reader game

On July 17, Google and Target are introducing the Iriver Story HD, a $139 e-reader. And the more I think about it, the more I think Google is really serious about being a player in this space. The analysts who are dismissing it as a me-too, too-late product miss one key thing.

Read more

A snapshot in history of Gates and Microsoft, 1992

Hard Drive: Bill Gates and the Making of the Microsoft Empire is a 1992 autobiography of Microsoft co-founder Bill Gates. It’s old. But it’s a compelling snapshot of what the industry thought of Gates and Microsoft before Windows 95, before Microsoft Office, and before Internet Explorer. Indeed, it gives an early glimpse into the struggle to bring Windows to market, some of the bad bets Microsoft cast on its early productivity software, and just how close Microsoft came to betting the company on the success of the Apple Macintosh.

If Microsoft’s history were written today, many of these stories would probably be forgotten.

Read more

Microsoft buyouts that worked

Microsoft buyouts that worked

On May 10, 2011, Microsoft surprised a lot of people by buying Skype for $8.5 billion. The deal closed October 13, 2011. I think most people thought Facebook would do it. Now I keep hearing pundits say that this will fail, because Microsoft buyouts always fail.

Thing is, I can think of 11 Microsoft buyouts that worked out really well. Over the years, I think Microsoft has proven itself to be pretty adept at both cloning products and buying products. They don’t always improve them all that much, but they frequently remain popular.

Sometimes I think Microsoft is better at buying products than developing them. After you see this list, you might agree.
Read more

The Nlite-d Compaq revisited

I installed antivirus software on the Compaq today. As expected, it weighed things down–boot time doubled, to 40 seconds, and memory usage approximately doubled, to 212 MB.

I can’t do much about the memory usage. But half the system memory is still available for apps, which should be fine. Upgrading the memory is always an option for the future. The boot time was fixable.I ran Jk-Defrag, which is probably my favorite utility now. Full optimization didn’t take long on a system with so little on it. I used the option -a7 to sort by filename, which works surprisingly well.

To help the memory usage a little, I yanked the Microsoft Office stub out of the startup group. All that does is preload some of Office at boot time, so Office apps load faster. But modern hardware negates it. With that running, Word loads in about two seconds. Without it, Word loads in about two seconds. Windows XP’s prefetching gives the same benefit for free, so there’s no point in wasting memory on the Office startup piece.

The two changes dropped the boot time to 30 seconds, which is pretty good, especially on a conventional drive. A minute is typical for a stock Windows XP system, even on new hardware. Solid-state drive manufacturers brag about how their products can boot XP in 30 seconds.

I wonder how fast they’d boot if they’d been installed off my Windows CD?

Memory usage and boot time will jump some more when it comes time to actually use the system–scanner drivers and digital camera software need memory and take time to load. But that’s OK. My goal was just to reduce the overhead somewhat, since antivirus software is an absolute requirement these days, and its overhead is only going to go up. I ran across a year-old stash of virus definition files recently, and today’s files are more than 50% larger. The number of viruses out there is growing, and they are becoming more complex.

Cheap hardware won’t stop software piracy

Who’s to blame for rampant software piracy? According to Steve Ballmer, AMD and Intel. Oh, and Dell. Charge less for the computer, and there’ll be more money to pay for Windows and Office.

Steve Ballmer doesn’t know his history.

Read more

Munich\’s unexpected migration costs prove nothing so far

I saw an article in the Toronto Star in which Steve Ballmer was, um, well, talking gleefully about the city of Munich’s highly publicized and controversial migration to Linux, server to desktop, costing more money than expected.

So I suppose Mr. Ballmer is prepared to reimburse one of my clients for its unexpected expenses in migrating from VMS to Windows then, eh?

Read more

What needs to happen for Linux to make it on the desktop

I saw an editorial at Freshmeat that argued that there’s actually too much software for Linux. And you know what? It has a point.
I’m sure some people will be taken aback by that. The number of titles that run under Windows must number into six digits, and it’s hard to walk into a computer store and buy Linux software.

But I agree with his argument, or at least most of it. Back in my Amiga days, the first thing people used to ask me was, “What, do you not like software?” Then I asked why they felt the need to have their choice of 10 different word processors, especially when they’d just buy pirate Microsoft Word or WordPerfect anyway. (Let’s face it: Large numbers of people chose PCs in the early 90s over superior architectures was because they could pirate software from work. Not everyone. Maybe not even the majority. But a lot.) I argued that one competent software title in each category I needed was all I wanted or needed. And for the most part, the Amiga had that, and the software was usually cheaper than the Mac or PC equivalent.

Linux is the new Amiga. Mozilla is a far better Web browser than IE, and OpenOffice provides most of the functionality of Microsoft Office XP–it provides more functionality than most people use, and while it doesn’t always load the most complex MS Office documents correctly, it does a much better job of opening slightly corrupt documents and most people don’t create very complex documents anyway. But let’s face it: Its biggest problem is it takes an eternity to load no matter how fast your computer is. If it would load faster, people would be very happy with it.

But there is nothing that provides an equivalent to a simple database like Access or Filemaker. I know, they’re toys, and MySQL is far more powerful. But end users like dumb, brain-dead databases with clicky GUI interfaces on them that they can migrate to once they realize a spreadsheet isn’t intended to do what they’re trying to do with it. Everyone’s first spreadsheet is Excel. Then someday they realize Excel wasn’t intended to do what they’re using it for. But you don’t instantly dive into Oracle. You need something in between, and Linux doesn’t really have anything for that niche.

People are constantly asking me about a WYSIWYG HTML editor for Linux as well. I stumbled across one. Its name is GINF. Yes, another stupid recursive-acronym name. GINF stands for “GINF is not Frontpage.” How helpful. What’s wrong with a descriptive name like Webpage-edit?

More importantly, what was the first non-game application that caught your fancy? For most people I know, it was Print Shop, or one of the many knockoffs of Print Shop. People love to give and receive greeting cards, and when they can pick their own fonts and graphics and write their own messages, they love it even more. Not having to drive to the store and fork over $3.95 is just a bonus. Most IT professionals have no use for Print Shop, but Linux’s lack of alternatives in that department is hurting it.

Take a computer with a CPU on the brink of obsolesence, a so-so video chipset, 128 megs of RAM and the smallest hard drive on the market, preload Linux on it along with a fast word processor that works (AbiWord, or OpenOffice Writer, except it’s not fast), a nice e-mail client/PIM (Evolution), a nice Web browser (Mozilla), and a Print Shop equivalent (bzzzt!), and a couple of card games (check Freshmeat) and you’d have a computer for the masses.

The masses do not need 385 text editors. Sysadmin types will war over vi and emacs until the end of time; one or two simple text-mode editors as alternatives will suffice, and one or two equivalents of Notepad for X will suffice.

Linux’s day will eventually arrive regardless, if only because Microsoft is learning what every monopolist eventually learns: Predatory pricing stops working once you corner the market. Then you have to raise prices or find new markets. Eventually you run out of worthwhile markets. So in order to sustain growth, you have to raise prices. Microsoft is running out of markets, so it’s going to have to raise prices. Then it will be vulnerable again, just like Apple and CP/M were vulnerable to Microsoft because their offerings cost more than Microsoft was willing to charge. And, as Microsoft showed Netscape, you can’t undercut free.

But that day will arrive sooner if it doesn’t take a week to figure out the name of the Linux equivalent of Notepad because there are 385 icons that vaguely resemble a notepad and most of them have meaningless names.