Excel now support lists and arrays as values in a cell, but it still thinks February 29th, 1900 is a thing because 40 year-old backwards compatibility?
This is a strange world we live in.
Backwards compatibility with Lotus 1-2-3: <a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/wrongly-assumes-1900-is-leap-year" rel="nofollow">https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...
Is that a contradiction? Adding list and arrays doesn't break backwards compatibility. In general, guaranteeing backwards compatibility doesn't prevent you from adding new features, and having both old quirks and new features is fairly common for any decently old software
Ooh, interesting -- I didn't know what. Obviously it's a curiosity, not a real annoyance unless I'm trying to calculate how many days my great-grandfather lived :-)
gcanyon · · focus · HN ↗
This is a strange world we live in.
Backwards compatibility with Lotus 1-2-3: <a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/wrongly-assumes-1900-is-leap-year" rel="nofollow">https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...
sheept · · focus · HN ↗
NetMageSCW · · focus · HN ↗
gcanyon · · focus · HN ↗