Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #76
| Newsgroups | comp.apps.spreadsheets |
|---|---|
| Date | 2018-11-11 04:04 -0800 |
| References | <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> <N3e8I5be72ac8T2d61@kulungile.erack.de> <ed71b486-2940-4c29-9434-9dd6fbe288cb@googlegroups.com> <N3e8I5be80c80T2101@kulungile.erack.de> |
| Message-ID | <34e6b875-6965-4cac-8701-f9856ea50204@googlegroups.com> (permalink) |
| Subject | Re: Long spreadsheets |
| From | dr.s.lartius@gmail.com |
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