Re: M$ Excel Supreme Stupidity

On Fri, 17 Jan 2025 15:55:42 -0500, -hh wrote:

On 1/17/25 11:39 AM, Chris Ahlstrom wrote:

Farley Flud wrote this post while blinking in Morse code:
 

Wanna good laugh?
>
Fire up Microcrap Excel.  Open a blank workbook and format
a cell as "Date."  (Accept the default display format.)
>
Now in that same cell enter "60."
>
What do you see?  Answer: “February 29, 1900” (or whatever
display format you have chosen).
>
The problem is that Feb 29, 1900 does not exist!
>
The year 1900 is not a leap year!
>
I'm seeing this right in front of me right now and I am using
the very latest version of Microcrap Excel.
>
OMFG!  What junk!
>
I thank John Walker for this:
>
https://www.fourmilab.ch/documents/calendar/

 
In LibreOffice, it's just "60". When you apply the "Date" format, the
result is 2/28/00;  or choose the full date format to see the 1900.

 
Looking into the Excel bug, it actually appears to be more than merely
that 2/29/1900 doesn't exist:
 
Using a value of 1 ... it reports as being 1/1/1900.  Good enough, but
it also reports that that was a Sunday.  But calendars report that
1/1/1900 was actually a Monday
 
Values 2 thru 59:  same as above: the day of the week is off by one.
 
60:  the Wednesday, 2/29/1900 error
 
61 & higher:  Thursday 3/1/1900 .. so the day of week is now correct.
 
 
-hh

If you read the article that I linked then you will discover
the total bullshit:

"But this is a Microsoft calendar, remember, so one must first look to make
sure it doesn't contain one of those bonehead blunders characteristic of
Microsoft. As is usually the case, one doesn't have to look very far.
If you have a copy of PC Excel, fire it up, format a cell as containing
a date, and type 60 into it: out pops “February 29, 1900”.

"By the time the 1900 blunder was discovered, Excel users had created millions
of spreadsheets containing incorrect day numbers, so Microsoft decided to leave
the error in place rather than force users to convert their spreadsheets,
and the error remains to this day."

It's fucking unbelievable!  To save millions of dummy spreadsheets
Microslop decided to fudge the dates for all users.  Incredible!

Ha, ha, ha, ha, ha!  If this were FOSS there would be an immediate
hostile, and fruitful, reaction.



--
Systemd: solving all the problems that you never knew you had.