Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #71

Re: Long spreadsheets

Show all headers | View raw

On 7-11-2018 00:29, dr.s.lartius@gmail.com wrote:
> 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.
> 

I only know the possibility to copy a formula from the line above, using
CTRL+D


About if there is a 'better' list, there is a mailinglist:
https://www.libreoffice.org/get-help/mailing-lists/

or a forum:
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

both have (as far as i know) the same content..

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