I'm new to spreadsheet calculations. I'm using LibreOffice, but would like the sheet to be Excel-compatible.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.
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
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, andnever 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 calculateyyyy-Www-d correctly for all dates.
P.S. Is there a better newsgroup for spreadsheets? this one seems quiet.
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..
* dr.s.lartius@gmail.com, 2018-11-06 23:29 UTC:calculate yyyy-Www-d correctly for all dates.
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
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.
You should read ISO 8601, or at least https://en.wikipedia.org/wiki/ISO_8601.
I should have, for consistency, put yyyy-ddd ; but the condensed forms without the '-' characters are also standard and are unambiguous for a string which is known to be an ISO 8601 date.
* dr.s.lartius@gmail.com, 2018-11-10 22:56 UTC:
You should read ISO 8601, or at least https://en.wikipedia.org/wiki/ISO_8601.
Ok, point taken. Could work for the yyyy-Www-d form.
I should have, for consistency, put yyyy-ddd ; but the condensed forms without the '-' characters are also standard and are unambiguous for a string which is known to be an ISO 8601 date.
In the context of spreadheets though any numeric input without
separators is a number.
In the context of spreadheets though any numeric input without
separators is a number.
No; I type 33333 into my first column, and see 1999-04-05 appear;
I type 9 into my third column, and see £9.00 appear.
I believe that they are stored as IEEE Doubles;
but the cells know what the number should mean.
* dr.s.lartius@gmail.com, 2018-11-11 12:04 UTC:
In the context of spreadheets though any numeric input without
separators is a number.
No; I type 33333 into my first column, and see 1999-04-05 appear;
That is because dates(+time) are formatted date serial numbers, 33333
days since the null-date, which is 1899-12-30.
1) 12/30/1899 (default)
And the strange thing is that EXCEL uses '31 december 1899'
(actually EXCEL only supports dates starting from the year 1900) DATAVALUE("01-01-1900") returns 1 in Excel
DATAVALUE("01-01-1900") returns 2 in LibreOffice
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 68:19:11 |
Calls: | 6,655 |
Calls today: | 1 |
Files: | 12,200 |
Messages: | 5,332,031 |
Posted today: | 1 |