Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Eike Rathke Newsgroups: comp.apps.spreadsheets Subject: Re: Long spreadsheets Date: 10 Nov 2018 19:09:41 GMT Organization: possibly Lines: 25 Message-ID: References: <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> X-Trace: individual.net QJOlN31Px21FXAB3BVuI8gnYjebK/97F2VgtQM4SErSQruTPw= Cancel-Lock: sha1:fY2y+aEM3vn5iz7INTlWlEdCu/I= X-Accept-Language: de,en X-PGP-Hash: SHA256 X-PGP-Key: 0x6A6CD5B765632D3A X-PGP-Sig: GnuPG-v2 From,Newsgroups,Subject,Message-ID iQIzBAEBCAAdFiEEImXX86ewlcw5GGMLamzVt2VjLToFAlvnKsgACgkQamzVt2Vj LTo08w/+PQZRL7iRipRxctmrq3cUWqzKMpI5XsdrdaPCc+1ziod31Ln80juXjMEW AKGsBWIpQuJpuVnjoocN4D6qNdOSUkK3bCxZ3St5twb88SYv32+S4qm0BVON/qIa bMvGvZxwPt0U4caTMaYfXs1F2e0g5NIcytMTKB5qCbmRUMorElCtlpLHc1oveiZN 9z1+g7hQgmStNhlwMPv5sTLKOc+UYI2L71puzQp3QfCWG3NpE0NB0oExpvwtXwFR k6DerUrsVwlylo85QAqySm1N1SvUoe42eBqejjo7iUnGSxECeh698H5sf98ioVVU mVKNpic6YuT7DGHj6XaREUSG4AiQ2+eySsJgx+gpopsk9TexpTdhjldRJYQrFHGl b7bFINfmMNGyUiyAbW7s1P5nhxmW6vZIV5tEqsXiSkHc606zGitHrhUYAERVDu/x QfluO3PDH7UNe9MndaPl0fQm5vhB7m+3HjcLUCxEE0MQyyQLG65ZGt7kVUqQan1g ai83AIk6CnjEyEtNWKbZnevvROG3hULiw+lnlPxuLs/jjjTyaxxEi+p+Yng6C4W0 RIwphT8BRlVbCiDAPq6rfHMc1/oO8XyHvDvz8pmej1xmHlHC20s90wd8n7FRrVyJ 6zd0OePG/rVNgfgclLsu0qxZSW+mTPMOz0u9LhbNTM3lP7Yrrb8= =zoiT User-Agent: slrn/1.0.3 (Linux) Xref: csiph.com comp.apps.spreadsheets:73 * dr.s.lartius@gmail.com, 2018-11-06 23:29 UTC: > But I need to append new lines to the calculation part. Is it *necessary* to remember to drag the expression down *each time*, or is there a way of making that automatic? I could, of course, drag the expression down manually a very long way, and never insert new lines. As Luuk mentioned, there's Ctrl+D to copy values and formulas from the row above, which also works on a selection. So you could select the columns and press Ctrl+D once to copy all cells from above (automatically adjusting relative references in formula expressions to the new position) and then replace the input value with the new value. > ASIDE - general spreadsheets - it should be possible to have a numeric column formatted as Date, with the dates being in any of the three main ISO8601 forms - yyyy-mm-dd, yyyy-Www-d, & yyyyddd. Please. Don't trust US coders (NIST apart) to calculate yyyy-Www-d correctly for all dates. I don't quite understand what you mean with Www, if it's abbreviated month name then it is MMM, if it is the week number then it would be WW but then yyyy-Www-d wouldn't make sense. Anyhow, yyyy-mm-dd is recognized as date as is yyyy-mmm-dd but of course the actual month name abbreviation recognized depends on the current locale. A numeric yyyyddd input can't be a date because it is a number. Eike -- OpenPGP/GnuPG encrypted mail preferred in all private communication. GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A Use LibreOffice! https://www.libreoffice.org/