Re: M$ Excel Supreme Stupidity

On Fri, 17 Jan 2025 11:39:28 -0500, Chris Ahlstrom wrote:

 
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.
>

That's correct for LibreOffice because the LO epoch, or Day 0, is
December 30, 1899.  (Don't ask why.)

But for Microslop Excel, the correct date should be March 1, 1900
because the Excel epoch, or Day 1, is January 1, 1900.

Another superiority of LO Calc is that it handles dates before the
epoch (negative times) all the way back to the year 1582.

Microslop Excel cannot display dates before its epoch.  Total junk!

But the Excel epoch can be changed to 1904 and then can use negative
time, but then this will fuck up a lot of other spreadsheets.

For dates M$ Excel is a total mess.


--
Hail Linux!  Hail FOSS!  Hail Stallman!