X-Received: by 2002:a24:e04d:: with SMTP id c74-v6mr7024980ith.26.1541937881158; Sun, 11 Nov 2018 04:04:41 -0800 (PST) X-Received: by 2002:a25:50cd:: with SMTP id e196-v6mr155009ybb.0.1541937881013; Sun, 11 Nov 2018 04:04:41 -0800 (PST) Path: csiph.com!feeder.erje.net!1.eu.feeder.erje.net!newsreader4.netcologne.de!news.netcologne.de!peer02.ams1!peer.ams1.xlned.com!news.xlned.com!peer02.am4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!g188-v6no2348362itg.0!news-out.google.com!n199-v6ni3904itn.0!nntp.google.com!g188-v6no2348358itg.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.apps.spreadsheets Date: Sun, 11 Nov 2018 04:04:40 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=94.30.84.71; posting-account=IO1IaQoAAABlv5RUEEpdO5OBlwR6lP8q NNTP-Posting-Host: 94.30.84.71 References: <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <34e6b875-6965-4cac-8701-f9856ea50204@googlegroups.com> Subject: Re: Long spreadsheets From: dr.s.lartius@gmail.com Injection-Date: Sun, 11 Nov 2018 12:04:41 +0000 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Received-Bytes: 2555 X-Received-Body-CRC: 1796312239 Xref: csiph.com comp.apps.spreadsheets:76 On Sunday, 11 November 2018 11:04:42 UTC, Eike Rathke wrote: > * dr.s.lartius@gmail.com, 2018-11-10 22:56 UTC: > > You should read ISO 8601, or at least https://en.wikipedia.org/wiki/ISO= _8601. >=20 > Ok, point taken. Could work for the yyyy-Www-d form. If that means that you are considering implementing it, be sure to work fro= m ISO 8601, real or Wikipedia, and do not think of using DatePart. =20 > > I should have, for consistency, put yyyy-ddd ; but the condensed forms = without the '-' characters are also standard and are unambiguous for a stri= ng which is known to be an ISO 8601 date. >=20 > In the context of spreadheets though any numeric input without > separators is a number. No; I type 33333 into my first column, and see 1999-04-05 appear; I type 9 = into my third column, and see =C2=A39.00 appear. I believe that they are s= tored as IEEE Doubles; but the cells know what the number should mean. Per= haps, to help low-level work, it should be possible to format the displayed= numbers as Hex or Octal, and to interpret input correspondingly. --=20 (c) Dr. S. Lartius, UK. Gmail: dr.s.lartius@