InsideMicrosoft

part of the Blog News Channel

Download 35 Free MP3 Songs Courtesy of Artistdirect and Zune

ARTISTdirect has a free MP3 website, “brought to you by Zune”, with 35 free songs you can download, no matter what player you have, Zune, iPod, Zen, whatever. Just head to the promo page and right-click the download button, then select whatever your browser needs to download the file. Songs include Weird Al’s “Don’t Download This Song”, “Easy” by Barenaked Ladies, “Feeling So Real” by Moby and “I’ll Be Home For Christmas” by Aimee Mann.
(via Neowin)

January 22nd, 2007 Posted by | General, Windows Media, Zune | one comment



Excel Has 1900 Leap Year Error

microsoft-excel-1904-date-system.pngI was reading some stuff over the weekend and found out that Microsoft Excel has had, for a very long time, an error that interprets the year 1900 as a leap year. Since 1900 was not a leap year (the first year of a century is only a leap year if the first two digits are divisible by four, typically), the date system was incorrect prior to March 1, 1900.

As a result of this error, Microsoft Excel has two different date systems: The 1900 date system and the 1904 date system. The 1900 date system is the original system, and contains the leap year error, while the 1904 system does not have the error, but does not display dates prior to 1904 (much like the 1900 system does not display dates prior to 1900). Even Office 2007 has the option to use the 1904 system, and it is turned off by default!

The reason it is turned off? The dates system stores dates as a date serial number, using the same general idea:

  • In the 1900 system, January 1, 1900 has the date serial number of 1
  • In the 1904 system, January 1, 1904 has the date serial number of 1

See the problem? If you have a spreadsheet formatted with the 1900 system, and you import the data from it into a spreadsheet using the 1904 system, your dates all break, adding 1,462 days (four years plus one incorrect leap day) to every single date you import. Luckily, there’s a Paste Special option that auto-corrects this, but it only helps if you know to expect it (as you do right now).

There are all sorts of problems in this, and all of them stem from the fact that backwards compatibility won’t let Microsoft change this. If new Excel documents were all created with the 1904 system, then opening them on older Excel systems would feature all the dates being pushed back 1,462 days. Also, if someone on an older system handed you a document, and you were pasting it into a by default 1904 system document, you’d have to account for the change in date systems every damn time.

I have to believe Microsoft could have fixed this, but decided there problems in the system were too small, and that the 1904 system handled it for anyone who really needs it perfect. I wish they would just junk both systems, replaced with a newer system that reaches further back than just 1900, and that auto-corrects dates from older systems. Plus, since Office 2007 documents can’t be opened in older versions of Office without a file converter, the file converter could fix the date system on the way out, too.

O’Reilly discusses what would happen if the United States changed the date system to match Microsoft’s:

To help Office to become a standard, one adaptation governments could make would be to retroactively declare 1900 a leap year. This would require updates to history books and other documents (for instance, V-E day would change to May 7, and the World Trade Center attacks would have taken place on September 10) but I’d like to see a cost comparison with the alternative that businesses dread: migrating to open document formats.

(Found on Findory)

January 22nd, 2007 Posted by | Applications, General, Office | 4 comments

Hosting sponsored by GoDaddy

New Vanishing Point Clues Shown On Famous Structures

This is the third week of Microsoft’s Vanishing Point game, which will ultimately send one contestant into space, and each week is begun with a big event showing off the clues to that week’s puzzles. The first week was a video shown in the Bellagio fountain in Las Vegas, then sky-writing above multiple cities, and this week it involved projections on famous structures around the world. Clues were shown on:

  • The Palace of Fine Arts Theatre in San Francisco
  • The Brandenburg Gate in Berlin
  • The National Gallery in London
  • The Hockey Hall of Fame in Toronto
  • The Victoria Theater in Singapore

Take a look at these pictures, which are all just really cool:

Here’s the Brandenburg Gate in Berlin, by quik boy on Flickr:

Here’s the Hockey Hall of Fame in Toronto, by quik boy on Flickr:

Here’s the National Gallery of London, by quik boy on Flickr:

Here’s the Victoria Theatre and Concert Hall in Singapore, by quik boy on Flickr:

Here’s the Palace of Fine Arts in SF, by ue06 on Flickr:

January 22nd, 2007 Posted by | General, Vista, Windows | no comments

Windows Live Maps Adds 3D Miami, More High-Res Cities

LiveSide announced the following cities have new higher-resolution satellite maps in Windows Live Maps:

  • Manhattan
  • Portland
  • Bellevue
  • Miami
  • Philadelphia
  • several areas of California including San Diego
  • Hamilton, Canada
  • Ontario, Canada

In addition, Miami has been blessed with a sweet 3D update.

Here are screenshots:

Rockefeller Center, Manhattan, New York City:

Rockefeller Center Windows Live Maps

Coral Gables, Miami, Florida, in 3D:

Coral Gables Miami Windows Live Maps

As always, click to enlarge.

January 22nd, 2007 Posted by | General, Live, Local, Windows | no comments