Hi, Here's one way to do it, applied to an example that takes less space: With ten rows, say we want to count down from 365 to 358 in the middle of the middle column ($2), leaving an empty row on top and bottom (@1 and @10).
Set the value of @2$2 to 365, either manually or (as below) in the table formula. Then set the rest of the range from rows @3 down to @9 to decrement by one from the cell above (@-1): | | | | | | 365 | | | | 364 | | | | 363 | | | | 362 | | | | 361 | | | | 360 | | | | 359 | | | | 358 | | | | | | #+TBLFM: @2$2=365::@3$2..@9$2=@-1-1 Yours, Christian Uwe Brauer writes: > Hello > > In most spreadsheets I know, it is possible to generate easily a column > say starting in 365 ending in 23.[1] > > Is there any way to do this in the org spreadsheet, without a loop? > > thanks > > Uwe Brauer > > Footnotes: > [1] (Or in matlab without a loop)
