So I’m not the only one ditching Microsoft Office

Rick Broida wrote a fairly harsh piece on Cnet about why he’s ditching Microsoft Office. Our reasons differ, and while I agree with all of his reasons he may not agree with all of mine. That’s OK.

I stuck with Office 2003 because its user interface is familiar and makes sense. By using the program, you learn the keyboard shortcuts from the menu and can graduate from casual user to power user relatively quickly. That went away in Office 2007, so I never moved on. Office 2003 was the best version Microsoft ever made, but it loses security updates next month, so it’s the end of the road.

Fortunately, Libre Office has a traditional user interface and most of the same keyboard shortcuts. If you don’t use mail merge, it’s a capable replacement, and it’s free and actively maintained. It’s not as fast as Office 2003 was, but neither is anything Microsoft has made since.

Now, in corporate environments, with a recent version of Office and Sharepoint you can do some really nifty things, like automatically building Powerpoint presentations from Excel spreadsheets created by different people. You could probably approximate the same thing with other software, but what I saw a Sharepoint-literate colleague build this week with MS Office was very impressive.

But I don’t need that at home, and I don’t want to pay $100 per year for the rest of my life to use a program that I tolerate at best, so I’ll save my money and move to Libre Office.

Giving Libre Office another look

With the end-of-life of Office 2003 rapidly approaching, I’m having to look at alternatives. Even after five years, I find the Office ribbon demeaning and productivity-killing, so Microsoft’s newer products are out. With Libre Office, the price is right ($0), so I’m giving it a long look.

Read more

Merge CSV files from a command prompt

I had a bunch of CSV files I needed to merge. I don’t spend half an hour loading all of them into Excel and doing a bunch of copying and pasting. Here’s how I merge CSV files from a command prompt.

Read more

How to increase the capacity of a Log Logic appliance by 45%

My 9-5 gig revolves primarily around Tibco LogLogic (I’ll write it as Log Logic going forward, as I write in English, not C++), which is a centralized logging product. The appliances collect logs from a variety of dissimilar systems and present you with a unified, web-based interface to search them. When something goes wrong, having all of the logs in one place is invaluable for figuring it out.

That value comes at a price. I don’t know exactly what these appliances cost, but generally speaking, $100,000 is a good starting point for an estimate. So what if I told you that you could store 45% more data on these expensive appliances, and increase their performance very modestly (2-5 percent) in the process? Read on.

Read more

Excel won’t scroll down or otherwise? Try this

Excel won’t scroll down or otherwise? Try this

I regularly work with Excel spreadsheets with tens of thousands of rows, correlated. Or hundreds of thousands of rows of raw data. Working with gigabytes of data taught me a lot. Including things it wasn’t supposed to, like what to do when Excel won’t scroll down or otherwise with the keyboard, or Excel mouse scroll isn’t working.

Large, complex Excel sheets are pretty fragile. Among other things, the largest of the sheets will stop scrolling. The scrollbar on the right scrolls, but the display doesn’t move. The mouse wheel scrolls, but again, the screen doesn’t move. And the arrow keys don’t work either. I can’t scroll down, I can’t scroll right, or do anything useful with the data because I can’t see the whole worksheet. In this blog post, I cover two ways to solve the problem when Excel won’t scroll.

Read more

Libre Office and Open Office both grow up a bit–together

Both Libre Office and Open Office released new versions this week, and the changelog indicates a good amount of shared code between the two, at least in this go-round. The animosity between the two—Libre Office is a fork of Open Office, dating to before the time Oracle spun the project off to Apache—may thus be overstated. Read more

No, this doesn’t mean Ubuntu and Linux are giving up

This week, Mark Shuttleworth closed the longstanding Ubuntu bug #1, which simply read, “Microsoft has majority market share.” Because Microsoft didn’t lose its market share lead to Ubuntu, or Red Hat, or some other conventional Linux distribution, some people, including John C. Dvorak, are interpreting this as some kind of surrender.

I don’t see it as surrender at all. Microsoft’s dominant position, which seemed invincible in 2004 when Shuttleworth opened that bug, is slipping away. They still dominate PCs, but PCs as we know it are a shrinking part of the overall computing landscape, and the growth is all happening elsewhere.

I have (or at least had) a reputation as a Microsoft hater. That’s a vast oversimplification. I’m not anti-Microsoft. I’m pro-competition. I’m also pro-Amiga, and I’ll go to my grave maintaining that the death of Amiga set the industry back 20 years. I have Windows and Linux boxes at home, my wife has (believe it or not) an Ipad, and at work I’m more comfortable administering Linux than Windows right now, which seems a bit strange, especially considering it’s a Red Hat derivative and I haven’t touched Red Hat in what seems like 400 years.

What Shuttleworth is acknowledging is that we have something other than a duopoly again, for the first time in more than 20 years, and the industry is innovating and interesting again. Read more

The trouble with bringing your own software

PC Magazine is advocating a bring your own laptop, with your own software approach to business. It likens it to mechanics who bring their own tools.

The trouble is that while mechanical tools in a toolbox operate autonomously and don’t interfere with one another, software residing on a computer does. Read more

Firefox 20 is out. I don’t blame you if you wait for 20.1.

I need to sync my haircut cycle with Firefox’s release cycle. It’s that time again. Version 20 is out, and it has some new features, but as frequently as dot-one releases follow new releases, I don’t blame you if you wait.

I usually update at least one of my machines right away, if only out of curiosity, but tend to let the others lag a day or two. Or a week.

And this is why I’ve been saying to uninstall Java, rather than disable it

Apple just uncovered and fixed a vulnerability that allowed an exploit to re-enable Java in a browser when it’s been disabled, which then of course allows a litany of exploits.

There are two lessons here. Macintoshes are hackable just like any other device, and latent software can be re-enabled. If you don’t think someone’s trying to do the same thing in Windows and Linux, you’re not paying attention.

Read more