Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.os.linux.advocacy > #684263

Re: MS Excel Working As Designed

From -hh <recscuba_google@huntzinger.com>
Newsgroups comp.os.linux.advocacy
Subject Re: MS Excel Working As Designed
Date 2025-01-17 21:57 -0500
Organization A noiseless patient Spider
Message-ID <vmf5b6$d902$2@dont-email.me> (permalink)
References <181b83589a58e91d$131121$32720$802601b3@news.usenetexpress.com> <spqdnTWpWv8iUhf6nZ2dnZfqn_adnZ2d@supernews.com> <vmenu5$9hcv$2@dont-email.me> <-L6dnZ9Zr8JUdBf6nZ2dnZfqnPGdnZ2d@supernews.com>

Show all headers | View raw

On 1/17/25 6:37 PM, Tyrone wrote:
> On Jan 17, 2025 at 6:08:53 PM EST, "Lawrence D'Oliveiro" <ldo@nz.invalid>
> wrote:
> 
>> On Fri, 17 Jan 2025 21:46:39 +0000, Tyrone wrote:
>>
>>> Maybe if you read and learn FIRST, you would stop making a fool of
>>> yourself.
>>
>> Hard to believe it’s come to the point where the Microsoft marketing
>> machine has persuaded people that the ones pointing out the bug are the
>> “fools”, rather than the ones who were stupid enough to make it in the
>> first place.
> 
> It was designed that way to be compatible with Lotus 1,2,3.  Multiplan (and
> later Excel) HAD to be 100% compatible with that.

Huh.  That's a TIL for me.


> This issue probably goes all the way back to the first spreadsheet, VisiCalc
> in 1979 on the Apple II.  Lotus 1,2,3 was the IBM PC version of Visicalc in
> 1983.

Makes sense, even before contemplating if their original choice was 
motivated because of how limited memory/storage/etc was in that era, or 
just a lack of sophistication on leap year rules ... or both, since it 
was decades prior to Y2K awareness.

> BTW, since LO does not follow this standard (as weird as it is), this is
> probably yet another reason why businesses don't use it.

Well, in modern context it isn't all that hard (once one is aware of the 
limitation/requirement) to write some code that addresses 'special 
rules' of how to address dates earlier than 1 March 1900, including the 
compatibility layer for using files from other spreadsheet apps.


-hh

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

