![]() |
|
#11
|
||||
|
||||
|
As the link provided by xor explains, the issue arose because, when Excel was introduced, Lotus 123 was the dominant spreadsheet program and Microsoft was more or less obliged to replicate the bug so as to be able to work with Lotus worksheets and vice-versa. Having done that, later versions of Excel likewise have had to maintain the bug for backwards compatibility. Correcting the bug could cause data loss and/or calculation errors in a wide range of workbooks with severe financial implications. Furthermore, if Microsoft were to correct the 1900 leap-year 'bug' in Excel, that would immediately make it incompatible with every other worksheet program out there, all of which have the same bug and for essentially the same reasons.
You might think Microsoft's reasons are weak - but just look at the furore that's been created by Apple doing something as innocuous as reducing processor performance on devices using old batteries... Somehow, I doubt Microsoft wants to be bankrupted for having the temerity to fix a long-documented, historical, bug that wasn't of its own design.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2011 for apple mac
|
denisethetutor@gmail.com | Excel | 1 | 05-12-2015 09:57 AM |
| excel 2011 vs 2010 | kharrington82 | Excel | 0 | 03-17-2015 03:52 PM |
| Excel 2008 vs Excel 2011 for Mac | nfotx | Excel | 0 | 12-05-2014 03:48 PM |
Is it possible to transfer my Excel 2011 for MAC to another MAC
|
Dalesman | Office | 4 | 12-04-2014 02:51 AM |
Excel 2011 can't open old Excel 98 or Excel X files
|
FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |