The latest version of Open Office is pretty good - it can handle some pretty hairy Excel spreadsheets and can even print directly to PDF, a very useful feature.

But, there are still some show stopping problems with it.

  • It uses semicolons instead of commas in formulae? What?!
  • It requires the '=' sign to start a formula instead of '+' like Excel.

Look, if you want people to change from the market leading spreadsheet product (and undoubtedly Microsoft's best software product), you can't do it by changing all of the finger macros that real spreadsheet geeks (like me) have developed from using Excel for years. Thirteen years or so, in my case.

If I can't sit down and make a simple spreadsheet with some VLOOKUPs and COUNTIFs on absolute row or column ranges without having to scour through the online help, I'm simply not going to change.

Oh, and make the macro language something modern like perl or python. Or better yet, provide an API so that any language can be used.

About Me


  • Unsolicited Bulk Email (spam), commercial solicitations, SEO related items, link exchange requests, and abuse are not welcome here and will result in complaints to your ISP.
  • Any email to the above address may be made public at the sole discretion of the recipient.

Other Stuff

  • Powered by Linux
  • (RedHat Linux)


Monthly Archives

About this Entry

This page contains a single entry by dave published on November 12, 2006 10:33 PM.

Letting the days go by... was the previous entry in this blog.

Mac Facts? is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.