M$ Excel Supreme Stupidity Farley Flud <fsquared@fsquared.linux> - 2025-01-17 15:08 +0000
  Re: M$ Excel Supreme Stupidity Chris Ahlstrom <OFeem1987@teleworm.us> - 2025-01-17 11:39 -0500
    Re: M$ Excel Supreme Stupidity Farley Flud <fsquared@fsquared.linux> - 2025-01-17 17:20 +0000
    Re: M$ Excel Supreme Stupidity -hh <recscuba_google@huntzinger.com> - 2025-01-17 15:55 -0500
      Re: M$ Excel Supreme Stupidity Farley Flud <ff@linux.rocks> - 2025-01-17 22:05 +0000
  Re: MS Excel Working As Designed (was: M$ Excel Supreme Stupidity) Tyrone <none@none.none> - 2025-01-17 21:46 +0000
    Re: MS Excel Working As Designed (was: M$ Excel Supreme Stupidity) Farley Flud <ff@linux.rocks> - 2025-01-17 22:49 +0000
    Re: MS Excel Working As Designed (was: M$ Excel Supreme Stupidity) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-17 23:08 +0000
      Re: MS Excel Working As Designed DFS <guhnoo-basher@linux.advocaca> - 2025-01-17 18:35 -0500
      Re: MS Excel Working As Designed Tyrone <none@none.none> - 2025-01-17 23:37 +0000
        Re: MS Excel Working As Designed Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-17 23:52 +0000
          Re: MS Excel Working As Designed Tyrone <none@none.none> - 2025-01-18 01:00 +0000
            Re: MS Excel Working As Designed Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-18 02:19 +0000
            Re: MS Excel Working As Designed Farley Flud <ff@linux.rocks> - 2025-01-18 09:27 +0000
              Re: MS Excel Working As Designed Farley Flud <ff@linux.rocks> - 2025-01-18 10:04 +0000
                Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 19:45 -0600
              Re: MS Excel Working As Designed Joel <joelcrump@gmail.com> - 2025-01-18 17:20 -0500
                Re: MS Excel Working As Designed Stéphane CARPENTIER <sc@fiat-linux.fr> - 2025-01-18 23:21 +0000
            Re: MS Excel Working As Designed Farley Flud <fflud@gnu.rocks> - 2025-01-18 18:04 +0000
        Re: MS Excel Working As Designed Farley Flud <ff@linux.rocks> - 2025-01-18 00:05 +0000
          Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 13:38 -0600
            Re: MS Excel Working As Designed DFS <guhnoo-basher@linux.advocaca> - 2025-01-18 16:03 -0500
              Re: MS Excel Working As Designed Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-19 00:52 +0000
        Re: MS Excel Working As Designed -hh <recscuba_google@huntzinger.com> - 2025-01-17 21:57 -0500
          Re: MS Excel Working As Designed Tyrone <none@none.none> - 2025-01-18 04:34 +0000
            Re: MS Excel Working As Designed Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-18 06:50 +0000
              Re: MS Excel Working As Designed Farley Flud <ff@linux.rocks> - 2025-01-18 10:58 +0000
                Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 14:01 -0600
                Re: MS Excel Working As Designed Farley Flud <ff@linux.rocks> - 2025-01-18 21:02 +0000
                Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 16:05 -0600
                Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 16:27 -0600
                Re: MS Excel Working As Designed Tyrone <none@none.none> - 2025-01-19 00:19 +0000
                Re: MS Excel Working As Designed Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 18:34 -0600
                Re: MS Excel Working As Designed CrudeSausage <crude@sausa.ge> - 2025-01-18 21:12 -0500
                Re: MS Excel Working As Designed rbowman <bowman@montana.com> - 2025-01-19 04:35 +0000
                Re: MS Excel Working As Designed CrudeSausage <crude@sausa.ge> - 2025-01-19 05:58 -0500
                Re: MS Excel Working As Designed chrisv <chrisv@nospam.invalid> - 2025-01-19 11:02 -0600
                Re: MS Excel Working As Designed CrudeSausage <crude@sausa.ge> - 2025-01-19 12:18 -0500
                Re: MS Excel Working As Designed rbowman <bowman@montana.com> - 2025-01-19 19:32 +0000
                Re: MS Excel Working As Designed CrudeSausage <crude@sausa.ge> - 2025-01-19 14:37 -0500
                Re: MS Excel Working As Designed rbowman <bowman@montana.com> - 2025-01-20 01:48 +0000
                Re: MS Excel Working As Designed Stéphane CARPENTIER <sc@fiat-linux.fr> - 2025-01-18 23:16 +0000
                Re: MS Excel Working As Designed Joel <joelcrump@gmail.com> - 2025-01-18 16:33 -0500
            Re: MS Excel Working As Designed -hh <recscuba_google@huntzinger.com> - 2025-01-18 13:57 -0500
  Re: M$ Excel Supreme Stupidity DFS <guhnoo-basher@linux.advocaca> - 2025-01-17 18:31 -0500
  Re: M$ Excel Supreme Stupidity Farley Flud <ff@linux.rocks> - 2025-01-18 09:39 +0000
    Re: M$ Excel Supreme Stupidity Physfitfreak <physfitfreak@gmail.com> - 2025-01-18 20:00 -0600
      Re: PhysFatFuck's Supreme Delusion DFS <guhnoo-basher@linux.advocaca> - 2025-01-20 16:37 -0500

csiph-web