Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #70

Long spreadsheets

Show all headers | View raw

I'm new to spreadsheet calculations.  I'm using LibreOffice, but would like the sheet to be Excel-compatible.

I have a "Running Total" column, a plus column, and a minus column; in pseudo-code, RT[n] = RT[n-1] + plus[n] - minus[n], all being currency.  I also have a date column and a text column.  I will append lines about twice a week or so.  At the top there is a text heading, and after that the initial Running Total is pseudo-calculated as =0.  There is also a text footer.  So far so good, I think.  The columns are formatted as columns, and the RT[first] expression has been dragged down.  Still good.

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.

I think I must have missed seeing something which should have been obvious.

Advice?


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.


P.S. Is there a better newsgroup for spreadsheets? this one seems quiet.

-- 
  (c) Dr. S. Lartius, UK.  Gmail: dr.s.lartius@                       |

Back to comp.apps.spreadsheets | Previous | Next — 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