On Sun, Jan 15, 2012 at 05:13:27PM +0000, Keith Edmunds wrote:
On Sun, 15 Jan 2012 16:44:48 +0000, cl@isbd.net said:
So there isn't actually a syntax for "all the way to the end"?
I don't know.
I'd read through the help on relative/absolute column references and saw that it could do some of what I wanted but was hoping for something more straightforward.
Such as?
A way to put a formula in the column as a whole in the same way as right clicking on the column header allows one to set the font size, style, justification, etc. It just seems such an obvious sort of thing to want to do.
Isn't there some way of 'auto filling' a column with the same calculation as the previous row whenever a new row is entered into the spreadsheet?
No need. Copy the formula/formulae all the way to the foot of the spreadsheet in one go. That will put the last value of the balance in all the unused rows, but you could easily fix that with an "if" formula. In English: if cell B this row is empty, insert "" else insert the formula I gave before.
If this was a more realistic case where one wanted running balances of "Total including VAT", "Total excluding VAT" and "VAT" it would get very tedious having to make sure the formulae were copied down as one entered new values.
As I say, copy them to the end of the spreadsheet once. Job done.
Hmm, OK, but it's not exactly 'pretty' is it! When I look at my spreadsheet I don't want to see 50 rows where only the first ten have values in them, I just want to see the rows with values.
Where's the 'end' anyway, it could have hundreds or thousands of rows after a few years use with only the last few tens of rows being shown.
Sorry, I was just hoping a spreadsheet would be a cleaner/tidier solution to my requirement than it actually is.