From: Farley Flud <fsquared@fsquared.linux>
Subject: Re: M$ Excel Supreme Stupidity
Newsgroups: comp.os.linux.advocacy
References: <181b83589a58e91d$131121$32720$802601b3@news.usenetexpress.com> <vme140$470n$3@dont-email.me>
User-Agent: Pan/0.146 (Hic habitat felicitas; d7a48b4 gitlab.gnome.org/GNOME/pan.git)
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Lines: 26
Path: ...!eternal-september.org!feeder3.eternal-september.org!tncsrv06.tnetconsulting.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!news.usenetexpress.com!not-for-mail
Date: Fri, 17 Jan 2025 17:20:25 +0000
Nntp-Posting-Date: Fri, 17 Jan 2025 17:20:25 +0000
X-Received-Bytes: 1424
Organization: UsenetExpress - www.usenetexpress.com
X-Complaints-To: abuse@usenetexpress.com
Message-Id: <181b8a8e6104a26a$11994$2942$802601b3@news.usenetexpress.com>
Bytes: 1861

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!