Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #71
| Path | csiph.com!news.redatomik.org!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!nzpost1.xs4all.net!not-for-mail |
|---|---|
| Subject | Re: Long spreadsheets |
| Newsgroups | comp.apps.spreadsheets |
| References | <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> |
| From | Luuk <luuk@invalid.lan> |
| Date | Wed, 7 Nov 2018 14:55:38 +0100 |
| User-Agent | Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 |
| MIME-Version | 1.0 |
| In-Reply-To | <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> |
| Content-Type | text/plain; charset=utf-8 |
| Content-Language | en-US |
| Content-Transfer-Encoding | 7bit |
| Lines | 29 |
| Message-ID | <5be2eed6$0$32240$e4fe514c@news.xs4all.nl> (permalink) |
| NNTP-Posting-Host | 546653cf.news.xs4all.nl |
| X-Trace | G=oglM+R/N,C=U2FsdGVkX1/5EoJmsojSFvxCryV5fZFeCEkYeWGQYxsL8FZhsdSgev2LKXsHmPC6ezHnL+AEIji3Tc/HRxyUm0poQZGKX5uVdZ+cOD++6vuuT4t4V/c3u/dKGo3FAT93 |
| X-Complaints-To | abuse@xs4all.nl |
| Xref | csiph.com comp.apps.spreadsheets:71 |
Show key headers only | 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
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