Comment on Bet you didn't know that before Excel, people used Lotus 1-2-3
mercano@lemmy.world 2 days ago
There’s a long-standing bug in Excel, dating back to the original release, where it thinks 1900 is a leap year. This isn’t a mistake, though, Microsoft coded it this way because Lotus 1-2-3 thought 1900 was a leap year, and they wanted to be compatible so they could import Lotus spread sheets. However, by doing this, they locked themselves in, and they need to continue to have this bug even today to be compatible with old Excel spreadsheets.
Pippipartner@discuss.tchncs.de 2 days ago
Biggest commercial supplier of OS and surrounding software suits. Everybody think Microsoft Windows is a computer, same as WiFi = Internet. International trade is based on Excel, science, probably government and your Warhammer 40k Army list as well. Can’t properly determine leap year.
(Also when dumping genetic strings, these long AAACGCG, into Excel it turns them into dates silently. Which has ruined the reproducibility of genetics research since forever.)