Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #76
| 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 | <N3e8I5be80c80T2101@kulungile.erack.de> |
| 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> <N3e8I5be72ac8T2d61@kulungile.erack.de> <ed71b486-2940-4c29-9434-9dd6fbe288cb@googlegroups.com> <N3e8I5be80c80T2101@kulungile.erack.de> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <34e6b875-6965-4cac-8701-f9856ea50204@googlegroups.com> (permalink) |
| 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 |
Show key headers only | View raw
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. > > Ok, point taken. Could work for the yyyy-Www-d form. If that means that you are considering implementing it, be sure to work from ISO 8601, real or Wikipedia, and do not think of using DatePart. > > I should have, for consistency, put yyyy-ddd ; but the condensed forms without the '-' characters are also standard and are unambiguous for a string which is known to be an ISO 8601 date. > > 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 £9.00 appear. I believe that they are stored as IEEE Doubles; but the cells know what the number should mean. Perhaps, to help low-level work, it should be possible to format the displayed numbers as Hex or Octal, and to interpret input correspondingly. -- (c) Dr. S. Lartius, UK. Gmail: dr.s.lartius@
Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Next in thread | Find similar
Long spreadsheets dr.s.lartius@gmail.com - 2018-11-06 15:29 -0800
Re: Long spreadsheets Luuk <luuk@invalid.lan> - 2018-11-07 14:55 +0100
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-10 19:09 +0000
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-10 19:09 +0000
Re: Long spreadsheets dr.s.lartius@gmail.com - 2018-11-10 14:56 -0800
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-11 11:04 +0000
Re: Long spreadsheets dr.s.lartius@gmail.com - 2018-11-11 04:04 -0800
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-11 23:08 +0000
Re: Long spreadsheets Luuk <luuk@invalid.lan> - 2018-11-17 14:00 +0100
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-18 01:17 +0000
csiph-web