Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #73

Re: Long spreadsheets

Show all headers | View raw

* 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/

Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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