The problem with Microsoft

I often encounter things that reinforce my belief that Microsoft are unbelievably clueless when it comes to writing software.

My latest find: How to prevent the automatic creation of hyperlinks in Excel for Mac.

"Excel for Mac does not provide a built-in method to override this behavior. However, this article contains sample methods that you can use to prevent Excel for Mac from automatically creating hyperlinks."

"To prevent Excel for Mac from automatically creating a hyperlink, use any of the following methods."

  1. "Type an apostrophe at the beginning of the cell entry"
  2. "Use a program-level event handler to prevent hyperlinks" (11 steps: ~50 lines of code)
  3. "Use a program-level event handler to remove existing hyperlinks and to prevent Excel for Mac from automatically creating hyperlinks" (11 steps: ~45 lines of code)

So my options to stop this 'feature' are: corrupt my data, or use 45-50 lines of code to fix the program's poor usability.

I mean, it was only the 2004 version...

Tagged and .

Most used blog post tags

Blog entries by month

  1. January 2012 (1)
  2. August 2011 (2)
  3. March 2011 (1)
  4. February 2011 (1)
  5. November 2010 (1)
  6. October 2010 (1)
  7. August 2010 (2)
  8. January 2009 (1)
  9. December 2008 (1)
  10. November 2008 (1)
  11. October 2008 (2)
  12. September 2008 (3)